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

Export Artifact from RQM to Excel file.

Questions
Tags
Users
Badges
Naveen Tyagi
(197●78●152) Feb 27 '15, 12:16 a.m.
 I am able to Import data from Excel file to RQM but now i am tasked to do just opposite to it. I am wondering, is there any way to do this?

0 votes

2 answers
4,002 views
0 votes

Accepted answer

Permanent link
Reshma Ratnani
JAZZ DEVELOPER (1.1k●1) Feb 27 '15, 12:22 a.m.
Hi Naveen,

You can download artifact as csv from RQM UI. Lets say you want to get csv file of a TestCase, then goto Browse->TestCases and in the Table select the testcases you want to download as csv and click on "Download as spreadsheet (csv)" icon located after the "Download as PDF" icon above the table on left side
Naveen Tyagi selected this answer as the correct answer

0 votes

Comments
Naveen Tyagi
Feb 27 '15, 12:38 a.m.

 I know about .CSV file but i want to pull out all the artifact data in Excel/.csv file and that's not happening in case of CSV but PDF. whatever[Artifact with data] being Exported in PDF i want same for  in Excel and it would be great if if possible for multiple test cases at a time. 

Reshma Ratnani
JAZZ DEVELOPER Feb 27 '15, 2:23 a.m.

It is possible to download csv of multiple TestCases (lets say) from Browse TestCase page. Select the TestCases and click on Download as Spreadsheet icon

Naveen Tyagi
Feb 27 '15, 2:51 a.m.

 Right!! but downloading that .csv file didn't meet to our requirement. i want to pull out all the artifacts with their value into Excel file in same way it was imported to RQM.

One other answer

Permanent link
Ara Masrof
JAZZ DEVELOPER (3.2k●1●5) Feb 27 '15, 9:41 a.m.
 There is no built in way to export directly from QM into Excel (other than what Reshma has pointed out in her prior post). One option would be to use the REST API to return the XML of the artifact you are interested in then convert that to spreadsheet format

Also, the Rational Publishing Engine provides the capability to export RQM data to a variety of format including format compatible with Word and Excel, that may be something you may want to pursue.

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
× 10,938

Question asked: Feb 27 '15, 12:16 a.m.

Question was seen: 4,002 times

Last updated: Feb 27 '15, 9:41 a.m.

Confirmation Cancel Confirm