It's all about the answers!

Ask a question

Exporting Test Cases from RQM to Excel


Stephen Meehan (23144) | 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.4k12) | 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.4k12) | 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 (23144) | 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.4k12) | 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 (23144) | 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.4k12) | 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.


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.