Installation guide

l If you select this option, batch job-dependent index values will be recorded in a different
node (for an XML file) or a different row (for CSV and TSV files, and database tables). This
does not apply when the connector is processing only one batch scanning job
39.1.14 - Mapping index fields to fields in a database
This feature enables you to specify a database that will 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.
Note:
The connector profile stores all mapped index values in the target database as STRING data, regardless of the type of
index field.
If you store 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.
Example:
Click here to see the example:
You configured a connector profile to scan insurance claims using the following file naming format:
eCopyClaims<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.
To map index fields to fields in a database:
1. Select the Index file tab, click New, and then define each index field that you want to map.
2. Under File format, select Database and then click Map Fields.
The Configure data source window opens.