Re: [rt-users] Custom numbering scheme?
mysql ALTER TABLE Tickets AUTO_INCREMENT=2013000; INSERT INTO Tickets(Disabled) VALUES(1); DELETE FROM Tickets WHERE id = '2013000' Tickets will then start at 2013000 and increment 2013001, 2013002, etc. How many 0s you append to 2013 should reflect the expected ticket load for that year. If you get 2000 tickets in 2013 then it will be 2015000 by the end of the year. N.B.,Tickets.id is int(11), so you won't be able to do more than 2013000, but a million tickets a year would be impressive. You'll have to execute the above commands again in 2014 and every year after to maintain this. Maybe a cron job will take care of it. On Thu, May 2, 2013 at 1:52 PM, Cena, Stephen (ext. 300) s...@qvii.comwrote: ** I'm going to be deploying another RT installation for our service department here. One thing they would like is to have the ticket numbers customized. What they'd like is for the current year to be prepended to each ticket number, and then reset. So for 2013 it's be, say, 20131 - 2013n and then next year have 20141 to 2014n and so on. Is something like this possible, or should I just tell them it's too difficult? Stephen Cena QVII MIS/IT Dept 850 Hudson Ave. Rochester, NY. 14620 585-544-0450 x300 s...@qvii.com Thank you for helping us help you help us all. --For email related issues, please contact postmas...@qvii.com
[rt-users] Custom numbering scheme?
I'm going to be deploying another RT installation for our service department here. One thing they would like is to have the ticket numbers customized. What they'd like is for the current year to be prepended to each ticket number, and then reset. So for 2013 it's be, say, 20131 - 2013n and then next year have 20141 to 2014n and so on. Is something like this possible, or should I just tell them it's too difficult? Stephen Cena QVII MIS/IT Dept 850 Hudson Ave. Rochester, NY. 14620 585-544-0450 x300 s...@qvii.com Thank you for helping us help you help us all. --For email related issues, please contact postmas...@qvii.com
Re: [rt-users] Custom numbering scheme?
On Thu, May 2, 2013 at 9:52 PM, Cena, Stephen (ext. 300) s...@qvii.comwrote: ** I'm going to be deploying another RT installation for our service department here. One thing they would like is to have the ticket numbers customized. What they'd like is for the current year to be prepended to each ticket number, and then reset. So for 2013 it's be, say, 20131 - 2013n and then next year have 20141 to 2014n and so on. Is something like this possible, or should I just tell them it's too difficult? It's too difficult. Stephen Cena QVII MIS/IT Dept 850 Hudson Ave. Rochester, NY. 14620 585-544-0450 x300 s...@qvii.com Thank you for helping us help you help us all. --For email related issues, please contact postmas...@qvii.com -- Best regards, Ruslan.
