Interlogix Topaz Reference Manual User Manual
Page 8
Card Import for Sapphire Pro and Topaz
Reference Manual
4
Importing Security Areas
If Security Areas are to be assigned to a cardholder in the import process, the area name
is the Field Name in the first line of the comma delimited file and the Time Schedule ID
number is the value in the card record. For example, the cardholder is to be assigned to
the Lobby during Business Hours. The Lobby Security Area is LOBBY and the Business
Hours ID is 8. The field name LOBBY will be included in the first line of the import field.
The number 8 will be in the corresponding place on the cardholder record line of the
import file.
Other Field Formatting Parameters
The file to be imported can use either comma delimited fields with quotes on fields when
embedded commas are used (EXCEL format) or comma delimited fields with quotes on
all fields (ACCESS format).
Dates can be YY/MM/DD or YYMMDD.
Empty values. i.e., , "", or ,, are permissible for field types DATE,BCD,BINARY and ASCII
fields. DATE, BCD and BINARY fields receive zero fill. ASCII fields receive blank fill.