You can just alter the table to start auto_increment from a higher number…
So that RT starts from 18001->
Very easy to do with phpMyAdmin
Med vennlig hilsen / with kind regards
BroadPark Games drift/design
NextGenTel AS, part of TeliaSonera Group
Tlf: +47 466 988 46
Mail: firstname.lastname@example.org mailto:email@example.com
please don’t print this e-mail unless you really need to.
-----Opprinnelig melding-----Fra: firstname.lastname@example.org [mailto:email@example.com] På vegne av Dominic Hargreaves
Sendt: 19. januar 2009 11:53
Emne: Re: [rt-users] Programatically creating tickets with specific idnumbers
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
Community help: http://wiki.bestpractical.com
Commercial support: firstname.lastname@example.org
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com