The Scan File Data Extractor enables you to summarise and record all the verifications made by recording them in a standalone database. It uses the data from the Axicon scan files (those with a .scn extension) to create a complete record of all the files that have been saved, either automatically or manually.
It is therefore possible for a quality manager, for instance, to inspect verifications made by a member of staff from a particular shift, or even from a remote site over any period (say, a week or a month) in order to monitor print press performance and barcode quality.
Scan files can also be imported into the database manually by selecting the import function from the file menu. It is possible to import a whole folder of scan files, or just a selection, in one import process, simply by selecting all of the files that are required.
Imported verification results are displayed in the table of records. Each row contains data from one scan file, and each column contains a single item of data from the scan file. If verifications have been saved with additional plugin data, this information is displayed in its own panel below the main table. The table can be sorted on certain fields to make locating a particular verification record easier when the table contains many results, and it is also possible to see more detail about an individual record by selecting Display Scan from the file menu, or clicking on the Axicon Linear Verifier icon . This will launch the Axicon Linear Verifier software (if it is not already running), and will open the scan file for viewing in that application.
The table itself can be extremely useful for viewing the complete data about all of the verifications that have been imported, but when generating a report from this data it is likely that only some of the data will be required. It is possible to export chosen fields of data from the table to a CSV (comma separated values) file, for use in an application such as Microsoft Excel.
This is done by selecting Choose CSV fields from the options menu. It is possible to select whichever data fields may be required and to choose whether or not plugin results are also output to the CSV file by selecting the plugin fields tab and ticking the appropriate plugin. This data can then be stored in a CSV file format by selecting Save CSV from the file menu and it is possible to see the output format for this file in the panel beneath the table if the CSV preview tab is selected.
Data can always be added to the table by importing more scan files. It is possible to clear the database completely by selecting the appropriate option from the options menu if a fresh start is required. Individual records can also be deleted from the database by selecting the record so that it is highlighted and then clicking the - button.
Scan file Data Extractor -
Verification results in a spreadsheet
JOB REF - All
Allows a single line reference for ISO traceability and spreadsheet information; forms part of the printed report. You can configure a default Job Reference, and also choose to be prompted for a job reference on every scan.
LENGTH CHECK - All
Allows for checking of minimum and maximum lengths of Code 39, ITF, Codabar, Code 128, GS1 DataBar, MSI Plessey, and Code 93 symbols.
LOOKUP - All
Links to an existing database to show (and print) description of product along with quality control information. Please see Text Lookup below.
LPPR - Pharmaceutical
Checks French (Liste des Produits et Prestations Remboursables) LPPR codes as applicable.
M&S - Retail
Gives details on in-store reference, supplier code, GTIN, quantity and check digit on 20 digit M&S transit labels.
MSI PHARM - Pharmaceutical
Validates code structure and format of CNK (Code Nationale Kode) used on Belgian pharmaceutical products.
MULTI PLUG - All
Configurable to allow for checking that one or more plugins have been satisfied.
NL INTERNAL - Retail
Checks data on in-store variable measure products (eg: variable weight with price or weight shown) as specified by GS1 Netherlands.
PZN - Pharmaceutical
German Pharmaceuticals Code. Validates code structure and format.
SISAC - All
Displays expanded version of the data encoded in the SICI (Serial Item and Contribution Identifier) incorporating: ISSN, Chronology enumeration/supplement and all other details.
TEXT LOOKUP - All
Specially designed for .csv and .txt databases. Several copies of the Lookup plugin can be installed if the user needs to refer to multiple databases for two or more fields within a single database. Click here for more information.
TIME ZONE - All
Records the time zone setting of the PC where the scan is made.
UB PHARM - Pharmaceutical
Displays Belgian Pharmacodes.
UK COUPON - All
Shows the monetary value of a United Kingdom coupon code from a standard EAN-13 barcode.
UPC - All
Displays UPC-A and UPC-E codes formatted in their original short forms, rather than as EAN-13s.
USER DATA - All
Allows multiple job referencing: relevant information can be appended to a scan. This can be exported to a spreadsheet using Scan DB Extractor and saved in CSV format. Particularly suitable for undertaking audits in manufacture and retailing.
USER NAME - All
Automatically displays network user logged on at time of scan; ideal for ISO 9001 procedures.
WOOLWORTHS - Retail (Aus)
Checks variable measure consumer unit barcodes beginning with 20, 21, 23, 25, 26, 27 for Woolworths Australia.