[rt-users] Programatically creating tickets with specific idnumbers

[Steffen Tronstad]

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 
Steffen Tronstad 
BroadPark Games drift/design 
NextGenTel AS, part of TeliaSonera Group 
Tlf: +47 466 988 46
Mail: sttr at nextgentel.com <mailto:sttr at nextgentel.com> 
 please don't print this e-mail unless you really need to. 


-----Opprinnelig melding-----
Fra: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] På vegne av Dominic Hargreaves
Sendt: 19. januar 2009 11:53
Til: rt-users at lists.bestpractical.com
Emne: Re: [rt-users] Programatically creating tickets with specific idnumbers

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: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com