Tus neeg siv phau ntawv

10/2021 · User Manual Version 1.0 · valid from firmware version 3.1.22
38
WEBLOG 250
5. Export files
The WebLog is able to export logged M-Bus data with XLSX, CSV or structured XML file format.
The above example shows an excerpt of an XLSX file opened in Microsoft Excel with the file name
“export_WEBLOG_Export1_20140924_003416.xlsx“. All export files are named using the scheme:
„export_LoggerID_ExportName_ExportDate_ExportTime.Filetype“. The header in the export file itself
contains the export date, the export name and the Logger ID (site identification). The start and end time point
of the logged data are also part of the header.
The next line gives the column headers for the exported data. The example “Export2” includes the values for
energy and volume of alls meters. The data for energy and volume and the corresponding units are each in
separate rows. If the telegram of a meter contains historic values (storage no. > 0), tariff values (tariff > 0) or
values from functional sub devices (subdevice > 0) these values will be in separate lines. You can define the
maximum numbers for storage no., tariff and subdevice to be included in the export (see chapter 4.1.7 “Export
Filter”). The vertical order of lines is defined by the time points of the logged data.