Export csv file for RTC every few hours
Accepted answer
Hi
I don't think there is a way to do this through the UI.
However, there are a few ways you might be abl to do it.
One way is to use the plain java api, write a simple java app to read out the work items, and save them as your csv file. Then use an operating system scheduler to run the java program every few hours. The java api can be downloaded from the all downloads page on the release of rtc, and the wiki has code examples.
Another way, depending on why you want them in csv, might be to use RRDI (the free data warehouse reporting solution that comes with rtc), which has daily snapshots of the data, but you can configure rtc to take snapshots at more frequent intervals. Then you can configure RRDI to analyse the data into a graph or report, put it on a dashboard, and even email it around.
Hope this helps
Steve
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.
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.