Konica Minolta eCopy - Manual (Page 127)

Quick Connect Update | Page 119
Mapping an index field to a database location
You can map any type of index field — Alphanumeric, File Name, Numeric, etc. — to fields in a
database. When a user enters values in mapped index fields, the connector stores the index values
in the associated database fields.
All mapped information is stored in the database as STRING data, regardless of the type of index
field.
If you are storing scanned documents in a database and you want to create a relationship between
the database fields where the documents are stored and the database fields where the index values
are stored, make sure that one of the mapped index fields is of the type “File Name”. Index fields of
type “File Name” automatically use the file name of the scanned document that is stored in the
database destination.
For example, assume that you configured a connector profile to scan insurance claims using this
file name: <eCopy><Claims><Date><Time>. You also configured the profile to store the scanned
documents — named “eCopyClaims20060523123318.pdf”, “eCopyClaims20060523123319.pdf”,
etc — in a database. In addition, you created several index fields to capture account information
and mapped them to a database. To associate the record in the database that stores the scanned
documents with the record in the database that contains the document’s index values, you must
have an index field of type “File Name”, which captures the file name during scanning.
If you modify a mapped index field, the mapping becomes invalid. You must always re-map
mapped index fields after you change them.
To map index fields to a database location:
1 Select Quick Connect > Properties > Index File .
2 Define the index fields that you want to map (see “Defining an index field”).
3 Select File Format > Database , then click Map Fields .
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.
> To configure a new data source, click Modify . When the Select Recent DataSource window
opens, click New (see “Configuring a datasource” ).