How To Reset Ticket Numbers

From SDU
Revision as of 21:01, 11 August 2008 by Gityerfix (Talk | contribs)

Jump to: navigation, search
To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.

Overview

This article provides instructions to reset ticket numbers.

Steps

1. First do an extract of the Key_Contol (kc) table to a file.

pdm_extract Key_Control > key_control_tbl.txt

2. Open the newly created file and change the key_value field to a value you want and save.

3. Load the updated data.

pdm_userload -u key_control_tbl.txt

4. Recycle USD.

Warning

If you reset the value to a very low number, you might get duplicates when searching for tickets. Idearly you would want to first archive the old tickets before re-using the numbers all over.