Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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

0 votes



2 answers

Permanent link
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>

0 votes


Permanent link
Vidya malkarnekar :
                             testscript.steps.title=D
                             testscript.steps.name=D
What is the difference between the above two code? didnt feel any difference?

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 10,938
× 64
× 17

Question asked: Sep 19 '13, 11:28 a.m.

Question was seen: 8,654 times

Last updated: Nov 11 '13, 1:15 a.m.

Confirmation Cancel Confirm