how to export test artifacts from rqm to excel ?
![]()
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
![]()
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
Dev K selected this answer as the correct answer
|
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.