Can HC3 send data to Influxdb with Telegraf?

[JcBorgs 52]

Relatively new to this and can’t get it to work, have searched in other places/forums but can’t find any good information so hoping for some guidance here.

 

I have a HC3 and two RaspBerry Pi 4, one running 32bit OS and the other 64bit OS.

 

Have now tried on both of them to first setup InfluxDB  (version 1.8.4 on the 32bit and version 2.0.4 on the 64bit), so far so good and that piece seems to be working. Then I want to get the HC3 to send data into InfulxDB and saw that Telegraf has a Fibaro plug-in. Had some hassle to configure it, mostly on the 64bit Raspberry. But eventually got it installed on both, but here my problem start.

 

Both InfluxDB and Telegraf reports as active and running in both of the Raspberry’s. But as soon as I add configuration for the Fibaro plug-in in Telegraf I start to see messages when checking the Telegraf Status that there is an Error, something related to JSON not being able to pharse a “value.dead” as string (will copy the exact error message in a later post).

 

But my first questions are:
1. Is the Fibaro Plug-in in Telegraf compatible with the HC3 or is it intended to be used with the HC2?

2. Are there any alternative methods of getting the HC3 to log data to the InfluxDB?

3. Anyone with a similar working setup that can share some config examples? (Setup = HC3 logging to InfluxDB with Telegraf)

[hater 43]

push data from scene to Infulx. i think it better than polling from grafana / telegram HC3.

you can use this scene

 

Please login or register to see this code.

 

base usage:

 

saveByDeviceID("flow", 2116, "value")

 

"flow" - just metric name in influx

2116 - device id what u wish to persist

"value" - just device value. you can use any support directives here like "batteryLevel" / "power" etc.

 

Please login or register to see this attachment.

Please login or register to see this attachment.

 

 

[JcBorgs 52]

Thank you for quick and detailed answer!

 

One thing I don’t get about your scene:

The first line under — Power

fibaro.call (1141, ’poll’)

 

What does that do and in your setup what kind of device/scene/etc. are 1141?

 

Otherwise the scene seems rather straight forward, will definitely test it out.

 

Edited March 6, 2021 by JcBorgs

[JcBorgs 52]

Ok, this works like a charm.

Did select a few devices and logged the batteryLevel from them to the InfluxDB..

 

(still curious about the fibaro.call (1141, ’poll’), what does it do and what device is 1141?)

Edited March 6, 2021 by JcBorgs

[twanve 18]

2 hours ago, JcBorgs said:

Ok, this works like a charm.

Did select a few devices and logged the batteryLevel from them to the InfluxDB..

I use also this code, but how I get the batteryLevel in InfluxDB, have you an example....

saveByDeviceID("Battery", xxxxx, "????")

 

Edited March 6, 2021 by twanve

[JcBorgs 52]

I do it by this example:

 

SaveByDeviceID(“Battery”,1234,”batteryLevel”)

 

[hater 43]

3 hours ago, JcBorgs said:

 

(still curious about the fibaro.call (1141, ’poll’), what does it do and what device is 1141?)

some crazy devices like HEM3

it's still works in HC ugly.

[mariokil 11]

Hi guys,

I was able to run the script and save the data to influxdb. Unfortunately, I can't cope with having the status of devices sent from fibaro-> influxdb regularly. To get the next batch of data I have to run the scene manually each time.
Any idea how to solve/workaround this is more than welcome
Thank you.

[hater 43]

7 minutes ago, mariokil said:

To get the next batch of data I have to run the scene manually each time.

witam. nie wiem ale mam pomysl  

 

Please login or register to see this code.

 

[mariokil 11]

1 minutę temu, hater napisał:

witam. nie wiem ale mam pomysl

Ok, dzięki. Postaram się sprawdzić

Thank you, Ill check this

[mariokil 11]

3 godziny temu, hater napisał:

{ conditions = { { isTrigger = true, operator = "match", property = "cron", type = "date", value = { "*", "*", "*", "*", "*", "*" } } }, operator = "all" }

It works

Thank you ✌

[Laco Jurdik 8]

I solved it easily.
I ran OS Home Assistant on my Synology virtual machine.
Link:

Please login or register to see this link.

OS Home Assistant contains many applications as well as a database of infuxdb and grafan.
I added my fibaro HC3 to Home Assistant where it loaded all the devices.

Now everything from Home Assistant and Fibaro HC3 writes to my influx db database.

I also used an android tablet with the HomeHabit app on the wall.

Please login or register to see this attachment.

Please login or register to see this attachment.

Please login or register to see this attachment.

[mariokil 11]

W dniu 6.03.2021 o 13:01, hater napisał:

Please login or register to see this code.

 

Hi,

fortuanetly LUA scen works (almost) fine. Above part of script shows only defaulte sensors assigned to specific room. How to get value for other devices for the same room which are not "default" ?

 

thank you for any suggestion

Edited March 15, 2021 by mariokil

[hater 43]

22 hours ago, mariokil said:

 

Hi,

fortuanetly LUA scen works (almost) fine. Above part of script shows only defaulte sensors assigned to specific room. How to get value for other devices for the same room which are not "default" ?

 

thank you for any suggestion

saveByDeviceID("garage_lighting", 927, "value")