kpfriedberg wrote:jay wrote:That probably means you didn't turn on sql logging until today...
true, but how often does it update? it doesn't poll hourly or something?
kpfriedberg,
I had the exact same startup problems as you (see earlier in thread): extra folder, lower case in the URL, and enabling sql logging for the first time on the day I installed this plugin.
The usagereporter has been running smoothly since day two (meaning since the day after I enabled sql logging) Also, see berkinet's midnight applescript,
supra.Until someone with computer talent and knowledge offers something much better, I've been pulling the reports into a Numbers spreadsheet. Although rather tedious to manually import each day's report, then apply a filter to remove motion detectors and other devices, the cumulative data is very interesting and useful to me.
The spreadsheet includes a table with the actual, maximum wattage of each device along with my estimates of each device's typical (i.e. dimmed) wattage the reports include projected yearly costs to run each device / light. (The spreadsheet calculates actual kWh's used, then projects to 30 days and 1 year using my current electric rate). It's starting to show clear trends of usage, allowing me to identify high priority areas where I can cut electricity usage along with best solutions based upon location and usage patterns: (1) changing to CFL or LED, (2) adding auto-off triggers, or (3) changing default brightness levels.
mjc