Importing From Excel: Making Test Case = Test Script
We need to import over a thousand test cases from Testopia to RQM. Since Testopia does not distinguish between 'Test Cases' and 'Test Scripts', we would like to make each line in our excel spreadsheet both a Test Case and a Test Script (and link them together).
Everytime I try a new mapping the results are the same, the first row is used as a Test Case and all the remaining rows are used as Test Scripts to the Test Case. I've place multiple new XLSDelimeters in the mapping to no affect. What am I doing wrong? //--- Test Script testscript.XLSStartRow=2 testscript.scripttype="Manual" testscript.steps.type="execution" testscript.alm:state="Approved" testscript.title=A testscript.dc:description=B testscript.steps.description=E testscript.steps.expectedResult=F //--- Test Case testcase.identifier=testscript.title testcase.dc:title=testscript.dc:description testcase.dc:description=testscript.dc:description testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=C testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=testscript.steps.description testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXPECTED-RESULTS-TITLE")=testscript.steps.expectedResult testcase.category term="Category".value=L testcase.jzalm:owner=I testcase.XLSDelimeter=\n testcase.XLSLink=testscript -Laurie |
5 answers
Try placing the following as the first line for the Test Cases section:
testcase.XLSStartRow=2 We need to import over a thousand test cases from Testopia to RQM. Since Testopia does not distinguish between 'Test Cases' and 'Test Scripts', we would like to make each line in our excel spreadsheet both a Test Case and a Test Script (and link them together). |
Try placing the following as the first line for the Test Cases section: It made no difference. The first row is still viewed as the Test Case and the remaining rows are linked as Test Scripts. -Laurie |
We need to import over a thousand test cases from Testopia to RQM. Since Testopia does not distinguish between 'Test Cases' and 'Test Scripts', we would like to make each line in our excel spreadsheet both a Test Case and a Test Script (and link them together). Try something like: Configuration: testscript.XLSStartRow=1 testscript.dc:title=A testscript.dc:description=B testcase.dc:description=testscript.dc:description testcase.XLSStartRow=1 testcase.dc:title=A Excel: A B 1 title1 description1 2 title2 description2 |
Hi Laurie,
do you have each testcase/testscript separated by a new line? and which version of Excel Importer are you using. |
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.