On Mon, Jan 19, 2009 at 10:22:16AM +0000, Matthew Seaman wrote: > We're in the process of migrating to RT from an ancient ticketing system. > I'd like to load our existing database of around 18,000 tickets into RT -- > which seems eminently do-able using a bit of perl scripting. Except for > one thing: is it possible to set ticket ID numbers programatically? As > far as I can tell the ticket id is derived from an autoincrement value in > one of the DB tables and there's no api for choosing a specific value. > Which makes it rather hard to preserve the existing ticket ID numbers. > > If anyone can point me towards examples on the Net of code for doing this > sort of migration I'd be grateful.
You might find that there is inspiration to be drawn from dumpfile-to-rt-3.0, part of RT::Extension::RT2toRT3 available on CPAN. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
