Author |
|
patrickm Senior Member
Joined: February 22 2007 Location: United States
Online Status: Offline Posts: 188
|
Posted: June 15 2009 at 11:24 | IP Logged
|
|
|
Hello,
I have several Insteon switchlincs that get their links messed up by people leaning on them (switches on the kitchen island). I have been using the Insteon explorer to restore their links manually. I would like to have a macro or script that could restore those links automatically. Any ideas other than bird spikes mounted around the switches?
|
Back to Top |
|
|
dhoward Admin Group
Joined: June 29 2001 Location: United States
Online Status: Offline Posts: 4447
|
Posted: June 15 2009 at 22:30 | IP Logged
|
|
|
Patrick,
Bummer.
Never seen a request like this before but it should be easy enough to handle. The following formula will do the equivalent of pressing the "Rebuild" text in the Insteon Links tab of the Insteon Explorer.
Code:
ph_directsql("update insteonlinks set mcheck = 101,mrecno = 0 where sourceid = 'YOUR INSTEON ADDRESS TO REBUILD HERE'") + ph_directsql("update insteonlinks set rcheck = 101,rrecno = 0 where remoteid = 'YOUR INSTEON ADDRESS TO REBUILD HERE'") |
|
|
HTH,
Dave.
|
Back to Top |
|
|
patrickm Senior Member
Joined: February 22 2007 Location: United States
Online Status: Offline Posts: 188
|
Posted: June 16 2009 at 02:14 | IP Logged
|
|
|
Thanks Dave,
I will give this a try.
|
Back to Top |
|
|