Wednesday, December 31, 2008

How to Reset Your Case Numbering for 2009

Some programs reset their case numbering counter every year, so that the first new case of the year will be numbered XXXX00001. If you're one of those programs, here's a reminder on how to do the reset.

* Log into your preferred database administration software (often this is phpMyAdmin.)

* Select your Pika database from the menu of
databases on the server.

* Click on the tab labeled "SQL".

* Paste the following SQL code into the form:

UPDATE counters SET count='0' WHERE id='case_number'
LIMIT 1;

* Click the "Go" button.

That's it! Give us a call if you run into any problems, (888) 321-7452 x0. Happy New Year!

No comments: