Exporting Test Cases from RQM to Excel

Unfortunately, not from the UI. The only two ways are:

1) Using the RQM Reportable REST API (https://jazz.net/wiki/bin/view/Main/RqmApi) to GET the test resources. Your client code would have to read the XML resource and generate a CSV file. See https://jazz.net/wiki/bin/view/Main/RqmApi#Common_Usage_Scenarios to get started.

2) Create/export a report as CSV using Insight (see https://jazz.net/wiki/bin/view/Main/CALMReportingSetupSteps).

Unfortunately, not from the UI. The only two ways are:

1) Using the RQM Reportable REST API (https://jazz.net/wiki/bin/view/Main/RqmApi) to GET the test resources. Your client code would have to read the XML resource and generate a CSV file. See https://jazz.net/wiki/bin/view/Main/RqmApi#Common_Usage_Scenarios to get started.

2) Create/export a report as CSV using Insight (see https://jazz.net/wiki/bin/view/Main/CALMReportingSetupSteps).

In addition, see https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/52746.

Unfortunately, not from the UI. The only two ways are:

1) Using the RQM Reportable REST API (https://jazz.net/wiki/bin/view/Main/RqmApi) to GET the test resources. Your client code would have to read the XML resource and generate a CSV file. See https://jazz.net/wiki/bin/view/Main/RqmApi#Common_Usage_Scenarios to get started.

2) Create/export a report as CSV using Insight (see https://jazz.net/wiki/bin/view/Main/CALMReportingSetupSteps).

Hi Paul, Thanks for this information. I wanted to try the RQM URL Utility, according to the wiki it "is available in the Extras section of the All Downloads tab on the Rational Quality Manager" but I am unable to find it there. Can you direct me to where I can download this utility from. Also if you could provide an example of how to call the GET service to retrieve test case(s) and generate a .csv from the response xml using this utility, that would be very helpful.

Thanks,
Stephen

See https://jazz.net/wiki/bin/view/Main/RQMURLUtility#Setup_Considerations and https://jazz.net/wiki/bin/view/Main/RqmApi#Common_Usage_Scenarios. You would have to write the code/script to convert the XML to CSV format.

See https://jazz.net/wiki/bin/view/Main/RQMURLUtility#Setup_Considerations and https://jazz.net/wiki/bin/view/Main/RqmApi#Common_Usage_Scenarios. You would have to write the code/script to convert the XML to CSV format.

I still can't get the RQM URL Utility download from those extra links you provided.

For RQM 3.0.1:

https://jazz.net/downloads/rational-quality-manager/releases/3.0.1?p=allDownloads >> Rational Quality Manager URL Utility