It's all about the answers!

Ask a question

Import data from RTC to excel

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


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?


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

permanent link
Ralph Schoon (63.0k33645) | answered Mar 06 '17, 3:59 a.m.

permanent link
Sian O'Briain (35921) | 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.

permanent link
Melody Melody (1113) | 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.9k1318) | answered Apr 18 '17, 9:34 a.m.

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.

Your answer

Register or to post your answer.