It's all about the answers!

Ask a question

how to export test artifacts from rqm to excel ?

Dev K (512833) | asked Dec 09 '13, 4:35 a.m.
Hi ,
we can  import from rqm to excel  using "Rational Quality Manager Excel and Word Importers" .

Can  you please let me know how to export test artifacts from rqm to excel ?

Thanks in Advance,
Best regards,
Dev Kashyap.

Accepted answer

permanent link
Ara Masrof (3.2k15) | answered Dec 09 '13, 7:15 a.m.
Currently, RQM does not have the built in functionality to export individual Test Artifacts to a MS Excel. The Browser view does have an option to 'Download as Spreadsheet (.csv)' which will export the list of Test Assets to a .csv file.

One option would be to us the REST API to capture the details of a Test  Asset 
An example of the syntax would look like this (In this case the Test Asset is a Test Case)


Public URI is clm4:9443
QM Project are is LPA+project+1+(Quality+Management)
Test Case ID is 32

You can use any type of HTTP client to run the GET request (i.e. Poster, cURL..etc); be sure specify the content type as txt/xml or application/xml
The request will return XML which you can then parse to a spreadsheet

Another option would be to use the Rational Publishing Engine; it has the capability to export RQM data in various formats 

Dev K selected this answer as the correct answer

Dev K commented Dec 10 '13, 4:33 a.m.

Thanks Ara !

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.