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.