EDW LPEX V2.0 communication protocol
Description
Communication line configuration
Communication station configuration
I/O tag configuration
I/O tag address
Error indication
Literature
Changes and modifications
Document revisions
Description
EDW LPEX V2.0 protocol is a simple text file protocol. Its implementation is based on a sequential processing of file rows. 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 row of table correspond with 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 is displayed in the table below. The header columns are described 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 |
Communication line configuration
- Communication line category: FILE I/O
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 |
|---|---|---|
| Date Column Name | Datum | Column name containing date. |
| Time Column Name | Zeit | Column name that contains a time data. |
| Address Column Name | ZPB | Column name that contains a value address. |
| Tech. Units Column Name | EinHeit | Column name that contains a unit of a measured value. |
| Value Column Name | Werte | Column name that contains the measured values. |
| Value Type Column Name | Kennzahl | Column name that contains a value type (AP+ ,AP- ,AQ+ ,AQ-). |
| Interval Name | MPDauer | Column name that contains a granularity of measurements [s]. |
| Max. Columns Number | 30 | Defines maximum column count, that are scanned when data acquisition. |
| Column Delimiter | ; | Value separator in the header and body. |
| Date Conversion Mask | dd.mm.rr | A mask for a conversion of date in the text format to an internal date. |
| Time Conversion Mask | hh:mi:ss | A mask for a conversion of time in the text format to an internal time. |
| Command Path | Directory for storing the batch files (e.g. unpacked ZIP archive). | |
| Command Path VMS | Only for OpenVMS. Directory (e.g. DKA0:[IFAZD]) containing the batch files TESTZIP.COM and UNZIP.COM. | |
| Download Command File | ftp_download.com | Batch file for downloading data from FTP server. |
| Delete Temporary Files | deltmp.com | Batch file for deleting of temporary files (FTP_DELETECMD, MAKE_TESTZIP.COM, MAKE_UNZIP.COM). |
| ZIP File Mask | GOEONL{rrrr}-{mm}-{dd}-{hh}-{mi}-{ss}.zip* | Time and date mask for name of .zip file. |
| LPX File Mask | 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. |
| Remote Data Directory | 2Rove | Directory on FTP server that contains .zip files. |
| Primary FTP Server | 10.11.1.131 | Name/IP address of primary FTP server. |
| Secondary FTP Server | 10.11.1.131 | Name/IP address of secondary FTP server. |
| FTP User | azduser | FTP user name on both the primary and secondary FTP server. |
| FTP Password | *** | FTP user password on both the primary and secondary FTP server. |
| FTP Connection Timeout | 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. |
| Expected Interval | 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. |
| Send Old Values | NO | Analyzes also the files that are older than "Maximum File Age". |
| 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
Permitted I/O tags: Ai
I/O tag address
I/O tag address consists of three parts. First one defines the value of work or performance. The second one - "Primary EAN Code" and "BackupEAN Code" are used as a unique identifier of value, which is placed in "Address Column Name" of source file. The third part represents the value type (AP+,AP-,AQ+,AQ-), which is in the "Value Type Column Name".
Error indication
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 values on condition that the files comes from other 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" is enabled at the same time,
- data are not processed during the current hour, for example, if the record with time stamp 13:45 comes in the time 14:03,
- older data, as already processed, come for I/O tag.
In these cases, the values are archived without flag. The most recent valid value will have FB flag.
- There were received data with the same time stamp as current time stamp of I/O tag, but with the different value. 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 of value stored in the file, this data has also FB flag, in case of both archival and current value.
The performance values will be preprocessed before sending to 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 from the integral value of work will be average performance. The time stamp of this artificial performance value will be moved to the beginning of interval.
If the protocol is configured so that data are downloaded from FTP servers, user may set the primary and secondary FTP server. If data downloading from primary server failed, the secondary one is used. Data processed in such a way have FA flag.
These value flags are displayed in the archival dialog box of I/O tag, column "Value flag".
Literature
Changes and modifications
-
Document revisions
- Ver. 1.0 - April 23, 2014 - New document
Related pages: