Format de fichier disponibles (Parsers) - FTP, SFTP and Email

Irene Šimić

9 octobre 2024 15:18

Exemple

Dans cet article, vous allez apprendre à propos de tous les analyseurs disponibles pour les passerelles FTP, SFTP (externe) et les passerelles de messagerie.

Formats de fichiers FTP
Formats de fichiers SFTP
Formats de fichiers email
Liste complète des formats de fichiers disponibles

Formats de fichiers FTP

La plateforme EMS vous permet d'utiliser librement son serveur FTP pour importer des données. Pour l'utiliser, vérifiez ce qu'est une passerelle FTP et comment la créer.

Les fichiers envoyés via FTP ont une limite de taille de 15 Mo.

Voici la liste des formats disponibles pour FTP :

ADM-SMS_gas_ft3*100
ADM-SMS_gas_ft3
ADM-SMS_gas_m3
ADM-SMS_water_m3 (15min)
Aqualogy
Capfile PME PMI
Carlo Gavazzi Sx2WEB24
Carlo Gavazzi VMU-C
Carlo Gavazzi UWP
Continuum (OPTIMISED)
DEXMA Default CSV format
DEXMA Default 30min shifted
Edison
Elcomponent (Smappee)
Elcomponent SG-GSM/LAN-i
Enerdis
Fleetsolve - Wipulse
Fluvius
HH Read Data
Huawei - FusionSolar - SmartLogger
HWM RT:Wi5
ICE - FTP
ICF-STRUXTUREWARE
ND Meter
Nelissen
QH Read Data
Roquetude
Satel DL
Schneider COMX510 / PASS800
Schneider StruxtureWare
Sedical
SenseLogix
Sistrol
Sistrol (Active Energy)
Sistrol (Indexed)
S-Monitor (SCADA & HMI)
SOLARLOG
SOLARLOG v2
STARK cumulative
STARK instantaneous
Synapsis SIP
Synetica
Telefonica
Trend v1
TREND V2
Tridium JACE 8000
UNED
UNIWIN32
Veolia
Water Fiscal Meter
WIT-DSET
WONDERWARE

Si vous souhaitez envoyer des données via FTP en utilisant un format de fichier différent, contactez-nous à support.energy@spacewell.com.

Formats de fichiers SFTP

La plateforme EMS vous permet d'utiliser librement son serveur SFTP pour importer des données. Pour l'utiliser, vérifiez ce qu'est une passerelle SFTP et comment la créer.

Les fichiers envoyés via FTP ont une limite de taille de 15 Mo.

Voici la liste des formats disponibles pour SFTP :

ADM-SMS_gas_ft3*100
ADM-SMS_gas_m3
ADM-SMS_water_m3
DEXMA Default CSV format
DEXMA Default 30min shifted
Encon FF
Huawei - FusionSolar - SmartLogger
Sistrol
Sistrol (Active Energy)
Sistrol (Indexed)
Tridium JACE 8000

Si vous souhaitez envoyer des données via SFTP en utilisant un format de fichier différent, contactez-nous à support.energy@spacewell.com.

Formats de fichiers email

La plateforme EMS vous permet d'envoyer des données par email, en les stockant sur un serveur EMS. Pour l'utiliser, vérifiez ce qu'est une passerelle d'email et comment la créer.

Voici la liste des formats disponibles pour les e-mails :

Carlo Gavazzi Sx2WEB24
DataHub
Desigo
DEXMA Default CSV format
Elcomponent SG-GSM/LAN-i
Energinord
HWM RT:Wi5
ICE - EMAIL
KS_KPI
Metropol
Nelissen
NeOSS Controller
Pure World - 1Life
Pure World - Carbon
Pure World - Jace
Pure World - Parkwood
Pure World - PL Exporter
Roquetude
RoquetudeFuel
Selby
SSE BEC Excel
STARK cumulative
STARK instantaneous
Synetica
Trend v1
UNED

Si vous souhaitez envoyer des données par email en utilisant un format de fichier différent, contactez-nous à support.energy@spacewell.com.

Liste complète des formats de fichiers disponibles

REMARQUE : Veuillez suivre la mise en forme exacte de l'un des types de fichiers suivants utilisés pour insérer des données dans la plateforme (horodatage exact, fuseau horaire valide, etc.).

Les formats inclus dans cet article sont les suivants :

Aqualogy

Parser spécifique pour comprendre les données envoyées par une passerelle Aqualogy.

Disponible pour

Paramètres disponibles

901 - Volume d'eau

Type de format

Les valeurs doivent être séparées par des points-virgules.
Le nom de chaque fichier envoyé doit être unique.
Toutes les valeurs sont insérées comme volume d'eau en utilisant le paramètre 901.
Toutes les valeurs sont divisées par 1000 (pour convertir en litres d'eau)
Fichier CSV

Le format du fichier CSV :

Colonne 1-2: -
Colonne 3: Nom du dispositif (DeviceID).
Colonne 4 : Horodatage dans le format suivant : DD/MM/YYYY hh:mm:ss (heure local)
Colonne 5: Valeur

Exemple

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

Disponible pour

Paramètres disponibles

45271 - Produced Active Energy
40271 - Active Energy

Type de format

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: -

Exemple

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

Disponible pour

Paramètres disponibles

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)

Type de format

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' }

Exemple

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

Carlo Gavazzi VMU-C

Disponible pour

FTP avec passerelle Carlo Gavazzi VMU-C EM.

Paramètres disponibles

402 - Énergie active
452 - Énergie active produite
405 - Tension active
434 - Tension L-L
406 - Courant actif
401 - Puissance active
403 - Puissance réactive inductive
409 - Puissance apparente
412 - Facteur de puissance
414 - Fréquence
423 - Distorsion du courant (THD-distorsion harmonique totale)
422 - Distorsion de la tension (THD-distorsion harmonique totale)
404 - Énergie réactive inductive
454 - Puissance réactive inductive produite
408 - Énergie réactive capacitive
502 - Compteur d'impulsions
413 - Courant neutre
410 - Énergie apparente

Type de format

Les valeurs doivent être séparées par des virgules.
Fichier CSV

Le format du CSV :

Ligne 1 : -
Ligne 2-X :
- Column 1 : elle indique le type de compteur.
  - AC
  - DC
- Colonne 2-3 : -
- Colonne 4 : Nom du dispositif.
  - Le dispositif créé aura le nom : 'colonne 4' + '' + 'colonne 1'
- Colonne 5-7 : -
- Colonne 8 : horodatage au format ISO 8601.
- Colonne 9-X : ces colonnes contiennent les relevés en fonction du type de compteur.
  - Compteur DC : il contiendra 4 colonnes supplémentaires avec ces paramètres :
    
    [402, 405, 406, 401]
  - Compteur AC : il contiendra jusqu'à 68 colonnes supplémentaires qui seront considérées comme les paramètres suivants dans l'ordre suivant :
    
    [402, 452, 405, '405-a', '405-b', '405-c', 434, '434-a', '434-b', '434-c', '406-a', '406-b',
    
    '406-c', 401, '401-a', '401-b', '401-c', 403, '403-a', '403-b', '403-c', 409, '409-a',
    
    '409-b', '409-c', 412, '412-a', '412-b', '412-c', '', 414, '423-a', '423-b', '423-c', '422-a',
    
    '422-b', '422-c', '', '', 404, 454, 408, '', '502-a', '502-b', '502-c', '402-a', '402-b', '402-c', 413,
    
    '', 406, '404-a', '404-b', '404-c', '454-a', '454-b', '454-c', '452-a', '452-b', '452-c',
    
    410, '410-a', '410-b', '410-c', '', '', '']
    - Note : les paramètres contenant les lettres a, b ou c seront des paramètres se référant aux Phases A, B et C, et seront insérés dans différents appareils, un se référant à chaque phase. Par exemple, le '405-a' sera un paramètre inséré dans l'appareil 'colonne 4' + '' + 'colonne 1' + '_' + 'a'

Exemple

OK
AC;SUN2000-60KTL-M0--VLN;;INVERSOR.1_AC;2;1;1708938900;2024-02-26T10:15:00+01:00;;1.0700;;229.9;231.3;228.7;;399.9;398.9;396.4;0.845;0.854;0.860;0.5807;;;;0.0000;;;;;;;;1.000;;;;;50.0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
AC;SUN2000-60KTL-M0--VLN;;INVERSOR.1_AC;2;1;1708939800;2024-02-26T10:30:00+01:00;;1.2800;;231.1;232.5;229.8;;402.0;400.8;398.4;1.190;1.196;1.203;0.8244;;;;-0.0001;;;;;;;;1.000;;;;;50.0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
AC;SUN2000-60KTL-M0--VLN;;INVERSOR.1_AC;2;1;1708940700;2024-02-26T10:45:00+01:00;;2.1100;;231.2;233.5;230.4;;403.0;402.4;398.8;4.763;4.753;4.765;3.3329;;;;0.0001;;;;;;;;1.000;;;;;50.0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
AC;SUN2000-60KTL-M0--VLN;;INVERSOR.1_AC;2;1;1708941600;2024-02-26T11:00:00+01:00;;3.2200;;231.1;233.6;230.7;;402.9;402.8;398.8;6.416;6.400;6.414;4.4473;;;;0.0001;;;;;;;;1.000;;;;;49.9;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Note : d'après cet exemple, les 4 dispositifs suivants seront créés :
- INVERSOR.1_AC_AC
- INVERSOR.1_AC_AC_a
- INVERSOR.1_AC_AC_b
- INVERSOR.1_AC_AC_c

Continuum (OPTIMISED)

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

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

Disponible pour

Paramètres disponibles

402 - Active Energy
419 - Gas Volume

Type de format

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: EXAMPLE 
 
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.

Disponible pour

Email
FTP
SFTP

Paramètres disponibles

Tous les paramètres. Trouvez la liste complete ici.

Type de format

Values must be separated by semicolons.
The name of each file sent must be unique.
Decimals must be separated by dot.
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: Reading or Consumption. It can have decimals with point (.) as decimal separation.

Example 1 - Value: Reading

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 time the reading was taken. The consumption is calculated and assigned at the beggining of the consumption period.

So, the consumption value for device General at 08:00:00 will be:

[reading for General device at 08:00:00] - [reading for Genreal Device at 08:15:00] = 200-100 = 100 kWh

Example 2 - Value: Consumption

Europe/Madrid;2020/07/01 00:00:00;Device;40241;100.64
Europe/Madrid;2020/08/01 00:15:00;Device;40241;100
Europe/Madrid;2020/09/01 00:30:00;Device;40241;300.5
Europe/Madrid;2020/10/01 00:45:00;Device;40241;250

Timestamp corresponds to the beginning of the consumption period. This means that, for example, value 100.64 of device Device with timestamp 2020/07/01 00:00:00 represents the consumption for July 2022.

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.10
Europe/Madrid;2020/10/28 03:00:00;device_1;40211;100.6

Troubleshooting:

Make sure there are no spaces when writing the timezone
There can be only one TimeZone in each file. If you want to upload data from devices in different time zones, you have to do it in two separated files.
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.

Disponible pour

FTP
SFTP

Paramètres disponibles

Tous les paramètres. Trouvez la liste complete ici.

Type de format

Values must be separated by semicolons.
The name of each file sent must be unique.
Decimals must be separated by dot.
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 (Smappee)

Disponible pour

Paramètres disponibles

402 - Active Energy
404 - Reactive Energy
502 - Pulse counter

Type de format

Values must be separated by Semicolon ";".
The values are discrete.
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: device name
Column 3: Units.
- If unit is 402, the parameter is 40201
- If unit is "kWh", the parameter is 40201
- If unit is "kVArh", the parameter is 40401
- If unit is "", the parameter is 502.
Column 4: Date in the following format: DD/MM/YY
Column 5: Time in the following format: hh:mm (local time related to the Timezone in the gateway, not UTC)
Column 6: Data value

Example

"DeviceID";"DeviceName";"Units";"Date";"Time";"Value"
5120000004;Main incomer;kWh;21/4/21;0:00;7.5668
5120000004;Main incomer;kVArh;21/4/21;0:00;-2.0228
5120000004;Sws 1-4;kWh;21/4/21;0:00;1.5938
5120000004;Sws 1-4;kVArh;21/4/21;0:00;-0.7425
5120000004;Sws 1-5;kWh;21/4/21;0:00;0.0787
5120000004;Sws 1-5;kVArh;21/4/21;0:00;-0.0072
5120000004;Main incomer;kWh;21/4/21;0:15;7.5775
5120000004;Main incomer;kVArh;21/4/21;0:15;-1.8454

Fleetsolve - Wipulse

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

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.

Fluvius AMR

If you are monitoring buildings in Belgium and you have AMR measurement devices from Fluvius for electricity and gas accounting, you will probably be interested in this.

Requirement

Request Fluvius to upload EXPORT91 and EXPORT93 files: daily and monthly csv files with all your quarter hourly consumption.

Remember to configure the General Gateway in DEXMA, select the Fluvius option as parser and give Fluvius this gateway's credentials for them to hang the files there.

More information in Fluvius' documentation NPS-exportcatalog_impact MIG 6_v4.pdf

Disponible pour

Paramètres disponibles

40201 - Discrete 15min Active Energy
40201 - Discrete 15min Active Energy
40401 - Discrete 15min Inductive Reactive Energy
40801 - Discrete 15min Capacitive Reactive Energy
45201 - Discrete 15min Produced Active Energy
45401 - Discrete 15min Inductive Reactive Energy
45801 - Discrete 15min Capacitive Reactive Energy

Type de format

Values must be separated by semicolon.
CSV file

The format of the CSV:

Row 1-17: Different informations. It is not used in the parser, but needs to be there. Format and values like in the example below
- Only the second EXPORTXX field of the first row is used to filter by file type. EXPORT91 and EXPORT93 formats can be read. EXPORT92, EXPORT94, EXPORT95 and EXPORT96 are NOT readable.

From Row 18: Actual Data. Each line is a full day of data each 15 minutes.

Position 1: Day at 00:00 that data from that row starts
Position 2: Day at 00:00 that data from that row ends
Position 3: Device key
Position 4:empty
Position 5: Parameter classification (B31=A, B30=I, B29=C)

Position 6: Parameter

In the CSV file		In the platform (dividing by 4)
A+	Active Power	40201	Active Energy
C-	Capacitive Reactive Power	40801	Capacitive Reactive Energy
I+	Inductive Reactive Power	40401	Inducitive Reactive Energy
A-	Produced Active Power	45201	Produced Active Energy
C+	Produced Capacitive Reactive Power	45801	Produced Capacitive Reactive Energy
I-	Produced Inductive Reactive Power	45401	Produced Inducitive Reactive Energy

*Produced=exported

Position 7: Indication od the measured direction from the net. If the parameter is consumption (E12-E17) or production/injection (E12-E18).
Position 8: Units where KWT=kW and KVR=kVar
Position 9:
Position 10-105: 96 values (24h * 4 15-min period/hour)
- These values will be devided by 4 to transform them from power to electric consumption/production
Last positions:
- Position 106-109: 0
- Position 110-205: DA if parameter is A, D otherwise (96 values)
- Position 206-209: H
- Position 210: 15
- Position 211: Text description of the source

Example

The CSV file inserted in the FTP server:

[Subject];EXPORT93;MIGv3.03;9;3.0;
[Time zone];+0100;
[Created on];06122022;02:33;
[Market];23;
[To];9920000063113;
[From];5499757493404;
[MS];;
[File ID];I_1111111111;
[Contract Id];111111111111;
[Name];FARYS;
[Address];Street;1;08000;Barcelona;
[Phone];1111111111;
[Fax];;
[Email];fm.beheer@farys.be;
[V.A.T.];111111111;
[H.R.];;
[Body Start]
01112022 00:00;02112022 00:00;key_device_1;;B31;A+;E12-E17;KWT;E23;11,16;27,90;10,11;0,56;3,48;27,90;27,80;5,08;0,56;0,51;21,72;25,59;0,56;0,51;0,56;0,51;0,56;0,56;0,51;0,56;0,56;0,51;0,56;0,51;0,56;0,56;0,51;0,56;0,56;0,56;0,51;0,36;0,21;0,21;0,21;0,21;1,32;22,77;20,31;10,01;5,03;3,23;7,70;18,40;3,12;1,57;21,87;21,72;19,31;16,24;18,35;18,55;18,90;23,78;22,62;32,32;37,45;48,25;48,35;47,55;20,91;36,84;50,16;39;45,38;56,04;38,70;47,80;44,53;28,95;28,90;29;29,10;29;29,05;29,05;29;29,05;29;29,05;28,95;29;29;28,95;28,85;28,95;28,90;28,85;28,85;28,80;28,85;28,80;28,70;14,93;0,56;27,60;0;0;0;0;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
01112022 00:00;02112022 00:00;key_device_1;;B29;C-;E12-E17;KVR;E23;0,05;0;0,05;0,10;0,10;0;0;0,10;0,10;0,10;0;0;0,15;0,10;0,10;0,10;0,10;0,10;0,10;0,10;0,10;0,10;0,10;0,10;0,10;0,15;0,10;0,10;0,10;0,10;0,10;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0,05;0,10;0;0;0;0;0;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
01112022 00:00;02112022 00:00;key_device_1;;B30;I+;E12-E17;KVR;E23;3,53;6,40;3,28;1,58;2,13;6,40;6,30;2,38;1,58;1,58;5,29;5,95;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,88;1,58;1,58;1,58;1,58;1,98;7,86;7,86;7,81;6,75;7,35;5,54;9,77;4,04;2,28;12,93;12,83;12,93;12,88;12,88;12,93;12,88;12,93;12,93;12,93;12,98;13,03;12,98;12,98;10,52;11,73;13,58;10,72;11,57;13,33;10,32;11,07;9,62;6,85;6,85;6,85;6,85;6,85;6,85;6,90;6,85;6,90;6,85;6,85;6,90;6,85;6,85;6,90;6,85;6,85;6,75;6,75;6,75;6,75;6,75;6,70;6,75;4,24;1,58;7;0;0;0;0;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
01112022 00:00;02112022 00:00;key_device_2;;B31;A-;E12-E18;KWT;E23;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
01112022 00:00;02112022 00:00;key_device_2;;B29;C+;E12-E18;KVR;E23;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
01112022 00:00;02112022 00:00;key_device_2;;B30;I-;E12-E18;KVR;E23;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
02112022 00:00;03112022 00:00;key_device_1;;B31;A+;E12-E17;KWT;E23;29,05;5,69;0,56;0,51;0,56;3,53;28;15,99;0,56;0,56;0,51;0,56;0,51;0,56;0,56;0,51;0,56;0,56;0,51;0,56;0,56;0,51;0,56;0,56;0,51;0,56;0,56;0,51;0,56;0,56;0,56;14,58;27,04;7,50;0,21;0,21;0,21;0,21;10,11;10,56;6,99;3,53;9,91;23,83;3,63;39,61;24,73;22,32;24,53;20,71;23,73;34,93;46,19;27,40;23,53;20,31;25,18;27,80;32,27;36,24;40,46;44,58;28,35;32,27;43,07;24,08;25,94;26,99;27,70;27,75;27,65;27,70;27,55;0,56;1,77;29,10;29;28,90;28,95;29;28,90;28,95;29,05;29;28,95;28,95;29,05;29;28,95;28,95;28,95;28,95;28,90;29;28,95;29;0;0;0;0;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
02112022 00:00;03112022 00:00;key_device_1;;B29;C-;E12-E17;KVR;E23;0;0,10;0,10;0,10;0,10;0,10;0;0,05;0,10;0,10;0,10;0,15;0,10;0,10;0,10;0,10;0,10;0,10;0,10;0,15;0,10;0,10;0,10;0,10;0,10;0,15;0,10;0,10;0,10;0,10;0,05;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0,10;0,10;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
02112022 00:00;03112022 00:00;key_device_1;;B30;I+;E12-E17;KVR;E23;7,25;2,58;1,58;1,58;1,58;2,18;6,40;4,29;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,58;1,63;5,19;7,81;3,33;1,58;1,58;1,58;1,58;6,55;8,61;8,56;8,61;9,82;12,63;3,18;12,98;12,98;12,88;13,08;13,03;13,03;15,34;15,39;13,08;12,98;12,98;12,98;13,03;12,98;13,03;13,08;12,98;9,46;10,02;11,52;7,66;7,71;7,66;7;6,25;6,20;6,25;6,20;1,58;1,88;6,95;6,95;6,85;6,85;6,85;6,85;6,85;6,80;6,85;6,80;6,85;6,85;6,80;6,75;6,80;6,80;6,80;6,80;6,80;6,80;6,75;0;0;0;0;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
02112022 00:00;03112022 00:00;key_device_2;;B31;A-;E12-E18;KWT;E23;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;DA;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
02112022 00:00;03112022 00:00;key_device_2;;B29;C+;E12-E18;KVR;E23;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;
02112022 00:00;03112022 00:00;key_device_2;;B30;I-;E12-E18;KVR;E23;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;D;H;H;H;H;15;Tussengemeentelijke maatschappij de;;;;;;;

HH Read Data

Disponible pour

Paramètres disponibles

40261 - Discrete 30min Active Energy
41961 - Discrete 30min Gas Volume
42061 - Discrete 30min Gas Energy
45261 - Discrete 30min Produced Active Energy
90161 - Discrete 30min Water Volume

Type de format

Values must be separated by commas.
CSV file
The name of the file indicates which parameter is going to be pointing the parser. The parameter will be one the following depending on how the file name begins, as follows:
- eleckwh_ : 402
- gasm3_ : 419
- gaskwh_ : 420
- waterm3_ : 901
- exportkwh_ : 452
- NOTE: if the file does not have one of the previous beginnings, the parser will point by default the parameter 402.

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

Huawei - FusionSolar - SmartLogger

Disponible pour

FTP
SFTP

Paramètres disponibles

411 - Cos Phi
701 - Device Temperature (ºC)
702 - Inversor photovoltaic Temperature (ºC)
703 - Errors
704 - Status
451 - Produced Active Power (W)
452 - Produced Active Energy (kWh)
453 - Produced Inductive Reactive Power (VAr)
301 - Temperature (ºC)
313 - Wind Speed (km/h)
314 - Wind direction
316 - Solar Radiation Intensity (W/m2)

Type de format

Values must be separated by semicolons.
CSV file

The format of the CSV:

Row 2: Name of the first device
Row 3: Parameter type. The parser recognises:
- WSP: 313 (the value is multiplied by 3,6 to convert it from m/s to km/h)
- WD: 314
- PV Temp.: 701
- Amp Temp.: 301
- Radiation: 316
- Status: 704
- Error: 703
- Temp: 702
- cos: 411
- Pac: 451 (the value is divided by 1000 to convert it from kW to W)
- Qac: 453 (the value is divided by 1000 to convert it from kVar to Var)
- E-Total: 452
Row 4-XX:
- Column 1: Timestamp in the following format: YY-MM-HH hh:mm:ss
- Column 2-XX: Reading values
Row XX+1: Name of the second device.
And so on, following the same format.

Example

#SmartLogger ESN:112233445566
#NAME OF THE FIRST DEVICE 
#Time               WSP  WD  PV Temp.  Amp Temp.  Radiation  Status
22-12-14 15:00:00   0.0  0   30.0      25.4       289.0      45057
22-12-14 15:30:00   0.0  0   29.8      24.4       304.0      45057
22-12-14 16:00:00   0.0  0   30.1      25.0       307.0      45057
#NAME OF THE SECOND DEVICE
#Time               Status  Error  Temp   cos     Pac      Qac   E-Total
22-12-14 15:00:00   512     0      30.3   1.000   31.316   23    456.67
22-12-14 15:30:00   512     0      30.1   1.000   33.071   20    459.32
22-12-14 16:00:00   512     0      30.7   1.000   33.277   -75   462.03
#NAME OF THE THIRD DEVICE
#Time               Status  Error  Temp   cos   Pac      Qac   E-Total
22-12-14 15:00:00   512     0      41.6   998   25.131   34    473.17
22-12-14 15:30:00   512     0      41.4   998   26.420   -17   475.32
22-12-14 16:00:00   512     0      41.7   998   27.085   -59   478.02

For more information regarding the Huawei SmartLogger configuration you can have a look on this article.

HWM RT:Wi5

Disponible pour

Paramètres disponibles

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

Type de format

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

Disponible pour

Paramètres disponibles

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

Type de format

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;

ND Meter

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

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.

QH Read Data

Disponible pour

Paramètres disponibles

40201 - Discrete 15min Active Energy
41901 - Discrete 15min Gas Volume
42001 - Discrete 15min Gas Energy
45201 - Discrete 15min Produced Active Energy
90101 - Discrete 15min Water Volume

Type de format

Values must be separated by commas.
CSV file
The name of the file indicates which parameter is going to be pointing the parser. The parameter will be one the following depending on how the file name begins, as follows:
- eleckwh_ : 402
- gasm3_ : 419
- gaskwh_ : 420
- waterm3_ : 901
- exportkwh_ : 452
- NOTE: if the file does not have one of the previous beginnings, the parser will point by default the parameter 402.NOTE: if the file does not have one of the previous beginnings, the parser will point by default the parameter 402.

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:15 represent consumption between 00:00 and 00:15, 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:15,0,1934,0
mtr/2376551956116_41060652,2020/03/12 00:30,0,1972,0
mtr/2376551956116_41060652,2020/03/12 00:45,0,1908,0
mtr/2376551956116_41060652,2020/03/12 01:00,0,1941,0
mtr/2376551956116_41060652,2020/03/12 01:15,0,1964,0
mtr/2376551956116_41060652,2020/03/12 01:30,0,1931,0
mtr/2376551956116_41060652,2020/03/12 01:45,0,1909,0

Roquetude

Disponible pour

Paramètres disponibles

Tous les paramètres. Trouvez la liste complete ici.

Type de format

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

Disponible pour

Paramètres disponibles

Tous les paramètres. Trouvez la liste complete ici.

Type de format

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 consumed)
  - ERInd imp (kvarh): corresponds to 40401 (quarter-hourly inductive reactive energy consumed)
  - ERCap imp (kvarh): corresponds to 40801 (quarter-hourly capacitive reactive energy consumed)
  - EAct exp (kWh): corresponds to 45201 (quarter-hourly active energy exported)
  - ERInd exp (kvarh): corresponds to 45401 (quarter-hourly inductive reactive energy exported)
  - ERCap exp (kvarh): corresponds to 45801 (quarter-hourly capacitive reactive energy exported)
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 / PASS800

Disponible pour

FTP, SFTP, FTPS

Paramètres disponibles

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

402 - Active Energy
401 - Active Power
403 - Reactive Power
404 - Reactive Energy
405 - Voltage
406 - Current
409 - Apparent power
412 - Power factor
413 - Neutral current
414 - Frequency
301 - Temperature ºC
302 - Humidity
303 - Light
307 - Air Quality (CO2)
312 - Dew Point
419 - Gas volume
432 - Diesel Fuel volume
434 - Voltage L-L
435 - Compressed air volume
436 - Compressed air massflow
452 - Active energy received
454 - Reactive energy received
503 - Generic Value
504 - Generic Volume
801 - Thermal Power (heating)
802 - Thermal Energy (heating)
804 - Mass flow
805 - Inlet Temperature
806 - Outlet Temperature
810 - Cooling Energy
851 - Gas flow rate
901 - Water volume
902 - Water flow
131 - Production

Type de format

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

Note: Gateway Name can be also related with Schneider PAS800.

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, ''],

'Active power A (W)': [401, 1, 'A'],

'Active power B (W)': [401, 1, 'B'],

'Active power C (W)': [401, 1, 'C'],

'Reactive power (VAr)': [403, 1, ''],

'Reactive power A ': [403, 1, 'A'],

'Reactive power B ': [403, 1, 'B'],

'Reactive power C ': [403, 1, 'C'],

'Active energy delivered (Wh)': [402, 1000, ''],

'Reactive energy (VArh)': [404, 1000, ''],

'Gasoil (l)': [432, 1000, ''],

'Temperatura (º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'],

'Active energy received (Wh)': [452, 1000, 'Entry'],

'Reactive energy received (VArh)': [454, 1000, 'Entry'],

'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, ''],

'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'],

'Current N (A)': [406, 1, ''],

'Voltage A-N (V)': [405, 1, 'A'],

'Voltage B-N (V)': [405, 1, 'B'],

'Voltage C-N (V)': [405, 1, 'C'],

'Voltage A-B (V)': [434, 1, 'A'],

'Voltage B-C (V)': [434, 1, 'B'],

'Voltage C-A (V)': [434, 1, 'C'],

'Power Factor ()': [412, 1, ''],

'Apparent power (VA)': [409, 1, ''],

'Temperature (°C)': [301, 1, ''],

'Compressed air massflow (m3/h)': [436, 1, 'm3/h'],

'Flujo de aire comprimido (m3/h)': [436, 1, 'm3/h'],

'Compressed air volume (m3)': [435, 1, 'm3'],

'Volumen de aire comprimido (m3)': [435, 1, 'm3'],

'Dew Point': [312, 1, ''],

'Punto de rocio': [312, 1, ''],

'Generic volume (m3)': [504, 1, 'm3'],

'Volumen generico (m3)': [504, 1, 'm3'],

'Mass flow (m3/h)': [804, 1, 'm3/h'],

'Flujo masico (m3/h)': [804, 1, 'm3/h'],

'HeatEnergy (kWh)': [802, 1, ''],

'HeatEnergy (MWh)': [802, 0.001, ''],

'TVOC': [342, 1, ''],

'RmsFrequency (Hz)': [414, 1, ''],

'RmsVoltagePhsAB (V)': [434, 1, 'A'],

'RmsVoltagePhsAN (V)': [405, 1, 'A'],

'RmsVoltagePhsBC (V)': [434, 1, 'B'],

'RmsVoltagePhsBN (V)': [405, 1, 'B'],

'RmsVoltagePhsCA (V)': [434, 1, 'C'],

'RmsVoltagePhsCN (V)': [405, 1, 'C'],

'AverageRmsVoltagePhsToPhs (V)': [434, 1, ''],

'AverageRmsVoltagePhsToNeut (V)': [405, 1, ''],

'TotalDeliveredActiveEnergy (Wh)': [402, 1000, ''],

'TotalRmsActivePower (W)': [401, 1, ''],

'HeatEnergyE1 (MWh)': [802, 0.001, ''],

'CoolingEnergyE3 (MWh)': [810, 0.001, ''],

'RmsCurrentPhsA (A)': [406, 1, 'A'],

'RmsCurrentPhsB (A)': [406, 1, 'B'],

'RmsCurrentPhsC (A)': [406, 1, 'C'],

'AverageRmsCurrent (A)': [406, 1, ''],

'RmsActivePowerPhsA (W)': [401, 1, 'A'],

'RmsActivePowerPhsB (W)': [401, 1, 'B'],

'RmsActivePowerPhsC (W)': [401, 1, 'C'],

'TotalRmsApparentPower (VA)': [409, 1, ''],

'TotalRmsPowerFactor': [412, 1, ''],

'TotalDeliveredReactiveEnergy (VArh)': [404, 1000, ''],

'GasFlowRate (m³/s)': [851, 1/3600, ''],

'GasVolume (m³)': [419, 1, ''],

'Water Volume (m³)': [901, 1, ''],

'Water Volume Flow Rate (m³/s)': [902, 1/3600, ''],

'Water Volume Flow Rate (m³/h)': [902, 1, ''],

'TotalRmsReactivePower (VAr)': [403, 1, ''],

'RmsCurrentNeut (A)': [413, 1, ''],

'RmsReactivePowerPhsA (VAr)': [403, 1, 'A'],

'RmsReactivePowerPhsB (VAr)': [403, 1, 'B'],

'RmsReactivePowerPhsC (VAr)': [403, 1, 'C'],

'RmsApparentPowerPhsA (VA)': [409, 1, 'A'],

'RmsApparentPowerPhsB (VA)': [409, 1, 'B'],

'RmsApparentPowerPhsC (VA)': [409, 1, 'C'],

'Heat energy (Wh)': [802, 1000, '']

Schneider StruxtureWare

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

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

Disponible pour

Paramètres disponibles

419 - Gas Volume
402 - Active Energy

Type de format

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)

Disponible pour

Paramètres disponibles

Tous les paramètres. Trouvez la liste complete ici.

Type de format

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

Disponible pour

Paramètres disponibles

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

Type de format

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.

STARK instantaneous

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

Values separated by commas.
CSV file

The format of the CSV:

Row 1: File name.
Row 2: Date of the last reading in the file.
Row 3: Report generation date.
Row 6: Number of meters in the file.
Rows 8 and 9:
- Column 5: Device ID.
- Column 6: Units.
- Column 7: Date.
- Columns 8 and beyond: Timestamp and values.
Row 11: Time zone.

Example

Meter Sequential - 1 Day - CSV Data Export - Gas
Report Date,              20/11/22 00:00:00
Report Run Date,          20/11/22 09:15:00
Company Name,             Stark Company
Reporting Set,            Gas - M01010101 - 3073503
Meters in Reporting Set,  1

Company Name,             Site Name,    Online Meter Name,           MPRN,     Meter ID,  Units, Date,     00:30, 01:00, 01:30, 02:00, 02:30, 03:00
Stark Company,            "Invernalia", "Gas - M01010101 - 3073503", 30763503, M01010101, kWh,   19/11/22, 0.000, 1.380, 1.390, 1.490, 1.530, 1.620

Report Time Zone: (UTC+00:00) Dublin, Edinburgh, Lisbon, London (With Daylight Saving)

Synapsis SIP

Disponible pour

Paramètres disponibles

40261 - Half hourly discretized Active Energy

Type de format

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

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

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

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

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

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

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

Tridium JACE 8000

Disponible pour

FTP
SFTP

Paramètres disponibles

Tous les paramètres. Trouvez la liste complete ici.

Type de format

CSV comma-separated

This parser processes information from JACE devices, following this format:

Column 1: Timestamp. Format: DD-<month>-YY HH:MM:SS <AM/PM> <Timezone>.
- Example: 01-Dec-20 4:30:00 AM GMT
Column 2 to the end of the file: Consumption values. Each column will refer to one meter/device only. These columns will be organised as follows:
- First row = Data header: <device name> + '_' + <parameter in the platform>.
  - Example: Main meter_402. Note that the headers will have to be configured manually in the devices. For more information, check this article.
  - The <device name> will be the key of the device in the platform.
  - The <parameter in the platform> must include the frequency if applies. Example:
    - Cumulative electricity consumption --> Parameter = 402.
    - Discrete quarter-hourly electricity consumption --> Parameter = 40201.
    - For more information, check this article.
- Other rows = Consumption values.
  - Decimal separator: '.'

Example

timestamp,Main meter_402,HVAC_402,Lighting_402,Heating_402,AC_402
01-Dec-20 4:30:00 AM GMT,4930914.6,2549940.8,2240380.8,4193507.2,2276845.2
01-Dec-20 5:00:00 AM GMT,4930929.9,2549951.6,2240401.2,4193507.2,2276861.6
01-Dec-20 5:30:00 AM GMT,4930945.2,2549966.4,2240423.6,4193507.2,2276881.2
01-Dec-20 6:00:00 AM GMT,4930962.2,2549976.8,2240442.4,4193507.2,2276898.4
01-Dec-20 6:30:00 AM GMT,4930977.5,2549982.8,2240458.4,4193507.2,2276914.4
01-Dec-20 7:00:00 AM GMT,4930993.65,2549986.8,2240474.4,4193507.2,2276930.4
01-Dec-20 7:30:00 AM GMT,4931009.8,2549991.2,2240490.8,4193507.2,2276946.8
01-Dec-20 8:00:00 AM GMT,4931034.45,2549998.4,2240508.4,4193507.2,2276966
01-Dec-20 8:30:00 AM GMT,4931059.95,2550006.4,2240526,4193507.2,2276984.8
01-Dec-20 9:00:00 AM GMT,4931078.65,2550010.4,2240542,4193507.2,2277002.8
01-Dec-20 9:30:00 AM GMT,4931097.35,2550014.4,2240558,4193507.2,2277018.4
01-Dec-20 10:00:00 AM GMT,4931114.35,2550018,2240574.4,4193507.2,2277034.4
01-Dec-20 10:30:00 AM GMT,4931132.2,2550022,2240590.4,4193507.2,2277050.4
01-Dec-20 11:00:00 AM GMT,4931150.05,2550026,2240606.4,4193507.2,2277066.4

Check the file JACE 8000.csv.

UNIWIN32

Disponible pour

Paramètres disponibles

301 - Temperature

Type de format

.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

Disponible pour

Paramètres disponibles

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

Type de format

.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

Disponible pour

Paramètres disponibles

503 - Generic Value

Toutes les valeurs sont insérées en utilisant l'ID de paramètre 503. Ensuite, chacune d'entre elles doit être dérivée vers le paramètre correspondant dans l'EMS.

Type de format

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

roquetude.csv
(3 KB)
schneider_stru.csv
(10 KB)
carlo_gavazzi.zip
(1 KB)
synetica.csv
(200 KB)
trend_v1.csv
(40 KB)
fleetsolve.xls
(30 KB)
capFile.xml
(100 KB)
HWM_RT_Wi5.txt
(2 KB)
icf_struxtureware.csv
(647 Bytes)
smonitor.csv
(371 Bytes)
optimised_building.csv
(4 KB)
solarlog.csv
(40 KB)
uniwin-siemens.ASC
(5 KB)
Wit.xml
(2 KB)
elcomponen.csv
(500 KB)
wonderware.csv
(1 KB)
Sedical.csv
(129 Bytes)
trend_v2.csv
(300 KB)
ND_meter.txt
(198 Bytes)
Synapsis.csv
(200 KB)
MAB.csv
(1 KB)
DEXMA_DEFAULT.csv
(2 KB)
HH-ReadData.csv
(2 MB)
Schneider_ComX-510.csv
(681 Bytes)
SatelDL.csv
(561 Bytes)
JACE 8000.csv
(2 KB)
NPS-exportcatalog_impact MIG 6_v4.pdf
(500 KB)

roquetude.csv
(3 ko)
schneider_stru.csv
(10 ko)
carlo_gavazzi.zip
(1 ko)
synetica.csv
(200 ko)
trend_v1.csv
(40 ko)
fleetsolve.xls
(30 ko)
capFile.xml
(100 ko)
HWM_RT_Wi5.txt
(2 ko)
icf_struxtureware.csv
(647 octets)
smonitor.csv
(371 octets)
optimised_building.csv
(4 ko)
solarlog.csv
(40 ko)
uniwin-siemens.ASC
(5 ko)
Wit.xml
(2 ko)
elcomponen.csv
(500 ko)
wonderware.csv
(1 ko)
Sedical.csv
(129 octets)
trend_v2.csv
(300 ko)
ND_meter.txt
(198 octets)
Synapsis.csv
(200 ko)
MAB.csv
(1 ko)
DEXMA_DEFAULT.csv
(2 ko)
HH-ReadData.csv
(2 Mo)
Schneider_ComX-510.csv
(681 octets)
SatelDL.csv
(561 octets)
JACE 8000.csv
(2 ko)
NPS-exportcatalog_impact MIG 6_v4.pdf
(500 ko)