It's all about the answers!

Ask a question

Export test script steps from RQM to Excel v4.0.2

Ade Adeyokunnu (16125) | asked Oct 02 '13, 2:28 p.m.
edited Oct 02 '13, 3:18 p.m.
Is there a way to export from RQM to excel, I only see an option to export to PDF

3 answers

permanent link
Ara Masrof (3.2k15) | answered Oct 02 '13, 9:53 p.m.
You can using the REST API to return the Test Script data, but it will be in XML, for example:

In this case my Public URI is "clm401:9443"
My QM Project is : LPA+project+1+%28Quality+Management%29
My Script ID is 34

You can use Poster (or any other HTTP client) to trigger the request. 
Also be sure to use the Request header text/xml or application/xml 
This will return the xml of the test script; you would need to then parse out the data you are interested in 

permanent link
Laura Kuczarski (21137) | answered Oct 02 '13, 2:53 p.m.
When you are viewing a list of test scripts, do you see the Download as spreadsheet (.csv) button on the toolbar?

Laura Kuczarski commented Oct 02 '13, 2:55 p.m.

You can also refer to this help topic for more information:


Ade Adeyokunnu commented Oct 02 '13, 3:00 p.m.
yes, however this only produces the test scripts name and not the actual steps in the script.

Laura Kuczarski commented Oct 02 '13, 3:06 p.m.

I just verified that this is the only test script information that you can currently export to CSV from the UI. 

Ade Adeyokunnu commented Oct 02 '13, 3:17 p.m. | edited Oct 02 '13, 3:19 p.m.

Oh i see, could you please provide a link to submit this a feature request? Also is there documentation detailing how to accomplish this with the REST API?

Laura Kuczarski commented Oct 02 '13, 3:26 p.m.

Sure, the link for submitting enhancement requests is here:

This is the wiki documentation for the REST API, although I don't see specific information about export test scripts:

Ade Adeyokunnu commented Oct 02 '13, 3:29 p.m.

Ok thanks, yea that is the same link I had, but cant seem to find how to actually do it. Thanks for your help

Laura Kuczarski commented Oct 02 '13, 3:30 p.m. | edited Oct 02 '13, 3:37 p.m.

This forum post also had a suggestion about using the Copy Utility to get the XML and importing that into Excel:

Paul Slauenwhite commented Feb 27 '14, 6:28 a.m. | edited Apr 15 '15, 10:32 a.m.
showing 5 of 8 show 3 more comments

permanent link
Christophe Lucas (86224948) | answered Feb 28 '14, 6:44 a.m.
Hello Ade,

2 other ways to get RQM Test Script Steps into a xls:

(1) Via Excel Importer and Test Case 'Run offline' mode (quick, easy)
Install the RQMExcelWordImporter
Find the Test Case which the Test Script is associated to. Click Run Offline.
This will generate a .rqms file, which you can easily open in xls using the RQM 'Import for offline' installed add-in.
This gives you all the Test Script Steps of the Test Script associated to the Test Case - see picture below.

(2) Create a RPE report: see this forum post (need RPE)

Hope this helps.

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.