zibous
commented
2 years ago It looks like you're running it for the first time.
As a result, the last value is 0 and that is why the current Hour and Day are so high.
You can correct the initial calculation by adjusting the values in config.py.
# data model smartmeter
WATERMETER_DATA = {
"name": SMARTMETER_NAME,
"device": "watermeter",
"deviceid": SMARTMETER_ID,
"date": "",
"time": "",
"total_m3": 0.00, <--- init value
"ratio": 0.00,
"m3": {
"current": 0.000, <--- init value
"hour": 0.000, <--- init value
"day": 0.000, <--- init value
"month": 0.000, <--- init value
"year": 0.000 <--- init value
},
"liter": {
"current": 0.000, <--- init value
"hour": 0.000, <--- init value
"day": 0.000, <--- init value
"month": 0.000, <--- init value
"year": 0.000 <--- init value
},
"last_total": {
"hour": "2020-14-09",
"hour_m3": 0.000,
"day": "2020-07-14",
"day_m3": 0.000,
"month": "2020-07",
"month_m3": 0.000,
"year": "2019-12-31",
"year_m3": 117.730
},
"wmbusmeter": "",
"alarm": "No alarm",
"last_alarm": "No alarm",
"periode": now.strftime(DATEFORMAT_DAY),
"month": now.strftime(DATEFORMAT_MONTH),
"year": now.strftime(DATEFORMAT_YEAR),
"timestamp": now.strftime(DATEFORMAT_TIMESTAMP),
"last_update": now.strftime(DATEFORMAT_CURRENT),
"elapsed_time": 0,
"icon": "mdi:billboard",
"unit_of_measurement": u"\u33A5",
"last_reset": "1970-01-01T00:00:00+00:00",
"state_class": "measurement",
"device_class": "energy",
"version": APPS_VERSION,
"attribution": "Data provided by Peter Siebler"
}The calculation is done:
result = current value - previous value
see:
self.cd['m3']['current']=round(meterM3 - float(self.pd['total_m3']), 3)
self.cd['m3']['hour']=round(meterM3 - float(self.pd['last_total']['hour_m3']), 3)
self.cd['m3']['day']=round(meterM3 - float(self.pd['last_total']['day_m3']), 3)
self.cd['m3']['month']=round(meterM3 - float(self.pd['last_total']['month_m3']), 3)
self.cd['m3']['year']=round(meterM3 - float(self.pd['last_total']['year_m3']), 3)
# caclulate the liter
self.cd['liter']['current']=round(float(self.cd['m3']['current']) * 1000.00, 2)
self.cd['liter']['hour']=round(float(self.cd['m3']['hour']) * 1000.00, 2)
self.cd['liter']['day']=round(float(self.cd['m3']['day']) * 1000.00, 2)
self.cd['liter']['month']=round(float(self.cd['m3']['month']) * 1000.00, 2)
self.cd['liter']['year']=round(float(self.cd['m3']['year']) * 1000.00, 2)The first time the values are taken from the config.py and then from the data/4113f6d2.json file the next time it is run through.
Should change on the next run. You can check the whole thing with MQTT Explorer. https://mqtt-explorer.com/
nayspl
Running on latest github version output.json:
}
I'm not python expert but from my understanding code looks OK. Dont know where is an issue...
Config from config,py:
date and time formats
DATEFORMAT_TIMESTAMP = '%Y-%m-%dT%H:%M:%SZ' DATEFORMAT_CURRENT = '%Y-%m-%d %H:%M:%S.%f' DATEFORMAT_HOUR = '%H' DATEFORMAT_DAY = '%Y-%m-%d' DATEFORMAT_MONTH = '%Y-%m' DATEFORMAT_YEAR = '%Y-%m' TIME_FORMAT = '%H:%M:%S'
application settings
SMARTMETER_ID = '4113f6d2' # internal used smartmeter identification SMARTMETER_NAME = 'Woda Dom' # Name of the smartmeter APPS_VERSION = '1.0.3' # Application version
Datafile, if defined every hour the data will be stored as csv to this location
DATAFILE = os.path.join(os.path.dirname(file), 'data/' + SMARTMETER_ID + ".json")
Reportfile, if defined every end of month data will be saved to this location
DAYREPORTFILE = os.path.join(os.path.dirname(file), 'data/' + SMARTMETER_ID + "-day-report.csv")
Reportfile, if defined every end of month data will be saved to this location
REPORTFILE = os.path.join(os.path.dirname(file), 'data/' + SMARTMETER_ID + "-report.csv")
all for the mqtt brocker
MQTT_HOST = '192.168.1.192' # mqtt brocker host ! must be a string MQTT_PORT = 1883 # mqtt brocker port ! must be a number MQTT_APPID = '*' # mqtt brocker user name MQTT_PASSWORD = '****' # mqtt brocker user password MQTT_KEEPALIVE = 60 # mqtt brocker keep alive time
all topic settings
test: mosquitto_sub -h localhost -p 1883 -u 'pi' -P 'raspberry' -v -t 'tele/wasser/verbrauch'
MQTT_TOPIC = 'tele/wasser/verbrauch' # listen to this wmbusmeters topic
all application publish topics
MQTT_TOPIC_NAME = 'IZAR' MQTT_PUBLISH_TOPIC = 'tele/' + MQTT_TOPIC_NAME + '/wasser' # used for publishing new data MQTT_STATE_TOPIC = 'tele/' + MQTT_TOPIC_NAME + '/wasser/status' # mqtt state topic MQTT_AVAILABILITY_TOPIC = 'tele/' + MQTT_TOPIC_NAME + '/LWT' # mqtt availability topic Online | Offline MQTT_ENABLE_LOGGING = False # enable | disable debug logging mqtt
switch logging
LOG_LEVEL = 10 # DEBUG: 10
LOG_LEVEL = 20 # INFO: 20
LOG_LEVEL = 30 # WARNING: 30
LOG_LEVEL = 40 # ERROR: 40
LOG_LEVEL = 50 # CRITICAL: 50
LOG_LEVEL = 100 # DISABLED: 100
LOG_DIR = './logs/'
write summary data to console
DATALOG_ENABLED = True # enable True | False, writes datalog to console DATALOG_FILENAME = './logs/data.csv' # output folder for data log
data.csv file doesn't create as well i don't see any datalog on console too