[rt-users] Migrating to RT from another ticket system

[ktm at rice.edu]

On Mon, Jun 06, 2011 at 01:44:01PM +0200, Bart wrote:
> Hi,
> 
> We are currently working on migrating to Request Tracker.
> 
> The step on which we are now is creating a proof of concept, this is coming
> along pretty nicely.
> With the O'Reilly book + mailing lists + wiki at hand we're getting there,
> just filling out the specific details :)
> 
> I do however want to look at a road bump ahead, which is migrating the old
> ticket date into RT.
> 
> We have the ability to export all the current date to CSV format, keeping
> those fields that we feel are fit for RT. (the old/current ticketing system
> is Assyst from Axios Systems)
> We don't mind if ticket numbers are new, we prefer it really, as long as we
> can store the old ticket number in a CF (which I believe we can).
> 
> What would be the best way to import the data?
> Can we use the command-line RT functions or do we have to do some database
> magic? (I'm not a database wizard so we'd have to find someone for that lol)
> 
> The reason why I'm asking this is mainly to get some information about the
> migration process before hand, such information would safe me allot of time
> later on.
> 
> So any information that would point us in the right direction would be
> helpful.
> 
> Thanks in advance.
> 
> Best regards,
> 
> Bart

Hi Bart,

I would take a look at the Tools->Offline and see if you can generate
an appropriate text file for import from your CSV. I used that method
to create several thousand tickets at one shot.

Cheers,
Ken