It's all about the answers!

Ask a question

How to export data from work-items?


CM 2006 (18911) | asked Apr 25 '13, 1:45 p.m.
Hello,

I got a task to export data from bug work-items, automatically.
I have to write an inter-op script (Perl? Phyton?) that finds all work-items for a given project, and then export some fields into a CSV file: I have to export id, priority and severity.

Can you help me please with guide-lines or pseudo code?
I don't know how to connect RTC ; how to fetch work items from a specific project; how to retrieve theses specific fields
Please let me know if there's some best practiecs and preferred script language for that task.

One more question -
in future we plan to integrate RTC with ClearCase (through bridge or syncronizer). Please let me know if I can retrieve ucm activity-id from within the work-item data, and if so - how to.


Thank you!

2 answers



permanent link
Masabumi koinuma (46115) | answered Apr 25 '13, 4:07 p.m.
JAZZ DEVELOPER
Also for the "one more question", you can find various information about the ClearCase integration here :
    Rational Team Concert and Rational ClearCase - Integration Cookbook
In particular, these pages have perl sample code to access UCM activity links on the work item for the ClearCase Bridge:
    https://jazz.net/library/article/636
    https://jazz.net/library/article/785

permanent link
Geoffrey Clemm (30.1k33035) | answered Apr 25 '13, 3:47 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
First a "tip of the hat" and a "wag of the finger":
TOTH: For posting your question in the form of a question.
WOTF: For submitting multiple questions in a single posting.
(:-)

WRT the "one more question":
For the Bridge, there is an HTTP link between the work-item and the UCM activity, so follow that link from the work-item, and you can access the UCM activity.  For the Synchronizer, the ucm activity-id's for the changes brought over by a given synchronization request are identified in the Description field of the work item created by the synchronizer for that synchronization request.

Comments
Masabumi koinuma commented Apr 25 '13, 4:06 p.m. | edited unknown
JAZZ DEVELOPER

Also for the "one more question", you can find various information on the cookbook :
    Rational Team Concert and Rational ClearCase - Integration Cookbook
In particular, these pages have perl sample code to access UCM activity links on the work item for the ClearCase Bridge:
    https://jazz.net/library/article/636
    https://jazz.net/library/article/785

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.