Script to list events that have script actions - Discussion Thread

[langenet]

Thanks.. yeah seems odd as my HS3 folder is very clean since I migrated less than a year ago with a fresh install. I have had no other problems and my system runs very well. My system is on Windows 2003 server however. So unless there's a path related problem - using C:\Program Files\HomeSeer HS3 I can't see why it doesn't work.

Robert

[jhirschhorn]

Hi Robert, it fails during the compile, so never executes. Whether debug is on or off is stored in scriptevents.ini for the aspx page. You could manually create it before it runs, but I don't believe it will help given that it fails during compile, not while running. Here's the default contents of it.

[Settings]
Debug=False
ShowScriptPath=False
ScriptsPath1=C:/Program Files (x86)/HomeSeer HS3/scripts/
ScriptsPath2=C:/program files (x86)/homeseer hs3/scripts/
HS3DataFile=HomeSeerData.hsd

I have no idea why Sqlite is automatically included on my system, but not yours. Still searching for a way. I haven't heard of anyone else having the same issue nor have I heard of anyone else running it successfully. Any others having the same issue or is it working for you?

Cheers
Al

Since you asked, I'm having exactly the same issue. Runs as an event, not as a ASPX page. I also have Jon00s charting working, and that also uses SQLite. I also have a few events which call my scripts that write to my own SQLite DB.

My observation is that it works from the script side, and in ASPX pages with a CodeBehind VB pages where the SQL is in the VB files, but not in ASPX only pages, even with the import namespace directive. I've also tried adding a reference to the SQLite namespace in HS web.config file with luck. For some reason the ASPX page can't resolve the namespace. Not sure why.

I was hoping to give it a few more days to see if anyone can find a resolution, after that I was going to try and split your code into an ASPX and codebehind VB file when I get time.

[sparkman]

Since you asked, I'm having exactly the same issue. Runs as an event, not as a ASPX page. I also have Jon00s charting working, and that also uses SQLite. I also have a few events which call my scripts that write to my own SQLite DB.

My observation is that it works from the script side, and in ASPX pages with a CodeBehind VB pages where the SQL is in the VB files, but not in ASPX only pages, even with the import namespace directive. I've also tried adding a reference to the SQLite namespace in HS web.config file with luck. For some reason the ASPX page can't resolve the namespace. Not sure why.

I was hoping to give it a few more days to see if anyone can find a resolution, after that I was going to try and split your code into an ASPX and codebehind VB file when I get time.

Thanks for letting me know. Not sure why it works on my system then. If I remove the import for the Sqlite namespace, I get the same error as you guys, so in my case HS is including it in the compile. I'll see if I can split the code and just reference the function in the vb file that I have.

Cheers
Al

[sparkman]

@langenet and @jhirschhorn

Attached is a version that uses the script file for the SQLite portion. Can you try it out. Remove the .txt extension and drop the .vb file in the Scripts folder and the .aspx file in the html folder and then open the .aspx file. Let me know if that works for you.

Cheers
Al

[jhirschhorn]

Sparkman,
This new version works perfectly. Awesome job.

Thanks.

[langenet]

Thanks Al. Works great now. Much appreciated!

Another great tool!

Awesome!!!

Robert

[sparkman]

Sparkman,
This new version works perfectly. Awesome job.

Thanks.

Thanks Al. Works great now. Much appreciated!

Another great tool!

Awesome!!!

Robert

Thanks gentlemen, glad it's working for you. I will move the files to the main post.

Cheers
Al

[sparkman]

New version available

Hi all,

A new version has been posted here: https://forums.homeseer.com/showthre...44#post1291644. This version no longer creates static reports, only dynamic reports generated through a web page. There is now also an option to generate the report in the standard HS3 table format or the simple format that was available in prior versions.

Please provide feedback, questions, etc. in this thread.

Cheers
Al

[sparkman]

New version has been posted with various enhancements and a few bug fixes. The enhancements include updating the Scripting References automatically if needed, and that it now also generates a report with events with Immediate Script Actions. Just overwrite the previous version with the new one.

Cheers
Al

[langenet]

Thanks Al for this. It's a nice tool to help manage the inventory of events with.

Robert

[sparkman]

Hi Don,

Here's a quick script.

Sub Main(ByVal Parms As object)

	Dim logName As String = "Event List"
	Dim Debug As String = True

	Dim EventArray() As strEventData = hs.Event_Info_All() 
	If Debug Then hs.writelog(logName, CStr(EventArray.GetUpperBound(0)) & " Events Found")

	For i As Integer = 0 To EventArray.getupperbound(0) - 1
		If Debug Then hs.writelog(logName, EventArray(i).GroupName & " - " & EventArray(i).Event_Name)
	Next

End Sub

Cheers
Al

[donstephens]

Thanks!

[larhedse]

Will this work on Linux?

[sparkman]

Will this work on Linux?

Not 100% sure. I don’t know if anyone else is running it on linux. Please give it a try and let me know if you run into any issues.

[Guest]

I’ll give it a try this week , on Linux