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

While exporting a test case in RQM from excel using RQMExcel importer plugin, how can we link it to an existing test plan

We are using RQM excel importer plugin to import test case and script into RQM. We would like the imported test cases to be automatically linked to an existing test plan in RQM.
What are the changes that we need to make in our configuration file.

The current configuration file creates a test case and test script and link them together. A new test scripts start whenever it finds an empty row.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data
// Start looking for scripts from row 2
testscript.XLSStartRow=2

// use the data in the first row of a found script's column B
testscript.XLSArtifactID=B
testscript.dc:title=D
testscript.dc:description=C
testscript.category term="Product".value=J


// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.title=E
testscript.steps.description=E
testscript.steps.expectedResult=F

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
   
// we want to use the data we got for each test script to create a test case
testcase.ID=testscript.XLSArtifactID

// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=B
testcase.dc:description=testscript.dc:description


//adding test case category values
testcase.category term="1. Project Team".value=H
testcase.category term="2. Release".value=I
testcase.category term="3. Product".value=J
testcase.category term="4. Module".value=K
testcase.category term="5. Function".value=L
testcase.category term="6. Test Phase".value=M
testcase.category term="8. Usage Frequency".value=Q
testcase.category term="9. Type of Change".value=R
testcase.category term="10. Design Complexity".value=P
testcase.category term="11. Risk".value=S
testcase.priority=O

//adding test case attribute values
testcase.customAttributes identifier="SR_Number".name="SR Number".type="MEDIUM_STRING".value=G

0 votes


Accepted answer

Permanent link
Hi, Rohit

You can use testcase.testplan=LinkExisting(E1)
in which E1 has existing test plan internal id (such as urn:com.ibm.rqm:testplan:1) or external id (suppose you know
testplan was previously exported into RQM and external id was specified)
Rohit Rishabh selected this answer as the correct answer

1 vote

Comments

Thanks, this worked :)

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,020

Question asked: Oct 25 '16, 5:30 p.m.

Question was seen: 1,485 times

Last updated: Oct 26 '16, 11:17 a.m.

Related questions
Confirmation Cancel Confirm