...
EDW LPEX V2.0 protocol is a simple text file protocol. Its implementation is based on a sequential processing of file rows. Two types of files are supported:
The LPEX A file consists of a header and part with data. The header contains a description of data, that are separated by a defined separator. This separator is used to separate also data in each row of a document.
An example of LPEX file body:
| LPEX V2.0 |
| Datum;Zeit;Kundennummer;Kundenname;eindeutigeKDNr;GEId;GEKANr;KALINr;Linie;eindeutigeLINr;ZPB;Kennzahl;Einheit;Wandlerfaktor;MPDauer;Werte |
| 15.04.14;00:07:00;;;;;;;;;SK40000041499000000000BESENOVA_T1;AP-M;kWh;1;01;0;00000 |
| 15.04.14;00:07:00;;;;;;;;;SK40000041499000000000BESENOVA_T1;AP+M;kWh;1;01;0;00000 |
| 15.04.14;00:07:00;;;;;;;;;SK40000041499000000000BESENOVA_T2;AP-M;kWh;1;01;27;00000 |
Where one One row of table correspond with corresponds to one row in a text file. As a separator there is used a symbol ";", which may be defined in the station parameters - parameter "Column Delimiter".
To better scan this data, there For better visibility, the data is displayed in the a table below. The header columns are described in Protocol parameters in the section Communication station configuration.
| LPEX V2.0 | | | | | | | | | | | | | | | | |
|---|
| Datum | Zeit | | | | | | | | | ZPB | Kennzahl | Einheit | Wandlerfaktor | MPDauer | Werte | |
|---|
| 15.4.2014 | 0:07:00 | | | | | | | | | xxx | AP-M | kWh | 1 | 1 | 0 | 0 |
| 15.4.2014 | 0:07:00 | | | | | | | | | yyy | AP+M | kWh | 1 | 1 | 0 | 0 |
| 15.4.2014 | 0:07:00 | | | | | | | | | zzz | AP-M | kWh | 1 | 1 | 27 | 0 |
The MPX file is an even more primitive text file protocol that has only a data portion. The body of the MPX file may look as follows:
SK10000022099000000000ETRENCIN_G1;AP-M;1;01;00;0;1805151136;92.4;kWh |
| SK10000022099000000000ETRENCIN_G2;AP-M;1;01;00;0;1805151136;94.8;kWh |
| SK10000022099000000000ETRENCIN_T1;AP-M;1;01;00;0;1805151136;91;kWh |
For better visibility, the data is displayed in a table below. The header columns are described in Protocol parameters in the section Communication station configuration.
| ZPB | Kennzahl | Wandlerfaktor | MPDauer |
|
| Datum+Zeit | Werte | Einheit |
|---|
| SK10000022099000000000ETRENCIN_G1 | AP-M | 1 | 01 | 00 | 0 | 1805151136 | 92.4 | kWh |
| SK10000022099000000000ETRENCIN_G2 | AP-M | 1 | 01 | 00 | 0 | 1805151136 | 94.8 | kWh |
| SK10000022099000000000ETRENCIN_T1 | AP-M | 1 | 01 | 00 | 0 | 1805151136 | 91 | kWh |
When MPX files are analyzed, the column order is fixed, and the protocol parameters that specify the column names in the LPEX header as well as the maximum number of columns (Date Column Name, Time Column Name .. Interval Name and Max. Columns Number) are ignored. Parameters Date Conversion Mask and Time Conversion Mask, specifying the date and time format, are also ignored, and format yymmddhhmi is assumed.
| Kotva |
|---|
| komunikacna_linka |
|---|
| komunikacna_linka |
|---|
|
Communication line configuration
...
- Communication line category: FILE I/O.
The parameter "Input File" is used only if the parameters Primary FTP Server and/or Secondary FTP Server are specified and by parameter ZIP File Mask specifies, that input files are in ZIP format - the input files are downloaded from the specified FTP servers and the ZIP files are looked for in the directory specified by the "Input File" parameter.
The parameter "Archive" specifies a folder for storing processed files.
| Kotva |
|---|
| komunikacna_stanica |
|---|
| komunikacna_stanica |
|---|
|
Communication station configuration
...
Communication station - configuration dialog box, Protocol parameters.
They influence some of the optional protocol parameters. A user may define the following station protocol parameters:
| Parameter | Default value | Meaning |
|---|
| LPEX | Type of processed files - LPEX or MPX. |
| Datum | Column name containing date. |
| Zeit | Column name that contains a time data. |
| ZPB | Column name that contains a value address. |
| EinHeit | Column name that contains a unit of a measured value. |
| Werte | Column name that contains the measured values. |
| Kennzahl | Column name that contains a value type (AP+ ,AP- ,AQ+ ,AQ-). |
| MPDauer | Column name that contains a granularity of measurements [s]. |
| 30 | Defines maximum column count, that are scanned when data acquisition. |
| ; | Value separator in the header and body. |
| dd.mm.rr | A mask for a conversion of date in the text format to an internal date. |
| hh:mi:ss | A mask for a conversion of time in the text format to an internal time. |
| | Directory for storing the batch files (e.g. unpacked ZIP archive). |
| | Only for OpenVMS. Directory (e.g. DKA0:[IFAZD]) containing the batch files TESTZIP.COM and UNZIP.COM. |
| ftp_download.com | Batch file for downloading data from FTP server. |
| deltmp.com | Batch file for deleting of temporary files (FTP_DELETECMD, MAKE_TESTZIP.COM, MAKE_UNZIP.COM). |
| GOEONL{rrrr}-{mm}-{dd}-{hh}-{mi}-{ss}.zip* | Time and date mask for name of .zip file. |
| GOEONL_{rr}{mm}{dd}{hh}{mi}.lpx* | Time and date mask for name of unzipped .lpx file. |
Directory for Unzipped files | DKA200:[000000.IFAZD.UNZIPPED] | Directory, from which the unzipped .lpx files will be read. |
| 2Rove | Directory on FTP server that contains .zip files. |
| 10.11.1.131 | Name/IP address of primary FTP server. |
| 10.11.1.131 | Name/IP address of secondary FTP server. |
| azduser | FTP user name on both the primary and secondary FTP server. |
| *** | FTP user password on both the primary and secondary FTP server. |
| 30 | If the downloading or deleting of files on FTP server took longer than this setting, this information is written into the log file of KOM process. |
Active Energy Tech. Units | MWH | Technical units of active energy . |
Reactive Energy Tech. Units | MVARH | Technical units of reactive energy. |
| 1 min | Expected time interval of all values. If the value of processed file in "Interval Name" column is higher than "Expected interval", the value will be evenly allocated. The value 0 disables this feature. |
Analyze Archived Files on Startup | YES | KOM process, when starting, inspects old data sources in order to recalculate the value of electrical work. |
| NO | Analyzes also the files that are older than "Maximum File Age". |
| 3 hod | If the interval is exceeded, the values are either ignored or processed as Old Values, depending on the parameter "Send Old Values". |
| Debug unknown and lost tags | NO | Enables displaying of warnings about addresses of measurement points with missing I/O tag. |
I/O tag configuration
...