DATA IMPORT/EXPORT

Using the Data Import tool, you can save the access history of several card holders in the database. You can use Export to save information of card holders, events, and closing rules in various formats.

1.From the upper menu bar, select [Tool] > [Data Import/Export].

TOOL

2.Select the [Import(card holder)] tab.

3.Click [Open file] to specify a file to import. (you can import files in the formats of .xls.)

4.Select a sheet name in [Sheet Name] to import.

5.Click [Connect].

6.When the connection is successfully made, map the items in the [Mapping data and column] pane and click [Mapping].

7.When the mapping is completed, click [Save].

JThe initial password of saved User is set to 0000 by default. You can change the password and user information in [Access Control] > [Card Holder Management].

The excel file for [Data Import] is recommended to have the following format:

MPreview Mapping Data

-Data Column(File): Click [Connect] to display the header information of the file of the card holder specified to be imported to the Data Column(File).

-Data Column(DB): This is the column header of the database table to which the card holder information is entered. You can select a company, employee ID, card number, department, title, sex, e-mail address, home phone number, office phone number, and mobile phone number from the combo box. The red-marked columns are required so you must provide information for the columns.

-Preview: Displays the mapping information between the selected header and the database column. These are the data that will be imported to the card holder information table.

English _189