Is it possible to use the old Excel importer template with SpiraTest 3.0?

Tuesday, March 1, 2011
Is it possible to use the old Excel importer template (XLS-file which contains the importing code in the XLS-file, not in the add-in) with SpiraTest 3.0?

I would like import test run results only for the test cases level, not for each test step, which seems impossible to do with the new addin based template.

When trying to load projects from the old template, I get run-time error 438 "object does not support this method or property" at line Set xmlDataSetNodeList = wsImport.RetrieveIncidentTypes()

I have Excel 2007 in Windows 7 Enterprise. The old template worked fine with previous 2.3.x SpiraTest version.
3 Replies
Tuesday, March 1, 2011
re: anssi_heikkila Tuesday, March 1, 2011

Unfortunately the old Excel sheet is no longer supported with v3.0

You could manually modify the old VBA code to not use any of the functions that were removed in v3.0. Specifically you can just comment out the code to retrieve incident types, statuses, etc. since you're not using that portion.

Wednesday, March 2, 2011
re: inflectra.david Tuesday, March 1, 2011
Thanks, test runs can be imported after commenting out the incident related code from the login page.
Wednesday, March 16, 2011
re: anssi_heikkila Wednesday, March 2, 2011
Great, glad that worked.

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


  • Started: Tuesday, March 1, 2011
  • Last Reply: Wednesday, March 16, 2011
  • Replies: 3
  • Views: 2075