Interlogix Topaz Reference Manual - Manual (Page 25)

21
The information can now be modified to conform to the Field titles that are used by the Host Upload
Program.
Manipulating the Data in Microsoft Excel
Moving the CARD# Field to Column One
Often, when a database is data exported from another database, the first field is not the CARD#
data. It may be the employee name or the Human Resources Employee Number. If this is the case,
the following procedure easily moves the data to the first column.
To move this column, click on the grey bar at the top of the column so that the entire column is
highlighted. Right-click and select Cut from the pop-up window. Now click on the grey bar at the top
of Column A. Again, right click and select Insert Cut Cells. The CARD# column disappears from its
former location, the other columns move to the right and the CARD# column with all its data
reappears in column A.
Renaming Column Headers
Sometimes the Column Headers (line one of the comma delimited file) have titles that do not match
the ones in the host system. Using the
“Employee Table Field Descriptions” on page 5 , verify that
each of the column headers is correct. In our example, CCFCCARD becomes CARD#, USERID
becomes CRDHLDR#, ISSUELVL becomes ISSUENUM, etc.
If the source file has the employee name in three columns instead of one (Sapphire Pro and Topaz
use the field CARDNAME to hold the employee name), make certain that the Last Name has the
column header LNAME, the First Name column header is FNAME and the Middle Name is only the
initial and the column header is MNAME. They must also be in order: LNAME, FNAME, MNAME.