Script to list events that have script actions - Discussion Thread

[sparkman]

Please use this thread for comments, questions, etc. for the script posted here: https://forums.homeseer.com/showthread.php?t=187187.

[drozwood90]

Al,

Again, seriously, why don't you just setup my system for me? I was just starting to run into similar as I tested out various parts of my updateEvent master script.

Now, I can just run your good stuff and be happy - yet again!

--Dan

[sparkman]

Al,

Again, seriously, why don't you just setup my system for me? I was just starting to run into similar as I tested out various parts of my updateEvent master script.

Now, I can just run your good stuff and be happy - yet again!

--Dan

Hi Dan,

No problem, just sent it over along with some (a lot of) beer and I'll have it ready in a few months

Cheers
Al

[sparkman]

One thing that I have noticed on my Windows system is that most scripts are referenced using the path with this capitalization:

C:/Program Files (x86)/HomeSeer HS3/scripts/

However, some events seem to use this path:

C:/program files (x86)/homeseer hs3/scripts/

I had about 7 or 8 with the second one and hundreds with the first one.

To catch all scripts/events, you would need to run the script twice modifying the ScriptsPath variable. I'll see if I can update the script to take both scenarios into account automatically. Would be interesting to know what other people are seeing for paths to their scripts in events.

Cheers
Al

[donstephens]

Hi Al;

Can't seem to get this script to run on my system. I changed the path for the scripts files to reflect my directory, added the reference for the needed dll in the system.ini file but I'm getting this error in my log.

Syntax error.
Feb-07 11:59:48 AM         Error    Compiling script EventswithScripts.vb: Namespace or type specified in the Imports 'System.Core' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases. 

I assume this issue is due to me hosing the System.Data.SQLite.dll path, but I can't see where I screwed up. In my setup HomeSeer sits in the C:\Homeseer HS3 directory.

Any suggestions?

Thanks

[sparkman]

Hi Don,

Can you post that line from your ini file? Can you also confirm that there's a System.Data.SQLite.dll in your Bin folder?

Cheers
Al

[donstephens]

Sure.

ScriptingReferences=DDay.iCal;DDay.iCal.dll,DDay.Collections;DDay.Collections.dll,antlr.runtime;antlr.runtime.dll,System.Data.SQLite;C:\HomeSeer HS3\Bin\System.Data.SQLite.dll 

I did verify that the System.Data.SQLite.dll is in the \bin directory.

[sparkman]

Sure.

ScriptingReferences=DDay.iCal;DDay.iCal.dll,DDay.Collections;DDay.Collections.dll,antlr.runtime;antlr.runtime.dll,System.Data.SQLite;C:\HomeSeer HS3\Bin\System.Data.SQLite.dll 

I did verify that the System.Data.SQLite.dll is in the \bin directory.

Hi Don, all looks good there. The other Imports should not require mods to the ScriptingReferences, so not sure what is going on. Can you set the Debug variable to True in the Main Sub as well as the one in the EventsWithScripts function? It likely may not tell us more if it fails to compile all together. If that doesn't tell us anything, I'll create a simpler test script to see if we can pinpoint the issue. Also, can you confirm the name of your HS data file?

Cheers
Al

[donstephens]

First, thanks for all the help.

I realized that I had renamed the data file to LostHorse.hsd. So I blew it there. I redid the statement to reflect the correct name of my file to

Dim HS3DataFile As String = "LostHorse.hsd" 

. Still getting the error. If you'd like I can start commenting out blocks of code to try and isolate the issue.

Hi Don, all looks good there. The other Imports should not require mods to the ScriptingReferences, so not sure what is going on. Can you set the Debug variable to True in the Main Sub as well as the one in the EventsWithScripts function? It likely may not tell us more if it fails to compile all together. If that doesn't tell us anything, I'll create a simpler test script to see if we can pinpoint the issue. Also, can you confirm the name of your HS data file?

Cheers
Al

[sparkman]

If you'd like I can start commenting out blocks of code to try and isolate the issue.

Hi Don,

That would be great if you could do that.

Thanks
Al

[donstephens]

Well; this is embarrassing. I had put a comment in while trying to troubleshoot the script and, well nevermind. It works now. I think putting the wrong data file name broke it and when I was trying to fix it, I really broke it, so I didn't notice that it was working.... Very red faced here.

Thanks

Hi Don,

That would be great if you could do that.

Thanks
Al

[sparkman]

Well; this is embarrassing. I had put a comment in while trying to troubleshoot the script and, well nevermind. It works now. I think putting the wrong data file name broke it and when I was trying to fix it, I really broke it, so I didn't notice that it was working.... Very red faced here.

Thanks

LOL. Trust me, I've done that many times myself too Glad it's now working for you.

Cheers
Al

[sparkman]

Posted version 0.0.6 which now searches two paths with different cases at the same time.

Cheers
Al

[sparkman]

An aspx version is now available to build the reports on the fly. Here are some screenshots:







Cheers
Al

[langenet]

This is super great Al. Though, I did try it and edited into the aspx file my hsd filename and path to SQLite but get the following error.

Line 47:
Line 48: 'Declare the main SQLite data access objects
Line 49: Dim cnn As SQLiteConnection = Nothing
Line 50: Dim comm As SQLiteCommand = Nothing
Line 51: Dim rdr As SQLiteDataReader = Nothing


Source File: C:\Program Files\HomeSeer HS3\html\scriptevents.aspx Line: 49


I've added the following reference to settings.ini
System.Data.SQLite;C:\Program Files\HomeSeer HS3\Bin\System.Data.SQLite.dll

Robert