why its shows error wile Importing test cases from excel into RQM ?
Hi Team,
I am trying to import test case from excel into RQM 6.0.1 but its showing the following error.
I am trying to import test case from excel into RQM 6.0.1 but its showing the following error.
- The uploaded content does not consist of well-formed XML or does not match the XML schema for testcase
- Server response was not properly formatted.
Please share related document if you have.
Thanks!
Accepted answer
Hi Krunal,
Have you tried exporting the samples provided with the installation? There is a Samples folder created when you install the utility. Path for that folder is
Have you tried exporting the samples provided with the installation? There is a Samples folder created when you install the utility. Path for that folder is
<rqm Excel="" Import="" Utility="" installation="" directory="">\Samples
By default, the RQM Excel Import Utility is installed in:
C:\Program Files\IBM\RQMExcelImporter
Comments
testcase.XLSStartRow=2
testcase.dc:title=A
testcase.dc:description=B
testcase.steps.type="execution"
testcase.steps.description=E
testcase.steps.expectedResult=F
testcase.XLSArtifactID=C
testcase.steps.state = H
I used above configuration file.Is this file is in correct format or i need to make some changes into that?
One other answer
Hi Krunal,
Make sure you are running the right "Microsoft Excel and Word to Rational Quality Manager Import Utility" version for your RQM version.
If not, you can download it using the following URL:
https://jazz.net/downloads/rational-quality-manager/milestones/6.0.1M3?p=allDownloads
I suggest you to uninstall the previous version first,
Open Control Panel > Add or Remove Programs
Select RQMExcelImporter
Click the Remove button and confirm desire to remove the application
Delete all the log files in the log directory
C:\Users\<USER>\AppData\Roaming\Mso2Rqm
Have you tried using a sample file ( C:\Program Files\IBM\RQMExcelImporter\Samples) ? What was the results?
For testing purposes, you can always do something like I did below (just an example), so you will narrow down the problem (import some data just using .cfg file):
//testcase.XLSStartRow=2
testcase.dc:title="test case title"
testcase.dc:description="description"
testcase.steps.type="execution"
testcase.steps.description="steps description"
testcase.steps.expectedResult="expectedResults"
testcase.XLSArtifactID="id"
testcase.steps.state="state"
Thank you
Make sure you are running the right "Microsoft Excel and Word to Rational Quality Manager Import Utility" version for your RQM version.
If not, you can download it using the following URL:
https://jazz.net/downloads/rational-quality-manager/milestones/6.0.1M3?p=allDownloads
I suggest you to uninstall the previous version first,
Open Control Panel > Add or Remove Programs
Select RQMExcelImporter
Click the Remove button and confirm desire to remove the application
Delete all the log files in the log directory
C:\Users\<USER>\AppData\Roaming\Mso2Rqm
Have you tried using a sample file ( C:\Program Files\IBM\RQMExcelImporter\Samples) ? What was the results?
For testing purposes, you can always do something like I did below (just an example), so you will narrow down the problem (import some data just using .cfg file):
//testcase.XLSStartRow=2
testcase.dc:title="test case title"
testcase.dc:description="description"
testcase.steps.type="execution"
testcase.steps.description="steps description"
testcase.steps.expectedResult="expectedResults"
testcase.XLSArtifactID="id"
testcase.steps.state="state"
Thank you