how to export test artifacts from rqm to excel ?
Accepted answer
Dev,
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)
https://clm4:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/LPA+project+1+(Quality+Management)/testcase/urn:com.ibm.rqm:testcase:32
where:
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
Thanks