Canon 220E Owner's Manual download pdf (Page 31)

eCopy Connector for Quick Connect Administrator’s Guide | 27

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 databas

e and you w

ant 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.

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

fol

low

ing file naming format:

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 reco

rd 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.

Quick Connect Admin Guide.book Page 27 Wednesday, March 26, 2008 3:45 PM

1 2 ... 26 27 28 29 30 31 32 33 34 35 36 ... 41 42

No comments

Canon 220E Owner's Manual Page 31