It's all about the answers!

Ask a question

RQM excel import-how to import testscript based on testcase (testcase is on the same row with testscript)


zhuang JunQian (1188) | asked Sep 19 '13, 11:28 a.m.
retagged Sep 26 '13, 2:20 p.m. by Lisa Caten (342913)
each row is a testcase 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

2 answers



permanent link
Vidya Malkarnekar (1.0k15) | answered Sep 23 '13, 1:11 p.m.
JAZZ DEVELOPER
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>

permanent link
archana kurup (2026972) | answered Nov 11 '13, 1:15 a.m.
Vidya malkarnekar :
                             testscript.steps.title=D
                             testscript.steps.name=D
What is the difference between the above two code? didnt feel any difference?

Your answer


Register or to post 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.