Opticon ESL Server User Manual

Opticon ESL
ESL Server manual
v1.0.62.2
41
An example of a product table with barcodes is shown below.
CREATE TABLE products
(
[Barcode] VARCHAR(20) PRIMARY KEY,
[ID] VARCHAR(20),
[Description] VARCHAR(60),
[Group] VARCHAR(10),
[Std. Price] VARCHAR(10),
[Sell Price] VARCHAR(10),
[Content] VARCHAR(20),
[Unit] VARCHAR(10))
The configuration in the ‘Data’-tab would then become:
7.2.1.4 Product staging table
Changed product information should be inserted in the product staging table and the ESL server
will automatically detect and process this data and insert the data into the Product table. If the
processed data requires an ESL to be updated, it will automatically generate a new image and
sent it to the ESL.
The product staging table must have the exact same formatting as the product table, but should
also contain a ‘DELETE’ column. The ‘DELETE’ column makes it possible to remove a product
from the link table, by placing an ‘X’ in this column. *
The product staging table that match the previous product table examples are shown below.
CREATE TABLE products_staging
(
[ID] VARCHAR(20) PRIMARY KEY,
[Description] VARCHAR(60),
[Group] VARCHAR(10),
[Std. Price] VARCHAR(10),
[Sell Price] VARCHAR(10),
[Content] VARCHAR(20),
[Unit] VARCHAR(10),
[DELETE] VARCHAR(1))
Or with barcode column:
CREATE TABLE products_staging
(
[Barcode] VARCHAR(20) PRIMARY KEY,
[ID] VARCHAR(20),
... )
* Oracle requires the column ‘DEL’ instead of ‘DELETE’

Opticon ESL Server Specifications

General

Brand	Opticon
Model	ESL Server
Category	Wireless Router
Language	English