Ticket numbering to start at 2000

RT Users
1

Hi,

I’ve setup a new installation of RT without migrating data from a previous installation : reason is that new queues/custom fields are defined in the new installation.

So the old installation has reached ticket number 1853.
To avoid having trouble/confusion with my external partner (to whom we are giving our ticket number for reference), I would like to start ticket numbering to 2000 or 3000.

I can’t imagine create and close 1999 tickets then use RT Schredder.
Is there another easy way to do this ?

Cdt,

Franck CALLEJA-ALBILLOS
Email : franck.calleja-albillos@alcatel-lucent.commailto:franck.calleja-albillos@alcatel-lucent.com

2

It is using MYSQL database. Is it possible just to setup the auto_increment like described here :

It depends on what database you are using. Look for the file called
schema.Pg for postgres or schema.mysql, or whatever. You’ll see a line
that says something like:

CREATE SEQUENCE tickets_id_seq;

That’s for Postgres. I changed it to:

CREATE SEQUENCE tickets_id_seq MINVALUE 8000;

Then I initialized my database.

Cdt,

Franck CALLEJA-ALBILLOS
TREFLE pour Alcatel-Lucent
Centre de Compétences Managed Services - IP/MPLS

Tél. : +33 1 30 77 1362
Email : franck.calleja-albillos@alcatel-lucent.commailto:franck.calleja-albillos@alcatel-lucent.comDe : rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] De la part de CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR **
Envoyé : mercredi 27 avril 2011 13:06
À : ‘rt-users@lists.bestpractical.com’
Objet : [rt-users] Ticket numbering to start at 2000

Hi,

I’ve setup a new installation of RT without migrating data from a previous installation : reason is that new queues/custom fields are defined in the new installation.

So the old installation has reached ticket number 1853.
To avoid having trouble/confusion with my external partner (to whom we are giving our ticket number for reference), I would like to start ticket numbering to 2000 or 3000.

I can’t imagine create and close 1999 tickets then use RT Schredder.
Is there another easy way to do this ?

Cdt,

Franck CALLEJA-ALBILLOS
Email : franck.calleja-albillos@alcatel-lucent.commailto:franck.calleja-albillos@alcatel-lucent.com

3

http://requesttracker.wikia.com/wiki/SetStartingIdOn Wed, Apr 27, 2011 at 3:23 PM, CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR ** Franck.Calleja-Albillos@alcatel-lucent.com wrote:

It is using MYSQL database. Is it possible just to setup the auto_increment
like described here :

It depends on what database you are using. Look for the file called
schema.Pg for postgres or schema.mysql, or whatever. You’ll see a line
that says something like:

CREATE SEQUENCE tickets_id_seq;

That’s for Postgres. I changed it to:

CREATE SEQUENCE tickets_id_seq MINVALUE 8000;

Then I initialized my database.

Cdt,

Franck CALLEJA-ALBILLOS

TREFLE pour Alcatel-Lucent

Centre de Compétences Managed Services - IP/MPLS

Tél. : +33 1 30 77 1362

Email : franck.calleja-albillos@alcatel-lucent.com

De : rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] De la part de
CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR **
Envoyé : mercredi 27 avril 2011 13:06
À : ‘rt-users@lists.bestpractical.com’
Objet : [rt-users] Ticket numbering to start at 2000

Hi,

I’ve setup a new installation of RT without migrating data from a previous
installation : reason is that new queues/custom fields are defined in the
new installation.

So the old installation has reached ticket number 1853.

To avoid having trouble/confusion with my external partner (to whom we are
giving our ticket number for reference), I would like to start ticket
numbering to 2000 or 3000.

I can’t imagine create and close 1999 tickets then use RT Schredder.

Is there another easy way to do this ?

Cdt,

Franck CALLEJA-ALBILLOS

Email : franck.calleja-albillos@alcatel-lucent.com

Best regards, Ruslan.

4

Hi,

It worked perfectly.
Many thanks.

Cdt,

Franck CALLEJA-ALBILLOS
TREFLE pour Alcatel-Lucent
Centre de Compétences Managed Services - IP/MPLS

Tél. : +33 1 30 77 1362
Email : franck.calleja-albillos@alcatel-lucent.com

-----Message d’origine-----De : ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@gmail.com] De la part de Ruslan Zakirov
Envoyé : mercredi 27 avril 2011 18:59
À : CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR **
Cc : rt-users@lists.bestpractical.com
Objet : Re: [rt-users] Ticket numbering to start at 2000

http://requesttracker.wikia.com/wiki/SetStartingId