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: [email protected] [mailto:[email protected]] On Behalf Of Michael Steen Sent: Thursday, August 04, 2011 6:12 PM To: [email protected] Subject: [rt-users] Convert Other Ticketing System DB to RT? All, 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. Thanks, Mike
-------- 2011 Training: http://bestpractical.com/services/training.html
