Available File formats (Parsers) - FTP, SFTP and Email

Follow

In this article you are going to learn about all the available Parsers for FTP, SFTP (external) and Email gateways

 

FTP File formats

The EMS Platform allows you to freely use its FTP server to import data. In order to use it, check what is an FTP gateway and how to create it.

Here's the list of available formats for FTP:

If you want to send data through FTP using a different file format, contact us at support@dexma.com.

SFTP File formats

The EMS Platform allows you to freely use an SFTP server of your own to import data. In order to use it, check what is an SFTP gateway and how to create it.

Here's the list of available formats for SFTP:

If you want to send data through SFTP using a different file format, contact us at support@dexma.com.

Email File formats

The EMS Platform allows you to send data through Emails, storing them in a server from the EMS. In order to use it, check what is an Email gateway and how to create it.

Here's the list of available formats for Email:

If you want to send data through Email using a different file format, contact us at support@dexma.com. 

 

Full list of available file formats

NOTE: Please follow the exact formatting of  any of the following file types used to insert data in the platform (exact timestamp, valid time zone, etc.) 

The included formats in this article are the following:

 

Aqualogy 

Specific parser to understand data sent by an Aqualogy gateway.

Available for

  • FTP

Available parameters

901 - Water volume

Format type

  • Values must be separated by semicolons.
  • The name of each file sent must be unique.
  • All the values are inserted as water volume using the 901 parameter
  • All the values are divided by 1000 (to convert to water liters)
  • CSV file

The format of the CSV:

  • Column 1-2: -
  • Column 3: Name of the device (DeviceID).
  • Column 4: Timestamp in the following format: DD/MM/YYYY hh:mm:ss (local time)
  • Column 5: Value

 

Example

AB CLIENTS IMETER;13060110;D13XK047959C;28/10/2020 07:00:00;7403300;
AB CLIENTS IMETER;13060110;D13XK047959C;28/10/2020 06:45:00;7403300;
AB CLIENTS IMETER;13060110;D13XK047959C;28/10/2020 06:30:00;7403300;
AB CLIENTS IMETER;13060110;D13XK047959C;28/10/2020 06:15:00;7403300;
AB CLIENTS IMETER;13060110;D13XK047959C;28/10/2020 06:00:00;7403300;
AB CLIENTS IMETER;13060110;D13XK047959C;28/10/2020 05:45:00;7402200;
AB CLIENTS IMETER;13060110;D13XK047959C;28/10/2020 05:30:00;7395600;

 

Capfile PME PMI

Available for

  • FTP

Available parameters

  • 45271 - Produced Active Energy
  • 40271 - Active Energy

Format type

  • Values must be separated by tabs.
  • The name of each file sent must be unique.
  • The parameters inserted are 40271 and 45271, through different columns of the file
  • .XML file with a .CSV file inside

The format of the CSV inside the XML:

  • Column 1 - Date: Timestamp in the following format: DD/MM/YYYY hh:mm:ss (timezone from the gateway configuration on the EM Platform)
  • Column 2 SouP : Value of the parameter id 40271
  • Column 3:
  • Column 4 InjP : Value of the parameter id 45271
  • Column 5-9: -

Example

Date                   SouP SouQ InjP InjQ Tens PuisSous Period Etat
20/11/2020 06:10:00    0  0    0    0    0   0   148    HPH    

 

 

Carlo Gavazzi Sx2WEB24

Available for

  • FTP
  • Email

Available parameters

  • 401  - Active Power
  • 402 - Active Energy
  • 452 - Produced Active Energy
  • 301 - Temperature ºC
  • 302 - Humidity
  • 503 - Generic Value
  • 404 - Reactive Energy
  • 403 - Inductive Reactive Power
  • 412 - Power Factor
  • 409 - Apparent Power
  • 414  - Frequency
  • 502 - Pulse counter
  • 405 - Voltage
  • 434 - Voltage L-L
  • 406 - Current
  • 423 - Current distortion (THD-total harmonic distortion)
  • 422 - Voltage distortion (THD-total harmonic distortion)
  • 303 - Light
  • 307 - Air Quality (CO2)

Format type

  • Values must be separated by semicolons.
  • The name of each file sent must be unique.
  • Values must be in quotes (" ")
  • .ZIP with multiple .CSV files

The format of each CSV:

"Position";"Timestamp";"Date";"Hour";"Part Number";"Object Name";"Location 
Name
"  "Sin" ; "Subnet" ; "Modbus Address" ; "Com Port" ;"Group";"Type";
"kWh AC [kWh]" ; "DMD W [W]"; ; ; ;.....
  • Column 1: -
  • Column 2: Timestamp in seconds in the epoch format (check online converter)
  • Columns 3-5:
  • Column 6: Part of the device_ID
  • Columns 7-9: -
  • Column 10: Part of the device_ID
  • Column 11: Com Port. If this field is empty, we take data only from the mono_service_dict columns.
  • Column 12: Part of the device_ID

Device_ID is: [Column6]-[Column7]-[Column10]-[Column12]

Compatible variables

service_dict = { 'Temperature 1 (ºC)' ,  'Temperature 2 (ºC)' ,  'Humidity (%)' , 'Light (Lux)' , 'Input1 0-10V' ,  'Input2 0-10V' , 'VL1N(V)' , 'VL2N(V)' , 'VL3N(V)' ,  'AL1(A) ,  'AL2(A)', 'AL3(A)' ,  'WL1(kW)' , 'WL2(kW)' ,  'WL3(kW)' ,  'VAL1(VA)' ,  'VAL2(VA)' ,  'VAL3(VA)',
'VarL1(Var)' ,  'VarL2(Var)' ,  'VarL3(Var)' ,  'PFL1' ,  'PFL2' ,  'PFL3' ,  'kWh AC (kWh)', 'DMD W sys (W)' ,  'Counter 1' ,  'Counter 2' ,  'Counter 3' ,  'Counter 4' ,  'Co2', 'Temperature' ,  'VLN sys [V]' ,  'VL1N [V]' ,  'VL2N [V]' ,  'VL3N [V]' , 'VLL sys [V]' ,  'VL1L2 [V]' ,  'VL2L3 [V]' ,  'VL3L1 [V]' , 'AL1 [A]' ,  'AL2 [A]' ,  'AL3 [A]' ,  'W sys [kW]' ,  'WL1 [kW]', 'WL2 [kW]' ,  'WL3 [kW]' ,  'kVA sys [VA]' ,  'kVA L1 [VA]' ,  'kVA L2 [VA]' ,  'kVA L3 [VA]', 'Var sys [Var]' ,  'kVar L1 [Var]' ,  'kVar L2 [Var]' ,  'kVar L3 [Var]' ,  'PF sys' ,  'PF L1' ,  'PF L2' ,  'PF L3' ,  'FREQUENCY [Hz]' ,  'kWh AC [kW]' ,  'KWh L1 [kW]' ,  'KWh L2 [kW]' , 'KWh L3 [kW]' ,  'Kvarh [kVarh]' ,  'KWh ACN [kWh]' , 'kWh AC [kWh]' ,  'COUNTER 1' ,  'COUNTER 2' ,  'COUNTER 3' ,  'COUNTER 4' , 'THDAl1' ,  'THDAl2' ,  'THDAl3', 'THDVl1' ,  'THDVl2' , 'THDVl3' }

mono_service_dict = { 'WL1 [kW]' , 'WL1(kW)' , 'kVar L1 [Var]' , 'VL1N [V]' , 'AL1 [A]' , 'kVA L1 [VA]' , 'PF L1' }

 

Example

Position;Timestamp;Date;Hour;Part Number;Object Name;Location Name;Sin;Subnet;Modbus Address;Com Port;Group;Type;A L1 [A];A L2 [A];A L3 [A];FREQUENCY [Hz];PF L1;PF L2;PF L3
1;1588824000;07/05/2020;06:00:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;304224;307041;316083;50.0;800;822;811
2;1588824300;07/05/2020;06:05:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;303873;306653;315105;50.0;799;819;809
3;1588824600;07/05/2020;06:10:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;303092;305719;314016;50.0;798;818;809
4;1588824900;07/05/2020;06:15:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;302709;305138;313166;50.0;798;816;808
5;1588825200;07/05/2020;06:20:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;301307;304232;312238;50.0;798;817;807
6;1588825500;07/05/2020;06:25:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;300192;303765;310839;50.0;799;817;807
7;1588825800;07/05/2020;06:30:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;299910;303117;310328;50.0;800;818;808
8;1588826100;07/05/2020;06:35:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;302537;300688;308070;50.0;800;813;815
9;1588826400;07/05/2020;06:40:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;304372;303219;306965;50.0;807;813;817
10;1588826700;07/05/2020;06:45:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;304037;303615;307052;50.0;808;814;818
11;1588827000;07/05/2020;06:50:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;304113;303997;307329;50.0;810;815;819
12;1588827300;07/05/2020;06:55:00;EM210_DCT;OBJECT;LOC;1;COM 2;4an;AVG;304238;304371;307473;50.0;811;817;820

In this example, the devices that would be created in the EMS would be:

  • OBJECT-LOC-1-4an
  • OBJECT-LOC-1-4ana
  • OBJECT-LOC-1-4anb
  • OBJECT-LOC-1-4anc

 

Continuum (OPTIMISED)

Available for

  • FTP

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Values must be separated by commas.
  • CSV file

The format of the CSV:

  • Column 1: Timestamp in the following format: DD/MM/YYYY hh:mm:ss XX (local time, with the timezone configured in the gateway registered in the EMS). XX meaning AM or PM.
  • Column 2-X: Information about each device that the file will insert data from.
  • Row 1: 
  • Row 2: Description of the Columns (1st one "DATE" and from the 2nd one on, the device ID of each device).
  • Rows 3-X: Timestamp and data from each of the devices. 

Example

DATE,H02_022,W01_05,E059_064,PoolKwh,GW01_05,BioMass,SolarPV,M006
10/10/2020 07:30:00 AM,289966,722.2,1318,1056,1539.66,684340,13193,589.5
10/10/2020 07:00:00 AM,289960,722.5,1292,1056,1539.64,684340,13193,589.5

 

Desigo

Available for

  • Email

Available parameters

  • 402 - Active Energy
  • 419 - Gas Volume

Format type

  • Values must be separated by tabs.
  • Decimals are defined using commas.
  • Each email can contain 1 or multiple CSV files.

The format of the CSV:

  • Row 1 - Column 2: Part of the device ID
  • Rows 2-5: -
  • Row 6: Description of the columns
  • Rows 7-X: Data

From row 7 on:

  • Column 1: -
  • Column 2: Part of the device ID
  • Column 3: Units - m3 is 419, kWh is 402. Other types of units are discarded.
  • Column 4: Value of the data
  • Column 5: Timestamp in the following format: DD/MM/YYYY hh:mm (local time, with the timezone configured in the gateway registered in the EMS). 

Example

Nombre informe: EJEMPLO 

Estado informe: La creación del informe se completó con éxito.

Description Name Unit Value TimeStamp
Contador de Gas Gas_Device m3 5000 08/05/2020 8:00
Energia Activa Active_Energy_Device kWh 456384 08/05/2020 8:00
Energia Reactiva Reactive_Energy_Device kVAr. 75689 08/05/2020 8:00
Potencia Act Fase 1 Active_Power_a kW 4,5 08/05/2020 8:00
Potencia Act Fase 2 Active_Power_b kW 7,4 08/05/2020 8:00
Potencia Act Fase 3 Active_Power_c kW 2,6 08/05/2020 8:00

In this example, only 2 devices would be imported in the EMS: Gas_Device and Active_Energy_Device. The device ID for each of them would be [Row 1-Column 2]_Name:

  • EJEMPLO_Gas_Device
  • EJEMPLO_Active_Energy_Device

 

DEXMA Default CSV format 

The EM Platform allows sending data through email/FTP/SFTP using a standard CSV file. This file allows any frequency and parameter.

Available for

  • Email
  • FTP
  • SFTP

Available parameters

All the parameters from DEXMA. Full list here.

Format type

  • Values must be separated by semicolons.
  • The name of each file sent must be unique.
  • CSV file

The format of the CSV:

  • Column 1: Timezone
  • Column 2: Timestamp in the following format: YYYY/MM/DD hh:mm:ss (local time related to Column1, not UTC)
  • Column 3: Name of the device (DeviceID) - Limited to 64 characters.
  • Column 4: Parameter
  • Column 5: Value

Example

Europe/Madrid;2020/07/07 08:00:00;General;402;100
Europe/Madrid;2020/07/07 08:00:00;HVAC;402;40
Europe/Madrid;2020/07/07 08:15:00;General;402;200
Europe/Madrid;2020/07/07 08:15:00;HVAC;402;50
Europe/Madrid;2020/07/07 08:30:00;General;402;300
Europe/Madrid;2020/07/07 08:30:00;HVAC;402;60
Europe/Madrid;2020/07/07 08:45:00;General;402;400
Europe/Madrid;2020/07/07 08:45:00;HVAC;402;70

The timestamp of the reading corresponds to the beginning of the consumption period. This means that, for instance, reading 100 from the General device with a timestamp of 2020/07/07 08:00:00 will represent the consumption from 08:00:00 until the next timestamp (08:15:00).

So, the consumption value at 08:00:00 will be:

  • [reading at 08:00:00] - [reading at 08:15:00] = 200-100 = 100 kWh

Dailylight savings changes

These should be set on the gateway that is sending the data to the FTP server, so that the hour that is doubled appears only one time in the file, but having the consumption of the repeated hour or latest hour.

For example, in the case where the consumption was 100 kWh per hour, to the row corresponding to 02:00:00 we would have to add the consumption of 02:00:00 of the summer schedule and that of 03:00:00 of the same schedule (moment in which the hour is changed and they become 02:00:00 again). Therefore, the consumption would be 200kWh. The row corresponding to 03:00:00 must contain the consumption of the new time, that is, the wintertime. 

Europe/Madrid;2020/10/28 01:00:00;device_1;40211;100
Europe/Madrid;2020/10/28 02:00:00;device_1;40211;200
Europe/Madrid;2020/10/28 03:00:00;device_1;40211;100

Troubleshooting:

  • Make sure there are no spaces when writing the timezone
  • When creating the CSV file, double-check that there are no extra quotation marks in the fields (for instance with a plain text editor such as Notepad or TextEdit), as some software for editing CSV will add them as field delimiters.

Note: This format does not include time change due to daylight changes. For the changeover from winter to summertime, there is no problem since the hours are not repeated. However, for the changeover from summertime to wintertime only one row has to be sent as specified above. Another alternative is to change the data to a format that does not have time changes such as UTC. 

 

DEXMA Default 30min shifted

The EM Platform allows sending data through FTP/SFTP using a standard CSV file, that adds 30min to the timestamp of the file.

Is the same as the DEXMA default CSV, but adding the 30min to the timestamp.

Available for

  • FTP
  • SFTP

Available parameters

All the parameters from DEXMA. Full list here.

Format type

  • Values must be separated by semicolons.
  • The name of each file sent must be unique.
  • CSV file

The format of the CSV:

  • Column 1: Timezone
  • Column 2: Timestamp in the following format: YYYY/MM/DD hh:mm:ss (local time related to Column1, not UTC)
  • Column 3: Name of the device (DeviceID) - Limited to 64 characters.
  • Column 4: Parameter
  • Column 5: Value

Example

Europe/Madrid;2020/07/07 08:00:00;General;402;100
Europe/Madrid;2020/07/07 08:00:00;HVAC;402;40
Europe/Madrid;2020/07/07 08:15:00;General;402;200
Europe/Madrid;2020/07/07 08:15:00;HVAC;402;50
Europe/Madrid;2020/07/07 08:30:00;General;402;300
Europe/Madrid;2020/07/07 08:30:00;HVAC;402;60
Europe/Madrid;2020/07/07 08:45:00;General;402;400
Europe/Madrid;2020/07/07 08:45:00;HVAC;402;70

In this format, the timestamp of the reading corresponds to the beginning of the consumption period + 30min. This means that, for instance, reading 100 from the General device with a timestamp of 2020/07/07 08:00:00 will represent the consumption from 08:30:00 until the next timestamp (08:45:00).

So, the consumption value at 08:30:00 will be:

  • [reading at 08:00:00] - [reading at 08:15:00] = 200-100 = 100 kWh

Troubleshooting:

  • Make sure there are no spaces when writing the timezone
  • When creating the CSV file, double check that there are no extra quotation marks in the fields (for instance with a plain text editor such as Notepad or TextEdit), as some software for editing CSV will add them as field delimiters.

 

Elcomponent

Available for

  • FTP

Available parameters

  • 402 - Active Energy
  • 404 - Reactive Energy
  • 502 - Pulse counter
  • 503 - Generic Value

All the values that are not Pulse counter, Active Energy or Reactive Energy, are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Values must be separated by commas.
  • Values must be quoted.
  • The timestamp is modified in the EMS substracting 30min.
  • CSV file

The format of the CSV:

  • Row 1: Description of each column
  • Rows 2-X: Data
  • Column 1: deviceID
  • Column 2: Type of Pulse counter (depending on the Pulse counter, a prefix PC0 or a prefix CC0 is added to the deviceID)
  • Column 3: Units.
    • If unit is "kWh", the parameter is 402
    • If unit is "kVArh", the parameter is 404
    • If unit is "", the parameter is 502.
  • Column 4: Date in the following format: YYYY-MM-DD
  • Column 5: Time in the following format: hh:mm (local time related to the Timezone in the gateway, not UTC)
  • Column 6: Data value
  • Column 7: -

Example

"DeviceName(deviceID)","DataItem","Units","Date","Time","Value","Status"
"Pulse-3-EGGG-CL","Channel 1 counter","","2014-09-07","00:30",42281322.00,0
"Pulse-3-EGGG-CL","Channel 1 counter","","2014-09-07","01:00",42281455.00,0
"Pulse-3-EGGG-CL","Channel 1 counter","","2014-09-07","01:30",42281585.00,0
"Pulse-3-EGGG-CL","Channel 1 counter","","2014-09-07","02:00",42281713.00,0
"Pulse-1-WWGG-OH","Channel 1 Pulse Count","","2014-09-07","00:30",1922752.00,0
"Pulse-1-WWGG-OH","Channel 1 Pulse Count","","2014-09-07","01:00",1922752.00,0
"Pulse-1-WWGG-OH","Channel 1 Pulse Count","","2014-09-07","01:30",1922752.00,0

  

Fleetsolve - Wipulse

Available for

  • FTP

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Cells with #### or null values are not taken into account.
  • Rows are ordered by the timestamp in descent order.
  • XLS file

The format of the XLS:

  • Rows 1-3: -
  • Row 4: Description of each column (from column 1 to 6).
    • Columns 7-X: DeviceIDs of each device.
  • Row 5-X: Data

From row 5 on:

  • Column 1-2: -
  • Column 3: Date in the following format: DD/MM/YYYY
  • Column 4: Time in the following format: hh:mm:ss (local time related to the Timezone in the gateway, not UTC)
  • Column 5-6: -
  • Column 7-X: Data values of each device at the defined timestamp

Example

Name  Firmware ver.           Application  Date      App. ver.   Ser. num. 
EMA IS-NT-2.5 R:14.01.2011 SPI 6/2/2014 2.5 101161E0

Num Reason Date Time RPM Pwr A2-2 A2-3 A2-4 A2-5 EA8
-29 Time stamp 01/06/2020 23:30:00.1 0 0 20 22 71 72 #####
-30 Time stamp 01/06/2020 23:00:00.1 0 0 20 22 64 63 #####
-31 Time stamp 01/06/2020 22:30:00.1 0 0 20 21 69 69 #####
-32 Time stamp 01/06/2020 22:00:00.0 0 0 21 22 70 70 #####
-33 Time stamp 01/06/2020 21:30:00.0 0 0 21 22 64 65 #####
-34 Time stamp 01/06/2020 21:00:00.0 0 0 21 22 71 72 #####

In this example, the EMS would import data from the devices A2-2, A2-3, A2-4 and A2-5.

 

HH Read Data

Available for

  • FTP

Available parameters

40261 - Discrete 30min Active Energy

Format type

  • Values must be separated by commas.
  • CSV file

The format of the CSV:

  • Column 1: Device ID
  • Column 2: Timestamp in the following format: YYYY/MM/DD hh:mm:ss (time in UTC)
    • IMPORTANT note: value at 00:30 represent consumption between 00:00 and 00:30, so we subtract one period to the timestamp, as the EMS represents the consumption at the beginning of the period (00:00).
  • Column 3: -
  • Column 4: Data value
  • Column 5: -

Example

mtr/2376551956116_41060652,2020/03/12 00:30,0,1934,0
mtr/2376551956116_41060652,2020/03/12 01:00,0,1972,0
mtr/2376551956116_41060652,2020/03/12 01:30,0,1908,0
mtr/2376551956116_41060652,2020/03/12 02:00,0,1941,0
mtr/2376551956116_41060652,2020/03/12 02:30,0,1964,0
mtr/2376551956116_41060652,2020/03/12 03:00,0,1931,0
mtr/2376551956116_41060652,2020/03/12 03:30,0,1909,0

 

HWM RT:Wi5

Available for

  • FTP
  • Email

Available parameters

  • 502 - Pulse Counter
  • 301 - Temperature ºC
  • 302 - Humidity

Format type

  • Name of the file contains part of the device ID
  • File .txt

The format of the .txt:

  • Digits 1-14: Timestamp in the following format: YYYYMMDDhhmmss
  • Digits 15-16: Parameter type. The parser recognises:
    • 81: Pulse counter (502 in the EMS)
    • 82: Temperature Cº (301 in the EMS)
    • 92: Temperature Cº (301 in the EMS)
    • 83: Humidity (302 in the EMS)
    • 93: Humidity (302 in the EMS)
  • Digits 17-22: Part of the device ID
  • Digits 26-36: Hexadecimal digits containing the value of the measure. Depending on the type of measure, the digits are structured in different ways.
    • Pulse measures: The parser obtains the 7 first digits and converts them into decimal.
    • Temperature: The first 2 digits indicate the sign, and the next 3 digits indicate the value. If it's negative (0F), the parser substracts 256 and then the value is divided by 2. If it is not negative, the parser just divides by 2.
    • Humidity: The parser obtains the 5 first digits and converts them into decimal (value). Then the following caculation is done:  Humidity= (value* value )*-0.0000028) + (value*0.0405) -4

Example

Let's take as an example a file called E4T5_20200509104539 with a line to import saying as follows:

20200401094449810217D802051C03474C03

In this case, the parameters will be:

  • Date: 20200401
  • Time: 094449
  • Parameter: 81
  • Device ID: [File name]_[Digits 17-22] = E4T5_0217D8

 

ICF-STRUXTUREWARE

Available for

  • FTP

Available parameters

  • 502 - Pulse Counter
  • 301 - Temperature ºC
  • 302 - Humidity
  • 412 - Power Factor
  • 404 - Reactive Energy
  • 402 - Active Energy
  • 401 - Active Power

Format type

  • Values must be separated by semicolons.
  • CSV file

The format of the CSV:

  • Column 1: Device ID
  • Column 2: Parameter type. The parser recognises:
    • Temperatura Retorn: 301
    • Temperatura Impulsio: 301
    • Humitat Interior: 302
    • Temperatura Interior: 301
    • Temperatura Exterior: 301
    • Humitat Exterior: 302
    • Total Consum: 402
    • Consum de gas: 419
  • Column 3: Data value
  • Column 4: Timestamp in the following format: YYYY-MM-DD hh:mm:ss (local time related to the Timezone in the gateway, not UTC)

Example

Sonda temperatura tuberia;Temperatura Retorn;25.298;2020-06-04 13:07:52;
Sonda temperatura tuberia;Temperatura Impulsio;25.14;2020-06-04 13:07:52;
Sonda temperatura humitat interior SHO101-T5;Humitat Interior;65.16;2020-06-04 13:07:52;
Sonda temperatura humitat interior SHO101-T5;Temperatura Interior;24.468;2020-06-04 13:07:52;
Sonda temperatura humitat exterior SHR-510-T;Temperatura Exterior;30.639;2020-06-04 13:07:52;
Sonda temperatura humitat exterior SHR-510-T;Humitat Exterior;48.187;2020-06-04 13:07:52;
iEM3255;Total Consum;342.487;2020-06-04 13:07:52;
iEM3255;Consum de gas;0;2020-06-04 13:07:52;

 

LoRa to GSM

Available for

  • FTP

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Values must be separated by semicolons.
  • The name of the deviceID is taken from the name of the file.
  • The EMS creates as many devices as channels defined (like [deviceID]_[channelnumber])
  • CSV file

The format of the CSV:

  • Column 1: Timestamp in the ISO 8601 format: YYYY-MM-DDThh:mm:ss+XX:XX (where XX:XX represents the UTC offset)
  • Column 2-4: -
  • Column 5: Number of channels
  • Columns 6-X: Data values of the different channels

Example

2020-06-12T00:15:56+00:00;-9;0;8000;2;989;547
2020-06-12T00:26:13+00:00;-9;0;8000;2;989;547
2020-06-12T00:36:13+00:00;-9;0;8000;2;989;547
2020-06-12T00:45:56+00:00;-9;0;8000;2;989;547
2020-06-12T00:56:13+00:00;-9;0;8000;2;989;547
2020-06-12T01:06:13+00:00;-9;0;8000;2;989;547
2020-06-12T01:16:13+00:00;-9;0;8000;2;990;547
2020-06-12T01:26:13+00:00;-9;0;8000;2;990;548
2020-06-12T01:35:56+00:00;-9;0;8000;2;990;548

 

ND Meter

Available for

  • FTP

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • File name, sent by the gateway, contains the deviceID, the date (like DDMMYY) and the time (hhmmss).
    • The composition is: [deviceID]_[date]_[time]
  • The parser creates as many subdevices (channels) as data columns in the file.
  • File .txt

The format of the .txt:

  • Row 1: ID of the ND meter Service
  • Row 2: Data values of the different channels

ND Meter services implemented in the parser are the following:

6656, 6657, 6658, 6659, 6660, 6661, 7680, 7681, 7682, 7683, 7684, 7685,
7686, 7687, 7688, 7689, 7690, 7691, 7692, 7693, 7694, 7695, 7696, 7697,
7698, 7699, 7700, 7701, 7702, 7703, 7704,  7705, 7706, 7707, 7708, 7709,
7710, 7711, 7712, 7713, 7714, 7715, 7716, 7717, 7718, 7719, 7720, 7721,
7722, 7723, 7724, 7725, 7726, 7727, 7728, 7729, 7730, 7731, 7732

Example

File name: 001BE5101010_110820_073000

SES XXXXX     7702  7703  7704  7736 7681 7680 7737 7688 7689 7690 7733 7701 7697 7686 7687  7691 7692 7693
160404_133000 65031 65205 65080 4 5357 3 5 235 160 211 2 954 500 0 37983 2230 2233 2239

In this example, the ID of the device created in the EMS would be 001BE5101010.

 

Roquetude

Available for

  • FTP
  • Email

Available parameters

All the parameters from DEXMA. Full list here.

Format type

  • Values must be separated by semicolons.
  • Values must be quoted.
  • The name of the deviceID is taken from the name of the file.
  • The EMS creates as many devices as channels defined (like [deviceID]_[channelnumber])
  • CSV file

The format of the CSV:

  • Column 1: Timezone like [Continent]/[City]
  • Column 2: Timestamp in the following format: YYYY/MM/DD hh:mm:ss (local time related to the timezone in Column 1)
  • Column 3: Device ID
  • Column 4: Parameter ID in the DEXMA format
  • Column 5: Data value

Example

"Europe/Paris";"2020/06/03 16:00:00"; "PCPT";401;48;
"Europe/Paris";"2020/06/03 16:15:00"; "PCPT";401;50;

 

Satel DL

Available for

  • FTP

Available parameters

All the parameters from DEXMA. Full list here.

Format type

  • Values must be separated by semicolons.
  • CSV file

The format of the CSV:

  • Row 1: Description of each column
    • Column 5-X: Parameter ID. The parser recognises:
      • Eact imp (kWh): corresponds to 40201 (quarter-hourly active energy)
      • ERInd imp (kvarh): corresponds to 40401 (quarter-hourly reactive energy)
  • Row 2-X: Data

Columns from row 2 on:

  • Column 1: Date in the following format: YYYY/MM/DD
  • Column 2: Times in the following format:  hh:mm:ss
  • Column 3: -
  • Column 4: Device ID
  • Column 5-X: Data values of each Parameter ID.

(Note that the parser will suppress the spaces and convert capital letters to low-case letters in the headers).

Example

date       time     id devname       EAct imp(kWh) EAct exp(kWh) ERInd imp(kvarh)
2019/03/20 07:15:00 ES00210096815 1 0 4
2019/03/20 07:30:00 ES00210096815 8 0 5.32

 

Schneider COMX510

Available for

  • FTP

Available parameters

Check out the ANNEX to find the matches with the parser's Parameter ID formats.

  • 402 - Active Energy
  • 401 - Active Power
  • 301 - Temperature ºC
  • 302 - Humidity
  • 303 - Light
  • 307 - Air Quality (CO2)
  • 312 - Dew Point
  • 419 - Gas volume
  • 432 - Diesel Fuel volume
  • 435 - Compressed air volume
  • 436 - Compressed air massflow
  • 503 - Generic Value
  • 504 - Generic Volume
  • 801 - Thermal Power (heating)
  • 802 - Thermal Energy (heating)
  • 804 - Mass flow
  • 805 - Inlet Temperature
  • 806 - Outlet Temperature
  • 901 - Water volume
  • 902 - Water flow
  • 131 - Production

Format type

  • File name: DeviceName_YYYYMMDDhhmmss.csv
  • Values must be separated by commas.
  • CSV file

The format of the CSV:

  • Row 1: -
  • Row 2 - Column 5: Device ID
  • Row 7: Description of each column
    • Columns 4-X: Parameters tags (described in the Annex).
  • Row 8-X: Data

Columns from row 8 on:

  • Columns 1-2: -
  • Column 3: Timestamp in the following format: YYYY-MM-DD hh:mm:ss (in local time, related to the timezone set up in the gateway in the EMS)
  • Columns 4-X: Values for each Parameter tag

Example

Gateway Name   Gateway SN Gateway IP    Gateway MAC    Device Name  Device     Device    Device      Logging   Historical
Address Address Local ID Type ID Type Name Interval Intervals
ComX510_F965D0 DN16020SE 192.16.23.50 00:80:67:F9:65 Device_XXXX 2 10000 PM3250    15 4
                   
      Topic ID1 Topic ID2          
      1042 1046          
                   
Error UTC Offset Local Time Stamp Active Reactive          
(minutes) Power (W) Power (VAr)
0 120 2020-07-11 01:00:00 76.8382 -7.3920          
0 120 2020-07-11 01:15:00 6.2608 -6.2291          
0 120 2020-07-11 01:30:00 6.2847 -6.7508          
0 120 2020-07-11 01:45:00 6.469 -6.8538           

ANNEX: Parameters

Parameters: depending on the "tags" located at each column header. Tags available:

Parameter                             Service  Applicable Factor  Subdevice
'Active energy (Wh)' 402 1000  
'Active Power (W)' 401 1  
'Reactive Power (VAr)' 403 1  
'Active energy delivered (Wh)' 402 1000  
'Reactive energy delivered (VArh)' 404 1000  
'Gasoil (l)' 432 1000  
'Temperature (ºC)' 301 1  
'CO2 Level ()' 307 1  
'Humidity Rate ()' 302 1  
'Litros (l)' 901 1000  
'Iluminancia (lx)' 303 1  
'Producción (Units)' 131 1  
'CO2 (ppm)' 307 1  
'Active energy delivered A (Wh)' 402 1000 'A'
'Active energy delivered B (Wh)' 402 1000 'B'
'Active energy delivered C (Wh)' 402 1000 'C'
'Active energy delivered rate 1 (Wh)' 402 1000 '1'
'Active energy delivered rate 2 (Wh)' 402 1000 '2'
'Active energy delivered rate 3 (Wh)' 402 1000 '3'
'Active energy delivered rate 4 (Wh)' 402 1000 '4'
'VLNAvg' 405 1  
'Agua (l)' 901 1000  
'Agua (m3)' 901 1  
'Gas (m3)' 419 1  
'Gas (l)' 419 1000  
'Caudal Agua (m3/h)' 902 1  
'Agua (m3) (m3)' 901 1  
'Consumo E0 ()' 503 1 'E0'
'Consumo E1 ()' 503 1 'E1'
'Consumo E2 ()' 503 1 'E2'
'Temperatura Impulsion ()' 806 100  
'HeatEnergy ()' 802 1  
'Temperatura Retorno ()' 805 100  
'WaterFlowRate' 804 1  
'Active Power ()' 801 1  
'Energia Reactiva Recibida (kVArh)' 404 1 'ENTRADA'
'Energia Activa recibida (kWh)' 402 1 'ENTRADA'
'Energia Reactiva Entregada (kVArh)' 404 1  
'Energia Activa Entregada (kWh)' 402 1  
'Frequency (Hz)' 414 1  
'Current A (A)' 406 1 'A'
'Current B (A)' 406 1 'B'
'Current C (A)' 406 1 'C'
'Voltage A-N (V)' 405 1 'A'
'Voltage B-N (V)' 405 1 'B'
'Voltage C-N (V)' 405 1 'C'
'Power Factor ()' 412 1  
'Apparent Power (VA)' 409 1  
'Temperature (°C)' 301 100  
'Compressed air massflow (m3/h)' 436 1  
'Flujo de aire comprimido (m3/h)' 436 1  
'Compressed air massflow (m3/min)' 436 1/60  
'Flujo de aire comprimido (m3/min)' 436 1/60  
'Compressed air volume (m3)' 435 1  
'Volumen de aire comprimido (m3)' 435 1  
'Dew Point' 312 1  
'Punto de rocio' 312 1  
'Generic Volume (m3)' 504 1  
'Volumen generico (m3)' 504 1  
'Mass flow (m3/h)' 804 1  
'Mass flow (m3/min)' 804 1/60  
'Mass flow (l/min)' 804 1000/60  
'Flujo masico (m3/h)' 804   1  
'Flujo masico (m3/min)' 804 1/60  
'Flujo masico (l/min)' 804 1000/60 

 

Schneider StruxtureWare

Available for

  • FTP

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Values separated by commas.
  • CSV file

The format of the CSV:

  • Column 1: Part of the device ID
  • Column 2: Part of the device ID
  • Column 3: Timestamp in the following format: YYYY-MM-DD hh:mm:ss (local time, related to the timezone set up in the gateway in the EMS)
  • Column 4: Data value

The device ID is [Column 1]_[Column 2]

Example

APT, CRL. Gas device_m3,   2020-05-07 00:00:00, 277459.81
APT, CRL. Elec device_MWh, 2020-05-07 00:00:00, 7212.04

This example would import 503 data in the EMS under the devices:

  • APT_CRL. Gas device_m3
  • APT_CRL. Elec device_MWh

 

Sedical

Available for

  • FTP

Available parameters

  • 419 - Gas Volume
  • 402 - Active Energy

Format type

  • Values separated by semicolons.
  • CSV file

The format of the CSV:

  • Column 1: Timestamp in the following format: DD/MM/YYYY hh:mm:ss (time in UTC)
  • Column 2: -
  • Column 3: Device ID
  • Columns 4-8: -
  • Column 9: Data value
  • Column 10: Parameter type
    • m3: Gas Volume (419 in the EMS).
    • Wh: Active Energy (402 in the EMS). The value is converted to kWh in the platform.
    • kWh: Active Energy (402 in the EMS).
  • Columns 11-19: -

Example

14/04/2020 00:00:00;11;1022001;REL;65;Gas;149;0;791;m3;14/04/2020 01:58:00;;15/09/1914;;0;m3;31/12/1916;C0010A0C

 

S-Monitor (SCADA & HMI)

Available for

  • FTP

Available parameters

All the parameters from DEXMA. Full list here.

Format type

  • Values separated by semicolons.
  • CSV file

The format of the CSV:

  • Row 1: Definition of each column
    • Column 3-X: Parameter type definition and device ID like [DEXMA Parameter ID]-[DeviceID]
  • Rows 2-X: Data

From row 2 on:

  • Column 1: Date in the following format: DD-MM-YYYY
  • Column 2: Time in the following format: hh:mm:ss (local time, related to the timezone configured in the gateway on the EMS)
  • Column 3-X: Data values for each parameter type

Example

Data; Hora; 301-Temp; 419-GasCoz; 419-GasCald; 402-TorreG; 901-AF; 901-AQS; 402-Geral; 402-Chiller
23-09-2014; 14:30:45; 24,6; 5995,0; 32506,0; 19987,3; 0,0; 5974,0; 845143,9; 66820,7; 43072,3; 

 

SOLARLOG

Available for

  • FTP

Available parameters

  • 401 - Active Power
  • 402 - Active Energy
  • 406 - Current
  • 405 - Voltage
  • 301 - Temperature ºC
  • 461 - Produced Active DC Power
  • 465 - Produced DC Voltage

Format type

  • Values separated by semicolons.
  • Each file includes information about N devices.
  • Each device sends information of various types of counters that are identified at the Header as INV, Pac, Uac...
  • Rows are ordered by the timestamp in descent order.
  • CSV file

The format of the CSV:

  • Column 1: Date in the following format: DD/MM/YY
  • Column 2: Time in the following format: hh:mm:ss (local time, related to the timezone configured in the gateway on the EMS)
  • Column 3-X: Concatenated information of each device in the following way:
    • Column x.1: Device ID
    • Column x.2-x.11: Information about different types of counters:
      • Pac: Active Power (401 in the EMS). You can find Pac1, Pac2 and Pac3, in triphasic cases.
      • Uac: Voltage (405 in the EMS). You can find Uac1, Uac2 and Uac3, in triphasic cases.
      • Iac: Current (406 in the EMS). You can find Iac1, Iac2 and Iac3, in triphasic cases.
      • Pdc: Produced Active DC Power (461 in the EMS). There can be 2.
      • Udc: Produced DC Voltage (465 in the EMS). There can be 2.
      • Temp: Temperature (301 in the EMS)
      • DaySum: For all the devices is Produced Energy (452 in the EMS) except for the last device, for which DaySum is Active Energy (402 in the EMS).

After all the parameters of 1 device are defined, the next column starts with the following device, and so on. It's a concatenated list of columns with information about all the parameters by each device.

Note: If the file includes information about a device called "N3", it is ignored. 

Example

Date;            Time;            INV;  Pac;  DaySum;  Status;  Error;  Pdc1;  Pdc2;  Udc1;  Udc2;  Temp;  Uac;  INV;  Pac;    DaySum;  Status;  Error;  Uac;  Iac;  Pac1;    Pac2;   Pac3;   Uac1;  Uac2;  Uac3
10/06/20; 23:55:00; 1; 0; 8943; 0; 0; 0; 0; 0; 0; 0; 0; 2; 6262; 235110; 1; 0; 230; 27; 2018; 2418; 1826; 230; 230; 230
10/06/20; 23:50:00; 1; 0; 8943; 0; 0; 0; 0; 0; 0; 0; 0; 2; 5829; 234582; 1; 0; 230; 25; 1981; 2201; 1645; 230; 230; 230
10/06/20; 23:45:00; 1; 0; 8943; 0; 0; 0; 0; 0; 0; 0; 0; 2; 6334; 234098; 1; 0; 230; 27; 2228; 2248; 1858; 230; 230; 230

In this example, the devices are called INV.

 

Synapsis SIP

Available for

  • FTP

Available parameters

  • 40261 - Half hourly discretized Active Energy

Format type

  • Values separated by commas.
  • CSV file

The format of the CSV:

  • Column 1: Timestamp in the following format: DD-MM-YYYY hh_mm (in local time, related to the timestamp set up in the gateway on the EMS)
  • Column 2: Data value
  • Column 3: Device ID

Example

Timestamp,        Value, MeterID
15-10-2020 00:30, 1.456, 10th Floor kWh
15-10-2020 01:00, 2.564, 10th Floor kWh

 

Synetica

Available for

  • FTP
  • Email

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Values separated by commas.
  • CSV file.

The format of the CSV:

  • Row 1: Headers
    • Column 3-X: Device ID (as many as columns there are)
  • Row 2-X: Data

From row2 on:

  • Column 1: Timestamp in the following format: DD/MM/YYYY hh:mm:ss (UTC time)
  • Column 2: -
  • Column 3-X: Data value for each device

Example

UTCTimeStamp,         LocalTimeStamp,      device1, device2, device3
21/05/2020 11:30:00, 21/05/2020 12:30:00, 4250, 212.23, 12.4


Trend v1

Available for

  • FTP
  • Email

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Values separated by commas.
  • CSV file.

The format of the CSV:

  • Column 1: Timestamp in the following format: DD/MM/YYYY hh:mm (UTC time)
  • Column 2: Part of the device ID
  • Column 3: Data value
  • Column 4:Part of the device ID

The device ID is composed like: [Column 4]-[Column 2]

Example

UTCTimeStamp,     Asset_ID,                   Value,   DeviceID
06/04/2020 13:15, 21_11_S1_Real Energy Total, 27363.9, Meter 51

In this example, the device ID would be: Meter 51-21_11_S1_Real Energy Total.

 

Trend v2

Available for

  • FTP

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Values separated by tabs.
  • CSV file.

The format of the CSV:

  • Column 1: Device ID
  • Column 2: Timestamp in the following format: YYYY-MM-DD hh:mm:ss (UTC time)
  • Column 3:  Data value

Example 

LabelsFromController   UTCTimeStamp          value
1stFlrTop     2020-04-03 12:45:00   84707
1stFlrTop    2020-04-03 13:00:00   84707
1stFlrTop     2020-04-03 13:15:00   84707
1stFlrTop    2020-04-03 13:30:00   84708

  

UNIWIN32

Available for

  • FTP

Available parameters

301 - Temperature

Format type

  • .ASC file.

This parser process SIEMENS Temperature probes DATA coming in files with the following structure:

  • Row 1: Number of devices the file has data from.
  • Row 2: -
  • Rows 3-X (where X is the last device): Devices IDs.
  • Row X+1 - X+7: -

From row X+8 on (separated by commas):

  • Column 1: -
  • Column 2: Timestamp in the following format: DD-MM-YYYY hh:mm:ss (parser takes the timezone from the gateway setup in the EMS).
  • Column 3-X:  Data values. Each column is the value of a different device, sorted by the order in the Rows 3-X.

Example

5
Histórico             : HISTO_PL02_DEXMA
Elemento     1        : C-201 Temperatura
Elemento     2        : C-202 Temperatura
Elemento     3        : C-203 Temperatura
Elemento     4        : C-204 Temperatura
Elemento     5        : C-205 Temperatura
Tiempo de muestreo    : 00:15:00
Intervalo muestreo    : 30/09/2014 0:07:30 --- 30/09/2014 23:52:30
Número de muestras    : 96
Estado actual         : ACTIVO    
Valor máximo          :   22.8    24.1    20.6    40.7    24.1  
Valor mínimo          :   22.3    23.0    19.9    40.7    23.4  
Valor medio           :   22.4    23.4    20.3    40.7    23.7  
                       ,,,°C,°C,°C,°C,°C
1,30/09/2020 0:15:30, 22.8, 23.6, 20.5, 40.7, 24.0
2,30/09/2020 0:30:30, 22.8, 23.6, 20.5, 40.7, 24.0
3,30/09/2020 0:45:30, 22.8, 23.6, 20.5, 40.7, 24.0
4,30/09/2020 0:00:30, 22.8, 23.6, 20.5, 40.7, 24.0

In this example, the file contains data from 5 temperature devices. For this reason, from the row where the data starts, there are 5 columns of data values. Column 1 contains data from the first device; column 2 contains data from the 2nd device... and so on.

 

WIT-DSET

Available for

  • FTP

Available parameters

  • 802 - Thermal Energy (heating)
  • 810 - Thermal Energy (cooling)
  • 806 - Outlet Temperature
  • 805 - Inlet Temperature
  • 804 - Mass flow
  • 801 - Thermal Power (heating)
  • 419 - Gas Volume
  • 402 - Active Energy
  • 401 - Active Power
  • 812 - Load factor
  • 161 - Time of use
  • 501 - Digital Binary Input 

Format type

  • .xml format

The format of the .xml:

  • tagdset: includes the information of 1 device at 1 timestamp
  • id: device ID
  • var: parameter; the parser recognises:
    • "TENERGYMWH": 802 in the EMS, divided by 1000
    • "TENERGYCMWH": 810 in the EMS, divided by 1000
    • "OUTTEMP": 806 in the EMS
    • "INTEMP": 805 in the EMS
    • "TPOWER": 801 in the EMS
    • "MASSFLOW": 804 in the EMS
    • "TENERGY": 802 in the EMS
    • "GASVOLUME": 419 in the EMS
    • "EAENERGY": 402 in the EMS
    • "EAPOWERKW": 401 in the EMS, divided by 1000
    • "LOADFACTOR": 812 in the EMS
    • "TENERGYC": 810 in the EMS
    • "TOU": 161 in the EMS
    • "IO": 501 in the EMS
  • time: timestamp in the following format: YYYYMMDDhhmm (UTC time)
  • value: data value

Example

<dset>
<tagdset id="WT1015-1" var="TENERGYCMWH" time="201504201115" value="1749.1"/>
<tagdset id="WT1015-1" var="OUTTEMP" time="201504201115" value="9.05"/>
<tagdset id="WT1015-1" var="INTEMP" time="201504201115" value="9.74"/>
<tagdset id="WT1015-1" var="TPOWER" time="201504201115" value="37"/>
<tagdset id="WT1015-1" var="MASSFLOW" time="201504201115" value="47.37"/>
<tagdset id="WT1015-2" var="GASVOLUME" time="201504201115" value="191882.1"/>
<tagdset id="WT1015-3" var="GASVOLUME" time="201504201115" value="254632"/>
<tagdset id="WT1015-4" var="TENERGYMWH" time="201504201115" value="0"/>
<tagdset id="WT1015-4" var="OUTTEMP" time="201504201115" value="90.02"/>
<tagdset id="WT1015-4" var="INTEMP" time="201504201115" value="61.13"/>
</dset> 

 

WONDERWARE

Available for

  • FTP

Available parameters

503 - Generic Value

All the values are inserted using the 503 parameter ID. Then, each of them has to be derived to the corresponding parameter in the EMS.

Format type

  • Values separated by semicolons.
  • CSV file.

The format of the CSV:

  • Row 1: Definition of each column.
    • Columns 2-X: Devices ID
  • Row 2-X: Data

From row 2 on:

  • Column 1: Timestamp in the following format: DD/MM/YYYY hh:mm:ss.
  • Column 2-X: Data values for each device.

Example

FECHA HORA;          VAP_CT-01_CNT;   VAP_CT-02_CNT;  VAP_CT-03_CNT
18/10/2020 0:00:00;  985789.1;        278382.5;       8171.1
18/10/2020 1:00:00;  987133.9;        278491.6;       8175.9
18/10/2020 2:00:00;  988619.3;        278602.1;       8186.1
18/10/2020 3:00:00;  990061.7;        278708.3;       8191.5
18/10/2020 4:00:00;  991509.4;        278816.7;       8194.5
18/10/2020 5:00:00;  993070.4;        278934.9;       8197.5
18/10/2020 6:00:00;  994572.3;        279052.8;       8202.3
18/10/2020 7:00:00;  995975.4;        279167.3;       8204.7
18/10/2020 8:00:00;  997378.9;        279285.1;       8213.7

 

Was this article helpful?