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/
The rt-users Archives
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
The rt-users Archives
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.