[rt-users] Importing data from a legacy system

[John Doe]

Hi,

The command line rt tool is probably your best bet.

Getting the data out of your legacy system is the first step though.

I ignored this advice and wrote my own import program which inserted
10 years worth of tickets, users and groups, after studying the
database schema and how relations were built by adding test data.
This approach was probably more costly in time and effort.

I'm very soon going to have to do it all over again and I think I'll
attempt to make use of the rt tool instead, this time.

John

On 9/12/06, Johan Schoen <johan.schon at capgemini.com> wrote:
> Hi,
>
> Where can I find information about how to import ticket data, including
> history, from a legacy system into RT? Using Google, I have found no useful
> information. I also can not find any information about migration in the RT
> Essentials book - are there any?
>
> Reading the RT 3.6.0 source code and module documentation I found the
> RT::Ticket::Import method in Ticket_Overlay.pm which I guess can be used to
> import the current ticket data. However, I  have been unable to understand
> how to import ticket history. The Create method in Transaction_Overlay.pm
> looks like it could be used for migrating ticket history, but according the
> documentation in Transaction_Overlay.pm, RT::Transaction::Create must not be
> called directly - only by RT::Ticket. I have not found any useful method for
> import ticket history in Ticket.pm or Ticket_Overlay.pm. Have I missed
> something? How should I import ticket history into the Transaction table
> without risking me kneecaps?
>
> Best regards,
> Johan Schön, Capgemini
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>