Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > Imported Test Sets dont s...
Imported Test Sets using the office addin and the Excel template and then assigned test cases to the Test Sets.
Was reading the integration like in the Integration documentation and noticed it had an extra frame at the bottom of the Test Set screen with the Test Cases in it that wasnt showing for me.
This gave me the clue I needed. With the imported Test Sets they didnt show the Test Cases at the bottom.
So I manually created a Test Set and allocated a Test Case to it and suddenly I had a Test Case linked to the Test Set showing in the bottom of the Test Set.
Wasted a lot of time on this one. Would be good if the import tool was better documented with a worked Excel template example rather than the small set of items in the current template.
Anyone know how to get the Test Cases to link correctly to the imported Test Sets?
Hi Sarah,
Using the latest Excel 2010 Add-In.
I imported the Test Sets first.
Then on the Test Cases I had filled in the Test Set ID with the ID value that had been assigned on the Test Set import.
I then imported the Test Cases and they were not linked.
The Test Sets that were imported do not show the Test Cases frame at all.
Then attempted to manually link these and it said it had linked them just fine, however when I looked the imported Test Sets still do not show the Test Cases frame at all.
I then created a new Test Set and it immediately showed the Test Cases frame. I then manually linked the Test Cases and they appeared within the Test Set's test cases frame.
Cheers,
Grant
Was this case ever resolved? I too am having a problem with getting cases linked to test sets via the template.
Test Sets created via export from spreadsheet. (worked)
Test Case(s) exists. Imported case from SpiraTest to spreadsheet. (worked)
Added Test sets ID to Test Case in spreadsheet and exported back to SpiraTest. No linkage is created. (failed).
Any help would be greatly appreciated.
john
Hi John,
No, that customer never logged a ticket so I have no idea what was tripping them up. That functionality does work though. Could you log a help desk ticket with details about what version of SpiraTest you have, what version of the Add-In, attach screenshots, attach a copy of your spreadsheet, etc. We'll be happy to help you get it straightened out.
Regards,
Elise
Hi Elise, thanks for the reply. I'm going to be on site with my customer next week and will get you everything you need. As it is Friday late afternoon for me now, I'll defer till then. regards -- john
Hello Elise
you can consider this matter resolved. Part operator error, part connectivity/DB problems. But
MSOffice2010AddinsSetup-26939.msi in Excel 2016
SpiraImportTemplate2010-23305.xls
going into | SpiraTest v4.2.0.10
together allow me to associate one or more test cases to a given test set or sets. Trying to connect test cases to a folder does not work; but, then again, it's not supposed to is it? :-)
thank you for your attention to this matter.
And if you have any questions, please email or call us at +1 (202) 558-6885
