Import data from RTC to excel

Melody Melody (11●1●2) | asked Mar 03 '17, 1:26 p.m.
edited Mar 03 '17, 1:57 p.m.

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

Comments

Donald Nong commented Mar 05 '17, 7:39 p.m.

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

Melody Melody commented Mar 07 '17, 4:40 p.m.

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

4 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Ralph Schoon (61.8k●3●36●43) | answered Mar 06 '17, 3:59 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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.

0	permanent link Sian O'Briain (35●3●20) \| answered Mar 07 '17, 5:35 p.m. 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	permanent link Melody Melody (11●1●2) \| answered Apr 17 '17, 5:39 p.m. 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.

permanent link

Daniel Moul (4.8k●11●18) | answered Apr 18 '17, 9:34 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

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.

It's all about the answers!

Related questions

Import data from RTC to excel

4 answers

Your answer