It's all about the answers!

Ask a question

Automatically export Worktitems


Fabien Araktingi (151016) | asked Apr 17 '14, 8:21 a.m.
Hi,

I would like to know if there is a way to export automatically the RTC / RQM  version 4.x worktitems (e.g. command line or any other web services, REST...).

The result of that operation could be a xml, json, text or any other exploitable format.

Thanks for any feedback.

Comments
Fabien Araktingi commented Apr 17 '14, 12:18 p.m.

Thanks for your answer Sam.

I suppose that this way does not allow to get the full history of a workitem (e.g. the different comments, activity history linked to the status).

Thanks for any feedback.


sam detweiler commented Apr 17 '14, 12:22 p.m.

correct.. only Export can get comments.. nothing will export history


Ralph Schoon commented Apr 28 '14, 8:21 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

If you want to export the full history, you would have to compute it e.g. using the API. A work item has up to two predecessor "states" and you can iterate from the current "State" to when it was created. The history view does exactly that. The information is there, but you would have to create your own export tool, if you want to export that too. You would need a different format than CSV to store all this information too.


sam detweiler commented Apr 28 '14, 8:29 a.m.

right.. didn't say it wasn't possible, just that nothing provides this function today.

2 answers



permanent link
sam detweiler (12.4k6171200) | answered Apr 17 '14, 8:50 a.m.
well sort of yes,

if u create a query to identify the workitems, display that query result in the wed UI,
select the printable form button  or the export to csv and then get the URL from the browser.. then u can use curl or somesuch from the commandline to invoke that url again...

permanent link
Brian Fleming (1.6k11728) | answered Apr 28 '14, 9:42 a.m.
You should investigate the reportable REST API: https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI
This is what is used to populate the data warehouse via RRDI or Insight.  A REST call such as this:
https://<host:port>/ccm/rpt/repository/workitem?fields=workitem/workItem[id=123]/(id|summary|itemHistory/comments/content)
will return the id and summary of the workitem, as well as all comment contents from each version of the workitem for workitem 123.  The API is quite powerful and you can customize the sample REST call above to return more attributes from more workitems and include search predicates (including based on modified date) so that you are not retrieving the full contents of your repository every time you run it.

Your answer


Register or to post your answer.