RQM excel import-how to import testscript based on testcase (testcase is on the same row with testscript)
I just tried the RQM excel importer to RQM 404 In one customer POC. and I had some customer questions as below:
1) I checked all sample configuration file with generating testcase. seems all sample files just create testscript firstly, then generate testcase based on test script. like below:
testscript.XLSStartRow=7
testscript.dc:title=B
// 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=B
testscript.steps.title=B
testscript.steps.name=B
testscript.steps.expectedResult=RichText(F)
// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
// test case defined with definite cell locations
testcase.dc:title=C1
testcase.dc:description=C2
testcase.XLSLink=testscript
the big limit is that the importor just support testscript.XLSDelimeter=\n, so we have to split different testscript with blank line! the original excel testcase doesn't include blank line at all!
2) so I have to generate testcase firstly, then generate testscript, and connect testscript with testcase. I created my cfg file, the problem is that it generated errors each time, If I delete the testscript part, just left the testcase part, it succeeds! why?
// we want to use the data we got for each test script to create a test case
testcase.XLSStartRow=2
testcase.XLSArtifactID=C
testcase.dc:title=D
testcase.dc:description=G
testcase.category term="CaseType".value=A
testcase.category term="Subject".value=B
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=H
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=E
//once the below testscript part is added, it failed.
testscript.dc:title=testcase.dc:title
testscript.dc:description=testcase.dc:description
testscript.steps.type="execution"
testscript.steps.description=G
testscript.steps.title=testcase.dc:title
testscript.steps.name=testcase.dc:title
testscript.steps.expectedResult=H
1) I checked all sample configuration file with generating testcase. seems all sample files just create testscript firstly, then generate testcase based on test script. like below:
testscript.XLSStartRow=7
testscript.dc:title=B
// 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=B
testscript.steps.title=B
testscript.steps.name=B
testscript.steps.expectedResult=RichText(F)
// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
// test case defined with definite cell locations
testcase.dc:title=C1
testcase.dc:description=C2
testcase.XLSLink=testscript
the big limit is that the importor just support testscript.XLSDelimeter=\n, so we have to split different testscript with blank line! the original excel testcase doesn't include blank line at all!
2) so I have to generate testcase firstly, then generate testscript, and connect testscript with testcase. I created my cfg file, the problem is that it generated errors each time, If I delete the testscript part, just left the testcase part, it succeeds! why?
// we want to use the data we got for each test script to create a test case
testcase.XLSStartRow=2
testcase.XLSArtifactID=C
testcase.dc:title=D
testcase.dc:description=G
testcase.category term="CaseType".value=A
testcase.category term="Subject".value=B
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=H
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=E
//once the below testscript part is added, it failed.
testscript.dc:title=testcase.dc:title
testscript.dc:description=testcase.dc:description
testscript.steps.type="execution"
testscript.steps.description=G
testscript.steps.title=testcase.dc:title
testscript.steps.name=testcase.dc:title
testscript.steps.expectedResult=H
2 answers
Hi Zhuang,
I didn't understand the question in part 1. Can you please clarify?
For part 2, you need to have Test Case title set to Test Script title.
Following config file works for me:
testscript.XLSStartRow=2
testscript.dc:title=D
testscript.dc:description=G
testscript.steps.type="execution"
testscript.steps.description=G
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=H
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
<rest of the Test Case stuff after this>
Vidya malkarnekar :
testscript.steps.title=D
testscript.steps.title=D
testscript.steps.name=D
What is the difference between the above two code? didnt feel any difference?
What is the difference between the above two code? didnt feel any difference?