It's all about the answers!

Ask a question

Excel import to RQM completes without test case updated


Bharathi Kumar (12) | asked May 17 '16, 5:55 a.m.
edited May 24 '16, 2:25 a.m.
Testcases from excel was imported though the excel importer, but on importing the testcases using import to repository, there is no test cases imported to RQM but status says Completed, please help


Hi, please find the below script used for the import..please advise if the below is correct.

// 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
testscript.XLSWorksheetID=Test Scripts

// use the data in the first row of a found script's column B
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=F

// 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=Pre(H)
testscript.steps.title=G
testscript.steps.name=G
testscript.steps.expectedResult=Pre(I)
//testscript.steps.property name="comment"=K

// 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.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=Pre(C)
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=Pre(D)
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=Pre(E)
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description

Comments
Don Yang commented May 17 '16, 8:48 p.m.

what is RQM and ExcelImporter version and if you tried with any sample cfg/xls and it has the same result or it only happens to your own cfg/xls files? if it only happens to your own files, you may want to post the files here for reference.

One answer



permanent link
Ara Masrof (3.2k15) | answered May 24 '16, 11:12 a.m.
JAZZ DEVELOPER
As Don noted, first off, I would import one of the samples included with the utility to ensure the environment is set up and working correctly
If the works, then take a look at the corresponding log files after the import is complete
The logs can be found here:
 C:\Documents and Settings\<USER>\Application Data\Mso2Rqm
Note: Windows 7 users will find the log directory at C:\Users\<USER>\AppData\Roaming\Mso2Rqm

The Mso2Rqm_Debug.log would be one of the files to focus on

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.