As well as measuring the quality of printed barcodes, Axicon’s verifier software can be used to check that the correct barcode is associated with the right product. Using a plugin called ‘TextLookup’ enables a user to consult a file to check the description of the product against the GTIN (global trade item number) shown in the barcode. ‘TextLookup’ is used with either .txt or .csv files and only permits read access, so users cannot change the data.
If you would prefer to access your database directly, another plugin called ‘Lookup’ may be used. ‘Lookup’ provides read/write access to the database, and can be used with ODBC (Open Database Connectivity) links with one or more databases.
Operation and configuration of the plugin
Establishing the text lookup file
A file for the verifier lookup can be established in several ways – small files can be created directly using a program like Windows Notepad or exported from an existing Excel spreadsheet file simply by using the “File/Save as” command and specifying the file type as .csv. A .csv file may be exported from an ERP system by using an “export” command.
Format of the text lookup file
The preferred format is a .csv (comma separated variables) file, so that each of the data fields is separated by a comma.
The file should include titles for each field of data. This will prevent any confusion about what the data means when accessing the database. A simple file would then look like this (right):
Please note that it is not necessary to enter the data in any particular sequence. If a file is constructed without double quotes (“) around the data fields, it is essential to check the data field entries for any embedded commas within them.
Configuring the TextLookup plugin
Start the Axicon Verifier program and then from the Command window menu select “Options” and then “Set up”. On this window, click on the tab “Plugins”. The following window will appear (right).
Highlight “TextLookup” and ensure that the box is ticked. Press the button marked “Configure”, and then the next window will appear (below ).