A-61635 December 2010
4-45
Index tab — Database
Lookup
Database Lookup can be used to populate or validate batch and document
index fields from ODBC (Open Database Connectivity) compliant data
sources. A configuration wizard is used to specify the data source, define how
the lookup is performed and what data is used to populate index files or
validate the contents of index fields. A Job Setup may contain more than one
Lookup. Each Lookup may be to a different data source and may be used to
populate or validate selected index fields. Lookups may occur during scanning
when the index value used for the Lookup is a result of a barcode reader or an
OCR action. Each Lookup takes the form: SELECT <table column 1>, <table
column 2>, ... <table column n> FROM <data source> WHERE <table column
x> = <index field value>.
Configuring Database
Lookup
Configuring Database Lookup starts with defining the batch and document
index fields that will be used by the Lookup. Database Lookups are configured
for each job.
NOTE: Defining of index fields in Job Setup has not changed from previous
versions of
Kodak
Capture Pro Software.
To add or edit a new lookup:
1. Click
File>Job Setup
. The Job Setup dialog box will be displayed.
2. Select a job setup from the
Job Name
drop-down list. The settings for the
job setup will be displayed.
3. Select the
Index
tab.
4. Select the
Database Lookup
tab. The Lookups table will be displayed with
the following fields:
Name, Input Index Field, Output Index Field (Batch)
and
Output Index Field (Document)
for each Lookup.