It's all about the answers!

Ask a question

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


Rohit Rishabh (1531336) | asked Oct 25 '16, 5:30 p.m.
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

Accepted answer


permanent link
Don Yang (7.7k21114139) | answered Oct 26 '16, 1:08 a.m.
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

Comments
Rohit Rishabh commented Oct 26 '16, 11:17 a.m.

Thanks, this worked :)

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.