It's all about the answers!

Ask a question

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

andreas hennig (1112) | 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 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

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

I'm a new user to 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.