Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to keep a query constantly updated in Excel?

Questions
Tags
Users
Badges
Dvir Dukhan
(1●1●1) Mar 05 '13, 3:40 a.m.
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

0 votes

Comments
Darrell Miller
Apr 25 '13, 3:28 p.m.
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?

2 answers
8,019 views
0 votes

2 answers

Permanent link
Stephanie Bagot
FORUM MODERATOR / JAZZ DEVELOPER (2.1k●1●5●13) Sep 11 '13, 10:53 a.m.
There is nothing out of box that will do this - you would need to investigate if this can be scripted manually.

0 votes

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) Sep 12 '13, 5:24 a.m.
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.

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Sep 12 '13, 5:26 a.m.
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/

Your answer

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

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,144

Question asked: Mar 05 '13, 3:40 a.m.

Question was seen: 8,019 times

Last updated: Sep 12 '13, 5:26 a.m.

Confirmation Cancel Confirm