Meter interval reading (indices) file format
This file is used to import monthly, daily, and hourly water meter index reading data. An index reading is the current index state of the meter at a specific point in time.
File name mask
The following file name convention is supported for index reading files:
*Indices.csv
Import behavior
The records are read in groups of consecutive records that belong to the same meter. After parsing and format validation, the read record groups are processed individually. If a line cannot be parsed because of a format error, or a record group cannot be imported, then the error will be logged and the import will continue with the other records and files. If multiple records are received for the same meter and the same time frame, the last record will overwrite the previous one in the database. If a reading is received for a meter that has not yet been imported, the system will populate the record immediately and save the imported index or consumption value(s).
If the ServicePointId is given in the file, then it will be checked before the import. In the case of a mismatch with the data in the database, a warning-level message will be logged; however, the import of the record will succeed.
Tip: If possible, all records belonging to the same water meter should be kept together in a single file. This can significantly improve the import speed.
File format
The following table describes the columns that comprise the indices CSV file.
|
Field Name |
Description |
Priority |
Data Type |
Constraints |
Unit |
Allowed Values |
|---|---|---|---|---|---|---|
|
ServicePointId |
The unique identifier of the service point. |
Recommended |
string |
Max length: 50 characters |
||
|
MeterId |
The unique identifier of the meter that is currently installed at the service point. |
Required |
string |
Max length: 50 characters |
|
|
|
Index |
The meter index as a double value. |
Required |
double |
|
The unit should be defined at the service point. Otherwise, it defaults to TODO. |
|
|
ReadingTime |
The time of the reading. |
Required |
datetime |
|
See Supported CSV features. |
File example
The following is an example of an index reading CSV file:
servicepointid meterid index readingtime 1705749489 D08TA242123 374.72300 19/12/2020 01:00:00 1705749489 D08TA242123 376.72300 20/12/2020 01:00:00 1705749489 D08TA242123 381.72300 21/12/2020 01:00:00 1705749490 D08TA242177 .72300 2020-12-19T02:00:00 1705749490 D08TA242177 11111111 2020-12-19T03:00:00-06:00 1705749490 D08TA242177 374.72300 2020-12-19T10:00:00Z 1705749500 D08TA242333 374.72300 19/12/2020 05:00:00