Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > Is it possible to use the...

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

Tuesday, March 1, 2011

anssi_heikkila

Is it possible to use the old Excel importer template 2.3.0.0 (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

inflectra.david

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

anssi_heikkila

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

inflectra.david

re: anssi_heikkila Wednesday, March 2, 2011

Great, glad that worked.