[rt-users] Convert Other Ticketing System DB to RT?

Jason Ledford jledford at biltmore.com
Thu Aug 4 22:33:45 EDT 2011

What database access do you have to those older tickets and what type of database is it?  Mine was a homebrew asp app with access db.  I created a page in asp that queried the db and wrote the page to look like the offline tool.  So I turned off all email notification and then ran through about 15000 tickets in the offline tool.  I broke it up in 5000 chunks.  I would be happy to share what I created if it is helpful.

From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Michael Steen
Sent: Thursday, August 04, 2011 6:12 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Convert Other Ticketing System DB to RT?


I am wondering if anyone has successfully converted a database from another ticketing system to RT.  I found a thread from 2008 about OTRS (http://www.gossamer-threads.com/lists/rt/users/81165) in which Jesse said that most people abandon their former ticketing systems to start fresh with RT.

In my case, I have about 1200 tickets that I would like to save currently living in a Support Center ticketing system by Quality Unit.  If anyone has had success in converting a DB, and/or if there is any existing documentation I haven't found, please let me know.  Also, if anyone has met with failure attempting to do something like this, I would appreciate your feedback, as well.  I'd like to avoid wasted effort if it's not worth it in the long run.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110804/ec837674/attachment.htm>

More information about the rt-users mailing list