It's all about the answers!

Ask a question

Exporting Test Cases from RQM to Excel


Stephen Meehan (23134) | asked Oct 04 '11, 3:42 a.m.
Is it possible to export test cases from RQM to Excel? What I would like to do is to update existing test cases in RQM in bulk using Excel and then export them back to RQM.

Thanks,
Stephen

6 answers



permanent link
Paul Slauenwhite (8.3k12) | answered Oct 04 '11, 7:58 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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).

permanent link
Paul Slauenwhite (8.3k12) | answered Oct 04 '11, 9:25 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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.

permanent link
Stephen Meehan (23134) | answered Oct 05 '11, 11:32 a.m.
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

permanent link
Paul Slauenwhite (8.3k12) | answered Oct 05 '11, 12:11 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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.

permanent link
Stephen Meehan (23134) | answered Oct 05 '11, 12:59 p.m.
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.

permanent link
Paul Slauenwhite (8.3k12) | answered Oct 05 '11, 1:01 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
For RQM 3.0.1:

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

Your answer


Register or to post your answer.