RQMExcelImporter Import multiple testsuites linked to multiple test cases, link testsuites to testplan
Jacob Huang (15●3●5)
| asked Aug 22 '13, 10:00 p.m.
retagged Aug 27 '13, 2:59 p.m. by Ralph Earle (257●3●9)
Hi, I have an excel document that contains multiple test suites and multiple test cases. Each test suite contains multiple test cases. Is it possible to create a config file that does the following in a single "Export to Repository":
Since each test suite contains multiple test cases, I would like to associate all "bundled" test cases with one copy of its test suite. So far, I am unable to do the following with a single import:
For linking imported test suites to existing test plans, I have tried both syntaxes for specifying an existing testplan via its ID:
-------------------------------------------------------------
cfg file below
-------------------------------------------------------------
-------------------------------------------------------------
imitation of excel worksheet below
notes: I would be happy to upload an actual spreadsheet if able
Also, column A values are merged in the spreadsheet
-------------------------------------------------------------
A B C
testsuite1 | ts1.1 | ab
| ts1.2 | cd
testsuite2 | ts2.1 | ef
| ts2.2 | gh
| ts2.3 | ij
|
Accepted answer
I tested this extensively using version 4.0.3 and 4.0.5 of the Importer and MS Excel 2010. Using Link() is supported for Test Plans linking to Test Case per example in Excel best practices pdf . However, it is not currently supported for Test Suites (Internal Server Error: 500) is encountered.
I hope this helps. Thank you, Diane Jacob Huang selected this answer as the correct answer
|
5 other answers
Hi Jacob,
1st, XLSArtifactID should work with external, but the value you specified is a type of internal id. you can change it to testplan1 and try again
|
|
Hi Hao,
I tried both of the following, and received errors as listed:
Unless I misunderstood the field I am supposed to change, changing the reference field to "testplan1" or "testplan2" as it is named in our environment, i.e. the name of the test plan, did not work.
|
I have the same problem. Any solution for that. I also tried "Link" and "LinkExisting". Neither were working for this case.
|
I am also facing the same problem. I have used the below syntax, to specific which existing test plan the newly created test cases/suites are supposed to be linked to. It doesn't work. Can someone please help. Thanks.
testplan.XLSArtifactID="urn:com.ibm.rqm:testplan:209"
Comments Hi Maria,
To link test cases to the existing test plan, you can try something like:
-------------------
testcase.XLSArtifactID=A
testcase.dc:title=B
testcase.dc:description=E
testcase.testplan=LinkExisting("urn:com.ibm.rqm:testplan:209")
-------------------
The Excel Importer best practice document has detail explanation about the "LinkExisting" usage.
Thank you for your response Lily.
I have tried this code but I am getting "(500) Internal Server Error"
|
Is this TestPlan to TestSuite linking issue is solved. Any Idea?
|
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.
Comments
By the way, I am using RQMExcelImporter 4.0.0 (CLM 4.0.0.1)