Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

mapping Bugzilla comments into a single work item field

Questions
Tags
Users
Badges
Tim Barrios
(26●1●10●5) Sep 15 '10, 7:19 p.m.
Similar to another posting of mine (see http://jazz.net/forums/viewtopic.php?t=12691), I need to be able to map an entire comment thread from Bugzilla into a single work item text field. That is, instead of the default mapping from the Bugzilla comments into a work item discussion (which works rather nicely), I need the comment user id, date/time, and comment text to all be mapped in a single work item field (Large String), concatenating all of the comments into this single field. For example, if Bugzilla had:

-----------------------------------------------------------------------------
|Comment #1 From Tim 2010-09-15 12:00:00
|
|Some comment text...
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
|Comment #1 From Sue 2010-09-15 12:02:00
|
|Some more comment text...
|----------------------------------------------------------------------------

That would all show up as a field in an RTC work item as:

Bugzilla comments field
Comment #1 From Tim 2010-09-15 12:00:00
Some comment text...

Comment #1 From Sue 2010-09-15 12:02:00
Some more comment text...

0 votes

3 answers
6,258 views
0 votes

3 answers

Permanent link
Daniel Cox
(426●1●16●8) Sep 16 '10, 11:20 a.m.
You can do your own processing on the bugzilla export file to do this condensation yourself before importing into RTC.

0 votes

Permanent link
Tim Barrios
(26●1●10●5) Sep 16 '10, 12:31 p.m.
Do you mean the Bugzilla mapping file or the individual bug's .xml (of which there are tens of thousands in this case)? And, what kind of processing?

0 votes

Permanent link
Daniel Cox
(426●1●16●8) Sep 16 '10, 1:15 p.m.
On the actual bug data that will be imported into RTC that you've exported from bugzilla. The fact that are thousands shouldn't matter much - just means you have to process each file with the same logic.

Literally change the individual XML entries in a file for each comment to merge them into one comment entry.

There are many technologies that you could do this with XLST, Java, perl, etc.

It's not pretty but it is doable...

0 votes

Your answer

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

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Sep 15 '10, 7:19 p.m.

Question was seen: 6,258 times

Last updated: Sep 15 '10, 7:19 p.m.

Confirmation Cancel Confirm