Is it safe to manually increase the ticket ID counter?

Hi,

we would like the ticket IDs to start at 100.000 and not at 1, thus
making the ticket ID look more like an ID than a counter[1]. Does
RT tolerate such ‘holes’ in the ticket ID sequence? Is it safe to
manually set the counter to 100000 in MySQL directly?
Or are there any for($i=1; $i <max $i++)-style loops that will break?

Thanks in advance.

Jan

Yes. This is perfectly safe.

-R

At Tue, 11 Nov 2003 20:05:57 +0100,
Jan Algermissen wrote:

I was going to ask a question like this myself. I wanted to start
tickets at a certain number, and I wanted to create tickets to have a
specific number (basically, I’m importing tickets from ticketsmith).

My thinking was 1) Set starting number, 2) create tickets in order,
incrementing starting number for any gaps.

However, if I can setup a script to pull tickets out of ticketsmith,
email them in, can I then change the numbers to what we had in the old
system directly in mysql? I’m pretty familiar with manipulating sql
databases, but I was wondering if I would have to change the ticket
number in multiple places or face breaking it.

I’m only talking about the first instance of the ticket. I would change
the ticket numbers, and then send in the ticket updates using the
updated ticket number.

Robert Spier wrote:

Yes. This is perfectly safe.

-R

At Tue, 11 Nov 2003 20:05:57 +0100,
Jan Algermissen wrote:

Hi,

we would like the ticket IDs to start at 100.000 and not at 1, thus
making the ticket ID look more like an ID than a counter[1]. Does
RT tolerate such ‘holes’ in the ticket ID sequence? Is it safe to
manually set the counter to 100000 in MySQL directly?
Or are there any for($i=1; $i <max $i++)-style loops that will break?

Thanks in advance.

Jan


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

John Hogenmiller, kb3dfz
Network Engineer

877-716-2002 x 545

http://fsck.com/rtfm/article.html?id=5#224

Is this of any help? It describes how to set the starting number for MySQL
and Pg. I would assume that importing the tickets in order after that would
work.

Mik

John Hogenmiller writes:

I was going to ask a question like this myself. I wanted to start
tickets at a certain number, and I wanted to create tickets to have a
specific number (basically, I’m importing tickets from ticketsmith).

My thinking was 1) Set starting number, 2) create tickets in order,
incrementing starting number for any gaps.

However, if I can setup a script to pull tickets out of ticketsmith,
email them in, can I then change the numbers to what we had in the old
system directly in mysql? I’m pretty familiar with manipulating sql
databases, but I was wondering if I would have to change the ticket
number in multiple places or face breaking it.

I’m only talking about the first instance of the ticket. I would change
the ticket numbers, and then send in the ticket updates using the
updated ticket number.

Robert Spier wrote:

Yes. This is perfectly safe.

-R

At Tue, 11 Nov 2003 20:05:57 +0100,
Jan Algermissen wrote:

Hi,

we would like the ticket IDs to start at 100.000 and not at 1, thus
making the ticket ID look more like an ID than a counter[1]. Does
RT tolerate such ‘holes’ in the ticket ID sequence? Is it safe to
manually set the counter to 100000 in MySQL directly?
Or are there any for($i=1; $i <max $i++)-style loops that will break?

Thanks in advance.

Jan


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm


John Hogenmiller, kb3dfz
Network Engineer
Pennswoods.net
877-716-2002 x 545


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Mik Firestone
Vice Principal
Rule of Ten, Inc.