Opticon ESL
ESL Server manual
v1.0.62.2
36
Sell price field: Field number that holds the current ‘sell price’ from the article. If no ‘sell price’ is
present in the CSV-record set it to the ‘0’
Discount % field: Field number which holds the automatically calculated discount percentage. If
the ‘from price’ and ‘sell price’ fields are equal or set to ‘0’, then the discount percentage isn’t
calculated.
Currency Symbol: Holds the currency symbol. Used by the image generator to add the currency
in front of the price. (Must be specified in the image template using %C%, see chapter 8)
Decimal Symbol: Holds the decimal symbol for prices, which can be either a dot or comma. If the
user accidently types in a comma instead of a dot (or vice versa) in a price field, then the CSV-
parser will automatically correct this.
Display leading zero: Specifies the price formatting when the price is smaller than one standard
currency (i.e. 0.75). The CSV-parser can automatically format prices in any of the following three
formats: 0.75, -.75 or .75.
7.2. SQL Data base configuration
The ESL server supports MS-SQL, MySQL, SQLite, PostgreSQL, Oracle and DB2, which need to
be installed besides the ESL server application in order to use it.
MS-SQL Express Server 2012 (with tools) is available at Microsoft.com.
MySQL can be installed separately or using XAMPP (see chapter 11)
Oracle Express can be downloaded from ORACLE.com
PostgreSQL can be downloaded from postgresql.org
SQLite is file based and does not require any installation or configuration.
DB2 Express-C can be downloaded from IBM.com
The ESL server application will generate most SQL tables automatically, except for the product
tables, which contain the product database.
The ESL Server installation contains example queries to quickly set-up a demo for each database
format. The example queries can be found in the following folder of your installation
‘/Examples/’
The demo configuration for MySQL can be found in ‘Appendix B: My-SQL demo configuration’
The demo configuration for MS-SQL can be found in ‘Appendix C: MS-SQL demo configuration’
The demo configuration for Oracle can be found in ‘Appendix D: Oracle demo configuration’
The demo configuration for PgSQL can be found in ‘Appendix E: PostgreSQL demo configuration’
To Next Page
Loading...
Need help?
General
