Canon 3323B001 Administrator's Guide - Page 32

Map Database Fields, Select Table Name

Page 32 highlights

28 | Installing and configuring the connector If you modify the name of an index field, the mapping becomes invalid. You must always re-map mapped index fields after you change them. You can map one index field to one database field. To map index fields to fields in a database: 1 In the console tree, select Quick Connect > Properties. 2 Select the Index File tab, click New, and then define each index field that you want to map (see page 18). 3 Under File Format, select Database and then click Map Fields. If you have not yet configured a data source, configure it now (see page 31). If you previously configured a data source, the Data Field Selector window opens. It displays the connection information. ■ To use the current data source, proceed to step 4. ■ If you do not want to use the current data source, click Modify to select a different data source. When the Select Recent Data Source window opens, click New and follow the instructions for configuring a new data source (see page 31). 4 On the Map Database Fields tab, under Select Table Name, select a table. 5 Under Map Fields, which displays the index fields that you created, select the Quick Connect index field that you want to map to a database field. You do not have to map all the Quick Connect fields. In the Database Field column, which only displays fields of STRING data type, select the target field. The index values that the user at the device enters in the index fields will be stored in the database fields after the document is scanned. 6 Click OK to save the settings and return to the Index File tab. Note: The Index File tab does not indicate whether an index field is mapped to a database field.

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42

28
|
Installing and configuring the connector
If you modify the name of an index field, the mapping becomes invalid.
You must always re-map mapped index fields after you change them.
You can map one index field to one database field.
To map index fields to fields in a database:
1
In the console tree, select
Quick Connect
>
Properties
.
2
Select the
Index File
tab, click
New
, and then define each index
field that you want to map (see page 18).
3
Under
File Format
, select
Database
and then click
Map Fields
.
If you have not yet configured a data source, configure it now (see
page 31).
If you previously configured a data source, the
Data Field
Selector
window opens. It displays the connection information.
To use the current data source, proceed to step 4.
If you do not want to use the current data source, click
Modify
to select a different data source. When the
Select Recent
Data Source
window opens, click
New
and follow the
instructions for configuring a new data source (see page 31).
4
On the
Map Database Fields
tab, under
Select Table Name
,
select a table.
5
Under
Map Fields
, which displays the index fields that you
created, select the Quick Connect index field that you want to map
to a database field. You do not have to map all the Quick Connect
fields.
In the
Database Field
column, which only displays fields of
STRING data type, select the target field. The index values that
the user at the device enters in the index fields will be stored in the
database fields after the document is scanned.
6
Click
OK
to save the settings and return to the
Index File
tab.
Note:
The Index File tab does not indicate whether an index field
is mapped to a database field.