It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×11,924
×10,908
×7,382

question asked: Oct 11 '12, 5:33 a.m.
question was seen: 6,356 times
last updated: Mar 20 '14, 11:44 p.m.

Related questions

FAQ - How this Forum works

How do i create a configuration file that can import testcase containing multiple test scripts into RQM

0
Rajesh Avanthi (108●15●138●173) | asked Oct 11 '12, 5:33 a.m.
Hi

I would like to import an excel sheet containing testcases.
Each testcase in-turn consists of multiple test scripts.
Can anyone help me with a sample excel sheet and relevant configuration file?

Thanks in advance

Accepted answer

0
permanent link
anoop mc (748●11●192●221) | answered Oct 11 '12, 9:32 a.m.
Here is the config file content

//***************Test Cases ***************************

testcase.dc:title=C2
testcase.XLSLink=requirement
testcase.XLSLink=testscript

//testcase.category term="Designer".value=E
//testcase.weight=D
//testcase.dc:description=B3



//***************** Test Scripts***************************

// We want to start looking for scripts after row 4

testscript.XLSStartRow=4

testscript.dc:title=B2
testscript.steps.type="execution"
testscript.steps.name=B
testscript.steps.title=B
testscript.steps.expectedResult=C
testscript.steps.description=B


 //*******************Requirements ****************************

//requirement.XLSStartRow=2
//requirement.XLSArtifactID=A
//requirement.dc:title=A
//requirement.dc:description=A
//requirement.XLSWorksheetID="Business Requirement"
//requirement.jzalm:owner=D
//requirement.dc:creator=D


// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n

Rajesh Avanthi selected this answer as the correct answer

4 other answers

Most liked answers|Newest answers|Oldest answers ↑

0
permanent link
anoop mc (748●11●192●221) | answered Oct 11 '12, 6:47 a.m.
HI Rajesh,

If you have installed RQM Excel importer utility - please check out in your samples directory. C:\Program Files (x86)\IBM\RQMExcelImporter\Samples .

You will find a sample excel and corresponding config file.

Also you may refer to this link - https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Supported_Resources


Comments
Rajesh Avanthi commented Oct 11 '12, 7:54 a.m.

Hi Anoop
Thanks for your reply.  In my scenerio, I have a testcase (with description) and each testcase has one or many testscripts (with descriptions).                 
How can we attach many test scripts to one test case in .CFG file ?  
For Example: The excel sheet contains the following columns

        A                     B                              C                  D                            E  
Testcasename  Testscenerio_Desc  Testscript   Testscript_Desc    Exp_Results


 

      
0
permanent link
anoop mc (748●11●192●221) | answered Oct 11 '12, 9:26 a.m.
Please find the format which we have used.

Test Case Import Template
0
permanent link
Hao Wan (1.5k●3●5) | answered Oct 14 '12, 10:23 p.m.
JAZZ DEVELOPER
another option is to use the Link() modifier.
0
permanent link
Vinaya Bhat (5●7●9) | answered Mar 20 '14, 12:35 p.m.
The above excel sheet just imports one testcase(linked to one testsciript).How should my excel and configuration file be  in order to import one testcase(linked to multiple testscripts) and also multiple testcases becasue I see its hardcoded as "testcase.dc:title=C2". I have many testcases(and each testcase linked to multiple testscripts)

Thanks!

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.