So my Shelly EM failed, the energy database stopped receiving data. I replaced with a Shelly Pro 3EM and now getting energy data again. Is there a way to recover the old energy data for the old device and merge it to the new device?
If you change your new entity_id to the same id as your old entity, it will keep the old entity statistics and start recording new statistics to that ID and continue from there.
If some time has passed and you have data in both the old and new entity_id that you want to save, there’s no easy way to save both without manually editing the SQLite tables.
There has to be a way to import and merger data. Isn’t there?
Not easily.
I studying the SQLite database site currently. Yes it will be a work. But will be neat when I get it done