Skip Navigation LinksForums > SpiraTeam Forums > SpiraTeam Issues & Questi... > Excel Import Template Doe...

Excel Import Template Does not Update the Lookups Worksheet RSS Feed

Tuesday, May 17, 2011
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.

3 Replies
Adam SAdam S
re: Justin Bergen on Tuesday, May 17, 2011
Tuesday, May 17, 2011

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.

Justin BergenJustin Bergen
re: Adam S on Tuesday, May 17, 2011
Tuesday, May 17, 2011
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.
Adam SAdam S
re: Justin Bergen on Tuesday, May 17, 2011
Wednesday, May 18, 2011
Are 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.
  • Started: 5/17/2011
  • Last Reply: 5/18/2011
  • Replies: 3
  • Views: 1876
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2017 | Licensed to Inflectra Corporation.