[rt-users] How to modify the ticket # format?

Tue May 12 11:11:09 EDT 2009

Well, I don't need to implement this style anymore - provided some 
reasoning, and was agreed upon.

What I would like to do, is now to increase the baseline of the ticket # - 
I don't need to start @ 1- too low, so I want to start around 1000.

Any idea how I can increase this number?

Eric Malenfant
Mitel Networks
IT Systems Specialist
AD / UNIX Systems / Network Applications 
Toll Free: 800.267.6244 ext 2864 
Eric_Malenfant at mitel.com

Unix is user friendly, it's just picky who it's friends are!

Eric_Malenfant at Mitel.com 
Sent by: rt-users-bounces at lists.bestpractical.com
05/12/2009 08:28 AM

To
Tom Lahti <toml at bitstatement.net>
cc
rt-users at lists.bestpractical.com, Ruslan Zakirov 
<ruslan.zakirov at gmail.com>
Subject
Re: [rt-users] How to modify the ticket # format?

Well, modifying the code is what was done years ago for our current 
implementation. It was deployed back before Mitel had purchased E-Smith 
(old Linux distro) and 
is actually still in use today, but we have some new requirements which 
warrants an upgrade. 

The one thing that would be great to keep, is how we are numbering our 
tickets today. 

Today, when a ticket is created, it does get a number like this: 

id: 20090414054 

this number would already be considered greater than 2147483647, and I 
believe from what I have heard about the history of this old RT 2.x 
deployment (I believe the old version in use is 2.0.7) 
was in fact that we worked with the devs to get this to work, and I can in 
fact see bigint(xx) in some parts of the schema. 

I can hack around that part. What I would like to know is where can I set 
the start # to begin with. 

If I do abandon this date format for tickets, I'd then want to start at 
something high, like 10000, not 1. 

Is that possible? 

Eric Malenfant
Mitel Networks
IT Systems Specialist
AD / UNIX Systems / Network Applications 
Toll Free: 800.267.6244 ext 2864 
Eric_Malenfant at mitel.com

Unix is user friendly, it's just picky who it's friends are! 

Tom Lahti <toml at bitstatement.net> 
05/11/2009 03:56 PM 

To
Ruslan Zakirov <ruslan.zakirov at gmail.com> 
cc
Eric_Malenfant at mitel.com, rt-users at lists.bestpractical.com 
Subject
Re: [rt-users] How to modify the ticket # format?

Ruslan Zakirov wrote:
> http://wiki.bestpractical.com/view/SetStartingId + cronjob to set it
> everyday, however you must understand limits on integers in your DB.

>> Example: #200905110001  would be the 1st ticket for today.

A normal signed int in 32-bit mysql has a maximum value of 2147483647, 
which
isn't big enough for the format requested.  You'd need to alter the table
structures to change ticket id's to a bigint.  How much code that would
break inside of RT, I have no idea.

-- 
-- ============================
  Tom Lahti
  BIT Statement LLC

  (425)251-0833 x 117
  http://www.bitstatement.net/
-- ============================
_______________________________________________
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090512/76f21971/attachment.htm>