It's all about the answers!

Ask a question

RQM Excel importer tool: Linking to existing artifacts (test scripts)


SC SC (312) | asked May 22 '13, 4:20 a.m.
Hi to all!
I have a set of test scripts in RQM 3, now I want to define my test cases in an Excel worksheet and then I want to import with the RQM importer tool. Can I link the test cases to the existing test scripts, for example using the scripts ID?
Thanks in advance!

Accepted answer


permanent link
Vidya Malkarnekar (1.0k15) | answered May 22 '13, 7:35 a.m.
JAZZ DEVELOPER
You should be using Link()  modifier as Hao mentioned, not  LinkExisting. 

Here's a sample .cfg file I have used in the past:

***
// Mapping for new Test Case
testcase.XLSWorksheetID="Sheet1"
testcase.XLSStartRow=4
testcase.XLSArtifactID=A
testcase.dc:title=B
testcase.dc:description=C

// Perform linking of artifacts
testcase.testscript=Link(D)

*****

My Excel file is below:





***
SC SC selected this answer as the correct answer

4 other answers



permanent link
Hao Wan (1.5k35) | answered May 22 '13, 4:32 a.m.
JAZZ DEVELOPER
 Hi SC,
you can use the Link() modifier
please refer to 
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter

permanent link
SC SC (312) | answered May 22 '13, 5:01 a.m.
HI Hao! thanks, first of all! I've read the document you linked, and there is a paragraph that is important:

"the LinkExisting modifier only deals with the support for linking master artifact and the artifact must exist on the RQM server side first.
the syntax will be
testcase.testplan=LinkExisting("testplanid"), testplanid1 is the external/internal id of the test plan on RQM server.
testscript.testcase=LinkExisting(E1)
testcase.testsuite=LinkExisting(F)"


I remember to you that I've in my RQM some testscripts ready, I want to import test cases, and link them, but from this paragraph I understand that testcase is considered the master artifact that must exist on the RQM server, so I could import just testscripts and link them, that is the opposite of what I need to do.

Am I wrong in my interpretation in your opinion?

permanent link
SC SC (312) | answered May 22 '13, 8:38 a.m.
Ok, thanks, I'll try it! :)

permanent link
Aparna Sukumaran (332452) | answered Oct 28 '13, 3:04 p.m.
 Will this work for Word as well?

Your answer


Register or to post your answer.