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 (333760) | answered Oct 28 '13, 3:04 p.m.
 Will this work for Word as well?

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.