View unanswered posts | View active topics It is currently Wed May 22, 2013 12:50 pm



Reply to topic  [ 7 posts ] 
 Search on Device ID 
Author Message
User avatar

Joined: Apr 10, 2006
Posts: 236
Location: Lower Hudson Valley
Post Search on Device ID
No biggie but it would be nice if the search box also searched on the Device ID.


Sun Aug 19, 2012 5:06 pm
Profile
Site Admin
User avatar

Joined: Mar 19, 2008
Posts: 6659
Location: Austin, Texas
Post Re: Search on Device ID
I've been thinking about some things along this line. Can you explain exactly what you were doing that you needed to know the ID? Where were you getting the ID you want to look up in the first place?

_________________
Jay (Indigo Support)
Image


Mon Aug 20, 2012 9:49 am
Profile WWW
User avatar

Joined: Apr 10, 2006
Posts: 236
Location: Lower Hudson Valley
Post Re: Search on Device ID
Nightly I look for X-10 motion detectors that have not picked up motion in a few days, likely time to change the batteries. My script has the IDs hardcoded in the SQL queries. First time with new SQL tables one came back. Even sorting on ID it's bit tricky to find with out commas in the ID.

Never mind, thinking about it now I just need to add one more step to the script, looking up the device name. I just quickly rewrote it after the SQL changes and today was the first time it picked something up for real. Thanks.


Mon Aug 20, 2012 10:18 am
Profile

Joined: Oct 17, 2004
Posts: 1114
Location: Rochester, Ny
Post Re: Search on Device ID
CharlieParker wrote:Nightly I look for X-10 motion detectors that have not picked up motion in a few days, likely time to change the batteries. My script has the IDs hardcoded in the SQL queries. First time with new SQL tables one came back. Even sorting on ID it's bit tricky to find with out commas in the ID.

Never mind, thinking about it now I just need to add one more step to the script, looking up the device name. I just quickly rewrote it after the SQL changes and today was the first time it picked something up for real. Thanks.


Charlie,

I am re-adding this feature into Switchboard... (It use to be in the proceeding Indigo Security Script...)

Somehow when I rewrote it as a plugin, that feature was missed.... So X10 Heartbeat monitoring will be available, in v0.7x+ of the Switchboard plugin... And switchboard will give you the proper name, etc, of the device...

So that might be an alternative to your hard coded sql queries...

- Ben

_________________
------
My Plugins for Indigo (v4, v5, and v6) - http://bit.ly/U8XxPG

Security Script for v4 - http://bit.ly/QTgclf
for v5 - http://bit.ly/T6WBKu

Support Forum(s) - http://www.perceptiveautomation.com/userforum/viewforum.php?f=33


Last edited by bschollnick2 on Mon Aug 20, 2012 1:18 pm, edited 1 time in total.



Mon Aug 20, 2012 11:16 am
Profile WWW
User avatar

Joined: Apr 10, 2006
Posts: 236
Location: Lower Hudson Valley
Post Re: Search on Device ID
Thanks Ben, for all your great contributions.


Mon Aug 20, 2012 12:13 pm
Profile

Joined: Oct 17, 2004
Posts: 1114
Location: Rochester, Ny
Post Re: Search on Device ID
CharlieParker wrote:Thanks Ben, for all your great contributions.


Your quite welcome.... (And if your interested in testing the Heartbeat monitoring, please feel free to contact me at Benjamin AT schollnick DOT net...)

_________________
------
My Plugins for Indigo (v4, v5, and v6) - http://bit.ly/U8XxPG

Security Script for v4 - http://bit.ly/QTgclf
for v5 - http://bit.ly/T6WBKu

Support Forum(s) - http://www.perceptiveautomation.com/userforum/viewforum.php?f=33


Mon Aug 20, 2012 1:19 pm
Profile WWW

Joined: Oct 17, 2004
Posts: 1114
Location: Rochester, Ny
Post Re: Search on Device ID
bschollnick2 wrote:
CharlieParker wrote:Nightly I look for X-10 motion detectors that have not picked up motion in a few days, likely time to change the batteries. My script has the IDs hardcoded in the SQL queries. First time with new SQL tables one came back. Even sorting on ID it's bit tricky to find with out commas in the ID.

Never mind, thinking about it now I just need to add one more step to the script, looking up the device name. I just quickly rewrote it after the SQL changes and today was the first time it picked something up for real. Thanks.


Charlie,

I am re-adding this feature into Switchboard... (It use to be in the proceeding Indigo Security Script...)

Somehow when I rewrote it as a plugin, that feature was missed.... So X10 Heartbeat monitoring will be available, in v0.7x+ of the Switchboard plugin... And switchboard will give you the proper name, etc, of the device...

So that might be an alternative to your hard coded sql queries...


Just as an update. I have v0.70 ready, I am currently testing it....

You can define each X10 device, with a different Heartbeat timeout value... (The default is 200 minutes).

I expect to release it, within the next couple of days....

- Ben

_________________
------
My Plugins for Indigo (v4, v5, and v6) - http://bit.ly/U8XxPG

Security Script for v4 - http://bit.ly/QTgclf
for v5 - http://bit.ly/T6WBKu

Support Forum(s) - http://www.perceptiveautomation.com/userforum/viewforum.php?f=33


Tue Aug 21, 2012 6:39 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 7 posts ] 

Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.   Template designed by STSoftware.