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

Export test script steps from RQM to Excel v4.0.2

Questions
Tags
Users
Badges
Ade Adeyokunnu
(16●1●2●5) 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

0 votes

3 answers
10,881 views
0 votes

3 answers

Permanent link
Ara Masrof
JAZZ DEVELOPER (3.2k●1●5) 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:
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 

1 vote

Permanent link
Laura Kuczarski
JAZZ DEVELOPER (211●3●7) Oct 02 '13, 2:53 p.m.
Hello,
When you are viewing a list of test scripts, do you see the Download as spreadsheet (.csv) button on the toolbar?

0 votes

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

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
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
JAZZ DEVELOPER Oct 02 '13, 3:06 p.m.

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
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
JAZZ DEVELOPER Oct 02 '13, 3:26 p.m.

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


1 vote

Ade Adeyokunnu
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
JAZZ DEVELOPER 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: 
https://jazz.net/forum/questions/63899/export-test-cases-from-rqm-to-excelpdf

Paul Slauenwhite
FORUM MODERATOR / JAZZ DEVELOPER Apr 15 '15, 10:32 a.m.

See [QM] CSV Export (52746) and Export test script steps from RQM to Excel v4.0.2 (96446).

showing 5 of 8 show 3 more comments
Permanent link
Christophe Lucas
(862●3●49●48) 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.




0 votes

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.

Ask a question
Guidelines
FAQ
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
× 12,020
× 1,381

Question asked: Oct 02 '13, 2:28 p.m.

Question was seen: 10,881 times

Last updated: Apr 15 '15, 10:32 a.m.

Confirmation Cancel Confirm