I have vera 2 set up with several smartswitches that also report their energy usage. I can currently log on to mios to see this energy usage, which is useful but doesn’t give me the flexibility to modify graphs, set up reports etc.
How do I access the energy figures (and historical data) directly off my vera2 so that I can then plug that in to a simple reporting engine such as excel?
I’m also interested in this! Anyone?
It’s not easy. Read on for a taste of what you would have to do.
Instantaneous energy usage can be seen on the Advanced tab under the variable “Watts”.
Recent high/low energy usage can be seen on the Advanced tab under the variable “Log”.
This data is then uploaded to cp.mios.com and discarded by Vera. History is not stored on the Vera (there isn’t room, and flash memory can’t sustain such repeated writes to it).
You could (write HTTP client code to) query the Watts and Log values periodically on a real computer, and append the value to a file on the real computer’s hard disk.
Or you could use the dataMine plugin (search this forum) to semi-automate the process on the Vera.
what do u mean is that i can’t know how much a device has energy consumed for this week for example?
unless i write a http code
so vera GIVES only Kw and not Kwh right?
Instantaneous consumption and not accumulative usage?
Yes, that’s essentially correct.