RTC update work items programmatically
Need to update large amount of existing defects in RTC. Looking for some programmable way to do it. Please share links, examples. |
5 answers
Larry,
Are you aware that there is "bulk" operation available in the RTC client as well as in the web UI ? Using either you can update attributes of selected work items all in one go. In the web ui, click on the icon that says "Edit multiple work items" while hovering. (at the top right of a query result) Clicking it will then present means of adding selecting attributes. This may be tedious, but it's faster than figuring out the API and writing scripts (unless one has done it before). I'll send you a note with more details Kevin |
I agree with Kevin that the Bulk Operation works good in the Eclipse Client for SOME attributes, but not all. For example, most things that there is a defined list of options (boolean fields, enumerations, people). But if you have just text fields that you need it doesn't work (at least not in 3.0.1). Also, there is no way to add a comment at the same time you change.
There is a CSNext project where my team has started sharing snippets of RTC Data Manipulation tools (https://csnext.ibm.com/projects/rtcdata/) that you can try (called RTC Data Manipulation Utilities). Susan |
Hi Larry,
It will depend on what exactly you need to do, but I believe the best way to update a lot of workitems in RTC is to use the REST API. A good starting is this page: https://jazz.net/wiki/bin/view/Main/ResourceOrientedWorkItemAPIv2 You should have some basic knowledge of a scripting language and/or shell scripting with curl, but it really isn't that hard. Hope that helps, Oliver |
|
We've migrated couple of thousands defects from another system about 2 weeks ago and now team realized that one text field is missing :-). Now we need to export that data and update all corresponding work items in RTC.
I was emailing Kevin directly and he mentioned some OSLC library that can be used for this purpose. |
Ralph Schoon (63.5k●3●36●46)
| answered Dec 04 '12, 1:09 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Larry, see http://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/ and other posts such as http://rsjazz.wordpress.comand the ones about /2012/10/12/changing-the-jazz-user-id-using-the-rtc-plain-java-client-libraries/ and the code in several posts on that blog to update the work item using a WorkitemOperation.
That should get you there pretty quickly. |
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.