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

REST API Syntax: Export ALL Test Scripts with Steps from RQM

Hello,

I am able to successfully export one script with its steps via a REST API added to Chrome. The GET result is an XML file, which I have not been able to successfully convert into a CSV file, yet. -Different problem

How can I capture all 23,000 scripts including their steps -I can export the scripts from RQM, but the steps aren't included, hence the REST GET:

https://rqmserver:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/projectarea/executionscript/urn:com.ibm.rqm:executionscript:2134

This example captured test script 2134 and its steps.

Thank you,
Matt

0 votes



2 answers

Permanent link

Matt, you can use a feed request (see https://jazz.net/wiki/bin/view/Main/RqmApi#feedUrl_for_interaction_with_a_f).  Make sure you pass the abbreviate=false request parameter (see https://jazz.net/wiki/bin/view/Main/RqmApi#abbreviate).

0 votes


Permanent link
Thanks Paul.  We found a manual way to get this, though very manual:

  1. In RQM, under “Planning”, select a test plan.
  2. Once the plan is open, then select the “PDF EXPORT” with “Export Comprehensive”.
  3. This can be done on all plans and it will list the scripts and steps which can be transferred (via the pdf export).
  4. Open it in Acrobat Pro > File > Export To > Spreadsheet > Microsoft Excel Workbook.

0 votes

Comments

This appears to be a solution for the CSV conversion issue. In this case, consider CSV export (see Exporting test-artifact list views as CSV files). 

Hi Paul,

If you export the Test Plans via the "export as .csv", it will not capture the Test Scripts' Steps, unfortunately.  But, the four-step sequence above allows you to get that granular.

Thanks 

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,938
× 1,700

Question asked: Feb 13 '19, 1:38 p.m.

Question was seen: 3,115 times

Last updated: Feb 19 '19, 10:33 a.m.

Confirmation Cancel Confirm