...
EDW LPEX V2.0 protocol is a simple text file protocol. Its implementation is based on a the sequential processing of file rows. Two types of files are supported:
...
For better visibility, the data is displayed in a the 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 the table below. The header columns are described in Protocol parameters in the section Communication station configuration.
| ZPB | Kennzahl | Wandlerfaktor | MPDauer | (Flags) |
| 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 , and Max. Columns Number) are , are ignored. Parameters Date Conversion Mask and Time Conversion Mask
parameters, specifying the date and time format, are also ignored, and format yymmddhhmi is assumed.
| Kotva |
|---|
| komunikacna_linka |
|---|
| komunikacna_linka |
|---|
|
Communication line configuration
...
| 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 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 [min]. |
| 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 the conversion of 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 a 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 MPX file is presumed to be in the winter 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 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 parameter Directory for Unzipped files. |
| GOEONL_{rr}{mm}{dd}{hh}{mi}.lpx* | Time and date mask for 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
|
Directory for Unzipped files | 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. |
| azduserazdinterface | 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 the FTP server took longer than this setting, this information is written into the log file of the 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 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. |
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. |
| NO | All values from communication (even old ones) go to the system as new values. |
...
I/O tag address consists of three parts.
First The first one defines the type of value:
- 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 size of Interval - see the parameter Expected Interval)
The second one - "Primary EAN Code" and "BackupEAN Code" are - is used as a unique identifier of value, which is placed in the "Address Column Name" of the source file.
The third part represents the value type (AP+,AP-,AQ+,AQ-), which is in the "Value Type Column Name".
Note: configuration of two I/O tags which are 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 Power + Work or Work + Energy are supported.
...
The flags FA and FB are used to indicate the situations , when data processing was not done as expected. FB flag is set only for the performance power values on the condition that the files comes come from other another server, i.e. they are transmitted through FTP. It relates to the following situations:
- time in the file is older than "Maximum File Age" and the parameter "Send Old Values" parameter is enabled at the same time,
- data are not processed during outside of the current hour, for example, if the record with time stamp a timestamp 13:45 comes in the time at 14:03,
- older data, as already processed, come for the I/O tag.
In these the following cases, the values are archived without a flag. The most recent valid value will have an FB flag .set:
- The There were received data with the same time stamp timestamp as the current time stamp timestamp of the I/O tag were received, but with the a different value. An FB flag is set for this particular value.
- The name of each processed file contains also the information about time. If this time is different from time stamp the timestamp of a value stored in the file, this data has also an FB flag, in case of both archival for historical and current value.
The performance values will be preprocessed before sending them to the D2000 Server. If the values are received in N-minutes intervals, the value from the file will be divided by a number (N* 60), which ensures that the average power will be obtained from the integral value of work will be average performance. The time stamp timestamp of this artificial performance power value will be moved to the beginning of the interval.
If the protocol is configured so that data are downloaded from FTP servers, user may set it is possible to configure the primary and secondary FTP server. 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, column in the "Value flag" column.
Literature
...