Interlogix Topaz Reference Manual Manual do Utilizador

Card Import for Sapphire Pro and TopazReference ManualP/N 460921001B • ISS 04MAR11

Card Import for Sapphire Pro and TopazReference Manual6Cardholder NameCARDNAME Alphanumeric Up to 32 characters.When the database being imported uses

7Keypad NumberKEYPAD Numeric 1 to 6 digits.This is the number entered by an employee at a reader. Also known as the PIN (personal Identification Numbe

Card Import for Sapphire Pro and TopazReference Manual8Security area1SA 4 TZ Numeric ID of time schedule when access is authorized to corresponding se

9User Defined Field #2USERFLD2 Alphanumeric Up to 24 characters.User defined fields can be set up by the operator for use in storing additional refere

Card Import for Sapphire Pro and TopazReference Manual10Format ReviewAs a final precaution, review the comma delimited file to verify that the informa

11Importing the Database ManuallyOnce the comma delimited file has been created, all Field names are correct, and data has been verified as in the cor

Card Import for Sapphire Pro and TopazReference Manual12If the exact path to the import file is known, type the path into the field beside Import from

13In the illustration above, the error is listed as FIELD CARDNUM, FIELD NAME NOT DEFINED. This means that one of the column headers in the Excel spre

Card Import for Sapphire Pro and TopazReference Manual14Place a check mark in the Enable Automatic Import checkbox.Note: This check box is also part

15There are several drivers that are already available in the program that can be used to retrieve data from the following data sources: Microsoft Acc

Copyright Copyright © 2011, UTC Fire & Security. All rights reserved. This document may not be copied in whole or in part or otherwise reproduce

Card Import for Sapphire Pro and TopazReference Manual16Double click on <New Data Source> to locate the database file to be imported. The follow

17Select the Database from the drop-down list of all databases on the data server selected above. If there is only one database on the server, you can

Card Import for Sapphire Pro and TopazReference Manual18Using the list of Field Name Definitions in the Appendix of this supplement, select the fields

19our example, we have already uploaded all the employee records before user number 127465. By selecting the USERID column and the is greater than con

Card Import for Sapphire Pro and TopazReference Manual20If uploads are performed routinely using the selections that have been made in this query, cli

21The 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

Card Import for Sapphire Pro and TopazReference Manual22When Sapphire Pro sees these columns, it combines them into the one field CARDNAME and discard

23Now separate the multiple data that is contained in some of the columns from the imported database. In our sample, all Security Areas in the importe

Card Import for Sapphire Pro and TopazReference Manual24.The next Wizard dialog box allows the operator to set the format for the data in each column.

25Click Finish. A message asks if the data being separated can “over write” the data in the columns to the right. Since these columns are empty, click

iContentsOverview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Card Import for Sapphire Pro and TopazReference Manual26

Card Import for Sapphire Pro and TopazReference Manualii

1OverviewThe information contained in this manual provides instruction on uploading and converting an external cardholder database to a Sapphire Pro o

Card Import for Sapphire Pro and TopazReference Manual2Formatting the Comma Delimited FileThe comma delimited file must have at least the card number

3CARDNAME FieldThe CARDNAME field is an exception to field names matching the descriptor file. Often the data for this field are contained in three fi

Card Import for Sapphire Pro and TopazReference Manual4Importing Security AreasIf Security Areas are to be assigned to a cardholder in the import proc

5Employee Table Field DescriptionsFunctionalField NameProtocolField Name Type of Value DescriptionAccess Group #1ACCGRP 1 Numeric Up to 3 charactersTh