eCopy ShareScan
®
Installation and Setup Guide
|
147
Mapping index fields to fields in a database
This feature enables you to specify a database to store index values entered at an eCopy-enabled
device. You can map any type of Quick Connect index field to fields in an SQL, Access, or Oracle
database. When a user enters values in mapped index fields, the connector profile stores the values
in the associated database fields.
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.
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.
Note:
The connector profile stores all mapped index values in the target database as STRING data, regardless
of the type of index field.
Example:
You configured a connector profile to scan insurance claims using the following file naming format:
<eCopy><Claims><
Date
><
Time
>
You configured the profile to store the scanned documents, named as shown below, in the target database:
eCopyClaims20060523123318.pdf
eCopyClaims20060523123319.pdf
eCopyClaims20060523123320.pdf
You created several Quick Connect index fields to capture account information and mapped them to fields in a
database.
To associate the database record used to store the scanned documents with the database record used to store
the scanned document’s index values, you must have an index field of type “File Name” that captures the file
name during scanning.
