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

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).

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

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