It's all about the answers!

Ask a question

RQMExcelImporter: export multiple testcases each with multiple test scripts into RQM


Don Yang (7.7k21114139) | asked Mar 31 '15, 7:00 a.m.
RQMExcelImport v4.0.5 and  5.0.1 used.
There is a use case that we need to export multiple test cases and each test case with multiple test scripts.
For example:
TC1 with TS1, and TS2
TC2 with TS3 and TS4
and so on
1) In this post:https://jazz.net/forum/questions/92751/exporting-multiple-test-case-with-test-scripts-into-rqm
it is suggested that we need to have separate worksheet for test case and test script,
is this still the case in latest version of ExcelImporter that one worksheet with both test cases and testscripts(sample similar to the above post question which was advised that it is not possible) can not have the result for our use case?

2) if we need to have two worksheets for test case and test script, according to the above post, we need to use link() keyword. what it could be like in cfg to let the tool know TC1 will have TS1 and TS2 linked and TC2 will have TS3 and TS4 link and so on. Using testcase.testscript=Link(C) for example, I am afraid it may end up with TC1 and TC2 will both have all test scripts linked.

Please shed some lights on this. thanks


Accepted answer


permanent link
Reshma Ratnani (1.1k1) | answered Mar 31 '15, 8:36 a.m.
JAZZ DEVELOPER
Hi Don,

We still dont have any solution to support the scenario in example. You will have to go with the solution suggested in https://jazz.net/forum/questions/92751/exporting-multiple-test-case-with-test-scripts-into-rqm

Using testcase.testscript=Link(C) , you need to specify the IDs of the associated Testscripts for the Testcase in single cell separated by newline. So if testcase is linked to 2 testscript then for that Testcase row, the Testscript cell should have 2 ID values separated by newline
Don Yang selected this answer as the correct answer

Comments
Reshma Ratnani commented Mar 31 '15, 8:43 a.m.
JAZZ DEVELOPER

Another thing you can try is instead of having testscript and testcases in separate worksheets, distribute TestCase-TestScript set in different worksheet.

So one worksheet will have data of TC1 with TS1, and TS2 and other worksheet will have data of TC2 with TS3 and TS4


Don Yang commented Mar 31 '15, 8:08 p.m.

Thanks Reshma for the confirmation and suggestions.
Putting each set of TC and TS into one worksheet is not practical if there are hundreds of TCs and TSs to export at one go.
I tested with the two worksheets way by specifying the testscript IDs in the same row of testcase and it works.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.