Kofax-Database Validation using an Excel spreadsheet

Owned by Michael Atkins
Feb 22, 2021
1 min read

Applies to

Kofax Capture 10.x and 11.0

Summary

How to utilize Kofax Capture's Database Validation feature using an Excel spreadsheet.

Answer/Solution

  1. In Excel, create a range using the columns from the worksheet to be used in the validation. Select the columns (A, B, C, etc.) and then click Insert ¦ Name ¦ Define... .

  2. Enter a unique name in the 'Names in workbook' field. Verify that the 'Refers To' field contains the columns that you selected. Note: If you select a name already on the list, the 'Refers To' column will automatically change to the currently configured cells for that range. Make sure that you modify the range before clicking OK.

  3. Click OK when done.

  4. Save the workbook.

  5. Configure an ODBC data source using the spreadsheet.
    Configure Kofax Capture's Database Validation as normal. The range name becomes the table name used in Kofax Capture. The columns that make up this range will be the fields validated against.

CASO Knowledge Base