It's all about the answers!

Ask a question

Help: how to link existing test plan to test cases using exc


Shashank Bellary (46167) | asked Feb 11 '12, 10:03 a.m.
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

6 answers



permanent link
Michael Tingey (8332) | answered Feb 12 '12, 8:35 p.m.
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

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

permanent link
Hao Wan (1.5k35) | answered Feb 15 '12, 11:10 p.m.
JAZZ DEVELOPER
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

permanent link
Brian Fleming (1.6k11928) | answered Feb 16 '12, 8:35 a.m.
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

permanent link
Hao Wan (1.5k35) | answered Mar 12 '12, 5:40 a.m.
JAZZ DEVELOPER
@flemingb,
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

permanent link
Brian Fleming (1.6k11928) | answered Mar 12 '12, 10:03 a.m.
@wanhaobj
Using just:
testplan.XLSArtifactID=B2
testplan.XLSLink=testcase

results in the same behavior. Any test cases linked to the test plan prior to the upload are no longer linked.

What else can we try?

permanent link
Brian Fleming (1.6k11928) | answered Dec 05 '12, 4:33 p.m.
This capability is now available in 4.0.1.  Search for "LinkExisting" here:
https://jazz.net/wiki/bin/view/Main/RQMWordAndExcelWhatSNewIn40

Comments
Shashank Bellary commented Feb 15 '13, 2:23 p.m.

 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!

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.