Hello there,i got a shelly 3EM configured with 3 phases here in greece,i was using Mqqt data of the shelly 3em for a long time when suddenly my home assistant pc crashed without any backup,what does that mean? That means when i fresh installed everything i was getting VIA mqtt the last total data of each phase in (WH).
Im trying now to merge the old data with the new data,im doing that via downloading the csv file from each phase and format it such as the influx db wants.The problem is that the shelly Csv data Is not correct,im getting more WH from the csv file with 3h of data missing than the actual "LIVE" mqtt feed
kWh,domain=sensor,entity_id=3em_l1_total_kwh_mqtt value=2281207.19 1663333980 <- THIS iS THE LAST VALUE OF L1 FROM THE SHELLY CSV WITH 3H DELAY FROM MQTT
total = 2214167.3 <---AND THIS IS THE LAST MQTT MSG I GOT...How is it posible to have more kwh consumption before than now...something is really wrong
On the L3phase im Getting this difference.
,domain=sensor,entity_id=3em_l3_total_kwh_mqtt value=10618697.83 1663345320
kWh,domain=sensor,entity_id=3em_l3_total_kwh_mqtt value=10618767.33 1663345380
kWh,domain=sensor,entity_id=3em_l3_total_kwh_mqtt value=10618837.03 1663345440
kWh,domain=sensor,entity_id=3em_l3_total_kwh_mqtt value=10618906.63 1663345500 <- THIS IS THE LAST VALUE OF L3 FROM THE SHELLY CSV WITH 3H DELAY FROM MQTT
10925978.8 <----------------- THIS IS THE LAST VALUE OF L3 FROM MQTT JUST MINUTES AGO
300KWH MORE!!! HOW?My point is that something really bad happens when we are downloading the csv files,developers must check this and there is no solution to this,im putting this right here so the devs can check it,i run the same procedure to my friends shelly 3em and he has the same issue,nobody has mention this before (at least as much as i searched nobody had this problem) cause nobody tryed to import csv files into influxDB.
The conclusion is that the CSV data of EACH phases are wrong,Or the mqtt is wrong but i doubt that.
P.S i check the format is something is missing and its not,i checked the original CSV file with excelll and i have the same reasult,Its just a wrong algorithm that downloads and build the Wh data on the shelly? i dont know..