...
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 |
21.12.22;11:45:00;;;;;;;;;SK100000314990000LMARA_F45Q5_KSP2;KSP;IMP;1;15;99;00000 |
One row of a table corresponds to one row in a text file. A symbol ";" is used as a separator, which may be redefined in the station parameters - the "Column Delimiter" parameter.
...
LPEX V2.0 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Datum | Zeit | ZPB | Kennzahl | Einheit | Wandlerfaktor | MPDauer | Werte | |||||||||||
15.4.2014 | 0:07:00 | xxxSK40000041499000000000BESENOVA_T1 | AP-M | kWh | 11 | 01 | 00 | 00000 | ||||||||||
15.4.2014 | 0:07:00 | yyySK40000041499000000000BESENOVA_T1 | AP+M | kWh | 11 | 01 | 00 | 00000 | ||||||||||
15.4.2014 | 0:07:00 | zzzSK40000041499000000000BESENOVA_T2 | AP-M | kWh | 1 | 01 | 27 | 00000 | 1 | 27 | ||||||||
21.12.2022 | 11:45:00 | SK100000314990000LMARA_F45Q5_KSP2 | KSP | IMP | 1 | 15 | 99 | 000000 |
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 a better visibility, the data is displayed in the table below. The header columns are described in Protocol parameters in the section section Communication station configuration.
...
- Communication line category: FILE 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 (*.zip) - the input files are downloaded from the specified FTP servers and the ZIP files are searched for in the directory specified by the "Input File" parameter.
The parameter "Archive" specifies a folder for storing processed files.
...
Parameter | Default value | Meaning | ||||||
---|---|---|---|---|---|---|---|---|
| LPEX | Type of processed files - LPEX (*.lpx) or MPX (*.mpx). | ||||||
| Datum | Column name containing the date. | ||||||
| Zeit | Column name that contains time data. | ||||||
| ZPB | Column name that contains a value address. | ||||||
| EinHeit | Column name that contains a unit of a measured value (or IMP for a KSP value type). | ||||||
| Werte | Column name that contains the measured values. | ||||||
| Kennzahl | Column name that contains a value type (AP+ ,AP- ,AQ+ ,AQ-, KSP). | ||||||
| MPDauer | Column name that contains a granularity of measurements [min]. | ||||||
| 30 | Defines maximum count of columns, that are scanned when data acquisition. | ||||||
| ; | Value separator in the header and body. | ||||||
| dd.mm.rr | A mask for the conversion of the date in the text format to an internal date. In the case of MPX files, the mask is ignored. | ||||||
| hh:mi:ss | A mask for the conversion of time in the text format to an internal time. In the case of MPX files, the mask is ignored. Note: time in LPEX, as well as the MPX file, is presumed to be in the wintertime. | ||||||
| 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 the 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 the name of the ZIP file. If the parameter is empty, it is assumed that LPEX or MPX files are located in the directory specified by the parameter Directory for Unzipped files. | ||||||
| GOEONL_{rr}{mm}{dd}{hh}{mi}.lpx* | Time and date mask for the name of unzipped LPEX files. If MPX files are processed, their name must match mask *{yy}{mm}{dd}{hh}{mi}.mpx or at least *{yy}{mm}{dd}{hh}{mi} e.g. ETREN_03_1805151136.mpx | ||||||
| DKA200:[000000.IFAZD.UNZIPPED] | Directory, from which the unzipped LPEX or MPX files will be read. | ||||||
| 2Rove | Directory on the FTP server that contains ZIP files. | ||||||
| 10.11.1.131 | Name/IP address of the primary FTP server. | ||||||
| 10.11.1.131 | Name/IP address of the secondary FTP server. | ||||||
| azdinterface | FTP user name on both the primary and secondary FTP serverservers. | ||||||
| *** | FTP user password on both the primary and secondary FTP serverservers. | ||||||
| 30 | If the downloading or deleting of files on the FTP server took longer than this setting, this information is written into the log file of the KOM process. | ||||||
| MWH | Technical units of active energy. | ||||||
| MVARH | Technical units of reactive energy. | ||||||
| 1 min | The expected time interval of all values. If the value in the processed file in the "Interval Name" column is higher than "Expected Interval", the value of energy will be evenly split into several intervals of "Expected Interval" size. The value 0 disables this feature. | ||||||
| NO | The parameter activates the archiving of processed files in subdirectories according to the hours within the day (i.e. 00 to 23). In the case of a large number of processed files, further work with them is simplified. | ||||||
| YES | When starting, the KOM process inspects old data sources to recalculate the value of electrical work. Note: if the "Hour Subdirectories in Archive" parameter is activated, only old files from the last hour will be inspected. | ||||||
| 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 "Send Old Values" parameter. | ||||||
| NO | Enables displaying warnings about addresses of measurement points with missing I/O tagtags. | ||||||
| NO | All values from communication (even old ones) go to the system as new values. |
...
- P - Power (calculated from Energy read from the input file)
- W - Work (calculated by integrating Power within the current hour)
- E - Energy (directly from the input file with possible recalculations due to the size of the Interval - see the the Expected Interval parameter)
...
The third part represents the value type (AP+, AP-, AQ+, AQ-, KSP), which is in the "Value Type Column Name".
Note: KSP means pulse values from the KSP devices (units are IMP = impulses). Such I/O tags should have a type of value equal to E (Energy), the technical units are ignored (the conversion is not performed).
Note: configuration of two I/O tags of types Power and Energy and the next two parts of their address is identical, is not currently supported. Only one of these I/O tags will work. Combinations Combinations of Power + Work or Work or Work + Energy are Energy are supported.
Following The following special addresses exist:
- I/O tag with TRIGGER address will be set to a value equal to the number of processed LPEX or MPX files immediately after the processing is done.
- I/O tag with INVALIDS address will be set to a value equal to the number of I/O tags the data for which were not found in a file that was just processed.
...
If the protocol is configured so that data are downloaded from FTP servers, it is possible to configure the primary and secondary FTP serverservers. If the data downloading from the primary server failed, the secondary one is used. Data processed in such a way have FA flag. These abovementioned value flags are displayed in the archival dialog box of the I/O tag, in the "Value flag" column.
...
- Ver. 1.0 - April 23, 2014 - New document.
- Ver. 1.1 - May 17, 2018 - Support for MPX files.
- Ver. 1.2 - August 1, 2023 - Support for KSP (impulses) in LPX files.
Info | ||
---|---|---|
| ||
...