<font size=2 face="sans-serif">Well, I don't need to implement this style
anymore - provided some reasoning, and was agreed upon.</font>
<br>
<br><font size=2 face="sans-serif">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.</font>
<br>
<br><font size=2 face="sans-serif">Any idea how I can increase this number?</font>
<br>
<br><font size=2 face="sans-serif">Eric Malenfant<br>
Mitel Networks<br>
IT Systems Specialist<br>
AD / UNIX Systems / Network Applications <br>
Toll Free: 800.267.6244 ext 2864 <br>
Eric_Malenfant@mitel.com<br>
<br>
Unix is user friendly, it's just picky who it's friends are!</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>Eric_Malenfant@Mitel.com</b>
</font>
<br><font size=1 face="sans-serif">Sent by: rt-users-bounces@lists.bestpractical.com</font>
<p><font size=1 face="sans-serif">05/12/2009 08:28 AM</font>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">Tom Lahti <toml@bitstatement.net></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td><font size=1 face="sans-serif">rt-users@lists.bestpractical.com, Ruslan
Zakirov <ruslan.zakirov@gmail.com></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">Re: [rt-users] How to modify the ticket
# format?</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 face="sans-serif">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</font><font size=3>
</font><font size=2 face="sans-serif"><br>
is actually still in use today, but we have some new requirements which
warrants an upgrade.</font><font size=3> </font><font size=2 face="sans-serif"><br>
<br>
The one thing that would be great to keep, is how we are numbering our
tickets today.</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
Today, when a ticket is created, it does get a number like this:</font><font size=3>
<br>
<br>
id: <b>20090414054</b> <br>
<br>
this number would already be considered greater than </font><tt><font size=2>2147483647</font></tt><font size=3>,
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) <br>
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. <br>
<br>
I can hack around that part. What I would like to know is where can I set
the start # to begin with. <br>
<br>
If I do abandon this date format for tickets, I'd then want to start at
something high, like 10000, not 1. <br>
<br>
Is that possible? <br>
<br>
</font><font size=2 face="sans-serif"><br>
Eric Malenfant<br>
Mitel Networks<br>
IT Systems Specialist<br>
AD / UNIX Systems / Network Applications <br>
Toll Free: 800.267.6244 ext 2864 <br>
Eric_Malenfant@mitel.com<br>
<br>
Unix is user friendly, it's just picky who it's friends are!</font><font size=3>
<br>
<br>
</font>
<table width=100%>
<tr valign=top>
<td width=38%><font size=1 face="sans-serif"><b>Tom Lahti <toml@bitstatement.net></b>
</font>
<p><font size=1 face="sans-serif">05/11/2009 03:56 PM</font><font size=3>
</font>
<td width=61%>
<br>
<table width=100%>
<tr valign=top>
<td width=11%>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td width=88%><font size=1 face="sans-serif">Ruslan Zakirov <ruslan.zakirov@gmail.com></font><font size=3>
</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td><font size=1 face="sans-serif">Eric_Malenfant@mitel.com, rt-users@lists.bestpractical.com</font><font size=3>
</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">Re: [rt-users] How to modify the ticket
# format?</font></table>
<br>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br><font size=3><br>
<br>
</font><tt><font size=2><br>
Ruslan Zakirov wrote:<br>
> </font></tt><a href=http://wiki.bestpractical.com/view/SetStartingId><tt><font size=2 color=blue><u>http://wiki.bestpractical.com/view/SetStartingId</u></font></tt></a><tt><font size=2>
+ cronjob to set it<br>
> everyday, however you must understand limits on integers in your DB.<br>
<br>
>> Example: #200905110001 would be the 1st ticket for today.<br>
<br>
A normal signed int in 32-bit mysql has a maximum value of 2147483647,
which<br>
isn't big enough for the format requested. You'd need to alter the
table<br>
structures to change ticket id's to a bigint. How much code that
would<br>
break inside of RT, I have no idea.<br>
<br>
-- <br>
-- ============================<br>
Tom Lahti<br>
BIT Statement LLC<br>
<br>
(425)251-0833 x 117<br>
</font></tt><a href=http://www.bitstatement.net/><tt><font size=2 color=blue><u>http://www.bitstatement.net/</u></font></tt></a><tt><font size=2><br>
-- ============================</font></tt><font size=3><br>
</font><tt><font size=2>_______________________________________________<br>
</font></tt><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users"><tt><font size=2>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</font></tt></a><tt><font size=2><br>
<br>
Community help: </font></tt><a href=http://wiki.bestpractical.com/><tt><font size=2>http://wiki.bestpractical.com</font></tt></a><tt><font size=2><br>
Commercial support: sales@bestpractical.com<br>
<br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <br>
Buy a copy at </font></tt><a href=http://rtbook.bestpractical.com/><tt><font size=2>http://rtbook.bestpractical.com</font></tt></a>
<br>