It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×1,207

question asked: Mar 03 '17, 1:26 p.m.
question was seen: 5,031 times
last updated: Apr 18 '17, 9:34 a.m.

Related questions

FAQ - How this Forum works

Import data from RTC to excel

0
Melody Melody (11●1●3) | 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 ↑

1
permanent link
Ralph Schoon (63.1k●3●36●46) | 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●9●21) | 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●3) | 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.
0
permanent link
Daniel Moul (4.9k●13●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.

Your answer

Register or 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.