[rt-users] Programatically creating tickets with specific id numbers

[Dominic Hargreaves]

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