Fibaro Event Panel data to a MySQL Database

[remcoploeg 10]

I really don't like the eventpanel of the Fibaro interface. It's slow and unable to get good statistics.

I want to store this data into an own database to get statistics and show information about my system to other users. Has somebody already created a php or other solution to get the data into a database? I have seen the Excel macro, but I want to have a direct input.

thanks

[Lockzi 1]

I really don't like the eventpanel of the Fibaro interface. It's slow and unable to get good statistics.

I want to store this data into an own database to get statistics and show information about my system to other users. Has somebody already created a php or other solution to get the data into a database? I have seen the Excel macro, but I want to have a direct input.

thanks

One possibility is to root the HC2 and get direct access to the MySQL database that Fibaro already stores the information in and have your "php or other solution" connect to fibaro's mysql database to retrieve the latest info.

[A.Socha 133]

Lockzi, hc2 don't use mysql :]

and what about using api?

last y events (example for 30 records)

Please login or register to see this code.

records from x time to y time (x and y in timestamp)

Please login or register to see this code.

when you got php you only download json and you working on it

[Dalle1985 16]

I built a script which does what you want - but you should be aware that it puts quite a bit of strain on your system. Especially as event log handling seems quite labor intensive on the HC2.

But it is quite simple to set up a script which will request the last hours events and then input it into a MySQL database for handling afterwards. If you are using a linux box as your server, you just set up a CRON job which runs hourly and then forward the last hours data to the database.

I can see if I have the script somewhere - unfortunately it got lost in a server crash, and that particular script (along with the entire MySQL database) was not part of my backup

Please login or register to see this image.

/emoticons/default_icon_redface.gif" alt=":oops:" />

Otherwise, just create a php script something like this:

Please login or register to see this code.

Very simple code and some good tutorials available on the web in case your php'sk isn't too strong. But I'll just check if I should have the script lying around somewhere.

[remcoploeg 10]

Dalle1985,

I am not a programmer, so if you have the example

Please login or register to see this image.

/emoticons/default_smile.png" alt=":)" srcset="https://forum.fibaro.com/uploads/emoticons/[email protected] 2x" width="20" height="20" /> I am running a synology, so I can run php

[MWDK 1]

remcoploeg - did you get the script? Im interested in making something for my Synology NAS aswell

Event Panel sucks - tbh!