Opticon ESL Server User manual

Electronic Shelf Label
ESLServermanual
The ESL server manual describes how to
demonstrate and set up the Opticon ESL solution.
User Manual
v1.0.62.2

Opticon ESL
ESL Server manual
v1.0.62.2
2
All information in this manual is subject to change without notice.
Document History
Model Number:
ESL Server Manual
Specification Number:
Edition:
1.0.62.2
Original Spec Number:
Date:
2017
Copyright 2017 Opticon. All rights reserved.
This manual may not, in whole or in part, be copied, photocopied, reproduced, translated or converted to any
electronic or machine readable form without prior written consent of Opticon.
Limited Warranty and Disclaimers
PLEASE READ THIS MANUAL CAREFULLY BEFORE INSTALLING OR USING THE
PRODUCT.
Serial Number
A serial number appears on all Opticon products. This official registration number is directly related to the device that is
purchased. Do not remove the serial number from your Opticon device. Removing the serial number voids the
warranty.
Warranty
Unless otherwise agreed in a written contract, all Opticon products are warranted against defects in materials and
workmanship for two years after purchase. Opticon will repair or, at its option, replace products that are defective in
materials or workmanship with proper use during the warranty period. Opticon is not liable for damages caused by
modifications made by a customer. In such cases, standard repair charges will apply. If a product is returned under
warranty and no defect is found, standard repair charges will apply. Opticon assumes no liability for any direct, indirect,
consequential or incidental damages arising out of use or inability to use both the hardware and software, even if
Opticon has been informed about the possibility of such damages.
Packaging
The packing materials are recyclable. We recommend that you save all packing material to use should you need to
transport your scanner or send it for service. Damage caused by improper packaging during shipment is not covered
by the warranty.
Trademarks
Trademarks used are the property of their respective owners.
Opticon Inc. and Opticon Sensors Europe B.V. are wholly owned subsidiaries of OPTOELECTRONICS Co., Ltd., 12-
17, Tsukagoshi 4-chome, Warabi-shi, Saitama, Japan 335-0002. TEL [phone]; FAX [phone]
SUPPORT
USA
Europe
Phone: [phone]
Phone: [phone]
Email: [email protected]
Email: [email protected]
Web: www.opticonusa.com
Web: www.opticon.com

Opticon ESL
ESL Server manual
v1.0.62.2
3
Contents
1. Features and Specifications...................................................................................................... 6
1.1. Abstract............................................................................................................................... 6
1.2. Contents of an ESL demo kit .............................................................................................. 6
1.3. Physical Features................................................................................................................ 6
1.3.1. Dimensions ................................................................................................................................6
1.3.2. Weight........................................................................................................................................6
1.4. Environmental Specifications.............................................................................................. 7
1.4.1. Operating Temperature and Humidity (EE201).........................................................................7
1.4.2. Storage Temperature and Humidity (EE201) ............................................................................7
1.5. Interface Specifications....................................................................................................... 7
1.6. Electrical Specifications ...................................................................................................... 7
1.6.1. Electrical Characteristics............................................................................................................7
1.6.2. Main Batteries............................................................................................................................8
1.7. Hardware Specifications ..................................................................................................... 9
1.8. Serial Number ................................................................................................................... 10
1.8.1. EBS-30 / EBS-31 / EBS-40......................................................................................................10
1.8.2. ESLs.........................................................................................................................................10
1.9. Safety................................................................................................................................ 10
1.9.1. Shock.......................................................................................................................................10
1.9.2. Temperature Conditions ..........................................................................................................10
1.9.3. Foreign Materials.....................................................................................................................10
1.9.4. Other........................................................................................................................................10
2. Solution overview..................................................................................................................... 11
2.1. CSV-file based solution..................................................................................................... 12
2.2. SQL Solution..................................................................................................................... 13
2.3. CSV / SQL hybrid solution ................................................................................................ 14
2.4. External content management solution............................................................................. 14
2.5. SQL API............................................................................................................................ 14
3. Setting up the hardware and software.................................................................................... 15
3.1. Installing the ESL Server application ................................................................................ 15
3.2. Installing and finding the EBS3x / EBS40 base stations................................................... 15
3.3. Installing and activating the ESLs ..................................................................................... 16
3.4. Mounting ESLs.................................................................................................................. 17
4. Linking of ESLs to products.................................................................................................... 18
4.1. Linking in the ESL server application................................................................................ 19

Opticon ESL
ESL Server manual
v1.0.62.2
4
4.2. Linking using an Opticon batch terminal ........................................................................... 20
4.3. Linking using the provided web application....................................................................... 20
5. Configuring the base stations................................................................................................. 21
5.1. Configuring the RF channel .............................................................................................. 21
5.2. Changing the local name .................................................................................................. 22
5.3. Changing the PAN ID / LAN ID ......................................................................................... 22
5.4. Configuring the Ethernet settings...................................................................................... 23
5.5. Factory default .................................................................................................................. 24
5.6. Base station firmware update............................................................................................ 25
5.6.1. Trouble shooting......................................................................................................................25
6. Configuration and monitoring of ESLs................................................................................... 26
6.1. Configuration of ESLs ....................................................................................................... 26
6.1.1. Associate interval.....................................................................................................................27
6.1.2. Poll Interval ..............................................................................................................................27
6.1.3. Poll timeout ..............................................................................................................................27
6.1.4. Display orientation ...................................................................................................................27
6.1.5. Poll - Info Ratio ........................................................................................................................28
6.1.6. Scan channels .........................................................................................................................28
6.1.7. Temperature range..................................................................................................................28
6.2. Monitoring of ESLs............................................................................................................ 29
6.3. Filtering ESLs.................................................................................................................... 30
6.4. Controlling ESLs ............................................................................................................... 30
6.4.1. Actions .....................................................................................................................................31
6.4.2. Load balancing.........................................................................................................................31
6.4.3. Firmware update......................................................................................................................32
7. Database configuration............................................................................................................ 32
7.1. CSV Data base configuration............................................................................................ 33
7.1.1. Changing the database format and settings............................................................................34
7.2. SQL Data base configuration............................................................................................ 36
7.2.1. Tables ......................................................................................................................................38
7.2.2. Connection...............................................................................................................................48
7.2.3. Tables configuration.................................................................................................................49
7.2.4. Fields configuration..................................................................................................................49
7.2.5. Web Application.......................................................................................................................49
7.2.6. Advanced Settings...................................................................................................................50
7.2.7. Apply and reset........................................................................................................................51
7.3. Open DataBase Connectivity (ODBC) configuration......................................................... 52

Opticon ESL
ESL Server manual
v1.0.62.2
5
7.4. CSV / SQL Hybrid configuration........................................................................................ 54
7.5. External content management configuration..................................................................... 56
7.6. Manual editing of the product database............................................................................ 58
7.7. Editing the Links-table....................................................................................................... 58
8. Designing the ESL image layout............................................................................................. 59
8.1. Template Selection ........................................................................................................... 60
8.1.1. Conditions................................................................................................................................61
8.2. Using the Template editor................................................................................................. 63
8.2.1. Static and dynamic Content.....................................................................................................65
8.2.2. Conditional objects...................................................................................................................65
8.3. Saving and exporting a template....................................................................................... 66
8.4. Using Example data.......................................................................................................... 66
9. Connecting the back office using CSV-files .......................................................................... 68
9.1. Product database format................................................................................................... 68
9.2. Product-ESL link database format .................................................................................... 69
9.3. Middleware application (CSV-files only)............................................................................ 71
10. Barcode terminal application .................................................................................................. 72
10.1. Setting up the barcode terminal ........................................................................................ 72
10.2. Loading the database files on the terminal ....................................................................... 73
10.3. Creating links between ESLs and products ...................................................................... 73
10.3.1. OPH100x, H13, OPH3000 or OPL9728 ..................................................................................74
10.3.2. OPN2002/3/4/5/6.....................................................................................................................75
10.4. Sending the link file back to the PC .................................................................................. 75
11. Using the Web Application for linking and monitoring......................................................... 76
11.1. Web application with Oracle, PostgreSQL, SQLite, MS-SQL and DB2 ............................ 78
12. Running the ESL server as service ........................................................................................ 78
Appendix A: Demo barcodes ........................................................................................................ 80
Appendix B: My-SQL demo configuration ................................................................................... 81
Appendix C: MS-SQL demo configuration................................................................................... 83
Appendix D: Oracle demo configuration...................................................................................... 85
Appendix E: PostgreSQL demo configuration ............................................................................ 87
Appendix F: SQLite demo configuration...................................................................................... 89
Appendix G: DB2 demo configuration ......................................................................................... 91
Appendix H: Restoring the ESL server back to default (CSV) ................................................... 93
Appendix I: Using the SQL API ..................................................................................................... 94
Appendix J: Version history.......................................................................................................... 99

Opticon ESL
ESL Server manual
v1.0.62.2
6
1. Features and Specifications
1.1. Abstract
This manual describes how to set-up an Electronic Shelf Labels (ESL) system with e-Paper ESLs
from Opticon Sensors Europe BV.
1.2. Contents of an ESL demo kit
The ESL demo kit consists of the following components:
Ethernet ESL base station (EBS-30 / EBS-40)
6 2” e-paper ESLs (EE201) including batteries
UTP cable
6.0V 2A Power supply (European)
PC Installation Software (ESL server and web application)
Opticon ESL Server User Manual
The demo kit does NOT include a barcode terminal or scanner, which can be used to link ESLs to
products using barcodes. Any of the following barcode terminals or scanners can be used for this
purpose:
OPH100x (+ CRD100x cradle)
H13 (+ CRD13 cradle)
OPL9728 / OPL9815 (+ CRD9723RU cradle)
OPN2002/3/4/5/6 (+ mini USB cable)
CLK3000 (+ mini USB cable)
Any handheld barcode terminal with Wifi and a web browser
Any USB-HID barcode scanner
1.3. Physical Features
1.3.1. Dimensions
2” e-paper ESL (EE201): W 65.0 x D 34.0 x H 15.0 mm
Base station (EBS-30/40): W 145.0 x D 110.0 x H 30.0 mm (excl. antenna)
1.3.2. Weight
2” e-paper ESL (EE201): 25 g (incl. 2 batteries)
Base station (EBS-30/40): 125 g (excl. power supply)

Opticon ESL
ESL Server manual
v1.0.62.2
7
1.4. Environmental Specifications
1.4.1. Operating Temperature and Humidity (EE201)
Temperature: 5 to 50° C
Humidity: 20-85%
1.4.2. Storage Temperature and Humidity (EE201)
Temperature: -20 to 60° C
Humidity: 20-85%
1.5. Interface Specifications
The radio interface of both the base stations and ESLs have the following specifications:
2.4gHz IEEE 802.15.4 compatible
Transmission speeds: up to 250 kbps
1.6. Electrical Specifications
1.6.1. Electrical Characteristics
EE201:
Parameter
Typical
Unit
Remarks
Operating voltage
2.8–3.2
V
2 x CR2450 Lithium battery
Operating current
7-33
mA
During RF and image refresh only
Sleep current
1
uA
EE201 is in sleep state >99,9%
EBS-30 / EBS-40:
Parameter
Typical
Unit
Remarks
Operating voltage
6.0
V
Power adapter
Operating current
<300
mA

Opticon ESL
ESL Server manual
v1.0.62.2
8
1.6.2. Main Batteries
The main batteries in the EE20x are 2 CR2450 Li-Mn batteries:
Nominal capacity: 2x600 mAh
Nominal voltage: 3V
Low voltage: Less than 2.8 V
Operating time: >7 years (default settings; 4 refreshes/day; 15-25° C)
The operating time of the batteries is based on a realistic estimation of any of the following
factors that influence the battery life:
Factor
Default values and
estimated averages
Correlation *
(Higher is better)
Influence
Polling for data &
reporting settings
Interval: 20 seconds
Retransmissions: 10%
Report ratio: 1 to 39
Yes
No
Yes
61%
Display updates
4 per day
Temperature: 15-25° C
No
Yes
20%
Out of range /
base station OFF %
Not connected: 2%
Number of channels: 5
No
No
4%
Sleep time
99,9%
Yes
9%
Battery self-discharge
1 % / year
No
6%
* The correlation shows whether increasing the listed value increases or decreases the power
consumption of the ESLs.
For example:
Increasing the poll interval lowers the power consumption
Turning off the base stations increases the power consumption
A lower operating temperature increases the power consumption
More display updates per day increase the power consumption

Opticon ESL
ESL Server manual
v1.0.62.2
9
1.7. Hardware Specifications
Items
Specifications
Remarks
CPU
Type
Stellaris LM3S9B96 (EBS-30)
Cortext-M4F TM4C129 (EBS-40)
CC2530-F128 (EE200)
CC2533-F96 (EE201)
Internal ROM
256 KB (EBS-30) / 512 KB (EBS-40)
128 KB (EE200)
96 KB (EE201)
Internal RAM
96KB (EBS-30) / 256KB (EBS-40)
8 KB (EE200)
6 KB (EE201)
External RAM
8MB (EBS-30 / EBS-40)
N/A (EE200)
N/A (EE201)
Clock frequency
80 MHz (EBS-30) / 120MHz (EBS-40)
32 MHz (EE20x)
Display
(EE20x)
Active area
W 45 x H 22 mm
Number of dots
W 200 x H 96
Model
EG020AS183
Gray scale level
1 bit
Black and white
Contrast ratio
10:1
Pixel pitch
111 dpi
Connector
(EBS-xx)
Ethernet
10/100 Mbit
Radio
Frequency
2.4gHz
Protocol
IEEE 802.15.4

Opticon ESL
ESL Server manual
v1.0.62.2
10
1.8. Serial Number
1.8.1. EBS-30 / EBS-31 / EBS-40
The serial number can be found on the back of the base station. The base stations also
have a unique MAC-address which is used for both Ethernet and radio communication.
1.8.2. ESLs
The serial number of the ESLs is based on the 16 hexadecimal digits MAC-address of the
RF-module.
However, the first 6 or 9 digits of the MAC address have been replaced by a letter.
‘B’ (instead of ‘3889DC’ or ‘3889DC000’)
The default barcode that is shown on the display of the ESL is identical to the bar code on
the back of the ESL.
1.9. Safety
Handle this product carefully. Do not deliberately subject it to any of the following.
1.9.1. Shock
Do not throw or drop the devices
1.9.2. Temperature Conditions
Do not use the devices at temperatures outside the specified range.
Do not pour water on the devices.
Do not throw the devices into the fire.
Do not forcibly bend the cable at low temperatures.
1.9.3. Foreign Materials
Do not immerse the devices in liquids.
Do not subject the devices to chemicals.
1.9.4. Other
Do not plug/unplug the connectors before disconnecting the power.
Do not disassemble this product.
The device may be damaged by power surges