Reading Event Log into SQL database

[rajp 14]

Hi

 

At present, I am running 4.033 and have always found that the Event Panel does not hold sufficient history. At max, it seems to hold 2 days worth of data. While trying to scroll thru 2 days worth of events, I find that the Event Panel is non respondant some times.

 

This is wholly insufficient for creating any analytics on temperature/humidity history as well as other alerts. I am sure it would be possible to read this information into a SQL database or even access and then we could use it for creating more analytics.

 

I raised a ticket with [email protected] and their answer was plain and simple. "You cannot check these data. You can check it in Event Panel, or Consumption".

 

Is anyone aware of any ways of running a batch that I can setup which would query this info using LUA and then dumping it into a SQL table?

 

Thanks

Raj

[petergebruers 1,268]

I certainly don't contradict Fibaro, there is no "export" or "dump" button. But maybe you can use the API. I can't help you with a batch file but I can point you in the right direction. You can query your HC2 doing http requests. The result will be JSON encoded. You can test in your browser:

Please login or register to see this link.

. Timestamp is the decimal representation of a point in time by lua, i.e. number of seconds since 1970

Please login or register to see this link.

For example, on my system:
 

Please login or register to see this link.

Please login or register to see this code.

[rajp 14]

 

I certainly don't contradict Fibaro, there is no "export" or "dump" button. But maybe you can use the API. I can't help you with a batch file but I can point you in the right direction. You can query your HC2 doing http requests. The result will be JSON encoded. You can test in your browser:

Please login or register to see this link.

. Timestamp is the decimal representation of a point in time by lua, i.e. number of seconds since 1970

Please login or register to see this link.

For example, on my system:

 

Please login or register to see this link.

Please login or register to see this code.

Thank you.. will have a look at this..

 

There is a utility that someone has created that allows you to read information about the Fibaro HC2 and all the components like device/scenes etc which are associated with it. I had it on my PC but lost it due to having to rebuild the PC.

[petergebruers 1,268]

Thank you.. will have a look at this..

 

There is a utility that someone has created that allows you to read information about the Fibaro HC2 and all the components like device/scenes etc which are associated with it. I had it on my PC but lost it due to having to rebuild the PC.

 

Do you mean this: 

Please login or register to see this link.

?

[rajp 14]

Do you mean this: 

Please login or register to see this link.

?

Thanks very much.. that's the one...

[remcoploeg 10]

Did you already have a solution for this? I am missing a lot of data because the Fibaro doesn't store the data long. 

[rajp 14]

Did you already have a solution for this? I am missing a lot of data because the Fibaro doesn't store the data long.

No. Haven't had a chance to investigate this further as other commitments have kept me away from much of the automation...