RQMExcelImporter Import multiple testsuites linked to multiple test cases, link testsuites to testplan
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":
- Import multiple test suites
- For each test suite, import associated test cases and link those test cases to the appropriate test suite.
- Must not duplicate associated test suite for each test case
- Link test suites to existing test plans.
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:
- Link multiple test cases with its single appropriate test suite without duplicating test suites.
- Link test suites to existing test plans.
For linking imported test suites to existing test plans, I have tried both syntaxes for specifying an existing testplan via its ID:
testplan.XLSArtifactID="urn:com.ibm.rqm:testplan:1"Error: Error sending to server "urn:com.ibm.rqm:testplan:1" of type testplan
The remote server returned an error: (400) Bad Request.
testplan.XLSArtifactID=urn:com.ibm.rqm:testplan:1Error: Configuration File, Line 35. Found a value that reduced to "urn:com.ibm.rqm:testplan:1", but was expecting a value equivalent to a column, cell, or literal.
-------------------------------------------------------------
cfg file below
-------------------------------------------------------------
testcase.XLSStartRow=2testcase.XLSWorksheetID="Sheet1"
testcase.ID=Atestcase.dc:title=Ctestcase.dc:description=B
testsuite.ID=testcase.XLSArtifactIDtestsuite.dc:title=testcase.dc:title
testplan.XLSArtifactID="urn:com.ibm.rqm:testplan:1"testplan.XLSLink=testcase
-------------------------------------------------------------
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
I hope this helps.
Thank you,
Diane
5 other answers
Hi Hao,
I tried both of the following, and received errors as listed:
Scenario 1// import testsuitestestsuite.XLSStartRow=2testsuite.XLSArtifact=Atestsuite.dc:title=A
// create link to existing testplantestplan.dc:title="urn:com.ibm.rqm:testplan:testplan2"testplan.XLSLink=testsuite
Error:Error sending to server test excel import_Sheet 1_2.xml of type testsuiteThe remote server returned an error: (500) Internal Server Error.
Scenario 2
// config file contents the same as Scenario 1 except changed the testplan section// create link to existing testplantestplan.XLSArtifactID="urn:com.ibm.rqm:testplan:testplan2"testplan.XLSLink=testsuite
Error:Error sending to server test excel import_Sheet 1_2.xml of type testsuiteThe remote server returned an error: (500) Internal Server Error.
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 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"
Comments
Jacob Huang
Aug 23 '13, 9:31 a.m.By the way, I am using RQMExcelImporter 4.0.0 (CLM 4.0.0.1)