Fibaro Temp Data

[Al3x 2]

Is there anyway to automate the export of the firbaro temp data? i have so many temp sensors in my property i am only getting two days worth of stats because its hitting the 500,000 event limit?

[petergebruers 1,268]

1 hour ago, Al3x said:

Is there anyway to automate the export of the firbaro temp data?

They only popular way posted on this forum (and used by me) is running scripts to transfer data to InfluxDB

 

Please login or register to see this link.

 

Then use the reporting tools that were introduced in newer versions or use the very popular "Grafana"

 

Please login or register to see this link.

 

If you put "influxdb" in the search field on the forum...

 

I have not posted my InfluxDB script because there are a few ways to store your data in that very specific database. When I developed my solution, I tried 5 (five) different ways and chose the one that allowed me to get data from multiple sensors at once. Newer versions of InfluxDB support "joins" using a new query language but when I started with this DB (around version 1.2) that does not exist. This limitation confused many users, because the syntax looks like SQL you kind of expect "join" to be a standard feature.

 

1 hour ago, Al3x said:

i have so many temp sensors in my property i am only getting two days worth of stats because its hitting the 500,000 event limit?

Ermmm... IIIRC the HC2 "event" table is limited to 40k events (it auto cleans every 24h), and the temp/power table has higher limit. That might explain why you only see 2 days. I have 90 nodes and can store 7-14 days so you seem to have quite a lot more reporting sensors. That's OK if you do not have issues but if you see unexpected delays, it might be worth investigating. Maybe turn down reporting "a notch". Not sure about data storage on HC3, I kept my transfer to InfluxDB (with a few changes due to new event reporting).

 

[RiccardoCanetta 13]

Hi, I use a VD button to push data to thingspeak and a scene to press that button every 30 mins. Here is the VD code:

 

Please login or register to see this code.

Then in thingspeak you can do all the analysis you like (including comparing different rooms' temperature using matlab) and you can also export all your history to excel. Plus, you can also setup thingspeak to trigger a webhook in IFTTH that sends you an email in case HC2 doesn't report temp data for 2 hours - this is useful to have an alert if something is going wrong.

 

Hope it helps!
R

Edited May 26, 2020 by RiccardoCanetta

[RH_Dreambox 189]

Here is a fantastic guide to getting started with Influx and Grafana.
I run this with @10der HC2 script, and it works amazingly well.

 

Getting started with Influx and Grafana

Please login or register to see this link.

@10derHC2 script

Please login or register to see this link.

[SmartHomeEddy 1,005]

On 5/26/2020 at 11:17 AM, petergebruers said:

I have not posted my InfluxDB script because there are a few ways to store your data in that very specific database. When I developed my solution, I tried 5 (five) different ways and chose the one that allowed me to get data from multiple sensors at once.

I am experimenting with InfluxDB and Grafana.  Now I just put the values of some devices every minute in Influx. But there are better ways I think. 
 

 What are your finding, in the way you get the values in Influx?