how create a new TCER for each test case on a test plan using RQM Excel Import
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
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