FTP Templates
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 of the report data file sent to server is in one of the following format depending on single file or one file per device.
<serial-number>_<report-type>_<time>_<report-id>.csv for single file
<serial-number>_<meter-serial-number>_<report-type>_<time>_<report-id>.csv for one file per meter
Example 4. FTP single file
Some examples of file names sent with different report types, report IDs:
0006123456_installreport_20100901010000_2001.csv
0006123456_eventreport_20100901010000_2005.csv
0006123456_logreport_20100901010000_2006.csv
0006123456_statusreport_20100901010000_2007.csv
0006123456_valiuereport_20100901010000_2101.csv
Example 5. FTP File per device
Examples of three different value report IDs, 2109, from a product with serial number 0009123456 with three attached meters 87654321, 87654322 & 87654323 at 2010-09-01 01:00:00.
0006123456_87654321_valuereport_20100901010000.csv
0006123456_87654322_valuereport_20100901010000.csv
0006123456_87654323_valuereport_20100901010000.csv
The file contains rows. Each row contains the origin of the value and the actual value for a specific time.
Table 205. Column header description
Column index (0 = first column) |
Column contents |
Description |
---|---|---|
0 |
|
Product serial number |
1 |
|
The device (meter) secondary address |
2 |
|
The date/time of this value. Format: YYYY-MM-DD hh:mm:ss |
3 |
|
The M-Bus telegram number from which this record is taken |
4 |
|
M-Bus raw data, starting with M-Bus CField. Stop character and checksum of the M-Bus telegram is excluded. |
Example of file contents |
---|
|
The file contains a column header line and key value pairs of information.
Table 206. 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 207. Value line definition
Column index (0 = first column) |
Column contents |
Description |
---|---|---|
0 |
|
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 |
The file contains a column header line and log information lines.
The log level can be changed using configuration key common.syslog.level.
Table 208. 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 209. Value line definition
Column index (0 = first column) |
Column contents |
Description |
---|---|---|
0 |
|
Serial number of the product |
1 |
|
The date/time for this log information line. Format: YYYY-MM-DD hh:mm:ss |
2 |
|
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 |
|
Log information message in clear text. |
The file contains a column header line and key value pairs of information.
Table 210. 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 211. Value line definition
Column index (0 = first column) |
Column contents |
Description |
---|---|---|
0 |
|
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 |
Example of 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 212. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all contents |
---|
|
The file contains rows. Each row contains the origin of the value and the actual value for a specific time.
Table 213. Column header description
Column index (0 = first column) |
Column contents |
Description |
---|---|---|
0 |
|
Product serial number |
1 |
|
The device (meter) secondary address |
2 |
|
The date/time of this value. Format: YYYY-MM-DD hh:mm:ss |
3 |
|
The M-Bus telegram number from which this record is taken |
4 |
|
M-Bus raw data, starting with M-Bus C-Field. Stop character and checksum of the M-Bus telegram is excluded. See Annex 1 for Wireless telegrams. |
Example of file contents |
---|
|
The file contains rows. Each row contains the origin of the value and the actual value for a specific time.
Table 214. Column header description
Column index (0 = first column) |
Column contents |
Description |
---|---|---|
0 |
|
Product serial number |
1 |
|
The device (meter) secondary address |
2 |
|
The date/time of this value. Format: YYYY-MM-DD hh:mm:ss |
3 |
|
The M-Bus telegram number from which this record is taken |
4 |
|
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 |
---|
|
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 215. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 216. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 217. 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 |
mbus-raw-value |
M-Bus raw data, starting with M-Bus C-Field. Stop character and checksum of the M-Bus telegram is excluded. |
Example of first line in file with column headers |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 218. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 219. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 220. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 221. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 222. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 223. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 224. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 225. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all 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 226. 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 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 |
---|
|
Example of value data lines |
---|
|
Example of file with all contents |
---|
|
Comments (0 comments)