Interlogix Topaz Reference Manual - Manual (Page 18)

Card Import for Sapphire Pro and Topaz
Reference Manual
14
Place a check mark in the Enable Automatic Import checkbox.
Note: This check box is also part of the Multi-Server Option and in that program facilitates the sharing of information
between the servers. If this option is not available on the system, this setting allows only the Host Upload program
to function.
Automatic Import Processing
The Sapphire Pro host system processes all files found in the folder each time a file is found. The
processing of each record consists of:
1. Update the record in the employee data file
2. Queue the record for background download to field panels
3. Generate a card record import event.
When a Record Fails
When a record fails for some reason, an error is reported as a card record upload event in the Event
queue and the program skips the record. No alarm is created for this event. If you know when an
import has been performed (for example, HR always generates a new employee report at the end of
each business day) the operator can check the Event Queue and verify that the import was
successful.
See “Verify the Card Import” on page 12.
Source File Parameters
The source computer (for example, the Human Resources database server) is responsible for giving
each import file a unique name. This could be an increasing integer file name such as “1.csv”,
“2.csv”, etc.
• Maximum size per record is about 3500 characters.
• Maximum fields per record is 200.
• File update rate is approximately 1000 records per minute.
Conversion Hints and Tools
Introduction
This provides some tools and short cut hints that can be used in formatting the comma delimited file
for import into the host system. These tools are available with the Microsoft
®
Office Suite.
Using Microsoft Query to Import the Database to Excel
Microsoft Query, is a feature that is available with Microsoft Office 2000. One way to import
information from a database into Excel is to use Microsoft Query. This program translates the data
directly from the database into Excel without the intermediate step of having to export it from the
database. In order for this to work however, the database must use a driver that can be used by
Query.