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

Import data from RTC to excel

  Hello,


I would like to import data from RTC to excel without manually exporting the work item information each time I want to refresh the data. Is there a way to do this automatically?

TIA

0 votes

Comments

So you want pull the RTC data directly into Excel, using a macro or plugin within Excel, correct?

 Yes, currently the process is download as spreadsheet and then manipulate the data weekly



4 answers

Permanent link

 See the answer to this question: https://jazz.net/forum/questions/49453/excel-and-oslc pointing to https://www.ibm.com/developerworks/rational/library/rational-team-concert-visual-basic/index.html


You would basically use OSLC from Excel.

1 vote


Permanent link

If you don't want to use visual basic you could also use OSLC with any language of choice to get the data and then output the results to a csv file.

0 votes


Permanent link

 Thanks but we are not allowed to execute scripts at work. I was looking for a way to import the data into excel and found that i can do it through the Jazz Builder Reporting service.

0 votes


Permanent link

You could use the Jazz Reporting Service Report Builder to create a report with work item information and export to excel. There is an option to export with "live links", which you can refresh with a push of a button in your excel spreadsheet.

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.

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
× 1,220

Question asked: Mar 03 '17, 1:26 p.m.

Question was seen: 5,915 times

Last updated: Apr 18 '17, 9:34 a.m.

Confirmation Cancel Confirm