Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Qu... > Excel Import Template Doe...

Excel Import Template Does not Update the Lookups Worksheet

Tuesday, May 17, 2011
Avatar
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.
(To Reply to this thread you first need to Sign-In )
5 Replies
Tuesday, May 17, 2011
Avatar
re: jbergen 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.
Tuesday, May 17, 2011
Avatar
re: inflectra.david 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.
Wednesday, May 18, 2011
Avatar
re: jbergen Tuesday, May 17, 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.
Friday, January 4, 2019
Avatar
re: jbergen Tuesday, May 17, 2011

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 can't be the solution
Friday, January 4, 2019
Avatar
re: pascal Friday, January 4, 2019

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

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 
Statistics
  • Started: Tuesday, May 17, 2011
  • Last Reply: Friday, January 4, 2019
  • Replies: 5
  • Views: 4231
Tel: 1-866-572-5878 | Help Desk | Legal Notices | Privacy Policy
Powered by KronoDesk v4.0.1 help desk software | © Copyright 2006-2024 | Licensed to Inflectra Corporation.