Help: how to link existing test plan to test cases using exc
6 answers
Take a look at the excellent samples that are part of the install.
Look for descriptions regarding XLSArtifactID on the utility page. I believe that's what you're looking for.
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
Look for descriptions regarding XLSArtifactID on the utility page. I believe that's what you're looking for.
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
Hi,
How do I link existing test plans to new test cases using the excel importer utility/
Please help me preparing the config file for this purpose.
Thanks,
_Shashank
hi,
you can specify the the existing testplan XLSArtifactID and using testplan.XLSLink=testcase to add testcases to the testplan.
and in the new version of Excel Importer(to be release planned RQM4.0 M8),
if there's testcase and testscript,
use testplan.testcase=testcases instead of testplan.XLSLink=testcase
you can specify the the existing testplan XLSArtifactID and using testplan.XLSLink=testcase to add testcases to the testplan.
and in the new version of Excel Importer(to be release planned RQM4.0 M8),
if there's testcase and testscript,
use testplan.testcase=testcases instead of testplan.XLSLink=testcase
Hi Hao Wan
When I tried to link test cases to an existing test plan as you suggested, the existing testplan apppeared to get overwritten - all category values were set back to Unassigned and all previously linked test cases were no longer linked.
The testplan portion of the config file is below. Do you see something wrong?
testplan.XLSArtifactID=B2
testplan.dc:title=B3
testplan.XLSLink=testcase
When I tried to link test cases to an existing test plan as you suggested, the existing testplan apppeared to get overwritten - all category values were set back to Unassigned and all previously linked test cases were no longer linked.
The testplan portion of the config file is below. Do you see something wrong?
testplan.XLSArtifactID=B2
testplan.dc:title=B3
testplan.XLSLink=testcase
@flemingb,
what about using
testplan.XLSArtifactID=B2
testplan.XLSLink=testcase
what about using
testplan.XLSArtifactID=B2
testplan.XLSLink=testcase
Hi Hao Wan
When I tried to link test cases to an existing test plan as you suggested, the existing testplan apppeared to get overwritten - all category values were set back to Unassigned and all previously linked test cases were no longer linked.
The testplan portion of the config file is below. Do you see something wrong?
testplan.XLSArtifactID=B2
testplan.dc:title=B3
testplan.XLSLink=testcase
This capability is now available in 4.0.1. Search for "LinkExisting" here:
https://jazz.net/wiki/bin/view/Main/RQMWordAndExcelWhatSNewIn40
https://jazz.net/wiki/bin/view/Main/RQMWordAndExcelWhatSNewIn40
Comments
I used this,
testcase.testplan=LinkExisting(1428)
Or
testcase.testplan=LinkExisting("urn:com.ibm.rqm:testplan:1428")
Excel Importer Utility is throwing an error. It is not working. Any suggestions ?
Error: Error: Configuration File, Line 58, Found a value that reduced to "LinkExisting(1428)", but was expecting a value equivelant to a column, cell, or literal.
Exporting Aborted: Errors found!