Importing a Price List into the ELCOM Fiscal Cash Register
To use the ELCOM fiscal cash register in a mode where sales are processed directly at the register (known as Offline mode), in addition to properly configuring the cash register, it is essential to have an up-to-date price list of goods and services loaded into the register. Using the Flexi2XML tool, you export data from Flexi and then import it into the fiscal cash register.
The Flexi2XML Tool
Flexi2XML is a conversion tool for transforming data, and it also serves as a batch export tool for Flexi data — or conversely, for batch importing data — whether Flexi is running locally or remotely.
The latest Windows version is available on the Flexi website. For Linux and Mac OS X, Flexi2XML is included with the Flexi installation; the linked page lists the folders where you can find the tool.
Configuration File
Create a configuration file named config-sales.xml with the following content:
<?xml version="1.0" encoding="UTF-8"?> <config> <username>username</username> <password>password</password> <company>company_name</company> <host>aaa.flexibee.eu</host> <port>5434</port> <directory>c:\pokladna</directory> <renameSuffix>-loaded</renameSuffix> <action method="GET" id="cenik"> <url>/cenik/(kodPlu is not empty).csv?detail=full&includes=/winstrom/skupZboz&format=elcom-50&limit=9999&no-ext-ids=true</url> <contentType>text/xml</contentType> <failMessage>Selhalo nahrání ceníku do pokladny.</failMessage> </action> <action method="PUT"> <url>/pokladni-pohyb.xml</url> <contentType>text/xml</contentType> <mask>sales.xml</mask> <failMessage>Selhalo nahrání prodejů do ABRA Flexi.</failMessage> </action> </config>
You will need to edit the file and configure certain parameters, whose meanings are described below:
<username>
The username under which the export will be performed.
<password>
The password for the specified user.
<company>
The unique identifier of the billed company, which is part of the web interface URL.
https://localhost:5434/c/mojefirma/cenik
<host>
The address of the Flexi server. This can be specified as a fully qualified hostname or as an IP address.
<port>
The Flexi server port, typically 5434.
<directory>
The directory in which files will be searched for (according to the <mask/> pattern).
<renamePrefix>
A prefix that will be added to the beginning of the name of successfully uploaded files.
<renameSuffix>
A suffix that will be appended to the end of the name of successfully uploaded files.
A special case is the format parameter in the URL of the action that retrieves the price list. Its value determines the format of the exported data to be used when importing into a specific fiscal cash register. Setting the format parameter is essential for the import to function correctly. Example values for selected cash registers:
ELCOM Euro-200TE: elcom
ELCOM Euro-50 TE Mini: elcom-50
ELCOM Euro-150 TE Flexy: elcom-50
Batch File
To export price list data from Flexi and upload the exported data to the fiscal cash register, you will need to create a file named nahraj-cenik.bat with the following content:
@echo off cd "C:\kasa" set PORT=COM4 set CODE=29 set EXPORT=cenik.csv flexi2xml-cli.exe --load config-sales.xml --id cenik -o cenik.csv flexi2xml-cli.exe --cash-port %PORT% --cash-number 1 --cash %CODE% --store-plu %EXPORT% --cash-sk
In the file, you will need to update:
the path to the folder containing the Flexi2xml-cli.exe program,
the port on which the fiscal cash register is available,
the numeric code of your fiscal cash register (see the register documentation or the table below),
the name of the file containing the exported price list.
ELCOM Cash Register Numeric Codes
Cash Register | Numeric Code |
Elcom-500FP | 28 |
Euro-1000 M | 2 |
Euro-1000 T | 3 |
Euro-100T | 24 |
Euro-150TE Flexy | 33 |
Euro-150TE Flexy Plus | 37 |
Euro-2000 M Alpha/2400 | 0 |
Euro-2000 M Alpha/10000 | 4 |
Euro-2000 T Alpha/2400 | 1 |
Euro-2000 T Alpha/10000 | 5 |
Euro-2000 TE Alpha/2400 | 6 |
Euro-2000 TE Alpha/6000 | 7 |
Euro-2000 TE Alpha/2400 v4 CZ fisc. | 15 |
Euro-2000 TE Alpha/6000 v4 CZ fisc. | 16 |
Euro-200T | 25 |
Euro-200TE (by RAM) | 26 |
Euro-200TE (by RAM) | 27 |
Euro-2100TE | 17 |
Euro-2100TE (version 2.xx) | 29 |
Euro-2100TX (by RAM) | 18 |
Euro-2100TX (by RAM) | 19 |
Euro-2100TX (version 2.xx) | 30 |
Euro-2500 T | 9 |
Euro-2500 T/18000 | 12 |
Euro-2500TX | 22 |
Euro-50 Cash | 34 |
Euro-500 T Handy/10000 | 11 |
Euro-500 T Handy/2100 | 10 |
Euro-500 TE/2400 | 20 |
Euro-500 TE/6000 | 21 |
Euro-500 TX Handy/10000 | 14 |
Euro-500 TX Handy/2100 | 13 |
Euro-50T Mini | 31 |
Euro-50TE Medi | 35 |
Euro-50TE Mini | 32 |
Euro-50TE Smart | 36 |
POS3000 ver.1 | 23 |
Running the Batch File
Before running the nahraj-cenik.bat file, verify that the fiscal cash register is switched on and connected to the computer on the specified port. The Flexi server should also be running at the address specified in the configuration file:
After running the batch file, the following should occur:
the price list data is exported from Flexi to the file cenik.csv
the data in the file cenik.csv is imported into the fiscal cash register