204_
tool
tool
It is recommended to confi gure the text fi le that will be used in [Data Import] as follows: (The following is an example fi le that is
imported using the semi-colon (;) as the custom delimiter.)
Map/Preview Data by Columns
- Data Column(File): Click [Connect] to display the header information of the fi le of the card holder specifi ed 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, offi ce 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.
Click the [Export] tab.
Select a [Type].
Select a [DSN].
Provide the [ID].
Enter the [Password].
Click [Connection].
Select a table in the [Table] item where the exported data from the [Target Database] will be saved.
When the column mapping is completed, click [Mapping completed.].
Check the preview and click [Export] if you want to export the previewed data.
- Type: Select an export type from Database, Excel, and Text.
- DSN: Select a DSN from the list where the target database is defi ned. You can also specify the DSN using the data
source (ODBC) setting in Control Panel > Administrative Tools.
J
M
10.
11.
12.
13.
14.
15.
16.
17.
18.
M
