[en] Email Report Templates
[en] This report contains information and status of the gateway and the installed meters. This report sends a meter data report to an SMTP server. On execution of this report, an emailed with plain text be sent to the configured email address(es).
[en] The email contains gateway information such as type serial number, software and hardware version etc, network information, as well as number of active and passive devices (meters). Furthermore, a complete device list of all connected meters with information such as Addressing mode, Fabrication number, Secondary address, Primary address, Type, Manufacturer, Version, Baud rate, Status, Created date.
[en] This report contains information and status of the gateway and the installed meters. This report sends a meter data report to an SMTP server. On execution of this report, an emailed with plain text be sent to the configured email address(es).
[en] The email contains multiple tables with the following information:
-
[en] Product Information and status
-
[en] Device List with all connected meters
-
[en] Meter value data table per meter
Tabell 243. [en] Device list
|
[en] Column index (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] |
|
|
1 |
[en] |
[en] Serial number of meter |
|
2 |
[en] |
[en] Set primary address of meter |
|
3 |
[en] |
[en] M-Bus type of meter |
|
4 |
[en] |
[en] Manufacturer of meter |
|
5 |
[en] |
[en] M-Bus version of meter |
|
6 |
[en] |
[en] Set baud rate |
|
7 |
[en] |
[en] If meter is active or not |
|
[en] Example of file contents |
|---|
|
[en] |
Tabell 244. [en] Device information
|
[en] Column index (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] |
[en] Name of measurement serie |
|
1 |
[en] |
|
|
2 |
[en] |
|
|
3 |
[en] |
|
|
4 |
[en] |
|
|
5 |
[en] |
|
|
6 |
[en] |
|
[en] Example of file contents |
|---|
|
[en] |
[en] This system report contains product and current configuration information. This report sends a system report to an SMTP server. On execution of this report, plain text with all meter values will be sent in an email.
[en] This report contains syslog data sent from the product. This report sends a meter data report to an SMTP server. On execution of this report, plain text with all log information of the gateway will be sent in an email.
[en] The email contains multiple tables with the following information:
[en] The email contains rows. Each row contains a log message for a specific time.
Tabell 245. [en] Column header description
|
[en] Column index (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] |
[en] The date/time of this value. Format YYYY-MM-DD hh:mm:ss |
|
1 |
[en] |
[en] Log information level |
|
2 |
[en] |
[en] ID of the log event |
|
3 |
[en] |
[en] Description of the log event |
[en] 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 SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_ eventreport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_eventreport_20200901010000_1005.csv.
[en] The file contains a column header line and key value pairs of information.
Tabell 246. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed value indicating column information line. |
|
1 |
[en] key |
[en] Fixed value |
|
2 |
[en] value |
[en] Fixed value |
Tabell 247. [en] Value line definition
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] |
[en] Key name [en] Can be one of the following: [en] time [en] serial-number [en] event [en] module-revision [en] sw-version [en] prepaid-infoavailable [en] prepaid-credits [en] prepaid-currency [en] prepaid-expiredate |
|
1 |
[en] <value> |
[en] Value |
[en] This report contains log information sent from the product. On execution of this report, one file with log information is sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_ logreport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_logreport_20200901010000_1006.csv. ccc
[en] The file contains a column header line and log information lines.
[en] The log level can be changed using configuration key common.syslog.level.
Tabell 248. [en] Value line definition
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
|
[en] Fixed value indicating column information line. |
|
1 |
[en] |
[en] Serial number of the product |
|
2 |
[en] |
[en] The date/time for this log information line. Format: YYYY-MM-DD hh:mm:ss |
|
3 |
[en] |
[en] The level of this log line. [en] Available levels are: [en] -2 = Debug [en] -1 = Unknown [en] 0 = Info [en] 1 = Warning [en] 2 = Error [en] 3 = Critical [en] 4 = Fatal [en] 5 = Unhandled exception [en] 6 = Event [en] 7 = Network event [en] 8 = Display text (only CMi2120) |
|
4 |
[en] |
|
|
5 |
[en] |
[en] Log information message in clear text. |
|
[en] Example of file contents |
|---|
|
[en] |
[en] 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 SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_ statusreport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_statusreport_20200901010000_1007.csv.
[en] The file contains a column header line and key value pairs of information.
Tabell 249. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed value indicating column information line. |
|
1 |
[en] key |
[en] Fixed value |
|
2 |
[en] value |
[en] Fixed value |
Tabell 250. [en] Value line definition
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] |
[en] Key name [en] Can be one of the following: [en] time [en] serial-number [en] name [en] part-number [en] imei [en] imsi [en] hw-version [en] sw-version [en] boot-time [en] internal-temperature [en] internal-voltage [en] rssi [en] gprs-available [en] operator [en] cell [en] apn [en] ip [en] simid [en] prepaid-infoavailable [en] prepaid-credits [en] prepaid-currency [en] prepaid-expiredate |
|
1 |
[en] |
[en] Value |
|
[en] Example of file contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file with values for all product connected meters will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1101.csv.
[en] 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.
[en] To distinguish column header lines and value data lines, look for “serial-number“ at the beginning of each line.
Tabell 251. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] serial-number |
[en] Fixed field |
|
1 |
[en] device-identification |
[en] Fixed field |
|
2 |
[en] created |
[en] Fixed field |
|
3 |
[en] value-data-count |
[en] Fixed field |
|
4 |
[en] Manufacturer |
[en] Fixed field |
|
[en] 5..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] The 6 fields are: [en] Description [en] Unit [en] Function [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] This report contains value data in M-Bus raw format. This report sends a meter data report file to an SMTP server. On execution of this report, one file with all meter values will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1102.csv.
[en] The file contains rows. Each row contains the origin of the value and the actual value for a specific time.
Tabell 252. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] |
[en] Product serial number |
|
1 |
[en] |
[en] The device (meter) secondary address |
|
2 |
[en] |
[en] The date/time of this value. Format: YYYY-MM-DD hh:mm:ss |
|
3 |
[en] |
[en] The M-Bus telegram number from which this record is taken |
|
4 |
[en] |
[en] M-Bus raw data, starting with M-Bus C-Field. Stop character and checksum of the M-Bus telegram is excluded. |
|
[en] Example of file contents |
|---|
|
[en] |
[en] This report contains value data in M-Bus raw format. This report sends a meter data report file to an SMTP server. On execution of this report, one file per device (per meter) will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.
[en] 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:
[en] 0006123456_00112233_valuereport_20200901010000_1103.csv.
[en] The file contains rows. Each row contains the origin of the value and the actual value for a specific time.
Tabell 253. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] |
[en] Product serial number |
|
1 |
[en] |
[en] The device (meter) secondary address |
|
2 |
[en] |
[en] The date/time of this value. Format: YYYY-MM-DD hh:mm:ss |
|
3 |
[en] |
[en] The M-Bus telegram number from which this record is taken |
|
4 |
[en] |
[en] M-Bus raw data, starting with M-Bus C-Field. Stop character and checksum of the M-Bus telegram is excluded. |
|
[en] Example of file contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file per device (per meter) will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.
[en] 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:
[en] 0006123456_00112233_valuereport_20200901010000_1104.csv.
[en] 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.
Tabell 254. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
[en] serial-number |
[en] Fixed field |
|
1 |
[en] device-identification |
[en] Fixed field |
|
2 |
[en] created |
[en] Fixed field |
|
3 |
[en] value-data-count |
[en] Fixed field |
|
[en] 4..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] The 6 fields are: [en] Description [en] Unit [en] Function [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file per device (per meter) will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.
[en] 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:
[en] 0006123456_00112233_valuereport_20200901010000_1105.csv.
[en] 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.
Tabell 255. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field |
|
2 |
[en] device-identification |
[en] Fixed field |
|
3 |
[en] created |
[en] Fixed field |
|
4 |
[en] value-data-count |
[en] Fixed field |
|
[en] 5..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] The 6 fields are: [en] Description [en] Unit [en] Function [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file with values for all product connected meters will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1108.csv.
[en] 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.
Tabell 256. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field.10 digits |
|
2 |
[en] device-identification |
[en] Fixed field. 8 digits, meter number |
|
3 |
[en] created |
[en] Fixed field. Date/Time of current row |
|
4 |
[en] value-data-count |
[en] Fixed field. M-Bus telegram number |
|
[en] 5..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] The 6 fields are: [en] Description [en] Unit [en] Function [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file per device (per meter) will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.
[en] 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:
[en] 0006123456_00112233_valuereport_20200901010000_1109.csv.
[en] 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.
Tabell 257. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field. 10 digits |
|
2 |
[en] device-identification |
[en] Fixed field. 8 digits, meter number |
|
3 |
[en] created |
[en] Fixed field. Date/Time of current row |
|
4 |
[en] value-data-count |
[en] Fixed field. M-Bus telegram number |
|
5 |
[en] manufacturer |
[en] Fixed field. M-Bus three letter manufacturer according to Flag Association. |
|
6 |
[en] version |
[en] Fixed field. M-Bus version. |
|
7 |
[en] device-type |
[en] Fixed field. M-Bus device type. |
|
8 |
[en] access-number |
[en] Fixed field. . M-Bus access number. |
|
9 |
[en] status |
|
|
9 |
[en] signature |
[en] Fixed field. M-Bus signature. |
|
[en] 10..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] The 6 fields are: [en] Description [en] Unit [en] Function [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file with values for all product connected meters will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1110.csv.
[en] 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.
Tabell 258. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field. Data row contains the CMe/CMi product serial number. |
|
2 |
[en] device-position |
[en] Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID). |
|
3 |
[en] device-identification |
[en] Fixed field. Data row contains the M-Bus device secondary address. |
|
4 |
[en] created |
[en] Fixed field. Data row contains the date/time of the data row. |
|
5 |
[en] value-data-count |
[en] Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc. |
|
6 |
[en] manufacturer |
[en] Fixed field. Data row contains the M-Bus device three letter manufacturer code. |
|
7 |
[en] version |
[en] Fixed field. Data row contains the M-Bus device version. |
|
8 |
[en] device-type |
[en] Fixed field. Data row contains the M-Bus device type as string. |
|
9 |
[en] access-number |
[en] 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 |
[en] status |
[en] Fixed field. Data row contains the M-Bus device status field. |
|
11 |
[en] signature |
[en] Fixed field. Data row contains the M-Bus device signature field. |
|
[en] 12..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] These fields are: [en] Unit [en] Description [en] Kind [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file with values for all product connected meters will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1111.csv.
[en] 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.
Tabell 259. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field. Data row contains the CMe/CMi product serial number. |
|
2 |
[en] device-identification |
[en] Fixed field. Data row contains the M-Bus device secondary address. |
|
3 |
[en] created |
[en] Fixed field. Data row contains the date/time of the data row. |
|
4 |
[en] value-data-count |
[en] Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc. |
|
5 |
[en] manufacturer |
[en] Fixed field. Data row contains the M-Bus device three letter manufacturer code. |
|
6 |
[en] version |
[en] Fixed field. Data row contains the M-Bus device version. |
|
7 |
[en] device-type |
[en] Fixed field. Data row contains the M-Bus device type as string. |
|
8 |
[en] access-number |
[en] 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 |
[en] status |
[en] Fixed field. Data row contains the M-Bus device status field. |
|
10 |
[en] signature |
[en] Fixed field. Data row contains the the M-Bus device signature field. |
|
[en] 11..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 8 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] The 8 fields are: [en] Dif [en] Vif [en] Unit [en] Description [en] Kind [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file with values for all product connected meters will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1112.csv.
[en] 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.
Tabell 260. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field. Data row contains the CMe/CMi product serial number. |
|
2 |
[en] device-position |
[en] Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID). |
|
3 |
[en] device-identification |
[en] Fixed field. Data row contains the M-Bus device secondary address. |
|
4 |
[en] created |
[en] Fixed field. Data row contains the date/time of the data row. |
|
5 |
[en] value-data-count |
[en] Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc. |
|
6 |
[en] manufacturer |
[en] Fixed field. Data row contains the M-Bus device three letter manufacturer code. |
|
7 |
[en] version |
[en] Fixed field. Data row contains the M-Bus device version. |
|
8 |
[en] device-type |
[en] Fixed field. Data row contains the M-Bus device type as string. |
|
9 |
[en] access-number |
[en] 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 |
[en] status |
[en] Fixed field. Data row contains the M-Bus device status field. |
|
11 |
[en] signature |
[en] Fixed field. Data row contains the M-Bus device signature field. |
|
[en] 12..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] These 6 fields are: [en] Unit [en] Description [en] Kind [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file with values for all product connected meters will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1113.csv.
[en] 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.
Tabell 261. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field. Data row contains the CMe/CMi product serial number. |
|
2 |
[en] device-position |
[en] Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID). |
|
3 |
[en] device-identification |
[en] Fixed field. Data row contains the M-Bus device secondary address. |
|
4 |
[en] created |
[en] Fixed field. Data row contains the date/time of the data row. |
|
5 |
[en] value-data-count |
[en] Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc. |
|
6 |
[en] manufacturer |
[en] Fixed field. Data row contains the M-Bus device three letter manufacturer code. |
|
7 |
[en] version |
[en] Fixed field. Data row contains the M-Bus device version. |
|
8 |
[en] device-type |
[en] Fixed field. Data row contains the M-Bus device type as string. |
|
9 |
[en] access-number |
[en] 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 |
[en] status |
[en] Fixed field. Data row contains the M-Bus device status field. |
|
11 |
[en] signature |
[en] Fixed field. Data row contains the M-Bus device signature field. |
|
[en] 12..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] These 6 fields are: [en] Unit [en] Description [en] Kind [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file with values for all product connected meters will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1114.csv.
[en] 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.
Tabell 262. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field. Data row contains the CMe/CMi product serial number. |
|
2 |
[en] device-position |
[en] Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID). |
|
3 |
[en] device-identification |
[en] Fixed field. Data row contains the M-Bus device secondary address. |
|
4 |
[en] created |
[en] Fixed field. Data row contains the date/time of the data row. |
|
5 |
[en] value-data-count |
[en] Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc. |
|
6 |
[en] manufacturer |
[en] Fixed field. Data row contains the M-Bus device three letter manufacturer code. |
|
7 |
[en] version |
[en] Fixed field. Data row contains the M-Bus device version. |
|
8 |
[en] device-type |
[en] Fixed field. Data row contains the M-Bus device type as string. |
|
9 |
[en] access-number |
[en] 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 |
[en] status |
[en] Fixed field. Data row contains the M-Bus device status field. |
|
11 |
[en] signature |
[en] Fixed field. Data row contains the M-Bus device signature field. |
|
[en] 12..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] These 6 fields are: [en] Unit [en] Description [en] Kind [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file with values for all product connected meters will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_valuereport_<time>_<report-id>.csv.
[en] Example of a file sent from a product with serial number 0006123456 at 2020-09-01 01:00:00:
[en] 0006123456_valuereport_20200901010000_1115.csv.
[en] 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.
Tabell 263. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field. Data row contains the CMe/CMi product serial number. |
|
2 |
[en] device-position |
[en] Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID). |
|
3 |
[en] primary-address |
[en] Fixed field. Data row contains the primary address of the M-Bus device. |
|
4 |
[en] device-identification |
[en] Fixed field. Data row contains the M-Bus device secondary address. |
|
5 |
[en] created |
[en] Fixed field. Data row contains the date/time of the data row. |
|
6 |
[en] value-data-count |
[en] Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc. |
|
7 |
[en] manufacturer |
[en] Fixed field. Data row contains the M-Bus device three letter manufacturer code. |
|
8 |
[en] version |
[en] Fixed field. Data row contains the M-Bus device version. |
|
9 |
[en] device-type |
[en] Fixed field. Data row contains the M-Bus device type as string. |
|
10 |
[en] access-number |
[en] 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 |
[en] status |
[en] Fixed field. Data row contains the M-Bus device status field. |
|
12 |
[en] signature |
[en] Fixed field. Data row contains the M-Bus device signature field. |
|
[en] 13..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] These 6 fields are: [en] Unit [en] Description [en] Kind [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
[en] 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 SMTP server. On execution of this report, one file per device (per meter) will be sent to the SMTP Server.
[en] Filename of the report data file sent to server is in the following format:
[en] <serial-number>_<device-identification>_valuereport_<time>_<report-id>.csv.
[en] 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:
[en] 0006123456_00112233_valuereport_20200901010000_1116.csv.
[en] 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.
Tabell 264. [en] Column header description
|
[en] Column index [en] (0 = first column) |
[en] Column contents |
[en] Description |
|---|---|---|
|
0 |
# |
[en] Fixed field indicating column header information line. |
|
1 |
[en] serial-number |
[en] Fixed field. Data row contains the CMe/CMi product serial number. |
|
2 |
[en] device-position |
[en] Fixed field. Data row contains a field that describes location or other information for identifying the meter (MOID). |
|
3 |
[en] primary-address |
[en] Fixed field. Data row contains the primary address of the M-Bus device. |
|
4 |
[en] device-identification |
[en] Fixed field. Data row contains the M-Bus device secondary address. |
|
5 |
[en] created |
[en] Fixed field. Data row contains the date/time of the data row. |
|
6 |
[en] value-data-count |
[en] Fixed field. Data row contains the M-Bus telegram number. 0 = first telegram, 1 = second telegram etc. |
|
7 |
[en] manufacturer |
[en] Fixed field. Data row contains the M-Bus device three letter manufacturer code. |
|
8 |
[en] version |
[en] Fixed field. Data row contains the M-Bus device version. |
|
9 |
[en] device-type |
[en] Fixed field. Data row contains the M-Bus device type as string. |
|
10 |
[en] access-number |
[en] 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 |
[en] status |
[en] Fixed field. Data row contains the M-Bus device status field. |
|
12 |
[en] signature |
[en] Fixed field. Data row contains the M-Bus device signature field. |
|
[en] 13..n |
[en] |
[en] Value description information. This information describes the exact contents of this column. Depending on meter, one or more value description columns are added. [en] The value description contains 6 fields delimited with comma. These fields provide the exact meaning of the contents of this column. [en] These 6 fields are: [en] Unit [en] Description [en] Kind [en] Tariff [en] Sub unit [en] Storage number [en] Please see Report Template Reference Information for complete description of these fields. |
|
[en] Example of first line in file with column headers |
|---|
|
[en] |
|
[en] Example of value data lines |
|---|
|
[en] |
|
[en] Example of file with all contents |
|---|
|
[en] |
Kommentarer (0 kommentarer)