Zählen Sie Stunden der Lichtnutzung

[Jujonet]

Freundlich übersetzt von Google. Englisch Version unten


Hallo

Ich versuche, das Licht in meinem Haus (KNX powered) mit einem Pi zu verfolgen.
Ab jetzt kann ich den Gruppenadressstatus erfassen, und sagen wir, ich kann für jeden Switch eine Datei haben, in die ich den Switch-Status schreiben kann (sagen wir 1 Fall ist an und 0 Fall ist aus). Außerdem könnte ich mich bei jedem Wechsel des Switches in eine Datei einloggen, so dass ich eine Datei mit dem folgenden Format hätte:

Datum / Uhrzeit - Schaltzustand


All das oben mit knxd + lynknx getan


Was ich gerne machen würde, um schöne Graphen zu erstellen, um die Anzahl der Stunden zu wechseln, wurde für die letzten 7 Tage / letzten 4 Wochen / letzten 12 Monate usw. verwendet. Etwas wie rrdtool, grafana etc ..... aber diese sind nicht (soweit ich weiß) für diese Art der Nutzung gedacht .....

Jeder könnte mich in die richtige Richtung weisen?


Entschuldigung für meine Notwendigkeit, Google Übersetzer zu verwenden


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Hello

I'm trying to track the light use in my house (KNX powered) using a pi.
As of now I'm able to capture the Group Address state, and let's say I can have a file for each switch where I can write the switch state (let's say 1 case is on and 0 case is off). Furthermore I could log to a file each time the switch is changing so I would have a file with the following format:

date/time -- switch state


All of the above done with knxd + lynknx


What I would like to do is to plot some nice graphs in order to track for each switch the number of hours has been used for the last 7 days / last 4 weeks / last 12 months etc.... Something like rrdtool, grafana etc..... but those are not intented (as far as I know) for this kind of usage.....

Anyone could point me in the right direction?

[bmx]

All of the above done with knxd + linknx

What I would like to do is to plot some nice graphs in order to track for each switch the number of hours has been used for the last 7 days / last 4 weeks / last 12 months etc.... Something like rrdtool, grafana etc..... but those are not intented (as far as I know) for this kind of usage.....

Anyone could point me in the right direction?

I am not sure if it helps you with linknx but you can do this stuff with SmartHomeNG. E.g. there is a plugin for influxdb which can serve its data to grafana.
You can however also use a sqlite or mysql database with the database plugin and use SmartVISU for visualisation of the graphs.

You can try it out using a Raspi Image available for download.

Regards,
Bernd

[Jujonet]

Thanks a lot for the answer.
Do you mean that influxdb+grafana are able to count the hours of a particular device usage?

Rgds

[bmx]

I did not try that with influxdb + grafana. I would do that within SmartHomeNG. I'd put a trigger on the item to watch for usage and each time it goes off I would query the time since last change and add that up with another item.
Influxdb is a database especially for measurement data. If a query within grafana supports it to sum up times then this should be fine, too.

[MarcusF]

Some KNX switch actuators (for example my Hager TXA207C) have an operation hour counter, which can be read out. This would be the easiest way.

[Jujonet]

Como de costumbre, la manera más simple es la más eficiente, ¡y no puedes reinventar la rueda!
Eso significa que acabo de encontrar que mis actuadores tienen la misma característica.
Por lo tanto, supongo que solo tengo valor GA y lo escribo en cactus. Además, con un cdef no solo puede usar las horas sino también los Watts utilizados.

¡Muchas gracias!

[Jujonet]

For any unknown reason Chrome translated into Spanish what I said in English :-(

I stated the the most efficient way is always the simplest, and just found out my actuators have the same feature.
In addition, just only have to input that GA value in cactis and with a simple cdef get the number of watts used.

Thanks a lot and sorry for the above.