<rss version="2.0" xmlns:a10="http://www.w3.org/2005/Atom"><channel><title>Inflectra Customer Forums: Custom Field in Excel Exports to Spira (Thread)</title><description>&#xD;
I have downloaded the latest excel template and am having trouble trying to load data from the cus-01 column into a required drop-down field. I am using the Cust_01 field in Spira Test Sets and have a list of 3 options from a drop-down menu. These options are High, Medium, Low.&#xD;
&#xD;
    When I input any of these into the Excel template cus-01 column, and try to export to Spira from excel, I get an error saying the field is required. However the data in the template does upload to Spira but doesn't create the Test Set id in Excel that is used as identification for future uploads/changes to that specific Test set..     Can you advise how to address this? Does the cus-01 field require the id value of the custom list contents rather than the exact text match?    </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/spirateam/issues-questions/1358.aspx</link><item><guid isPermaLink="false">threadId=1358</guid><author>Robbie Shortall (rshortal@revenue.ie)</author><category domain="http://www.inflectra.com/kronodesk/thread/tag">reporting</category><category domain="http://www.inflectra.com/kronodesk/thread/tag"> excel</category><title>Custom Field in Excel Exports to Spira</title><description>&#xD;
I have downloaded the latest excel template and am having trouble trying to load data from the cus-01 column into a required drop-down field. I am using the Cust_01 field in Spira Test Sets and have a list of 3 options from a drop-down menu. These options are High, Medium, Low.&#xD;
&#xD;
    When I input any of these into the Excel template cus-01 column, and try to export to Spira from excel, I get an error saying the field is required. However the data in the template does upload to Spira but doesn't create the Test Set id in Excel that is used as identification for future uploads/changes to that specific Test set..     Can you advise how to address this? Does the cus-01 field require the id value of the custom list contents rather than the exact text match?    </description><pubDate>Tue, 02 Feb 2016 12:40:09 -0500</pubDate><a10:updated>2016-02-02T17:01:54-05:00</a10:updated><link>/Support/Forum/spirateam/issues-questions/1358.aspx</link></item><item><guid isPermaLink="false">messageId=2465</guid><author>Kat A (elise.brooks@inflectra.com)</author><title>&#xD;
Hi Robbie,    Yes, as you suspected, you do need to  provide the numeric ID of the custom list val</title><description>&#xD;
Hi Robbie,    Yes, as you suspected, you do need to  provide the numeric ID of the custom list values (e.g.&#xD;
PV00005 would be entered as just “5”).          The Excel Add-In works great, but it can be a bit tricky to get everything in the necessary format. For complete details, please see the  Integration Guide .        If you need additional help, let us know.     Regards,  Elise </description><pubDate>Tue, 02 Feb 2016 17:01:54 -0500</pubDate><a10:updated>2016-02-02T17:01:54-05:00</a10:updated><link>/Support/Forum/spirateam/issues-questions/1358.aspx#reply2465</link></item></channel></rss>