import historical data

---

Hi, I’ve been using Pimatic for quite a while with the AtHome plugin which sends data from a RF sensor network via serial connection to Pimatic devices. Now I’m switching over to MQTT using MQTT-simple plugin. This works very well.

In parallel I’m storing all collected data in logfiles for archiving purposes. The idea is, to load all this historical data into a freshly installed pimatic instance (e.g. after a crash or when setting up a new system from scratch. I checked the API but could not find any function that allows to update a variable together with a timestamp, just like {“timestamp”:1456707600,“sensorName”:“OutdoorTemperature”,“value”:25.3}.

Does anybody have a solution for this? Would it be possible to simply post such historical data directly into the SQLite instance so that a new Pimatic can show all the old data as well?

Thanks a lot in advance.
Arwed

@arwed Hi. One solution may be to import/export data to/from the database. Note, you can also fine tune the data base storage: You can set for how long a variabke should be kept in the database and how often it should be updated.