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? en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/1058.aspxthreadId=1058Grant Cause (g.cause@cairns.qld.gov.au)import excel 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? Fri, 31 Oct 2014 06:03:17 -04002017-12-18T20:10:38-05:00/Support/Forum/spiratest/issues-questions/1058.aspxmessageId=1905Inflectra Sarah (donotreply6@kronodesk.net) Hi Grant In the Excel 2010 Add-In there should be a column for including the Test Set ID as one of the fields. Regards Sarah Fri, 31 Oct 2014 15:21:09 -04002014-10-31T15:21:09-04:00/Support/Forum/spiratest/issues-questions/1058.aspx#reply1905messageId=1907Grant Cause (g.cause@cairns.qld.gov.au) 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 Mon, 03 Nov 2014 01:27:31 -05002014-11-03T01:27:31-05:00/Support/Forum/spiratest/issues-questions/1058.aspx#reply1907messageId=1910Kat A (elise.brooks@inflectra.com) Hi Grant, The procedure you followed should have worked. That is, the test cases should have been linked to the test sets upon importing. To help us get to the bottom of this, could you please log a Help Desk ticket? Please include the SpiraTest version number, the spreadsheet itself, and a screenshot of a test set detail page. Also, can you please explain what you mean by the "Test Case frame". Thanks! Elise Mon, 03 Nov 2014 15:15:39 -05002014-11-03T15:15:39-05:00/Support/Forum/spiratest/issues-questions/1058.aspx#reply1910messageId=3187john beichman (jbeichman@excergy.com) 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 Thu, 14 Dec 2017 18:04:56 -05002017-12-14T18:04:56-05:00/Support/Forum/spiratest/issues-questions/1058.aspx#reply3187messageId=3191Kat A (elise.brooks@inflectra.com) 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. Well be happy to help you get it straightened out. Regards, Elise Fri, 15 Dec 2017 19:06:15 -05002017-12-15T19:06:15-05:00/Support/Forum/spiratest/issues-questions/1058.aspx#reply3191messageId=3192john beichman (jbeichman@excergy.com) Hi Elise, thanks for the reply. Im 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, Ill defer till then. regards -- john Fri, 15 Dec 2017 20:42:55 -05002017-12-15T20:42:55-05:00/Support/Forum/spiratest/issues-questions/1058.aspx#reply3192messageId=3195john beichman (jbeichman@excergy.com) 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 v 4.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, its not supposed to is it? :-) thank you for your attention to this matter. Mon, 18 Dec 2017 20:10:37 -05002017-12-18T20:10:37-05:00/Support/Forum/spiratest/issues-questions/1058.aspx#reply3195