<rss version="2.0" xmlns:a10="http://www.w3.org/2005/Atom"><channel><title>Inflectra Customer Forums: Importing from xl export (Thread)</title><description> I have an xl spreadsheet of data which I exported from SpiraTest I"m now trying to import them into a new instance of Spira.    I can connect ok and select the Project to import into and the artifact Release BUT when I try to import the Releases, if I remove the Release ID values, each line gets the same error  of "Database Foreign key violation occurred".     If I leave the Release ID values in place, I get the following error on each line 'Object reference not set to an instance of an object.    Any ideas what I'm doing wrong please ?     thanks - Lynn </description><language>en-US</language><copyright>(C) Copyright 2006-2026 Inflectra Corporation.</copyright><managingEditor>support@inflectra.com</managingEditor><category domain="http://www.dmoz.org">/Computers/Software/Project_Management/</category><category domain="http://www.dmoz.org">/Computers/Software/Quality_Assurance/</category><generator>KronoDesk</generator><a10:contributor><a10:email>support@inflectra.com</a10:email></a10:contributor><a10:id>http://www.inflectra.com/kronodesk/forums/threads</a10:id><ttl>120</ttl><link>/Support/Forum/integrations/importers/148.aspx</link><item><guid isPermaLink="false">threadId=148</guid><author>Lynn J Harden (lynn.harden@icognition.com.au)</author><title>Importing from xl export</title><description> I have an xl spreadsheet of data which I exported from SpiraTest I"m now trying to import them into a new instance of Spira.    I can connect ok and select the Project to import into and the artifact Release BUT when I try to import the Releases, if I remove the Release ID values, each line gets the same error  of "Database Foreign key violation occurred".     If I leave the Release ID values in place, I get the following error on each line 'Object reference not set to an instance of an object.    Any ideas what I'm doing wrong please ?     thanks - Lynn </description><pubDate>Wed, 31 Aug 2011 03:32:18 -0400</pubDate><a10:updated>2011-09-07T16:59:40-04:00</a10:updated><link>/Support/Forum/integrations/importers/148.aspx</link></item><item><guid isPermaLink="false">messageId=282</guid><author>David J (adam.sandman+support@inflectra.com)</author><title> Hi Lynn    Generally you want to leave the Release ID values blank if you're importing them as new </title><description> Hi Lynn    Generally you want to leave the Release ID values blank if you're importing them as new items. I'm not sure why you're getting the foreign key errors. If you have a support plan with us,please send the Excel sheet to  support@inflectra.com   </description><pubDate>Wed, 07 Sep 2011 16:59:40 -0400</pubDate><a10:updated>2011-09-07T16:59:40-04:00</a10:updated><link>/Support/Forum/integrations/importers/148.aspx#reply282</link></item></channel></rss>