It's all about the answers!

Ask a question

RTC update work items programmatically


Larry Bakun (2143) | asked Dec 03 '12, 1:52 p.m.

Need to update large amount of existing defects in RTC. Looking for some programmable way to do it. Please share links, examples.

5 answers



permanent link
Ralph Schoon (55.5k23642) | 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.

permanent link
Larry Bakun (2143) | answered Dec 04 '12, 9:54 a.m.
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.

permanent link
Oliver Siebenmarck (1111) | answered Dec 04 '12, 6:13 a.m.
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

permanent link
Susan Hanson (1.6k2169193) | answered Dec 03 '12, 6:00 p.m.
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

permanent link
Kevin Ramer (4.4k6158178) | answered Dec 03 '12, 3:11 p.m.
edited Dec 03 '12, 3:13 p.m.
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


Your answer


Register or to post your answer.