| Line 13: |
| |
|
|
|
| |
=Software Solutions= |
|
=Software Solutions= |
| |
|
+ |
{| class="wikitable"border="3"; text-align: center; cellpadding="30"
|
| - |
{| class="wikitable" border="2" style="color:#47888c; text-align: center; background-color:#F1F5F7;" cellpadding="30"
|
+ |
|-
|
| |
|
+ |
! style="color:black" |Solution
|
| - |
! 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]]
|
+ |
! style="color:black" |Details
|
| - |
|}
|
+ |
! style="color:black" |Diagram
|
| |
|
+ |
|-
|
| |
|
+ |
|CSV-File
|
| |
|
+ |
|Operates by running the provided ESL server application that monitors an input folder in which CSV-files, containing
|
| - |
==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 |
|
the product and link databases, are being placed by a back-office system. Logging |
| |
is done in an SQLite database file. |
|
is done in an SQLite database file. |
| |
|
+ |
|[[Image:csv_sol_diag.png|frameless|600px]]
|
| - |
[[Image:csv_sol_diag.png]]
|
+ |
|-
|
| |
|
+ |
|SQL
|
| |
|
+ |
|The SQL-based solution provides the possibility to monitor and control multiple stores
|
| |
|
|
|
| - |
==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 |
|
using one central or multiple local SQL databases in combination with the provided web |
| |
application. |
|
application. |
| Line 41: |
| |
* Allows manual editing of product and link data bases (optional) |
|
* 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. |
|
* Creates/changes image templates, generates the ESL images and sends them to the ESL tags. |
| |
|
+ |
|[[Image:sql_sol_diag.png|frameless|600px]]
|
| - |
[[Image:sql_sol_diag.png]]
|
+ |
|-
|
| |
|
+ |
|CSV / SQL Hybrid (Default)
|
| |
|
+ |
|Matches the CSV-solution but status information on the ESLs and base station are logged into a local SQL database. This information can then be retrieved by the back-office system. <br><i>Refer to chapter 7.4 in the user manual for more information</i>
|
| |
|
+ |
|[[Image:extern_mgmt_diag.png|frameless|600px]]
|
| - |
==CSV / SQL hybrid solution==
|
+ |
|-
|
| - |
The CSV / SQL hybrid solution matches the CSV-solution with as only difference that all
|
+ |
|External Content Management
|
| - |
status information on the ESLs and base station are logged into a local SQL database
|
+ |
|The back office or content management system handles the generation of the images and the linking of products to ESLs. <br>The ESL server application basically only monitors an input folder for new images and
|
| - |
which can be retrieved by the back-office system
|
+ |
distributes them to the corresponding base stations / ESLs. <br> Status information will be logged into a local SQL database.
|
| - |
<i>Refer to chapter 7.4 in the user manual for more information</i>
|
+ |
|[[Image:extern_mgmt_diag.png|frameless|600px]]
|
| |
|
+ |
|-
|
| - |
==External content management solution==
|
+ |
|SQL API
|
| - |
When using external content management solution, the back office or content
|
+ |
|SQL queries can be used as API to create your own (web) application by executing SQL
|
| - |
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 |
|
queries to control and monitor the ESL system, while running the ESL server as |
| - |
background service.
|
+ |
background service.<br>
|
| |
|
+ |
<br>
|
| - |
Refer to the service manual for the below topics:
|
+ |
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.
|
| |
|
+ |
|Refer to the service manual for the below topics:
|
| |
|
+ |
<br>
|
| |
*<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 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>Chapter 12</b> on how to run the ESL server as service.</i> |
| Line 76: |
| |
|
+ |
|-
|
| - |
For maximum flexibility the SQL API can also be used in combination with the CSV/SQL
|
+ |
|REST API<br><br><br> [[Image:rest_api_diag.png| frameless|400px]]
|
| - |
hybrid solution and with the external content management solution.
|
+ |
|The ESL server has a web service with a REST API that can be enabled to control the ESL
|
| |
|
|
|
| - |
==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. |
|
system locally or remotely using your own application. |
| |
<br> |
|
<br> |
| |
|
|
|
| |
To enable this feature, go to the Settings-tab, select Web Service / REST-API and check |
|
To enable this feature, go to the Settings-tab, select Web Service / REST-API and check |
| |
the ‘Enabled’ checkbox and then press Apply. |
|
the ‘Enabled’ checkbox and then press Apply. |
| Line 89: |
| |
*<i>Refer to the user manual <b>Appendix J:</b> For a listing of REST API commands.</i> |
|
*<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> |
|
*<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:enable_rest_api.png|frameless|600px]]
|
| - |
[[Image:rest_api_diag.png| thumbnail|]]
|
+ |
|}
|
| |
|
+ |
<br>
|
| |
|
+ |
<br>
|
| |
=Setup= |
|
=Setup= |
| |
===Setting up the hardware and software=== |
|
===Setting up the hardware and software=== |
