Canon 3323B001 Administrator's Guide - Page 31

Mapping index fields to fields in a database

Get Canon 3323B001 - imageFORMULA ScanFront 220e PDF manuals and user guides
UPC - 013803103397
View all Canon 3323B001 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 31 highlights

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. 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 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.. Example: You configured a connector profile to scan insurance claims using the following 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 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.

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