Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RQM: Converting XML of Testscript to Excel format

Questions
Tags
Users
Badges
Rajesh Avanthi
(108●15●145●173) Oct 30 '14, 5:30 a.m.
Which is the best way to Export test cases from RQM to Microsoft Excel? (along with Actual and Expected results Column) .
Also how to convert this XML of test script to excel format?

0 votes

1 answer
3,485 views
0 votes

One answer

Permanent link
Reshma Ratnani
JAZZ DEVELOPER (1.1k●1) Oct 30 '14, 5:52 a.m.
Hi Rajesh,

Firstly did you mean exporting TestCase or TestScript? If it was TestCase then goto Browse->TestCases else goto Browse->TestScripts, select the testcases or testscripts respectively which you want to export. Click on Download as Spreadsheet icon. This will give you csv file which you can directly open in Excel. But there is no way to get the Actual and Expected results Column in both cases

Thanks

0 votes

Comments
Reshma Ratnani
JAZZ DEVELOPER Oct 30 '14, 5:55 a.m.

By the way the above way is from RQM UI.

If you have the xmls of TestCase or TestScript then currently there is no utility which converts xml to Excel directly. You need to export the xml to RQM and follow the steps mentioned in above comment to get the Excel file

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 30 '14, 5:30 a.m.

Question was seen: 3,485 times

Last updated: Oct 30 '14, 5:55 a.m.

Confirmation Cancel Confirm