Opticon ESL
ESL Server manual
v1.0.62.2
14
2.3. 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. See chapter 7.4 for more information.
2.4. 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. See chapter 7.5 for more information.
2.5. SQL API
SQL 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.
See chapter 7.2 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.
See chapter 12 on how run the ESL server as service.
See Appendix I: Using the SQL API for more information on this API.
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.