It's all about the answers!

Ask a question

mapping Bugzilla comments into a single work item field

Tim Barrios (26105) | asked Sep 15 '10, 7:19 p.m.
Similar to another posting of mine (see, 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...

3 answers

permanent link
Daniel Cox (4261168) | answered 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.

permanent link
Tim Barrios (26105) | answered 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?

permanent link
Daniel Cox (4261168) | answered 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...

Your answer

Register or to post your answer.