How To Reset Ticket Numbers

From SDU
Revision as of 12:59, 11 August 2008 by BrianM (Talk | contribs) (Steps)

Jump to: navigation, search

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.