Match and Merge says “No Matches Found” when matches do exist.

Description


When running match and merge against a delimited file in PaperVision Capture, a user receives the message “No Matches Found” even though matches do exist. This issue occurs when a field contains values that are all numbers as well as values that are numbers and letters mixed.

 

Summary


This error is caused by ODBC attempting to identify the field type for a column based on the most common type of data. For example, if there is a column that contains invoice numbers, some of which contain only numbers and some contain a mixture of letters and numbers, ODBC will make this a number field if the majority of the fields contain only numbers. This makes the fields that contain a mixture unreadable.

Following these steps should resolve this issue if using a .csv file:

  1. Create a text file called schema.ini
  2. Open the file and update the Column Name and Column Type for each column of the file.
    1. [test.csv]Format=CSVDelimitedCharacterSet=OEM

      Col1="Column Name" Column Type

      Col2="Column Name" Column Type

      Col3="Column Name" Column Type

  3. Place the schema.ini file in the same folder as the .csv file.

 

Note that this will not be an issue with a database setup such as SQL or Access, since they explicitly define the column types. If using a different kind of delimited file (other than csv), this method can still be used; simply modify the format and character set to your needs.

Filed under PaperVision® Capture, R74.1

Last modified June 7, 2017

Submitted Dec 13, 2011

Related Articles

Share via Email Print