Problem occured to import excel into RQM
Hi,
I want to import test cases along with test scripts from Excel file to RQM, but my requirement is not getting catered due to wrong config file, as I have made one config file, which created both the test cases and test scripts but not able to associate those. I have attached the excel test case which would be uploaded and the config file, which I used.
Please help me to upload the excel into RQM, minimal change of format is possible.
Regards,
Sumita
excel format is
Test Case name Summary (description) Test Case design Pre-condition Test Data Expected results Test-script-Name Step Number Step description Expected Result Review Comments
The sample config file is
/ This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data
// Start looking for scripts after row 2
testscript.XLSStartRow=2
// use the data in the first row of a found script's column B
testscript.XLSArtifactID=G
testscript.dc:title=G
// 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=I
testscript.steps.title=H
testscript.steps.name=H
testscript.steps.expectedResult=J
// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
// we want to use the data we got for each test script to create a test case
//testcase.ID=testscript.XLSArtifactID
// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
//testcase.dc:title=testscript.dc:title
//testcase.dc:description=testscript.dc:description
// test case defined with definite cell locations
testcase.dc:title=A2
testcase.dc:description=B2
testcase.XLSLink=testscript
E
I want to import test cases along with test scripts from Excel file to RQM, but my requirement is not getting catered due to wrong config file, as I have made one config file, which created both the test cases and test scripts but not able to associate those. I have attached the excel test case which would be uploaded and the config file, which I used.
Please help me to upload the excel into RQM, minimal change of format is possible.
Regards,
Sumita
excel format is
Test Case name Summary (description) Test Case design Pre-condition Test Data Expected results Test-script-Name Step Number Step description Expected Result Review Comments
The sample config file is
/ This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data
// Start looking for scripts after row 2
testscript.XLSStartRow=2
// use the data in the first row of a found script's column B
testscript.XLSArtifactID=G
testscript.dc:title=G
// 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=I
testscript.steps.title=H
testscript.steps.name=H
testscript.steps.expectedResult=J
// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
// we want to use the data we got for each test script to create a test case
//testcase.ID=testscript.XLSArtifactID
// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
//testcase.dc:title=testscript.dc:title
//testcase.dc:description=testscript.dc:description
// test case defined with definite cell locations
testcase.dc:title=A2
testcase.dc:description=B2
testcase.XLSLink=testscript
E
One answer
Note: This post is 4+ years old.
Please upgrade to the latest version of RQM (see https://jazz.net/downloads/rational-quality-manager/) and review the product documentation (see https://jazz.net/help-dev/clm/topic/com.ibm.help.common.jazz.calm.doc/com.ibm.help.common.jazz.calm.doc_eclipse-gentopic1.html) and jazz.net resources (see https://jazz.net/help). If your issue persists, please ask a new question (https://jazz.net/forum/questions/ask), open a defect (see https://jazz.net/mystuff/#tab=workitems), or open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639).
Please upgrade to the latest version of RQM (see https://jazz.net/downloads/rational-quality-manager/) and review the product documentation (see https://jazz.net/help-dev/clm/topic/com.ibm.help.common.jazz.calm.doc/com.ibm.help.common.jazz.calm.doc_eclipse-gentopic1.html) and jazz.net resources (see https://jazz.net/help). If your issue persists, please ask a new question (https://jazz.net/forum/questions/ask), open a defect (see https://jazz.net/mystuff/#tab=workitems), or open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639).