As databases often contain additional columns such as internal customer IDs or contact names and are not displayed on the document. You need to consider the following aspects for the creation of the fuzzy database and the columns you select for the Columns to Use import settings option for the use with Kofax Transformation Modules.

Extraction

When you use a fuzzy database for extraction such as for a Database Locator, but not in validation, you need to clear the selection of columns whose values are not displayed on the document as these decrease the confidence of the returned alternatives. The complete record inclusive the non selected columns is returned to the database locator and will be used for the final confidence computation.

Validation

If you use a fuzzy database in validation such as a database lookup button on a validation form, but not for extraction, you have to select all database columns you want to search for, even if their values are not displayed on the document. Only if those columns are imported can they be displayed in the Kofax Transformation Modules - Validation within the Fuzzy Database Search window. The complete alternative is returned and includes all columns, even if the columns are not selected and mapped to the fields normally.

Extraction and validation

If you use a fuzzy database for both extraction and validation, you have to select a column even if its values are not displayed on the document so that they are imported and you can search for them in Validation. For the extraction, in order that additional invisible columns do not decrease the confidence, you have to change the settings for the Database Locator and clear the selection of such a column in the properties on the Search Masks tab.

You can change the name of the columns by selecting a column, then clicking the column a second time and typing the new column name.