How to Migrate the Bugzilla Ticket Description into Request Tracker

Issue

My colleague and I have mostly completed the migration of our company
bugzilla database to request tracker.

The issue I am currently encountering is that although the tickets have
migrated across, the actual body content
of the ticket has not migrated across.

I have seen that the detail for a ticket should be held in the
attachments table.

I would really appreciate any advise that you can offer me.

Thanks,

Kwasi Date-Bah
Database Administrator

Direct Line: +44 20 7813 9536
kwasi.date-bah@snowvalley.com mailto:sarah.clelland@snowvalley.com

10 Emerald Street, London, WC1N 3QA
Website: http://www.snowvalley.com http://www.snowvalley.com

Blog: http://snowpatrol.snowvalley.com
http://snowpatrol.snowvalley.com/

Kwasi,

I'm not sure I understand what you mean by "Detail of the Ticket" 

(especially in terms of attachments), but in the RT wiki, I put the code
for a perl program we used to convert a legacy ticket system to RT using
API. Take a look, it might answer some of your questions. Hope this helps.

Kenn
LBNLOn 6/2/2009 8:23 AM, Kwasi Date-Bah wrote:

Issue

My colleague and I have mostly completed the migration of our company
bugzilla database to request tracker.

The issue I am currently encountering is that although the tickets
have migrated across, the actual body content
of the ticket has not migrated across.

I have seen that the detail for a ticket should be held in the
attachments table.

I would really appreciate any advise that you can offer me.

Thanks,


Kwasi Date-Bah
Database Administrator

Direct Line: +44 20 7813 9536
kwasi.date-bah@snowvalley.com mailto:sarah.clelland@snowvalley.com

10 Emerald Street, London, WC1N 3QA
Website: http://www.snowvalley.com

Blog: http://snowpatrol.snowvalley.com http://snowpatrol.snowvalley.com/



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Content of tickets is organized as MIME parts in attachments table.
Each attachment may have a parent and sticketed to a transaction.
Transactions with attachments usually have Create, Correspond or
Comment type.

What else do you want to know?On Tue, Jun 2, 2009 at 7:23 PM, Kwasi Date-Bah kwasi.date-bah@snowvalley.com wrote:

Issue

My colleague and I have mostly completed the migration of our company
bugzilla database to request tracker.

The issue I am currently encountering is that although the tickets have
migrated across, the actual body content
of the ticket has not migrated across.

I have seen that the detail for a ticket should be held in the attachments
table.

I would really appreciate any advise that you can offer me.

Thanks,


Kwasi Date-Bah
Database Administrator

Direct Line: +44 20 7813 9536
kwasi.date-bah@snowvalley.com

10 Emerald Street, London, WC1N 3QA
Website: http://www.snowvalley.com

Blog: http://snowpatrol.snowvalley.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.