Yes, I know that I can correct the database, my question is which entry should be changed? The 'Counter' number is (I think) the total of m3 gas * 1000 that the P1 picks up from the meter. So in my old house the number was 3117.214 m3 and in the new house 3654.233 on date 2025-02-13.
537 m3 ...
Search found 2 matches
- Friday 13 February 2026 19:40
- Forum: Utility
- Topic: Correcting database month total value
- Replies: 3
- Views: 43
- Friday 13 February 2026 14:53
- Forum: Utility
- Topic: Correcting database month total value
- Replies: 3
- Views: 43
Correcting database month total value
Last year february 12 I moved house. Now these values are in the database causing a huge usage in feb 2025:
sqlite> SELECT * FROM Meter_calendar WHERE DeviceRowID=8 AND Date>='2025-01-28' AND Date<'2025-03-08';
DeviceRowID|Value|Counter|Date
8|2534|3087874|2025-01-28
8|1387|3089261|2025-01-29
8 ...
sqlite> SELECT * FROM Meter_calendar WHERE DeviceRowID=8 AND Date>='2025-01-28' AND Date<'2025-03-08';
DeviceRowID|Value|Counter|Date
8|2534|3087874|2025-01-28
8|1387|3089261|2025-01-29
8 ...