Import Test Cases from Excel

Unfortunately, the test case resource does contain a reference to a containing test plan (see https://jazz.net/wiki/bin/view/Main/RqmApi#Detailed_Schema_Documentation). Otherwise, you could use the Link() keyword (see https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/51360). However, you could specify the test plan with the XLSArtifactID keyword (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Keywords_and_special_cases) set to the it's external ID in your configuration file.

Thanks for the links. I have to say, I'm not much clearer on whether it's possible to import a test case to an existing test plan.

I tried using the XLSArtifactID keyword set to the external ID in the cfg file, but it's not working. I'm guessing I'm not understanding how external IDs work.

The idea is to update the existing test plan with the references to the test cases. For example:

testplan.XLSArtifactID=B1
testplan.dc:title="test plan title"
testplan.XLSLink=testcase

testcase.XLSStartRow=1
testcase.dc:title=A
...

Note, https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/56614. As a side effect, addition test plans (equaling the same number of test cases) are created.