| Line 1: |
| |
|
+ |
=ESL Non Web Server=
|
| |
|
|
|
| |
|
+ |
[[Image:win10_esl_server_sw.png|frameless|400px ]]
|
| |
|
+ |
[[Image:ebs40.png|frameless|400px ]]
|
| |
|
|
|
| |
|
|
|
| |
|
+ |
The Opticon ESL Server Software will monitor and control all your ESLs and base stations fully automatically, therefore saving you precious time that can be spent elsewhere.
|
| |
|
|
|
| |
|
+ |
The software will connect the ESLs through a base station to a database for price processing and product changes, this will make sure that all content shown on the displays is up to date. This information exchange is logged and view able for remote monitoring, one way to monitor this remotely is through the web application. This included web application is used for in-store monitoring and linking ESLs to products.
|
| |
|
+ |
Template
|
| |
|
|
|
| |
|
+ |
With the graphical template designer you can design customized templates so they fit perfectly in the style of your store, making your store look more high-tech than ever. The ESL Server Software will also automatically generate and distribute all modified images to the ESLs.
|
| |
|
|
|
| |
|
+ |
=Software Solutions=
|
| |
|
|
|
| |
|
+ |
{| class="wikitable" border="2" style="color:#47888c; text-align: center; background-color:#F1F5F7;" cellpadding="30"
|
| |
|
|
|
| |
|
+ |
! CSV-file solution <br><br><br>SQL solution<br><br><br>CSV / SQL hybrid solution<br><br><br>External content management solution<br><br><br>SQL API<br><br><br>REST API style="width: 80%;" rowspan="6"|[[Image:sol_overview.png|thumbnail]]
|
| |
|
+ |
|}
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
+ |
==CSV-file solution==
|
| |
|
+ |
The CSV-file based solution operates by running the provided
|
| |
|
+ |
ESL server application that monitors an input folder in which CSV-files, containing
|
| |
|
+ |
the product and link databases, are being placed by a back-office system. Logging
|
| |
|
+ |
is done in an SQLite database file.
|
| |
|
|
|
| |
|
+ |
[[Image:csv_sol_diag.png]]
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
+ |
==SQL solution==
|
| |
|
+ |
The SQL-based solution provides the possibility to monitor and control multiple stores
|
| |
|
+ |
using one central or multiple local SQL databases in combination with the provided web
|
| |
|
+ |
application.
|
| |
|
+ |
The local ESL server application(s) will:
|
| |
|
+ |
* Monitor a local or central SQL database using staging tables and processes them.
|
| |
|
+ |
* Inserts status information of all ESLs into the SQL database
|
| |
|
+ |
* Controls, monitors and configures ESLs and base stations
|
| |
|
+ |
* Allows manual editing of product and link data bases (optional)
|
| |
|
+ |
* Creates/changes image templates, generates the ESL images and sends them to the ESL tags.
|
| |
|
|
|
| |
|
+ |
[[Image:sql_sol_diag.png]]
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
+ |
==CSV / SQL hybrid solution==
|
| |
|
+ |
The CSV / SQL hybrid solution matches the CSV-solution with as only difference that all
|
| |
|
+ |
status information on the ESLs and base station are logged into a local SQL database
|
| |
|
+ |
which can be retrieved by the back-office system
|
| |
|
+ |
<i>Refer to chapter 7.4 in the user manual for more information</i>
|
| |
|
|
|
| |
|
+ |
==External content management solution==
|
| |
|
+ |
When using external content management solution, the back office or content
|
| |
|
+ |
management system handles the generation of the images and the linking of products to
|
| |
|
+ |
ESLs.
|
| |
|
+ |
The ESL server application basically only monitors an input folder for new images and
|
| |
|
+ |
distributes them to the corresponding base stations / ESLs.
|
| |
|
+ |
Status information will be logged into a local SQL database.
|
| |
|
|
|
| |
|
+ |
[[Image:extern_mgmt_diag.png]]
|
| |
|
|
|
| |
|
|
|
| |
|
+ |
<i>See chapter 7.5 in the user manual for more information</i>.
|
| |
|
|
|
| |
|
+ |
==SQL API==
|
| |
|
+ |
SQL queries can be used as API to create your own (web) application by executing SQL
|
| |
|
+ |
queries to control and monitor the ESL system, while running the ESL server as
|
| |
|
+ |
background service.
|
| |
|
|
|
| |
|
+ |
Refer to the service manual for the below topics:
|
| |
|
+ |
*<i><b> Chapter 7.2 </b> for information on how to use the SQL product and link staging tables to link and update ESLs and use the status tables to monitor the ESL system. </i>
|
| |
|
+ |
*<i><b>Chapter 12</b> on how to run the ESL server as service.</i>
|
| |
|
+ |
*<i><b>Appendix J:</b> Using the SQL API for more information on this API.</i>
|
| |
|
|
|
| |
|
+ |
For maximum flexibility the SQL API can also be used in combination with the CSV/SQL
|
| |
|
+ |
hybrid solution and with the external content management solution.
|
| |
|
|
|
| |
|
+ |
==REST API==
|
| |
|
|
|
| |
|
+ |
The ESL server has a web service with a REST API that can be enabled to control the ESL
|
| |
|
+ |
system locally or remotely using your own application.
|
| |
|
+ |
<br>
|
| |
|
|
|
| |
|
+ |
To enable this feature, go to the Settings-tab, select Web Service / REST-API and check
|
| |
|
+ |
the ‘Enabled’ checkbox and then press Apply.
|
| |
|
+ |
The output format can be configured as XML or JSON as desired.
|
| |
|
+ |
*<i>Refer to the user manual <b>Appendix J:</b> For a listing of REST API commands.</i>
|
| |
|
+ |
*<i><b>Depending on your PC settings, you may need to launch the ESL server as an administrator to start the web service.</i></b>
|
| |
|
+ |
[[Image:enable_rest_api.png| thumbnail|]]
|
| |
|
+ |
[[Image:rest_api_diag.png| thumbnail|]]
|
| |
|
|
|
| |
|
+ |
=Setup=
|
| |
|
+ |
===Setting up the hardware and software===
|
| |
|
+ |
The following pieces of hardware and software that will have to be installed in order to get
|
| |
|
+ |
an ESL demonstration or pilot up and running:
|
| |
|
|
|
| |
|
+ |
<b>The ESL Server installer containing:</b>
|
| |
|
+ |
** The ESL server application
|
| |
|
+ |
** Example database files and image templates
|
| |
|
+ |
** Firmware for the barcode terminal, base station and ESL tags.
|
| |
|
+ |
** Appload (optional)
|
| |
|
+ |
** USB drivers for the barcode terminal cradle (optional)
|
| |
|
+ |
** User manual
|
| |
|
|
|
| |
|
+ |
<b>EBS40 Base station that includes:</b>
|
| |
|
+ |
** 6 Volt 2 Amp Power supply
|
| |
|
+ |
** Ethernet cable
|
| |
|
|
|
| |
|
+ |
==Installing the ESL Server application==
|
| |
|
+ |
To install and run the software you will also need a PC or Server running Windows with .NET Framework 4.61 or higher (Windows 10 recommended)
|
| |
|
|
|
| |
|
+ |
<i>Before installing the software, make sure you have administrator rights and the PC is fully updated with all Windows updates.</i>
|
| |
|
|
|
| |
|
+ |
If your PC doesn’t have .NET Framework 4.6.1 (or higher) installed, it will be installed during the installation of the the ESL Server application.
|
| |
|
|
|
| |
|
+ |
# Run the installer by starting the ‘SetupEslServer.msi’ file.
|
| |
|
+ |
# Select the components that you wish to install.
|
| |
|
|
|
| |
|
+ |
If you haven’t installed Appload or the Opticon USB drivers on your PC before, make sure you install those components as well.
|
| |
|
|
|
| |
|
+ |
If you wish to use the REST-API make sure you enable the Web Service
|
| |
|
|
|
| |
|
+ |
If you wish to use the ESL Web application, make sure you enabled the installation of XAMPP (if you haven’t installed Apache or MySQL on your system already)
|
| |
|
|
|
| |
|
+ |
==Installing and finding the EBS-40 Base station==
|
| |
|
+ |
The base station can easily be installed by powering it up, connecting it to the Ethernet
|
| |
|
+ |
with DHCP support and placing it within 10 meters (the actual maximum range is bigger)
|
| |
|
+ |
of your ESLs.
|
| |
|
|
|
| |
|
+ |
#Plug in power supply to wall outlet and barrel connector to base station
|
| |
|
+ |
<i>The power LED on top of the EBS-40 should start blinking red. Once the LED turns solid continue.</i>
|
| |
|
|
|
| |
|
+ |
<b>1. Connect one end of the ethernet cable to either ethernet jack of the base station and the other end to the host computer that has DHCP enabled.</b>
|
| |
|
|
|
| |
|
+ |
<b>The PC will need to be connected to the same LAN, so it can communicate
|
| |
|
+ |
with the base station</b>.
|
| |
|
|
|
| |
|
+ |
<i>After starting the application for the first time, no base station will be available to
|
| |
|
+ |
communicate with ESLs</i>.
|
| |
|
|
|
| |
|
+ |
<b>2. Press the ‘Find’ button on the ‘Base stations-tab to find the connected base station.</b>
|
| |
|
+ |
<br>
|
| |
|
+ |
[[Image:find_bs.png|thumbnail]]
|
| |
|
+ |
</br>
|
| |
|
+ |
<b>3. Select the discovered base station to add and connect your PC to the base station.</b>
|
| |
|
|
|
| |
|
+ |
If activated ESLs are nearby, then the ESL count will start incrementing as they start
|
| |
|
+ |
connecting to the base station. However, if the ESLs are still ‘deactivated’, they will first
|
| |
|
+ |
have to be reactivated.
|
| |
|
|
|
| |
|
+ |
* Note 1: when the base station is connected to the LAN with DHCP the IP address can vary over time, making it necessary to remove the old base station entry by pressing the ‘Delete’-key of your keyboard and discovering the base station again using the ‘find' button. Using static IP leases in the DHCP server can resolve this problem.
|
| |
|
|
|
| |
|
+ |
* Note 2: when the base station is connected to the LAN without DHCP, the default IP address/subnet mask of the base station is 169.254.19.63 / 255.255.0.0. Configure a PC or laptop on the same subnet to change this using a web browser.
|
| |
|
|
|
| |
|
+ |
=Installing and activating the ESLs=
|
| |
|
+ |
<b>On arrival the ESLs already have their batteries inserted.</b>
|
| |
|
|
|
| |
|
+ |
However, to allow safe transport by airplane, it is likely that the ESLs will show a 'DEACTIVATED' message in their top left corner.
|
| |
|
+ |
<i>This means the ESLs do not emit any radio signals and won't be searching for base stations at this point.</i>
|
| |
|
+ |
<br>
|
| |
|
+ |
[[Image:deactivated_esl.png|250px|thumbnail]]
|
| |
|
+ |
</br>
|
| |
|
+ |
To reactivate these ESLs place them nearby the connected base station and select the base station in the list view of the 'Base stations'-tab. This allows you to press the 'Reactivate ESLs' button in the bottom right corner.
|
| |
|
|
|
| |
|
+ |
After pressing this button, a dialog will appear showing a progress bar and how many
|
| |
|
+ |
ESLs have been reactivated so far.
|
| |
|
|
|
| |
|
+ |
Since the ESLs will only wake-up for a split second every few minutes, it can take more
|
| |
|
+ |
than 15 minutes before all ESLs have been successfully reactivated. You can verify this
|
| |
|
+ |
by checking whether the ‘DEACTIVATED’ message has disappeared from the screen.
|
| |
|
|
|
| |
|
+ |
Active ESL’s will be periodically search for an Opticon base station, so as soon as an
|
| |
|
+ |
Opticon base station is within range, they will associate with it and start sending data
|
| |
|
+ |
requests and status information to it. When a base station is turned off or an ESL is
|
| |
|
+ |
moved out of range, an ESL will time out after a couple of minutes and starts seeking for
|
| |
|
+ |
another base station in range.
|
| |
|
|
|
| |
|
+ |
<i><b>See chapter 6.1 for more information about configuring ESLs. </i></b>
|
| |
|
|
|
| |
|
|
|
| |
|
+ |
=Linking of ESLs to products=
|
| |
|
+ |
Linking of ESLs is the process of telling the system which product should be shown on
|
| |
|
+ |
which ESL. This is usually done by scanning the MAC address bar code on the ESL label
|
| |
|
+ |
followed by scanning (or entering) the unique ID of the product.
|
| |
|
|
|
| |
|
+ |
The unique ID can be anything: an EAN code, article number, location, room number, etc.
|
| |
|
+ |
As long as it’s a unique identifier in the database, it can be linked to an ESL.
|
| |
|
|
|
| |
|
+ |
===Steps:===
|
| |
|
|
|
| |
|
+ |
<b><i>There are multiple ways to link an esl tag</b></i>
|
| |
|
+ |
<br>
|
| |
|
+ |
</br>
|
| |
|
+ |
<b>Select the <b>ESL</b> tab</b>
|
| |
|
+ |
<ul>Double click on an ESL<ul>
|
| |
|
+ |
<ul>Type, scan or find the MAC address of the ESL and the product ID.</ul>
|
| |
|
|
|
| |
|
+ |
<ul><b>or</b>
|
| |
|
+ |
Click on <i><b>Link to item</b></i> button on the top right side of the bottom gray panel.</ul>
|
| |
|
+ |
<ul>Type, scan or find the MAC address of the ESL and the product ID.</ul>
|
| |
|
+ |
<br>
|
| |
|
+ |
[[Image:link_esl.png|750px|thumbnail]]
|
| |
|
+ |
</br>
|
| |
|
+ |
<ul><b>or</b>
|
| |
|
+ |
Single click on an ESL and click on drop down section to choose action and select the Link action.</ul>
|
| |
|
+ |
<ul>Type, scan or find the MAC address of the ESL and the product ID.</ul>
|
| |
|
+ |
<br>
|
| |
|
+ |
</br>
|
| |
|
+ |
<b>Select the <i><b>Data</i></b> tab and press the <b>Add</b> button.</b>
|
| |
|
+ |
<ul>Type, scan or find the MAC address of the ESL and the product ID.</ul>
|
| |
|
+ |
<br>
|
| |
|
+ |
[[Image:link_esl2.png|750px|thumbnail]]
|
| |
|
+ |
</br>
|
| |
|
|
|
| |
|
+ |
=Documents=
|
| |
|
+ |
{| class="wikitable" border="2" style="color:#47888c; text-align: center; background-color:#F1F5F7;" cellpadding="30"
|
| |
|
+ |
|-
|
| |
|
+ |
! style="color:black" |Name
|
| |
|
+ |
! style="color:black" |Details
|
| |
|
+ |
! style="color:black" |Type
|
| |
|
+ |
! style="color:black" |Version
|
| |
|
+ |
! style="color:black" |Download Link
|
| |
|
+ |
|-
|
| |
|
+ |
!User Manual
|
| |
|
+ |
| Contains information on how to setup and use the ESL tags with the ESL Server
|
| |
|
+ |
| PDF
|
| |
|
+ |
| v1.0.75.0
|
| |
|
+ |
| [http://ftp.opticonusa.com/Downloads/esl/esl_server_manual.pdf Download]
|
| |
|
+ |
|-
|
| |
|
+ |
!MS-SQL Demo Tutorial
|
| |
|
+ |
| Step by step tutorial that covers setting up a sample MS-SQL database and sample configuration for communicating with the ESL Server software
|
| |
|
+ |
| PDF
|
| |
|
+ |
| v1.0
|
| |
|
+ |
| [http://ftp.opticonusa.com/Downloads/esl/ms-sql_instructions_demo.pdf Download]
|
| |
|
+ |
|-
|
| |
|
+ |
!Sample Tables
|
| |
|
+ |
| Sample table insert statements (CSV, MS-SQL and MySQL) that uses North America based decimal system.
|
| |
|
+ |
| CSV,MS-SQL,MySQL
|
| |
|
+ |
| v1.0
|
| |
|
+ |
| [http://ftp.opticonusa.com/Downloads/esl/sample_tables.zip Download]
|
| |
|
+ |
|-
|
| |
|
+ |
!EBS-40 Data Sheet
|
| |
|
+ |
| Contains technical specs on the EBS-40 base station
|
| |
|
+ |
| PDF
|
| |
|
+ |
| EBS-40_04.2019
|
| |
|
+ |
| [http://ftp.opticonusa.com/Downloads/esl/ebs40_leaflet.pdf Download]
|
| |
|
+ |
|-
|
| |
|
+ |
!Mounting and Accessories
|
| |
|
+ |
| Contains information on the various mounting items for the ESL Tags. <br> <i><b> Consult your local sales rep for assistance and ordering</b></i>
|
| |
|
+ |
| PDF
|
| |
|
+ |
| N/A
|
| |
|
+ |
| [http://ftp.opticonusa.com/Downloads/esl/esl_mounting_accessories.pdf Download]
|
| |
|
+ |
|}
|
| |
|
|
|
| |
|
+ |
=Software=
|
| |
|
+ |
{| class="wikitable" border="2" style="color:#47888c; text-align: center; background-color:#F1F5F7;" cellpadding="30"
|
| |
|
+ |
|-
|
| |
|
+ |
! style="color:black" |Name
|
| |
|
+ |
! style="color:black" |Details
|
| |
|
+ |
! style="color:black" |Type
|
| |
|
+ |
! style="color:black" |Version
|
| |
|
+ |
! style="color:black" |Download Link
|
| |
|
+ |
|-
|
| |
|
+ |
!ESL Server Software
|
| |
|
+ |
| Contains information on how to setup and use the ESL tags with the ESL Server
|
| |
|
+ |
| EXE Installer (Windows 10)
|
| |
|
+ |
| v1.0.76.2
|
| |
|
+ |
| [http://ftp.opticonusa.com/Downloads/esl/esl_server_application_1.0.76.2.zip Download]
|
| |
|
+ |
|}
|
| |
|
|
|
| |
|
+ |
=ESL Tutorial Videos=
|
| |
|
+ |
[[Image:jurgen.png|left|400px|link=https://www.youtube.com/watch?v=3xlQ67fy6e0&list=PLcmfO8Zqj6oPWOCh3VieObGD-PhADaOo_ ]]
|
| |
|
+ |
<br clear=all>
|
