Home Automation Domotica Forum Europe, Bwired Forum

Have made som interface for my databases now, with graphs. I kinda feel that I still have the need for a historical version of the devicestatus database. I have the 'datalog' table wich have power records by hour. This gives me powerconsumption, wich is ok with 60min interval. I have the 'devicestat...

What about a Autohotkey script that starts when user1 is logged in.

Autohotkey let you script events like mouse/keyboard input.

Shouldnt need many lines to send the key combinations for bringin up startmenu. click "switch user", click username and type pw, hit enter.

I liked that idea.. So i did like you..created new table and updated my script so that it updates the device_status table everytime the datalog table is updated.

I have it up and running now. Homeseer uploads the rfxmeter value on every devicechange. Producing one row each hour. with start and end values. One question for you again. On the site, ( http://www.hekkers.net/domotica/DeviceStatus.aspx ) I see the value for each sensor can be anything from a tempe...

Now I slowly start to understand your way of thinking, guys. Its only about to make som logic into the function that write the entry into the table. Because you will like to search up last entry from that specific device first to see if it allready exist. Thanks Robert and Pieter, this have "cl...

Hmm could you explain more detailed how you have start and end values, and how you use this for. e,x temperature? I mean, if i log temp one time each hour, what would you use both fields with the same value? I cant figure what u would use as start and end, since the timestamp represent a point in ti...

Thanks for your reply! I want to split it up, because the one containung current usage will be trunked (only contain last 30days os so) What did you mean with startvalue and end value? I was thinking that one line in the db would containing device_id, value, timestamp. (This is what i am doing now, ...

I would be very interested in this just to get started with plugwise and see if that is "usable" for me. Without having to spend €400

Contact me by mail if you still have not sold this ok?

espen (AT) gmx.no

Hello. First post here, so I might just spend a line or two to introduce me. I`m 25 years old boy from Norway, works as a IT consultant, mainly windows stuff, but spends some time with linux as well. I have a house wich I slowly try to make a "smarthome" as we say here in Norway. It all st...