Bulk Change ID

The Bulk Change ID option may be used to automatically handle large numbers of changed IDs for the Company, Department or Jobs 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 will be enabled.