Interlogix Topaz Reference Manual - Manual (Page 22)

Card Import for Sapphire Pro and Topaz
Reference Manual
18
Using the list of Field Name Definitions in the Appendix of this supplement, select the fields from
the database table by clicking on the desired field, then clicking the right arrow button to move it
from the Available window to the Columns in your query window. It is recommended that columns
are selected in the same order as the Field Definitions table to facilitate editing work in the Excel file.
Note: If the database being imported has the employee name in more than one column, select the columns in Last
Name, First Name, Middle Initial order. These are combined into the single field CARDNAME when the data is
imported into the host system.
Once you have selected all the columns to be converted, click Next to open the Filter dialog window.
This window allows you to limit the query to certain records that match selected criteria. This is
helpful if this table has been imported before and only the additional records are to be retrieved. In