How do i create a configuration file that can import testcase containing multiple test scripts into RQM
Accepted answer
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
//***************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
4 other answers
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
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
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
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!
Thanks!