FTP Report Templates

Report template 2001

Report format

This report contains value data in M-Bus raw format used when installation of new meter is completed. This information can be useful to add meters when installation process is completed. This report sends a meter data report file to an FTP server. On execution of this report, one file with all meter values will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_ installreport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00: 0006123456_installreport_20200901010000_2001.csv.

File contents

The file contains rows. Each row contains the origin of the value and the actual value for a specific time.

Table 229. Column header description

Column index (0 = first column)

Column contents

Description

0

<serial-number>

Product serial number

1

<device-identification>

The device (meter) secondary address

2

<created>

The date/time of this value. Format: YYYY-MM-DD hh:mm:ss

3

<value-data-count>

The M-Bus telegram number from which this record is taken

4

<mbus-raw>

M-Bus raw data, starting with M-Bus CField. Stop character and checksum of the M-Bus telegram is excluded.


Example of file contents

00000161;05047168;2009-12-17 00:00:00;00;08147268710405ac484103470000000c1480769604046dba092e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 01:00:00;00;08147268710405ac484103480000000c1480769604046dba0a2e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 02:00:00;00;08147268710405ac484103490000000c1480769604046dba0b2e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 03:00:00;00;08147268710405ac4841034a0000000c1480769604046dba0c2e1a426c 2a194c140000000042ec7e3f1c0fc010010c

Report template 2005

Report format

This report contains event information sent from the product. Example of events are firmware updated and rebooted unexpectedly. On execution of this report, one file with event information is sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_ eventreport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_eventreport_20200901010000_2005.csv.

File contents

The file contains a column header line and key value pairs of information.

Table 230. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed value indicating column information line.

1

key

Fixed value

2

value

Fixed value


Table 231. Value line definition

Column index

(0 = first column)

Column contents

Description

0

<key>

Key name

Can be one of the following:

time

serial-number

event

module-revision

sw-version

prepaid-infoavailable

prepaid-credits

prepaid-currency

prepaid-expiredate

1

<value>

Value


Example of file contents for firmware update event

#key;value time;2010-09-01 00:01:02 serial-number;0006123456 event;fwupdate module-revision;1.100

Report template 2006

Report format

This report contains log information sent from the product. On execution of this report, one file with log information is sent to the FTP Server.

Filename

ccc Filename of the report data file sent to server is in the following format:

<serial-number>_ logreport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_logreport_20200901010000_2006.csv. ccc

File contents

The file contains a column header line and log information lines.

The log level can be changed using configuration key common.syslog.level.

Table 232. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed value indicating column information line.

1

serial-number

Fixed value

2

created

Fixed value

3

level

Fixed value

4

message

Fixed value


Table 233. Value line definition

Column index

(0 = first column)

Column contents

Description

0

<serial-number>

Serial number of the product

1

<created>

The date/time for this log information line. Format: YYYY-MM-DD hh:mm:ss

2

<level>

The level of this log line.

Available levels are:

-2 = Debug

-1 = Unknown

0 = Info

1 = Warning

2 = Error

3 = Critical

4 = Fatal

5 = Unhandled exception

6 = Event

7 = Network event

8 = Display text (only CMi2120)

3

<message>

Log information message in clear text.


Example of file contents

#serial-number;created;level;message 0006123456;2010-09-01 00:00:00;0;[CMAppl] Starting application 0006123456;2010-09-01 00:00:02;0;[Event] event=boot 0006123456;2010-09-01 00:00:03;0;[storevalue] Storevalue completed successfully

Report template 2007

Report format

This report contains status information sent from the product. Example of status information is cell information, signal quality etc. On execution of this report, one file with status information is sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_ statusreport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_statusreport_20200901010000_2007.csv.

File contents

The file contains a column header line and key value pairs of information.

Table 234. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed value indicating column information line.

1

key

Fixed value

2

value

Fixed value


Table 235. Value line definition

Column index

(0 = first column)

Column contents

Description

0

<key>

Key name

Can be one of the following:

time

serial-number

name

part-number

imei

imsi

hw-version

sw-version

boot-time

internal-temperature

internal-voltage

rssi

gprs-available

operator

cell

apn

ip

simid

prepaid-infoavailable

prepaid-credits

prepaid-currency

prepaid-expiredate

1

<value>

Value


Example of file contents

#key;value time;2010-09-28 08:34:52 serial-number;0012000848 name; part-number;CMi2110 imei;353234020692347 imsi;240016002844890 hw-version;R4A sw-version;1.1.4 boot-time;2010-09-27 12:03:42 internal-temperature;28 °C internal-voltage;4074 mV rssi;-75 dBm gprs-available;2 operator;TELIA S cell;AB7C apn;online.telia.se ip;90.237.26.36 simid;89460100090806021242 prepaid-infoavailable;true prepaid-credits;92,30 prepaid-currency;SEK prepaid-expiredate;2011-09-29 00:00:00

Report template 2101

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file with values for all product connected meters will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2101.csv.

File contents

The file contains one column header line for each device, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

To distinguish column header lines and value data lines, look for “serial-number“ at the beginning of each line.

Table 236. Column header description

Column index

(0 = first column)

Column contents

Description

0

serial-number

Fixed field

1

device-identification

Fixed field

2

created

Fixed field

3

value-data-count

Fixed field

4

Manufacturer

Fixed field

5..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

The 6 fields are:

Description

Unit

Function

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0

Example of value data lines

06000885;00902947;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Example of file with all contents

serial-number;device-identification;created;value-datacount;manufacturer;parameter-set-id no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0;on-time noerror,hour(s),inst-value,0,0,0;energy no-error,Wh,instvalue,1,0,0;energy no-error,Wh,inst-value,2,0,0;energy noerror,Wh,inst-value,1,2,0;energy no-error,Wh,instvalue,2,2,0;manufacturer-specific,,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturerspecific,W,inst-value,0,2,0;power no-error,W,max-value,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0 06000885;00902947;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348 serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0 06000885;00902985;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Report template 2102

Report format

This report contains value data in M-Bus raw format. This report sends a meter data report file to an FTP server. On execution of this report, one file with all meter values will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2102.csv.

File contents

The file contains rows. Each row contains the origin of the value and the actual value for a specific time.

Table 237. Column header description

Column index

(0 = first column)

Column contents

Description

0

<serial-number>

Product serial number

1

<device-identification

The device (meter) secondary address

2

<created>

The date/time of this value. Format: YYYY-MM-DD hh:mm:ss

3

<value-data-count

The M-Bus telegram number from which this record is taken

4

<mbus-raw>

M-Bus raw data, starting with M-Bus C-Field. Stop character and checksum of the M-Bus telegram is excluded.


Example of file contents

00000161;05047168;2009-12-17 00:00:00;00;08147268710405ac484103470000000c1480769604046dba092e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 01:00:00;00;08147268710405ac484103480000000c1480769604046dba0a2e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 02:00:00;00;08147268710405ac484103490000000c1480769604046dba0b2e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 03:00:00;00;08147268710405ac4841034a0000000c1480769604046dba0c2e1a426c 2a194c140000000042ec7e3f1c0fc010010c

Report template 2103

Report format

This report contains value data in M-Bus raw format. This report sends a meter data report file to an FTP server. On execution of this report, one file per device (per meter) will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 and for device with secondary address 00112233 at 2020-09-01 01:00:00:

0006123456_00112233_valuereport_20200901010000_2103.csv.

File contents

The file contains rows. Each row contains the origin of the value and the actual value for a specific time.

Table 238. Column header description

Column index

(0 = first column)

Column contents

Description

0

<serial-number>

Product serial number

1

<device-identification>

The device (meter) secondary address

2

<created>

The date/time of this value. Format: YYYY-MM-DD hh:mm:ss

3

<value-data-count

The M-Bus telegram number from which this record is taken

4

<mbus-raw>

M-Bus raw data, starting with M-Bus C-Field. Stop character and checksum of the M-Bus telegram is excluded.


Example of file contents

00000161;05047168;2009-12-17 00:00:00;00;08147268710405ac484103470000000c1480769604046dba092e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 01:00:00;00;08147268710405ac484103480000000c1480769604046dba0a2e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 02:00:00;00;08147268710405ac484103490000000c1480769604046dba0b2e1a426c 2a194c140000000042ec7e3f1c0fc010010c 00000161;05047168;2009-12-17 03:00:00;00;08147268710405ac4841034a0000000c1480769604046dba0c2e1a426c 2a194c140000000042ec7e3f1c0fc010010c

Report template 2104

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file per device (per meter) will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 and for device with secondary address 00112233 at 2020-09-01 01:00:00:

0006123456_00112233_valuereport_20200901010000_2104.csv.

File contents

The file contains one column header line and one or more value data lines. Each column header in the first line of a file describes the contents of the value data lines.

Table 239. Column header description

Column index

(0 = first column)

Column contents

Description

0

serial-number

Fixed field

1

device-identification

Fixed field

2

created

Fixed field

3

value-data-count

Fixed field

4..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

The 6 fields are:

Description

Unit

Function

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0

Example of value data lines

06000885;00902947;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Example of file with all contents

serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0 06000885;00902947;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Report template 2105

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file per device (per meter) will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 and for device with secondary address 00112233 at 2020-09-01 01:00:00:

0006123456_00112233_valuereport_20200901010000_2105.csv.

File contents

The file contains one column header line and one or more value data lines. Each column header in the first line of a file describes the contents of the value data lines.

Table 240. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field

2

device-identification

Fixed field

3

created

Fixed field

4

value-data-count

Fixed field

5..n

<value-description

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

The 6 fields are:

Description

Unit

Function

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0

Example of value data lines

06000885;00902947;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Example of file with all contents

#serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0 06000885;00902947;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Report template 2108

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file with values for all product connected meters will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2108.csv.

File contents

The file contains one column header line for each device, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 241. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field.10 digits

2

device-identification

Fixed field. 8 digits, meter number

3

created

Fixed field. Date/Time of current row

4

value-data-count

Fixed field. M-Bus telegram number

5..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

The 6 fields are:

Description

Unit

Function

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0

Example of value data lines

06000885;00902947;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Example of file with all contents

#serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0 06000885;00902947;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348 #serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0 06000885;00902985;2010-04-19 00:00:00;00;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 01:00:00;00;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 02:00:00;00;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 03:00:00;00;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0;5550 ;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Report template 2109

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file per device (per meter) will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 and for device with secondary address 00112233 at 2020-09-01 01:00:00:

0006123456_00112233_valuereport_20200901010000_2109.csv.

File contents

The file contains one column header line for each device, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 242. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field. 10 digits

2

device-identification

Fixed field. 8 digits, meter number

3

created

Fixed field. Date/Time of current row

4

value-data-count

Fixed field. M-Bus telegram number

5

manufacturer

Fixed field. M-Bus three letter manufacturer according to Flag Association.

6

version

Fixed field. M-Bus version.

7

device-type

Fixed field. M-Bus device type.

8

access-number

Fixed field. . M-Bus access number.

9

signature

Fixed field. M-Bus signature.

10..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

The 6 fields are:

Description

Unit

Function

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-identification;created;value-datacount;LUG;1;heat;21;0;parameter-set-id no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0;on-time noerror,hour(s),inst-value,0,0,0;energy no-error,Wh,instvalue,1,0,0;energy no-error,Wh,inst-value,2,0,0;energy noerror,Wh,inst-value,1,2,0;energy no-error,Wh,instvalue,2,2,0;manufacturer-specific,,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturerspecific,W,inst-value,0,2,0;power no-error,W,max-value,1,0,0;power noerror,W,max-value,2,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0

Example of value data lines

06000885;00902947;2010-04-19 00:00:00;00; LUG;1;heat;21;0;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00; LUG;1;heat;21;0;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00; LUG;1;heat;21;0;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00; LUG;1;heat;21;0;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Example of file with all contents

#serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime no-error,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0 06000885;00902947;2010-04-19 00:00:00;00; LUG;1;heat;21;0;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 01:00:00;00; LUG;1;heat;21;0;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 02:00:00;00; LUG;1;heat;21;0;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885;00902947;2010-04-19 03:00:00;00; LUG;1;heat;21;0;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348 #serial-number;device-identification;created;value-datacount;parameter-set-id no-error,,inst-value,0,0,0;datetime noerror,,inst-value,0,0,0;on-time no-error,hour(s),instvalue,0,0,0;energy no-error,Wh,inst-value,1,0,0;energy noerror,Wh,inst-value,2,0,0;energy no-error,Wh,inst-value,1,2,0;energy no-error,Wh,inst-value,2,2,0;manufacturer-specific,,instvalue,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturer-specific,W,inst-value,0,0,0;power manufacturerspecific,W,inst-value,0,0,0;power manufacturer-specific,W,instvalue,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power manufacturer-specific,W,inst-value,0,2,0;power no-error,W,maxvalue,1,0,0;power no-error,W,max-value,2,0,0;voltage manufacturerspecific,V,inst-value,0,0,0;voltage manufacturer-specific,V,instvalue,0,0,0;voltage manufacturer-specific,V,inst-value,0,0,0;current manufacturer-specific,A,inst-value,0,0,0;current manufacturerspecific,A,inst-value,0,0,0;current manufacturer-specific,A,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0;manufacturer-specific,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0;reset-counter noerror,,inst-value,0,0,0;error-flags-dev-spec no-error,,instvalue,0,0,0;datetime no-error,,inst-value,0,0,0 06000885;00902985;2010-04-19 00:00:00;00; LUG;1;heat;21;0;1048543;353506619;420;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;239;239;239;0,00;0,00;0,00;498;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 01:00:00;00; LUG;1;heat;21;0;1048543;353506875;421;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;238;238;238;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 02:00:00;00; LUG;1;heat;21;0;1048543;353507131;422;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;240;240;240;0,00;0,00;0,00;497;0;0;0;9;0;352718348 06000885; 00902985;2010-04-19 03:00:00;00; LUG;1;heat;21;0;1048543;353566779;423;104730;50;1420;80;1;0;0;0;0;0;0; 5550;220;242;242;242;0,00;0,00;0,00;498;0;0;0;9;0;352718348

Report template 2110

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file with values for all product connected meters will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2110.csv.

File contents

The file contains one column header line, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 243. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field. Data row contains the CMe/CMi product serial number.

2

device-position

Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID).

3

device-identification

Fixed field. Data row contains the M-Bus device secondary address.

4

created

Fixed field. Data row contains the date/time of the data row.

5

value-data-count

Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc.

6

manufacturer

Fixed field. Data row contains the M-Bus device three letter manufacturer code.

7

version

Fixed field. Data row contains the M-Bus device version.

8

device-type

Fixed field. Data row contains the M-Bus device type as string.

9

access-number

Fixed field. Data row contains the M-Bus device access number which is increased by one on every request to the meter. This field can be used to verify that no other M-Bus master has read the device.

10

status

Fixed field. Data row contains the M-Bus device status field.

11

signature

Fixed field. Data row contains the M-Bus device signature field.

12..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

These fields are:

Unit

Description

Kind

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,inst-value,0,0,0

Example of value data lines

0016002609;14000170;2023-10-24 10:25:00;00;HYD;100;bus/system component;9;0;0;62001327;0;-80 0016002609;14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 0016002609;14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 0016002609;14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82

Example of file with all contents

#serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,inst-value,0,0,0 0016002609;14000170;2023-10-24 10:25:00;00;HYD;100;bus/system component;9;0;0;62001327;0;-80 0016002609;14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 0016002609;14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 0016002609;14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82 #serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,instvalue,0,0,0;data-container-wireless-m-bus,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0 0016002609;19430172;2023-10-24 10:25:00;00;ITW;0;cold water;140;0;0;62001327;0;- 66;3a4497a67201431900167a1c0020a53a8130ac7f245ae39cf0ea744173835cde48e f1c96c5f5f504f739b5881628b5027f662a0e79720143190000; 0016002609;19430172;2023-10-24 10:30:00;00;ITW;0;cold water;141;0;0;62001327;4;- 66;3a4497a67201431900167a1c0020a53a8130ac7f245ae39cf0ea744173835cde48e f1c96c5f5f504f739b5881628b5027f662a0e79720143190000; 0016002609;19430172;2023-10-24 10:35:00;00;ITW;0;cold water;142;0;0;62001327;4;- 66;3a4497a67201431900167a1d0020a5c3960daa1926001340c6241b1dd2abff24801 2448e7e588d68fa508a2193b396027f662a0e79720143190000; 0016002609;19430172;2023-10-24 10:40:00;00;ITW;0;cold water;143;0;0;62001327;4;- 66;3a4497a67201431900167a1e0020a5b875cd2766c8d490f932acf2479e2695fcc0a ca3408e0f93ba705545e66a5bae027f662a0e79720143190000; #serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;other-swversion,,inst-value,0,0,0;key,,inst-value,0,0,0;wmo,,instvalue,0,0,0;wse,,inst-value,0,0,0;wit,,inst-value,0,0,0;wis,,instvalue,0,0,0;wim,,inst-value,0,0,0;age,,inst-value,0,0,0;wif,,instvalue,0,0,0;wci,,inst-value,0,0,0;tmo,,inst-value,0,0,0;tdf,,instvalue,0,0,0;lcd,,inst-value,0,0,0;lan,,inst-value,0,0,0;sle,,instvalue,0,0,0;password,,inst-value,0,0,0;parameter-set-id,,instvalue,0,0,0;wfa,,inst-value,0,0,0;aif,,inst-value,0,0,0;rrc,,instvalue,0,0,0;sta,,inst-value,0,0,0;cam,,inst-value,0,0,0;mam,,instvalue,0,0,0;icf,,inst-value,0,0,0;wdi,,inst-value,0,0,0;i78,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0 0016002609;62001327;2023-10-24 10:25:00;00;ELV;3;communication controller gateway;40;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;62001327;2023-10-24 10:30:00;00;ELV;3;communication controller gateway;41;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;62001327;2023-10-24 10:35:00;00;ELV;3;communication controller gateway;42;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;62001327;2023-10-24 10:40:00;00;ELV;3;communication controller gateway;43;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0;

Report template 2111

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file with values for all product connected meters will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2111.csv.

File contents

The file contains one column header line, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 244. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field. Data row contains the CMe/CMi product serial number.

2

device-identification

Fixed field. Data row contains the M-Bus device secondary address.

3

created

Fixed field. Data row contains the date/time of the data row.

4

value-data-count

Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc.

5

manufacturer

Fixed field. Data row contains the M-Bus device three letter manufacturer code.

6

version

Fixed field. Data row contains the M-Bus device version.

7

device-type

Fixed field. Data row contains the M-Bus device type as string.

8

access-number

Fixed field. Data row contains the M-Bus device access number which is increased by one on every request to the meter. This field can be used to verify that no other M-Bus master has read the device.

9

status

Fixed field. Data row contains the M-Bus device status field.

10

signature

Fixed field. Data row contains the the M-Bus device signature field.

11..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 8 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

The 8 fields are:

Dif

Vif

Unit

Description

Kind

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;0c,78,fabrication-no,instvalue,0,0,0;02,75,minutes(s),act-duration,instvalue,0,0,0;01,fd71,dBm,rf-level,inst-value,0,0,0;02,65,°C,exttemp,inst-value,0,0,0;42,65,°C,ext-temp,instvalue,0,0,1;8201,65,°C,ext-temp,inst-value,0,0,2;22,65,°C,exttemp,min-value,0,0,0;12,65,°C,ext-temp,max-value,0,0,0;62,65,°C,exttemp,min-value,0,0,1;52,65,°C,ext-temp,maxvalue,0,0,1;02,fb1a,%,relative-humidity,instvalue,0,0,0;42,fb1a,%,relative-humidity,instvalue,0,0,1;8201,fb1a,%,relative-humidity,instvalue,0,0,2;22,fb1a,%,relative-humidity,minvalue,0,0,0;12,fb1a,%,relative-humidity,maxvalue,0,0,0;62,fb1a,%,relative-humidity,minvalue,0,0,1;52,fb1a,%,relative-humidity,maxvalue,0,0,1;02,fd1b,digital-input,inst-value,0,0,0; 0d,fd0f,other-swversion,inst-value,0,0,0;0f,manufacturer-specific,inst-value,0,0,0

Example of value data lines

0016002874;61000134;2018-11-29 00:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 01:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 02:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 03:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 04:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 05:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 06:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 07:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 08:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 09:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 10:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 11:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 12:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 13:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 14:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 15:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 16:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 17:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 18:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 19:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 20:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 21:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 22:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 23:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0

Example of file with all contents

#serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;0c,78,fabrication-no,instvalue,0,0,0;02,75,minutes(s),act-duration,instvalue,0,0,0;01,fd71,dBm,rf-level,inst-value,0,0,0;02,65,°C,exttemp,inst-value,0,0,0;42,65,°C,ext-temp,instvalue,0,0,1;8201,65,°C,ext-temp,inst-value,0,0,2;22,65,°C,exttemp,min-value,0,0,0;12,65,°C,ext-temp,max-value,0,0,0;62,65,°C,exttemp,min-value,0,0,1;52,65,°C,ext-temp,maxvalue,0,0,1;02,fb1a,%,relative-humidity,instvalue,0,0,0;42,fb1a,%,relative-humidity,instvalue,0,0,1;8201,fb1a,%,relative-humidity,instvalue,0,0,2;22,fb1a,%,relative-humidity,minvalue,0,0,0;12,fb1a,%,relative-humidity,maxvalue,0,0,0;62,fb1a,%,relative-humidity,minvalue,0,0,1;52,fb1a,%,relative-humidity,maxvalue,0,0,1;02,fd1b,digital-input,inst-value,0,0,0; 0d,fd0f,other-swversion,inst-value,0,0,0;0f,manufacturer-specific,inst-value,0,0,0 0016002874;61000134;2018-11-29 00:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 01:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 02:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 03:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 04:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 05:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 06:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 07:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 08:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 09:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 10:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 11:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 12:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 13:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 14:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 15:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 16:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 17:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 18:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 19:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 20:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 21:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0016002874;61000134;2018-11-29 22:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0 0016002874;61000134;2018-11-29 23:00:00;00;ELV;1;room sensor;51;4;0;62001253;3;- 66;25,060;24,800;24,590;24,660;25,060;23,660;25,740;25,200;25,100;23,7 00;25,100;25,200;20,800;26,200;17248;1.0.0

Report template 2112

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file with values for all product connected meters will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2112.csv.

File contents

The file contains one column header line, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 245. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field. Data row contains the CMe/CMi product serial number.

2

device-position

Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID).

3

device-identification

Fixed field. Data row contains the M-Bus device secondary address.

4

created

Fixed field. Data row contains the date/time of the data row.

5

value-data-count

Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc.

6

manufacturer

Fixed field. Data row contains the M-Bus device three letter manufacturer code.

7

version

Fixed field. Data row contains the M-Bus device version.

8

device-type

Fixed field. Data row contains the M-Bus device type as string.

9

access-number

Fixed field. Data row contains the M-Bus device access number which is increased by one on every request to the meter. This field can be used to verify that no other M-Bus master has read the device.

10

status

Fixed field. Data row contains the M-Bus device status field.

11

signature

Fixed field. Data row contains the M-Bus device signature field.

12..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

These 6 fields are:

Unit

Description

Kind

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-position;device-identification;created;valuedata-count;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,inst-value,0,0,0

Example of value data lines

0016002609;;14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 0016002609;;14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 0016002609;;14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82

Example of file with all contents

#serial-number;device-position;device-identification;created;valuedata-count;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,inst-value,0,0,0 0016002609;;14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 0016002609;;14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 0016002609;;14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82 #serial-number;device-position;device-identification;created;valuedata-count;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,instvalue,0,0,0;data-container-wireless-m-bus,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0 0016002609;itron vit;19430172;2023-10-24 10:30:00;00;ITW;0;cold water;141;0;0;62001327;4;- 66;3a4497a67201431900167a1c0020a53a8130ac7f245ae39cf0ea744173835cde48e f1c96c5f5f504f739b5881628b5027f662a0e79720143190000; 0016002609;itron vit;19430172;2023-10-24 10:35:00;00;ITW;0;cold water;142;0;0;62001327;4;- 66;3a4497a67201431900167a1d0020a5c3960daa1926001340c6241b1dd2abff24801 2448e7e588d68fa508a2193b396027f662a0e79720143190000; 0016002609;itron vit;19430172;2023-10-24 10:40:00;00;ITW;0;cold water;143;0;0;62001327;4;- 66;3a4497a67201431900167a1e0020a5b875cd2766c8d490f932acf2479e2695fcc0a ca3408e0f93ba705545e66a5bae027f662a0e79720143190000; #serial-number;device-position;device-identification;created;valuedata-count;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;other-swversion,,inst-value,0,0,0;key,,inst-value,0,0,0;wmo,,instvalue,0,0,0;wse,,inst-value,0,0,0;wit,,inst-value,0,0,0;wis,,instvalue,0,0,0;wim,,inst-value,0,0,0;age,,inst-value,0,0,0;wif,,instvalue,0,0,0;wci,,inst-value,0,0,0;tmo,,inst-value,0,0,0;tdf,,instvalue,0,0,0;lcd,,inst-value,0,0,0;lan,,inst-value,0,0,0;sle,,instvalue,0,0,0;password,,inst-value,0,0,0;parameter-set-id,,instvalue,0,0,0;wfa,,inst-value,0,0,0;aif,,inst-value,0,0,0;rrc,,instvalue,0,0,0;sta,,inst-value,0,0,0;cam,,inst-value,0,0,0;mam,,instvalue,0,0,0;icf,,inst-value,0,0,0;wdi,,inst-value,0,0,0;i78,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0 0016002609;Lgh 105;62001327;2023-10-24 10:30:00;00;ELV;3;communication controller gateway;41;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;Lgh 105;62001327;2023-10-24 10:35:00;00;ELV;3;communication controller gateway;42;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;Lgh 105;62001327;2023-10-24 10:40:00;00;ELV;3;communication controller gateway;43;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0;

Report template 2113

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file with values for all product connected meters will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2113.csv.

File contents

The file contains one column header line, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 246. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field. Data row contains the CMe/CMi product serial number.

2

device-position

Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID).

3

device-identification

Fixed field. Data row contains the M-Bus device secondary address.

4

created

Fixed field. Data row contains the date/time of the data row.

5

value-data-count

Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc.

6

manufacturer

Fixed field. Data row contains the M-Bus device three letter manufacturer code.

7

version

Fixed field. Data row contains the M-Bus device version.

8

device-type

Fixed field. Data row contains the M-Bus device type as string.

9

access-number

Fixed field. Data row contains the M-Bus device access number which is increased by one on every request to the meter. This field can be used to verify that no other M-Bus master has read the device.

10

status

Fixed field. Data row contains the M-Bus device status field.

11

signature

Fixed field. Data row contains the M-Bus device signature field.

12..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

These 6 fields are:

Unit

Description

Kind

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;dif=0c,vif=78,description=fabricationno,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=02,vif=75,unit=minute(s), description=act-duration,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=fd71,unit=dBm,desc ription=rf-level,kind=inst-value,tariff=0,subunit=0,storagenumber=0

Example of value data lines

ELV000016002609;HYD14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 ELV000016002609;HYD14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 ELV000016002609;HYD14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82

Example of file with all contents

#serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;dif=0c,vif=78,description=fabricationno,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=02,vif=75,unit=minute(s), description=act-duration,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=fd71,unit=dBm,desc ription=rf-level,kind=inst-value,tariff=0,subunit=0,storagenumber=0 ELV000016002609;HYD14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 ELV000016002609;HYD14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 ELV000016002609;HYD14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82 #serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;dif=0c,vif=78,description=fabricationno,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=02,vif=75,unit=minute(s), description=act-duration,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=fd71,unit=dBm,desc ription=rf-level,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=0d,vif=fd3b,description=d ata-container-wireless-m-bus,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=0f,vif=,description=manuf acturer-specific,kind=inst-value,tariff=0,subunit=0,storagenumber=0 ELV000016002609;ITW19430172;2023-10-24 10:30:00;00;ITW;0;cold water;141;0;0;62001327;4;- 66;3a4497a67201431900167a1c0020a53a8130ac7f245ae39cf0ea744173835cde48e f1c96c5f5f504f739b5881628b5027f662a0e79720143190000; ELV000016002609;ITW19430172;2023-10-24 10:35:00;00;ITW;0;cold water;142;0;0;62001327;4;- 66;3a4497a67201431900167a1d0020a5c3960daa1926001340c6241b1dd2abff24801 2448e7e588d68fa508a2193b396027f662a0e79720143190000; ELV000016002609;ITW19430172;2023-10-24 10:40:00;00;ITW;0;cold water;143;0;0;62001327;4;- 66;3a4497a67201431900167a1e0020a5b875cd2766c8d490f932acf2479e2695fcc0a ca3408e0f93ba705545e66a5bae027f662a0e79720143190000; #serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;dif=0c,vif=78,description=fabricationno,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=02,vif=75,unit=minute(s), description=act-duration,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=fd71,unit=dBm,desc ription=rf-level,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=0d,vif=fd3b,description=d ata-container-wireless-m-bus,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=0f,vif=,description=manuf acturer-specific,kind=inst-value,tariff=0,subunit=0,storagenumber=0 ELV000016002609;ITW19430266;2023-10-24 10:30:00;00;ITW;0;cold water;141;0;0;62001327;1;- 66;3a4497a66602431900167a840020a5b7f9de9597a1db9946b25ee24c8d3cdf4402d 4c70257c29a67bb40986740c888027f662a0e79660243190000; ELV000016002609;ITW19430266;2023-10-24 10:35:00;00;ITW;0;cold water;142;0;0;62001327;2;- 66;3a4497a66602431900167a850020a552783ca473b4a3fa5756594d34825f1685d0f afab88da6c996af847332ff86ba027f662a0e79660243190000; ELV000016002609;ITW19430266;2023-10-24 10:40:00;00;ITW;0;cold water;143;0;0;62001327;1;- 66;3a4497a66602431900167a860020a5cbf3c489a9fb69b1fd47dddd8ca2cd23e082f 0f53c903443af3e7c83e1d685ab027f662a0e79660243190000; #serial-number;device-identification;created;value-datacount;manufacturer;version;device-type;accessnumber;status;signature;dif=0c,vif=78,description=fabricationno,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=0d,vif=fd0f,description=o ther-sw-version,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=0d,vif=7c,description=key ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=wmo ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=wse ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=02,vif=7c,description=wit ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=02,vif=7c,description=wis ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=wim ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=02,vif=7c,description=age ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=04,vif=7c,description=wif ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=wci ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=tmo ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=tdf ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=lcd ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=lan ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=sle ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=0a,vif=fd16,description=p assword,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=04,vif=fd0b,description=p arameter-set-id,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=02,vif=7c,description=wfa ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=aif ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=04,vif=7c,description=rrc ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=sta ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=cam ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=mam ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=icf ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=wdi ,kind=instvalue,tariff=0,subunit=0,storagenumber=0;dif=01,vif=7c,description=i78 value,tariff=0,subunit=0,storagenumber=0;dif=1f,vif=,description=manuf acturer-specific,kind=inst-value,tariff=0,subunit=0,storagenumber=0 ELV000016002609;ELV62001327;2023-10-24 10:30:00;00;ELV;3;communication controller gateway;41;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; ELV000016002609;ELV62001327;2023-10-24 10:35:00;00;ELV;3;communication controller gateway;42;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; ELV000016002609;ELV62001327;2023-10-24 10:40:00;00;ELV;3;communication controller gateway;43;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0;

Report template 2114

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file with values for all product connected meters will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2114.csv.

File contents

The file contains one column header line, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 247. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field. Data row contains the CMe/CMi product serial number.

2

device-position

Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID).

3

device-identification

Fixed field. Data row contains the M-Bus device secondary address.

4

created

Fixed field. Data row contains the date/time of the data row.

5

value-data-count

Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc.

6

manufacturer

Fixed field. Data row contains the M-Bus device three letter manufacturer code.

7

version

Fixed field. Data row contains the M-Bus device version.

8

device-type

Fixed field. Data row contains the M-Bus device type as string.

9

access-number

Fixed field. Data row contains the M-Bus device access number which is increased by one on every request to the meter. This field can be used to verify that no other M-Bus master has read the device.

10

status

Fixed field. Data row contains the M-Bus device status field.

11

signature

Fixed field. Data row contains the M-Bus device signature field.

12..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

These 6 fields are:

Unit

Description

Kind

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-position;device-identification;created;valuedata-count;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,inst-value,0,0,0

Example of value data lines

ELV000016002609;;HYD14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 ELV000016002609;;HYD14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 ELV000016002609;;HYD14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82

Example of file with all contents

#serial-number;device-position;device-identification;created;valuedata-count;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,inst-value,0,0,0 ELV000016002609;;HYD14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 ELV000016002609;;HYD14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 ELV000016002609;;HYD14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82 #serial-number;device-position;device-identification;created;valuedata-count;manufacturer;version;device-type;accessnumber;status;signature;fabrication-no,,inst-value,0,0,0;actduration,minute(s),inst-value,0,0,0;rf-level,dBm,instvalue,0,0,0;data-container-wireless-m-bus,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0 ELV000016002609;itron vit;ITW19430172;2023-10-24 10:30:00;00;ITW;0;cold water;141;0;0;62001327;4;- 66;3a4497a67201431900167a1c0020a53a8130ac7f245ae39cf0ea744173835cde48e f1c96c5f5f504f739b5881628b5027f662a0e79720143190000; ELV000016002609;itron vit;ITW19430172;2023-10-24 10:35:00;00;ITW;0;cold water;142;0;0;62001327;4;- 66;3a4497a67201431900167a1d0020a5c3960daa1926001340c6241b1dd2abff24801 2448e7e588d68fa508a2193b396027f662a0e79720143190000; ELV000016002609;itron vit;ITW19430172;2023-10-24 10:40:00;00;ITW;0;cold water;143;0;0;62001327;4;- 66;3a4497a67201431900167a1e0020a5b875cd2766c8d490f932acf2479e2695fcc0a ca3408e0f93ba705545e66a5bae027f662a0e79720143190000;

Report template 2115

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file with values for all product connected meters will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:

0006123456_valuereport_20200901010000_2115.csv.

File contents

The file contains one column header line, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 248. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field. Data row contains the CMe/CMi product serial number.

2

device-position

Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID).

3

primary-address

Fixed field. Data row contains the primary address of the M-Bus device.

4

device-identification

Fixed field. Data row contains the M-Bus device secondary address.

5

created

Fixed field. Data row contains the date/time of the data row.

6

value-data-count

Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc.

7

manufacturer

Fixed field. Data row contains the M-Bus device three letter manufacturer code.

8

version

Fixed field. Data row contains the M-Bus device version.

9

device-type

Fixed field. Data row contains the M-Bus device type as string.

10

access-number

Fixed field. Data row contains the M-Bus device access number which is increased by one on every request to the meter. This field can be used to verify that no other M-Bus master has read the device.

11

status

Fixed field. Data row contains the M-Bus device status field.

12

signature

Fixed field. Data row contains the M-Bus device signature field.

13..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

These 6 fields are:

Unit

Description

Kind

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-position;primary-address;deviceidentification;created;value-data-count;manufacturer;version;devicetype;access-number;status;signature;fabrication-no,,instvalue,0,0,0;act-duration,minute(s),inst-value,0,0,0;rf-level,dBm,instvalue,0,0,0

Example of value data lines

0016002609;;11;14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 0016002609;;11;14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 0016002609;;11;14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82

Example of file with all contents

#serial-number;device-position;primary-address;deviceidentification;created;value-data-count;manufacturer;version;devicetype;access-number;status;signature;fabrication-no,,instvalue,0,0,0;act-duration,minute(s),inst-value,0,0,0;rf-level,dBm,instvalue,0,0,0 0016002609;;11;14000170;2023-10-24 10:30:00;00;HYD;100;bus/system component;10;0;0;62001327;0;-80 0016002609;;11;14000170;2023-10-24 10:35:00;00;HYD;100;bus/system component;11;0;0;62001327;0;-82 0016002609;;11;14000170;2023-10-24 10:40:00;00;HYD;100;bus/system component;12;0;0;62001327;0;-82 #serial-number;device-position;primary-address;deviceidentification;created;value-data-count;manufacturer;version;devicetype;access-number;status;signature;fabrication-no,,instvalue,0,0,0;act-duration,minute(s),inst-value,0,0,0;rf-level,dBm,instvalue,0,0,0;data-container-wireless-m-bus,,instvalue,0,0,0;manufacturer-specific,,inst-value,0,0,0 0016002609;itron vit;9;19430172;2023-10-24 10:30:00;00;ITW;0;cold water;141;0;0;62001327;4;- 66;3a4497a67201431900167a1c0020a53a8130ac7f245ae39cf0ea744173835cde48e f1c96c5f5f504f739b5881628b5027f662a0e79720143190000; 0016002609;itron vit;9;19430172;2023-10-24 10:35:00;00;ITW;0;cold water;142;0;0;62001327;4;- 66;3a4497a67201431900167a1d0020a5c3960daa1926001340c6241b1dd2abff24801 2448e7e588d68fa508a2193b396027f662a0e79720143190000; 0016002609;itron vit;9;19430172;2023-10-24 10:40:00;00;ITW;0;cold water;143;0;0;62001327;4;- 66;3a4497a67201431900167a1e0020a5b875cd2766c8d490f932acf2479e2695fcc0a ca3408e0f93ba705545e66a5bae027f662a0e79720143190000;

Report templates 2116

Report format

This report contains value data in decoded format, i.e. the data is sent in clear text and no knowledge of how to decode M-Bus information is needed. This report sends a meter data report file to an FTP server. On execution of this report, one file per device (per meter) will be sent to the FTP Server.

Filename

Filename of the report data file sent to server is in the following format:

<serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.

Example of a file sent from a product with serial number 0006123456 and for device with secondary address 00112233 at 2020-09-01 01:00:00:

0006123456_00112233_valuereport_20200901010000_2116.csv.

File contents

The file contains one column header line, followed by one or more value data lines. Each column header line describes the contents of the following value data lines.

Table 249. Column header description

Column index

(0 = first column)

Column contents

Description

0

#

Fixed field indicating column header information line.

1

serial-number

Fixed field. Data row contains the CMe/CMi product serial number.

2

device-position

Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID).

3

primary-address

Fixed field. Data row contains the primary address of the M-Bus device.

4

device-identification

Fixed field. Data row contains the M-Bus device secondary address.

5

created

Fixed field. Data row contains the date/time of the data row.

6

value-data-count

Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc.

7

manufacturer

Fixed field. Data row contains the M-Bus device three letter manufacturer code.

8

version

Fixed field. Data row contains the M-Bus device version.

9

device-type

Fixed field. Data row contains the M-Bus device type as string.

10

access-number

Fixed field. Data row contains the M-Bus device access number which is increased by one on every request to the meter. This field can be used to verify that no other M-Bus master has read the device.

11

status

Fixed field. Data row contains the M-Bus device status field.

12

signature

Fixed field. Data row contains the M-Bus device signature field.

13..n

<value-description>

Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added.

The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column.

These 6 fields are:

Unit

Description

Kind

Tariff

Sub unit

Storage number

Please see Report Template Reference Information for complete description of these fields.


Example of first line in file with column headers

#serial-number;device-position;primary-address;deviceidentification;created;value-data-count;manufacturer;version;devicetype;access-number;status;signature;fabrication-no,,instvalue,0,0,0;other-sw-version,,inst-value,0,0,0;key,,instvalue,0,0,0;wmo,,inst-value,0,0,0;wse,,inst-value,0,0,0;wit,,instvalue,0,0,0;wis,,inst-value,0,0,0;wim,,inst-value,0,0,0;age,,instvalue,0,0,0;wif,,inst-value,0,0,0;wci,,inst-value,0,0,0;tmo,,instvalue,0,0,0;tdf,,inst-value,0,0,0;lcd,,inst-value,0,0,0;lan,,instvalue,0,0,0;sle,,inst-value,0,0,0;password,,instvalue,0,0,0;parameter-set-id,,inst-value,0,0,0;wfa,,instvalue,0,0,0;aif,,inst-value,0,0,0;rrc,,inst-value,0,0,0;sta,,instvalue,0,0,0;cam,,inst-value,0,0,0;mam,,inst-value,0,0,0;icf,,instvalue,0,0,0;wdi,,inst-value,0,0,0;i78,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0

Example of value data lines

0016002609;Lgh 105;0;62001327;2023-10-24 10:30:00;00;ELV;3;communication controller gateway;41;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;Lgh 105;0;62001327;2023-10-24 10:35:00;00;ELV;3;communication controller gateway;42;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;Lgh 105;0;62001327;2023-10-24 10:40:00;00;ELV;3;communication controller gateway;43;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0;

Example of file with all contents

#serial-number;device-position;primary-address;deviceidentification;created;value-data-count;manufacturer;version;devicetype;access-number;status;signature;fabrication-no,,instvalue,0,0,0;other-sw-version,,inst-value,0,0,0;key,,instvalue,0,0,0;wmo,,inst-value,0,0,0;wse,,inst-value,0,0,0;wit,,instvalue,0,0,0;wis,,inst-value,0,0,0;wim,,inst-value,0,0,0;age,,instvalue,0,0,0;wif,,inst-value,0,0,0;wci,,inst-value,0,0,0;tmo,,instvalue,0,0,0;tdf,,inst-value,0,0,0;lcd,,inst-value,0,0,0;lan,,instvalue,0,0,0;sle,,inst-value,0,0,0;password,,instvalue,0,0,0;parameter-set-id,,inst-value,0,0,0;wfa,,instvalue,0,0,0;aif,,inst-value,0,0,0;rrc,,inst-value,0,0,0;sta,,instvalue,0,0,0;cam,,inst-value,0,0,0;mam,,inst-value,0,0,0;icf,,instvalue,0,0,0;wdi,,inst-value,0,0,0;i78,,inst-value,0,0,0;manufacturerspecific,,inst-value,0,0,0 0016002609;Lgh 105;0;62001327;2023-10-24 10:30:00;00;ELV;3;communication controller gateway;41;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;Lgh 105;0;62001327;2023-10-24 10:35:00;00;ELV;3;communication controller gateway;42;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0; 0016002609;Lgh 105;0;62001327;2023-10-24 10:40:00;00;ELV;3;communication controller gateway;43;0;0;62001327;1.8.2;<^9Q`J;4;0;60;0;1;1440;- 1;0;0;3;0;0;5;0;0;0;1;0;1;0;1;1;1;0;

Was this article helpful?

0 out of 0 found this helpful
Have more questions? Submit a request

Comments (0 comments)

Article is closed for comments.