Spreadsheet Preparation
Simple preparation is needed to perform a bulk change ID using a spreadsheet application.
The required spreadsheet layout is very simple. You can create your own or use the pre-formatted templates that can be found under CHANGEID\Templates on the directory on which SYSTOC is installed.
- Company.xls
- Jobs.xls
- Department.xls
The first spreadsheet tab within each file must be named the same as the file. For example, in the Company.xls file, the first spreadsheet must be named Company. The first row of each file is treated as a header and is not imported. The table below show exactly what to name each cell in the first row for each file; no variation is permitted. Each entry can contain no more than eight alphanumeric characters, which must be formatted as text; do not use any masks or unusual characters.
Filename | Header Column A | Header Column B | Header Column C |
---|---|---|---|
Company.xls |
OLDCID |
NEWCID |
|
Jobs.xls |
OLDJOB |
NEWJOB |
CID |
Department.xls |
OLDDEPT |
NEWDEPT |
CID |