Bulk Change ID

The Bulk Change ID option can be used to automatically handle large numbers of changed IDs for the Job, Department, or Company tables.

The ID information is imported from specially prepared Excel files, which must be saved in the CHANGEID folder (on the server’s SYSTOC subdirectory). A separate Excel file is required for each table, and the Bulk Change ID screen (show below) is used to bring the information into SYSTOC one file at a time. When this screen is opened, only the option boxes for files that exist in the CHANGEID folder are enabled.