beautypg.com

Middleware applications, Csv-parser, Image generator – Opticon ESL User Manual

Page 28

background image

Opticon ESL

DEMO KIT

User Manual




28

6. Middleware applications

The ESL server application uses middleware applications to process the information from the
Back office into file formats that the ESL server application uses to update ESL‟s.

The main tasks of the middleware are divided into 2 applications: the CSV-parser and the
Image generator. These will be described in the following chapters.

6.1. CSV-parser

The tasks of the CSV-parser are:

Parse product database files (modifications or complete databases) into a combined CSV-
database containing all product info.

Generate a reduced article database (CSV-format) for the barcode terminal.


The typical record format of a product modification database would be:


;;;;;;etc.


The typical record format of a complete product database would be:

;;;;;;etc.


Besides the first field (modification code) the order and amount of remaining fields can be
changed. See chapter 4.1 for more information on the CSV-format.

The record format of the truncated database file (scan.csv) for the bar code terminal that is
generated will have the following format:

;;

If no barcodes are used in your application or the Unique ID is the barcode, then the
field will be the same as the Unique ID.

The ESL server manager will call the CSV-parser with the following parameters as
specified in the setup window of the ESL server application:


.exe –O -i -b -dfield> .csv

So the default call by the ESL server application would be:


CsvParser.exe –O "Output" -i1 -b2 -d3 "Input\ProductData_1.csv"

6.2. Image generator

The task of the Image generator is to generate BMP- and XML-files for each linked ESL from the
combined product database (dbase.csv) and the link database (linked.csv).