Excel import to RQM completes without test case updated
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 |
One answer
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
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.
Comments
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.