Bug reports Found a bug? Post it here please.
Version 5.x > Bug reports > Import toolkit 5.5 Error on importing data View modes: 
User avatar
Member
Member
lancetek - 5/18/2011 4:54:29 AM
   
Import toolkit 5.5 Error on importing data
Attempting to import some rows gives me the unhelpful error of: An error occured on import: [DocumentHelper.InsertDocument]: Parent node does not exist!

I don't know what's causing this. It could be data too long or something else.

Does this tool have a log that I can view? I'm not sure what other helpful information I can give you, other than it's using the data that I sent Helena yesterday and the sql statement is:


select * from articles_live where article_id = 107


and my .iprofile contents are:


<?xml version="1.0" encoding="utf-8"?>
<import>
<target folder="C:\inetpub\wwwroot\lastWord" type="Documents" sitename="ia" classname="CMS.Article" fkmappings="CMS_Article.fkmap" importasproducts="False">
<location source="301" />
</target>
<source type="SQL" servername=".\sqlexpress" dbname="lwm_v2_20110510" authtype="WindowsAuthentication" query="select * from articles_live where article_id = 276">
<query><![CDATA[select * from articles_live where article_id = 276]]></query>
</source>
<mappings>
<mapping target="documentculture" source="=en-GB" />
<mapping target="articleleadparagraphtext" source="lead_paragraph" />
<mapping target="documentextensions" />
<mapping target="documentpagedescription" source="article_summary" />
<mapping target="requiresssl" />
<mapping target="documentname" source="={%Substring(headline, 0, 100)%}" />
<mapping target="nodegroupid" />
<mapping target="documentcreatedwhen" source="go_live_date" />
<mapping target="documentmenuitemrightimagehighlighted" />
<mapping target="articlefooter" />
<mapping target="documentcontent" />
<mapping target="documentusenamepathforurlpath" />
<mapping target="articleheadline" source="headline" />
<mapping target="articleimage" />
<mapping target="documentmenuredirecturl" />
<mapping target="documentmenuitemrightimage" />
<mapping target="documentmenucaption" />
<mapping target="documentmodifiedbyuserid" />
<mapping target="nodeid" />
<mapping target="documentcustomdata" />
<mapping target="nodecacheminutes" />
<mapping target="nodeinheritpagelevels" />
<mapping target="documentstylesheetid" />
<mapping target="nodeheadtags" />
<mapping target="documentpublishfrom" source="created_date" />
<mapping target="documentratingvalue" />
<mapping target="documentmenuitemleftimage" />
<mapping target="documentmenuitemimagehighlighted" />
<mapping target="documentcampaign" />
<mapping target="documentcreatedbyuserid" />
<mapping target="documenttype" source="=CMS.Article" />
<mapping target="documentmenuitemrightimageover" />
<mapping target="documenttaggroupid" />
<mapping target="nodealias" source="={%Substring(article_name, 0, 50)%}" />
<mapping target="documentmenustylehighlighted" />
<mapping target="articletext" source="body_txt" />
<mapping target="documentpagetemplateid" source="=62" />
<mapping target="nodeorder" />
<mapping target="documentmenuclass" />
<mapping target="documentratings" />
<mapping target="documentmenuitemimage" />
<mapping target="nodebodyelementattributes" />
<mapping target="documentmenustyleover" />
<mapping target="documentmenuitemleftimagehighlighted" />
<mapping target="documenturlpath" source="={%Substring(article_name, 0, 100)%}" />
<mapping target="documentshowinsitemap" source="=true" />
<mapping target="documentmenuiteminactive" />
<mapping target="articleshortheadline" source="={%Substring(headline_short, 0, 100)%}" />
<mapping target="documentmenujavascript" />
<mapping target="documentpagetitle" source="headline" />
<mapping target="documentmenuclasshighlighted" />
<mapping target="articleteaserimage" />
<mapping target="documentmenuitemleftimageover" />
<mapping target="nodedoctype" />
<mapping target="issecurednode" />
<mapping target="documentpublishto" />
<mapping target="documentmenuitemhideinnavigation" source="=false" />
<mapping target="nodeowner" />
<mapping target="documentmodifiedwhen" source="last_updated_date" />
<mapping target="articlename" source="={%Substring(headline, 0, 100)%}" />
<mapping target="nodecustomdata" />
<mapping target="documentmenuitemimageover" />
<mapping target="nodeguid" />
<mapping target="documenttags" source="tags" />
<mapping target="documentpagekeywords" source="tags" />
<mapping target="articleteasertext" source="article_summary" />
<mapping target="documentmenuclassover" />
<mapping target="nodeskuid" />
<mapping target="documentmenustyle" />
</mappings>
</import>