It's all about the answers!

Ask a question

Automatically export Worktitems

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

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.

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.

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
Brian Fleming (1.6k11928) | answered Apr 28 '14, 9:42 a.m.
You should investigate the reportable REST API:
This is what is used to populate the data warehouse via RRDI or Insight.  A REST call such as this:
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.

permanent link
sam detweiler (12.5k6195201) | 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...

Your answer

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