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.
JAZZ DEVELOPER
 
You can using the REST API to return the Test Script data, but it will be in XML, for example:
GET

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.
JAZZ DEVELOPER
Hello,
When you are viewing a list of test scripts, do you see the Download as spreadsheet (.csv) button on the toolbar?

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

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

http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/topic/com.ibm.rational.test.qm.doc/topics/t_export_to_csv.html

Thanks!
Laura


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.
JAZZ DEVELOPER

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


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?


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

Sure, the link for submitting enhancement requests is here: https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.newWorkItem

This is the wiki documentation for the REST API, although I don't see specific information about export test scripts:
https://jazz.net/wiki/bin/view/Main/RqmApi



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.
JAZZ DEVELOPER

This forum post also had a suggestion about using the Copy Utility to get the XML and importing that into Excel: 
https://jazz.net/forum/questions/63899/export-test-cases-from-rqm-to-excelpdf


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

permanent link
Christophe Lucas (8624647) | 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.