Export csv file for RTC every few hours
Sean Hannon (17●1●4●6)
| asked Oct 18 '12, 8:58 a.m.
edited Oct 19 '12, 5:10 a.m. by Ralph Schoon (63.7k●3●36●48)
Hi,
I'm trying to export all workitems in RTC to a csv file and store it some where every few hours but I want to do it automatically without someone having to open RTC and manually export it.
Is this even possible?
Thanks for the help
|
Accepted answer
Ralph Schoon (63.7k●3●36●48)
| answered Oct 19 '12, 5:08 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Oct 19 '12, 5:38 a.m.
The Plain Java API is a bunch of Java JAR's. They use HTTPs/HTML to access the REST interface of RTC. You don't have to and also should not try to access the database. The way the data is stored prevents you from learning a lot doing so anyway.
There are several articles and Wiki entries on Jazz.net that talk about Plain Java API. This one https://jazz.net/library/article/807 has a quick description on how to set it up. In my blog I try to publish things I learned about the API. http://rsjazz.wordpress.com/2012/08/01/uploading-attachments-to-work-items/ would be interesting for you. I haven't published about running queries. No time. I think however there are forum questions with code that you should be able to find. Sean Hannon selected this answer as the correct answer
|
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.