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

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.


0 votes


Accepted answer

Permanent link
 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

1 vote

Comments

Thanks Ara !

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.

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
× 10,927

Question asked: Dec 09 '13, 4:35 a.m.

Question was seen: 4,891 times

Last updated: Dec 10 '13, 4:33 a.m.

Confirmation Cancel Confirm