It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,844
×188

question asked: Jun 26 '12, 8:50 a.m.
question was seen: 5,573 times
last updated: Apr 25 '13, 3:20 p.m.

Related questions

starting a RTC query from excel - direct update/refresh instead of manual cycle via CSV-export

1
1
andreas hennig (11●1●2) | asked Jun 26 '12, 8:50 a.m.


Hi all,

maybe I'm looking at the wrong buzzwords and it is all easy :)

I'm trying to get RTC data (themes to tasks) into excel to do some further processing / calculation / analysis. 

I know how to create a query, export the csv, load that into excel and go ... but this is all manual.

Excel can directly load data from a http query (webquery), but that would need a URL version similar to https://bt-clmserver01.....com/ccm/web/projects/....#action=com.ibm.team.workitem.runSavedQuery&id=_pmZPwbt7EeGIU7iX9QvgUw that allows to get just the data (ideally in CSV format), without all the navigation around it.

I'm on the user-side of an existing RTC installation, i.e. I do not have access to server-side api's

Any help or tips?

thanks, Andreas

Comments
Darrell Miller commented Apr 25 '13, 3:20 p.m.

I'm a new user to Jazz.net and RTC but this question is one that I'm interested in as well.  Is there no answer to this other than using the manual export in RTC?

Be the first one to answer this question!

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.