It's all about the answers!

Ask a question

how create a new TCER for each test case on a test plan using RQM Excel Import


Brett Bohnn (94111156) | asked May 28 '20, 4:55 p.m.

 Hi,


We are using this config file to create test cases, test scripts and TCERs on an existing test plan, liking to the test plan using LinkExisting("urn:com.ibm.rqm:testplan:10")

// use the data in the first row of a found script's columns A and D for the Test Script information
testscript.XLSArtifactID=F
testscript.dc:title=F
testscript.dc:description=L
testscript.category term="Test Phase".value="User Acceptance Test"
testscript.jzalm:owner="jperof"

// columns F through I are the Test Script Steps ("Validation Steps" in the spreadsheet)
testscript.steps.type=O
testscript.steps.description=P
testscript.steps.title=N
testscript.steps.name=N
testscript.steps.expectedResult=Q

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

// by referring 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 and the existing Test Plan.
testcase.dc:title=G
testcase.dc:description=testscript.dc:description
testcase.priority=U
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=E
testcase.category term="LADWP Test Case ID".value=F
testcase.jzalm:owner="jperof"
testcase.testplan=LinkExisting("urn:com.ibm.rqm:testplan:10")

//static configured testcase definition with link to testcase
executionworkitem.XLSStartRow=8
executionworkitem.XLSLink=testcase
executionworkitem.XLSLink=testscript
executionworkitem.testcase=Link(G)
executionworkitem.testscript=Link(F)
executionworkitem.dc:title=W
executionworkitem.dc:description=testcase.dc:description
executionworkitem.testplan=Link("urn:com.ibm.rqm:testplan:10")
executionworkitem.XLSDelimeter=\n 

When importing from the same spreadsheet a second time to a different test plan ID, e.g urn:com.ibm.rqm:testplan:11 the test cases are used in the new test plan  (this is what we want) and the TCERs are updated to to use the new plan

We need new TCERs to be created for each test case but on the new test plan. 

At this point the only thing that changes on the TCER is the test plan, we are not using iterations or test environments. 

Thanks,
Brett

Accepted answer


permanent link
Mehul Patel (9695) | answered Jun 01 '20, 1:03 a.m.
FORUM MODERATOR

Brett,


As in your script you have not specified the execution work item artifact ID using the configuration syntax, export will create this ID internally and it will be the same on second import with different test plan ID too - hence it will update the existing one rather than creating the new one.

I suggest to use executionworkitem.XLSArtifactID and use some value which keep changing as you change the test plan, this will ensure you have new execution work item created on every import.

Regards,
Mehul

Brett Bohnn selected this answer as the correct answer

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.