How to keep a query constantly updated in Excel?
Hi
I need to constantly extract queries for analysis on Excel. Is there any other, useful way to schedule the queries export, or updating the Excel file via Excel itself (like updating a data connection) without doing so manually (meaning by export work items to *.csv file)? Excel can get data from a web page, but when i tried to import the data (from the web UI - that's where the query's link leads to) it failed. Thanks Dvir |
2 answers
Ralph Schoon (63.7k●3●36●48)
| answered Sep 12 '13, 5:24 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
If you search the net for EXCEL and REST, you can find several Extensions to EXCEL that allow using REST to call out for data, This would be one possible way to do it. You would have to code the way to access the RTC CCM OSLC and REST servcies yourself as Stephanie suggests above.
Comments The other way round would be to use the Plain Java Client Libraries or a server process to extract data to .csv files. Some hints here: http://rsjazz.wordpress.com/2012/11/19/using-expressions-for-automation/ and http://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
|
There is nothing out of box that will do this - you would need to investigate if this can be scripted manually.
|
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.
Comments
I am also interested in learning how this may be done....preferably without needing to code Java and such. Is it possible to do this using native functions and features of RTC and Excel?