Is there a way to force the usage plugin to update its database after making changes to the devices list in Indigo?

berkinet wrote:Is there a way to force the usage plugin to update its database after making changes to the devices list in Indigo?

No. The device name is what's logged in the SQLite DB, so if you change your device name it will appear as the new name moving forward. You could back and update it yourself.

Another feature of the plugin perhaps?

i am getting some strange readings now the

blue light should only show 180

Master Bedroom Lights should only show 15

and some others are not accurate


Device Name Minutes ON
Arch Lamp 914
Bathroom Hallway 0
Blue Light 1049
Front Outside Lights 848
Garage Lights 857
Green Lamp 307
Kitchen Breakfast Bar 45
Living Room 903
Main Kitchen FL 49
Master Bath Lights 832
Master Bedroom Lights 1010
Motion Sensor Doorbell 436
Office Lamps Den 882
Sensor Garage 436
Snake Light 135
TV Movie Lights 1929
Upper Hallway 981

When navigating to
http://127.0.0.1:8176/usageReporter
Safari says "undefined page requested"

Just installed this today. Is the error expected because it needs to run a day under the default of displaying yesterday's usage?

you need to stop the server then restart it that should work

artpics wrote:i am getting some strange readings now the

blue light should only show 180

Master Bedroom Lights should only show 15

and some others are not accurate

How are you determining what value should be shown? Is it by: 1) knowing how long you had them on, 2) checking the Indigo Event Log?

If a command was not seen by Indigo for some reason, then using technique #1 would show a different result. But if you are checking the time by searching all ON / OFF instances in the Event Log, then I would expect the durations to match.

#1

my blue light is on a time action for 180 mins each day i have 1010
the master bedroom was not on at all yesterday but i have 1820

very strange but on my post above this one with the screen shot the minutes seem correct.

here as you can see. most lights are on for more than 10hours

Arch Lamp 914
Bathroom Hallway 0
Blue Light 1049
Front Outside Lights 848
Garage Lights 857
Green Lamp 307
Kitchen Breakfast Bar 45
Living Room 903
Main Kitchen FL 49
Master Bath Lights 832
Master Bedroom Lights 1010
Motion Sensor Doorbell 436
Office Lamps Den 882
Sensor Garage 436
Snake Light 135
TV Movie Lights 1929
Upper Hallway 981

artpics wrote:#1

my blue light is on a time action for 180 mins each day i have 1010
the master bedroom was not on at all yesterday but i have 1820

I'm seeing exactly the same thing. Lights which are virtually never on are showing on for 500 - 600 minutes

eme jota ce wrote:When navigating to
http://127.0.0.1:8176/usageReporter
Safari says "undefined page requested"

Just installed this today. Is the error expected because it needs to run a day under the default of displaying yesterday's usage?

Restarted the server (and computer running Indigo) a few times before and after the post above.
Here's the other things I've checked / done:

"Log Device History to SQLite..." checkbox was checked for the first time yesterday in Indigo preferences when installing this plugin,
I use the default port settings on that page,
Can reach the other other pages Indigo serves via the "Go" menu, for example the Devices Page loads in Safari showing this url: http://127.0.0.1:8176/controlpage?name= ... _&asList=1
Confirmed that /Library/Application Support/Perceptive Automation/Indigo 4/IndigoSqlClient/IndigoSqlClient.conf file has "sqlite" specified as database_type, (no changes made to file, just confirmed settings)
Can see that the "sqlite_db" file exists at /Library/Application Support/Perceptive Automation/Indigo 4/IndigoSqlClient and is modified every time a light turns on or off.

Any thoughts?

eme jota ce -

Stop and Restart the Indigo Server, let it run for about a minute, then copy/paste the contents of the Event Log window into a post for us.

And what version of Mac OS X are you running?

Here it is,Matt.

Also, I'm running OSX 10.6.2

Code: Select all

Mar 5, 2010 9:47:56 AM
  Starting Indigo Server version 4.1.6
  Loading attachments
  "device target attachment.scpt" script loaded
  "group target attachment.scpt" script loaded
  "growl attachment.scpt" script loaded
  "iTunes attachment.scpt" script loaded
  "scenes attachment.scpt" script loaded
  "time stamp attachment.scpt" script loaded
  Bonjour registered "Indigo - ****Home"
  Indigo Cocoa client authenticated
  SQLite client authenticated
  SQLite             client connected to Indigo Server
  SQLite             client connected to sqlite_db
  SQLite             logging all device state changes
  SQLite             logging all variable value changes
  SQLite client authenticated
  SQLite             client connected to Indigo Server
  SQLite             client connected to sqlite_db
  SQLite             logging all device state changes
  SQLite             logging all variable value changes

Mar 5, 2010 9:48:00 AM
  Emails on POP server mail.****.com will be scanned every 5 minutes
  Trigger Action     NOAA Weather data
  Connected to PowerLinc 2413U interface
  PowerLinc address 13.AC.BB, firmware version 9.2
  Weather NOAA       Weather NOAA Script Launched
  WebServer client authenticated
  WebServer          started on port 8176 -- digest authentication enabled
  WebServer          enabled browser access to plugin path "plugins/usageReporter/usageReporter/css"
  Reflector          starting reflector connection to https://****.goprism.com

Mar 5, 2010 9:49:38 AM
  Received INSTEON   "Motion Detector Kitchen" on (button 1)
  Received INSTEON   "Motion Detector Steeple Room" on (button 1)

eme jota ce wrote: WebServer enabled browser access to plugin path "plugins/usageReporter/usageReporter/css"

Move the contents of the folder usageReporter up a level. You have the folder nested one too deep inside a folder with the same name.

bobeast wrote:

artpics wrote:#1

my blue light is on a time action for 180 mins each day i have 1010
the master bedroom was not on at all yesterday but i have 1820

I'm seeing exactly the same thing. Lights which are virtually never on are showing on for 500 - 600 minutes

Jay is out-of-town for a few days, but he'll look into this when he gets back.

support wrote:Move the contents of the folder usageReporter up a level. You have the folder nested one too deep inside a folder with the same name.

Ooops. That generated the report. Thanks Matt!

Of note... I'm seeing similarly very high, inaccurate, minutes in the report that others are mentioning:

Lights that were not turned On all day show that they were On for 702 minutes;
Some lights that show greater than 702 minutes are reported as 702 + the actual number of minutes shown in the log (so it would be accurate for some, except for the extra 702 minutes);
Only two out of about 60 lights and appliance/lamp lincs show less than 702 minutes. Those two lights turn on and off all day and show 514 and 564 minutes, which I do not have time to verify against the log, but would guess those numbers are right.

I checked yesterday's log and see that I restarted the Indigo Server at 11:42am, is 702 minutes after midnight and when this plugin was installed, and when I first enabled the SQLite logging in Indigo's preferences. I checked a week of logs and confirmed that "SQLite" is never mentioned in prior logs. First mention of "SQLite" in any of the logs is 11:42am yesterday. Since that's 702 minutes from midnight, I'm guessing that's more than coincidence and my numbers might look accurate tomorrow. Jay's original post mentions some assumptions about light status. The enigma is why two of my lights appear accurate and under 702 minutes?

Will keep an eye on this thread for updates. Will post if tomorrow's report of today's usage looks normal.

Here are the numbers from the report:

Code: Select all

Device Name   Minutes ON
1st Bath Fan   702
1st Bath Lights   792
1st Floor Hallway   872
2nd Bath Fan   702
2nd Bath Lights   702
2nd Bath Shower Light   702
3rd Floor Bathroom Fan   704
3rd Floor Bathroom Lights   1473
3rd Floor ******* Lamp   705
3rd Floor ******* Room   705
3rd Floor Guest Bath Fan   702
3rd Floor Guest Bath Shower Light   702
3rd Floor Guest Bath Vanity   702
3rd Floor Guest Room   702
3rd Floor Guest Room Closet Light   702
3rd Floor *******liancelinc Lamp   725
3rd Floor ******* Room   725
Basement Ceiling Lights   124
Basement Closet   702
Basement Door Sensor   702
Basement Keypad   702
Basement Laundry   742
Basement Sauna   702
Dining Room Chandelier   975
Dining Room East Overhead   717
Dining Room Keypad   1179
Dining Room West Overhead   1018
Family Room Accent Lights   702
Family Room Overhead Lights   702
Family Room Reading Lamp   702
Garage Light   730
Kitchen Cabinet Lights   546
Kitchen Fan Keypad   762
Kitchen Lights   514
Living Room Accent   889
Living Room Overhead   889
Master Bath Fan   706
Master Bath Lights   785
Master Bath Shower Lights   870
Master Bedroom Closet   871
Master Bedroom Table Lamp   801
Master Bedroom keypad   801
Motion Detector Basement   121
Motion Detector Kitchen   466
Motion Detector Living Room   1446
Motion Detector Steeple Room   657
Motion Sensor Master Closet   707
Motion Top Stairway   788
Office Overhead Lights   702
OustideOutlet East   702
Outside West Outlet & Garden Lighting   949
dog FOOD   703
Porch LIght   897
Stairway Low   913
Stairway LowB   913
Stairway Mid   1049
Stairway MidB   1050
Stairway Top   777
Stairway TopB   844
Steeple Chandelier   1435
Steeple Christmas Lights   703
Steeple East Wall Spot LIght   1293
Steeple Side Sconces   793
Steeple South Wall Flood Lights   1293
Steeple Tip Top   1043

support wrote:Jay is out-of-town for a few days, but he'll look into this when he gets back.

Okay thanks.

this might help checked useage this morning before anything was turned on

nothing showed up.

i turned on the master bathroom i got - 904 was reported.

just checked again (2hours later) i get this which is correct.

Device Name Minutes ON
Bathroom Hallway 3
Kitchen Breakfast Bar 45
Main Kitchen FL 24
Snake Light 208

checked 2 hours after the details above i get this.

Device Name Minutes ON
Bathroom Hallway 3
Kitchen Breakfast Bar 45
Main Kitchen FL 24
Snake Light 950
Upper Hallway 3

now another 1 hour later i get this.

Device Name Minutes ON
Bathroom Hallway 3
Kitchen Breakfast Bar 45
Main Kitchen FL 24
Snake Light 251
Upper Hallway 3

which is correct



have a great weekend