You are here

Home

60. How do I use a text file as an ODBC Lookup table in EzeScan?


  1. First use wordpad to create a simple text lookup file in the c:\Documents and Settings\All Users\Application Data\Outback Imaging\Lookups directory. The file will use a csv format. For example we will create a file called c:\Documents and Settings\All Users\Application Data\Outback Imaging\Lookups\Formtypes.txt. It will contain several rows like:
    2. "001","Form 1"
    "002","Form 2"

    Where column 1 is the form TYPE, and column 2 is the form DESCRIPTION.

  2. Then we create a new ODBC DSN using the Microsoft Text Driver (.txt). This will effectively make the text lookup file behave as a simple database table.

    3. To do this use the Control->Panel->Administrative Tools->Data Sources(ODBC) option to start the ODBC Data Source Administrator form. Then create a System DSN using the Microsoft Text Driver . The ODBC Text Setup form is displayed. Set the Data Source Name to Formtypes.

    Then Untick 'Use Current Directory'. Then press Select Directory and browse to the c:\Documents and Settings\All Users\Application Data\Outback Imaging\Lookups directory and press OK (Please Note that in some cases you might not be able to see this directory until you remove the hidden attribute on the :\Documents and Settings\All Users\Application Data directory).

    Press the Options>> button and then press the Define Format button. in the list of tables select Formtypes.txt and then press Guess. Press OK. Ignore the error message that says "Failed to save the attributes of (null) into (null)" - its a Microsoft issue.

    Press OK to close the ODBC Text Setup form. Close the ODBC Data Source Administrator form. If you now look in the c:\Documents and Settings\All Users\Application Data\Outback Imaging\Lookups directory there is now a new file called schema.ini that contains:

    [formtypes.txt]
    ColNameHeader=False
    Format=CSVDelimited
    MaxScanRows=25
    CharacterSet=OEM
    Col1=F1
    Col2=F2

  3. Using Wordpad or Notepad edit the c:\Documents and Settings\All Users\Application Data\Outback Imaging\Lookups\schema.ini file so that it contains the following text:

    4. [formtypes.txt]
    ColNameHeader=False
    Format=CSVDelimited
    MaxScanRows=25
    CharacterSet=OEM
    Col1=TYPE Char Width 255
    Col2=DESCRIPTION Char Width 255

    Close the editor, saving the changes.

  4. Then in KFI use the KFI Admin form, edit button to edit the KFI filed that is going to use this ODBC lookup. On the KFI ODBC Settings form set the ODBC DSN to Formtypes. The SQL statement syntax will be something like:

    5. select TYPE from formtypes.text

    select DESCRIPTION from formtypes.txt

    select DESCRIPTION from formtypes.txt where TYPE='001'

    select DESCRIPTION from formtypes.txt where TYPE='<<F1>>'

Direct link to FAQ