Change the ticketing number

leovipin1

Hi,

I am a complete newbee for PHP and MySQL. I would need your help for change in the ticketing number schema. I want the ticket number to be of 11 digits for ex. 20111117001. In this the first four digits are the year, next two digits are the month, the next two digits are day. The last three digits are the numbers that would increment everytime a ticket is opened.

I would like the date of the system be used here, for the first eight digits of the ticket. These eight digits change as the date of the system changes.

Also the last three digits of the ticket number reset, as the date changes.

Need your help on this. Need to implement this in my office.

Thanks in advance,

Vipin Kumar

leovipin1

Customize the ticket number

Hi All,

I tried to customize the ticket number by the help of the MOD in this link http://www.openscriptsolution.com/2009/11/18/how-to-customize-the-ticket-number-in-osticket-v1-6-rc5(http://www.openscriptsolution.com/2009/11/18/how-to-customize-the-ticket-number-in-osticket-v1-6-rc5) By inserting $today = date("Ymd"); instead of "custom" as mentioned in the link. But i am getting this error,

Unknown column '$today4' in 'field list' Kindly help me with this error, I am very much near to customize the ticket number.

masino_sinaga

Make sure your $today4 variable contains the valid value for the ticketID in your SQL. Try to echo it in order to make sure you have done what you should do. Good luck!

Sincerely,

Masino Sinaga