Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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!

0 votes


Accepted answer

Permanent link
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

1 vote


4 other answers

Permanent link
 Hi SC,
you can use the Link() modifier
please refer to 
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter

1 vote


Permanent link
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?

0 votes


Permanent link
Ok, thanks, I'll try it! :)

0 votes


Permanent link
 Will this work for Word as well?

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019

Question asked: May 22 '13, 4:20 a.m.

Question was seen: 8,157 times

Last updated: Oct 28 '13, 3:04 p.m.

Confirmation Cancel Confirm