How to import test cases inside the sections in RQM tool using RQM Excel importer.
Dear Team,
<o:p> </o:p>
// Start looking for scripts after row 16 <o:p> </o:p>
<o:p> </o:p>
testcase.XLSStartRow=17
<o:p> </o:p> testcase.XLSArtifactID=D
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCase.edit.testscript","Test steps")=G
testcase.steps.type="execution"
testcase.steps.description=G <o:p> </o:p>
testcase.steps.expectedResult=H <o:p> </o:p>
<o:p> </o:p>
// a new script starts when we encounter an empty row <o:p> </o:p>
testscript.XLSDelimeter=\n
testcase.dc:title=D
<o:p> </o:p>
// testcase.dc:description=testscript.dc:description <o:p> </o:p>
<o:p> </o:p> testcase.category term="Module Name".value=C
testcase.category term="Priority".value="L1"
<o:p> </o:p> testcase.customAttributes identifier="_5oHgsakrEem5MoDPCybrsg".name="Test Case ID".type="MEDIUM_STRING".value=D
<o:p> </o:p>
testcase.customAttributes identifier="_5pA4kKkrEem5MoDPCybrsg".name="Test Case Description".type="MEDIUM_STRING".value=E <o:p> </o:p>
testcase.customAttributes identifier="_5pKCgakrEem5MoDPCybrsg".name="Pre conditions".type="MEDIUM_STRING".value=F <o:p> </o:p>
testsuite.dc:title=C12
<o:p> </o:p>
testsuite.dc:description=C13 <o:p> </o:p>
testsuite.XLSLink=testcase <o:p> </o:p>
Please assist us.
2 answers
// 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 after row 2
testscript.XLSStartRow=13
// use the data in the first row of a found script's column B
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=C
// 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.description=D
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=F
testscript.steps.comment=E
// 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 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.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
testcase.Section("com.ibm.rqm.planning.editor.section.testSuitePreCondition", " RQM-KEY-TSUITE-PRE-COND-TITLE")=L
Hi Preetha,
&
The ampersand symbol is used to add two or more bits of data to the same field. The data can be a mix of items such as: testcase.description=”my description:” & C4 & testscript.description
Comments
Preetha T
Jul 18 '19, 8:44 a.m.