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
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


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

Your answer


Register or to post your answer.