Inflectra Customer Forums: Excel Import Template Does not Update the Lookups Worksheet (Thread) When importing data into SpiraTeam via the Excel import template some of the values are converted from a string to a numeric value. The Lookups worksheet lists all the conversion values. When importing to any project other than the initial default project the values are all incorrect and do not update. This causes corruption of the imported data. Whenever an import/export is performed, the Lookups worksheet should first be updated to reflect the values for the selected project. The workaround is to manually go into the DB and find the correct values for the desired project and update the worksheet accordingly. en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/76.aspxthreadId=76Justin Bergen (justin.bergen@flukenetworks.com)Excel Import Template Does not Update the Lookups Worksheet When importing data into SpiraTeam via the Excel import template some of the values are converted from a string to a numeric value. The Lookups worksheet lists all the conversion values. When importing to any project other than the initial default project the values are all incorrect and do not update. This causes corruption of the imported data. Whenever an import/export is performed, the Lookups worksheet should first be updated to reflect the values for the selected project. The workaround is to manually go into the DB and find the correct values for the desired project and update the worksheet accordingly. Tue, 17 May 2011 17:28:46 -04002019-01-04T17:34:31-05:00/Support/Forum/spirateam/issues-questions/76.aspxmessageId=147David J (support1@inflectra.com) If you change the project name in the dropdown list in the top of the Excel Add-In, it will automat If you change the project name in the dropdown list in the top of the Excel Add-In, it will automatically recalculate all the mappings for the incident lookups for the project. Tue, 17 May 2011 17:42:17 -04002011-05-17T17:42:17-04:00/Support/Forum/spirateam/issues-questions/76.aspx#reply147messageId=148Justin Bergen (justin.bergen@flukenetworks.com) This appears to be a compatibility issue with Office 2010. It does in fact get updated after selec This appears to be a compatibility issue with Office 2010. It does in fact get updated after selecting a project in Excel 2007. But I have tried two different Excel 2010 computers, and neither updated the Lookups worksheet. Tue, 17 May 2011 22:03:01 -04002011-05-17T22:03:01-04:00/Support/Forum/spirateam/issues-questions/76.aspx#reply148messageId=150David J (support1@inflectra.com)Are you sure the Sheet was set to allow Editing (a new option in the way Excel 2010 works)? I have nAre you sure the Sheet was set to allow Editing (a new option in the way Excel 2010 works)? I have not been able to reproduce the issue with Excel 2010 here. If you change the project dropdown, the Incident lookups change correctly.Wed, 18 May 2011 14:58:04 -04002011-05-18T14:58:04-04:00/Support/Forum/spirateam/issues-questions/76.aspx#reply150messageId=3485Pascal B (pascal@expertaas.com) where did you got an Excel Import Template? And where would you load such a template into TestSpira where did you got an Excel Import Template? And where would you load such a template into TestSpira Hosted Solution? I have around 360 Requirements in an Excel and need to load them into my fresh TestSpira Subscription. How to do that? copy pasting 360 Rqmts cant be the solution Fri, 04 Jan 2019 15:48:16 -05002019-01-04T15:48:16-05:00/Support/Forum/spirateam/issues-questions/76.aspx#reply3485messageId=3486Kat A (support2@inflectra.com) Hi Pascal, This thread refers to the Office Add-In, which is available on the downloads page of ou Hi Pascal, This thread refers to the Office Add-In, which is available on the downloads page of our website . For complete instructions, please see the Integration Guide , chapter 2. Regards, Elise Fri, 04 Jan 2019 17:34:31 -05002019-01-07T18:41:43-05:00/Support/Forum/spirateam/issues-questions/76.aspx#reply3486