It's all about the answers!

Ask a question

why its shows error wile Importing test cases from excel into RQM ?


Krunal Gaoli (67246) | asked Oct 08 '15, 6:40 a.m.
Hi Team,

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


permanent link
Reshma Ratnani (1.1k1) | answered Oct 08 '15, 6:49 a.m.
JAZZ DEVELOPER
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

<rqm Excel="" Import="" Utility="" installation="" directory="">\Samples

By default, the RQM Excel Import Utility is installed in:

C:\Program Files\IBM\RQMExcelImporter

Try to export a sample to your server and see if you get the same error. If not then you should check your .cfg file. Refer the samples for creating .cfg file
Krunal Gaoli selected this answer as the correct answer

Comments
Krunal Gaoli commented Oct 08 '15, 8:09 a.m.

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



permanent link
Joao Carusi (26314) | answered Oct 08 '15, 3:47 p.m.
edited Oct 08 '15, 3:50 p.m.
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

Your answer


Register or to post your answer.