Interlogix Topaz Reference Manual - Manual (Page 26)

Card Import for Sapphire Pro and Topaz
Reference Manual
22
When Sapphire Pro sees these columns, it combines them into the one field CARDNAME and
discards the other fields.
While renaming the columns, delete any columns of information that will not be used.
Renaming User Defined fields
Sapphire Pro and Topaz provide 11 fields for User defined additional personnel information. This
could include items like employee Blood Type, Home Address, or Birth Date. Anything that Security
would find helpful. These user field names can be modified in Sapphire Pro or Topaz and once
modified, the new labels appear on the Employee Custom field screen. However, Sapphire Pro and
Topaz still see this information as being in field USERFLD1, USERFLD2, etc. The operator must
ascertain what information is contained in a column and change the header name to the
corresponding USERFLD[#]. For example, In our sample database, a column with the header AFFIL
refers to the Function of the employee i.e. Executive, Engineer, etc. The operator determines that
this is USERFLD8 in Sapphire Pro or Topaz. The operator changes the header of that field from
AFFIL to USERFLD8. Using the Custom Field reference, rename the headers in the database that is
being imported to the corresponding USERFLD[#].
Continue to rename the column headers until all the headers match the field names in Sapphire Pro
or Topaz.
Distributing Data across Multiple Columns
There may be some columns that contain more than one piece of data. For example, in our spread
sheet, all of the Security Areas are contained in the one column named AREANAME
.
Sapphire Pro and Topaz use separate columns for each area so the operator must insert a column to
the right of this column for each area. (Row 6 requires three additional columns.) Rename the
columns to match the Sapphire Pro or Topaz fields.
Replace Imported Header with Sapphire
Pro or Topaz Header
This cell has both Break Area and
Conference. They are separated
by a vertical line.