How do i create a configuration file that can import testcase containing multiple test scripts into RQM
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
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
|
Please find the format which we have used.
|
another option is to use the Link() modifier.
|
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! |