Description
----------------------
Generates reports and charts for the HomeSeer log entries that are stored in UltraJones' UltraLog Microsoft Access database.
In addition to a general report of HomeSeer events, there are also more specialized reports/charts which are described in the following sections along with the requirements needed to enable the specialized reports/charts. Each of the reports/charts can be viewed for different timeframes and some allow filtering.
General Instructions
----------------------
- Must be using UltraLog
- Put doo_logs.asp in HomeSeer html folder
- Make sure that remaining .asp files are within the html\includes folder
- Make sure that the .ini onfiguration files are within the config folder
- Set USER DEFINED
General Event Log
----------------------
Description: Report showing HomeSeer Log Entries
Requirements: Set bUseEventLog to True in doo_logs.ini file (or User Defined Constants area below if you have version HS 1.5.38 or earlier).
Error Log
----------------------
Description: Report showing HomeSeer Log Errors
Requirements: Set bUseErrorLog to True in doo_logs.ini file (or User Defined Constants area below if you have version HS 1.5.38 or earlier).
Debug Log
----------------------
Description: Report showing HomeSeer Log Debug Statements
Requirements:
- Set bUseDebugLog to True in doo_logs.ini file (or User Defined Constants area below if you have version HS 1.5.38 or earlier).
- make a habit of adding some hs.WriteLog "DEBUG", ... statements within your problem scripts.
Motion Log
----------------------
Description: Report/chart showing motion sensor events
Requirements:
- Must use Jim Doolittle's Motion Sensor & Dusk/Dawn Sensor Script Package
- Set UseMotionLog to true in doo_logs.ini file (or USER DEFINED area below if you have version HS 1.5.38 or earlier).
Web Log
----------------------
Description: Report/chart showing HomeSeer web activity
Requirements:
- Must be using HomeSeer Web Server
- Set UseWebLog to true in doo_logs.ini file (or USER DEFINED area below if you have version HS 1.5.38 or earlier).
Call Log
----------------------
Description: Report/chart showing phone calls
Requirements:
- Must be using HomeSeer Phone
- Must subscribe to CallerID service
- Must log callerID to HomeSeer log
- Set UseCallLog to true in doo_logs.ini file (or USER DEFINED area below if you have version HS 1.5.38 or earlier).
Doorbell Log
----------------------
Description: Report/chart showing visitors who have rung your doorbell at either your frontdoor or backdoor
Requirements:
- Must have hardware that allows HomeSeer to know when one of your doorbells was rung
- Must have event/script that writes an entry in the HomeSeer log that contains "doorbell".
- Set UseDoorbellLog to true in doo_logs.ini file (or USER DEFINED area below if you have version HS 1.5.38 or earlier).
Garage Door Log
----------------------
Description: Report/chart showing garage door positions
Requirements:
- Must have hardware that keeps track of garage door position
- Must have event/script that writes an entry in the HomeSeer log that contains "garage door".
- Set UseGarageDoorLog to true in doo_logs.ini file (or User Defined Constants area below if you have version HS 1.5.38 or earlier).
Guestbook Log
----------------------
Description: Report showing entries in your HomeSeer Web Guestbook.
Requirements:
- Must use Jim Doolittle's guestbook.asp page
- Must have a table named tblGuestBook added to the UltraLog Microsoft Access database with the following fields:
ID: autonumber
Log_Date: date/time
GuestName: text 50
GuestIP: text 15
GuestComments: memo
Revision History
----------------------
Version 3.5.2
- fixed some Web IP bugs
Version 3.5.1
- the security.asp include file should have been the new misc_functions.asp include file
Version 3.5.0
- Supports an INI file
- Now uses standard includes from Jeff Farmer et. al.
- Phone numbers now have reverse lookup courtesy of Carlos Castillo
- Added garage door report and chart
- Added a report for Motion which was inadvertently left out
- Exclusively uses the GetRows function which is faster than iterating a recordset
Version 3.41 (3.4.1)
- Added missing gifs (oops)
Version 3.40 (3.4.0)
- Initial version released to public
HomeSeer Web Page for UltraLog Discussion
Jim Doolittle
[This message was edited by Jim Doolittle on Wednesday, 26 June 2002 at 08:15 AM.]
[This message was edited by Jim Doolittle on Friday, 28 June 2002 at 08:12 AM.]
----------------------
Generates reports and charts for the HomeSeer log entries that are stored in UltraJones' UltraLog Microsoft Access database.
In addition to a general report of HomeSeer events, there are also more specialized reports/charts which are described in the following sections along with the requirements needed to enable the specialized reports/charts. Each of the reports/charts can be viewed for different timeframes and some allow filtering.
General Instructions
----------------------
- Must be using UltraLog
- Put doo_logs.asp in HomeSeer html folder
- Make sure that remaining .asp files are within the html\includes folder
- Make sure that the .ini onfiguration files are within the config folder
- Set USER DEFINED
General Event Log
----------------------
Description: Report showing HomeSeer Log Entries
Requirements: Set bUseEventLog to True in doo_logs.ini file (or User Defined Constants area below if you have version HS 1.5.38 or earlier).
Error Log
----------------------
Description: Report showing HomeSeer Log Errors
Requirements: Set bUseErrorLog to True in doo_logs.ini file (or User Defined Constants area below if you have version HS 1.5.38 or earlier).
Debug Log
----------------------
Description: Report showing HomeSeer Log Debug Statements
Requirements:
- Set bUseDebugLog to True in doo_logs.ini file (or User Defined Constants area below if you have version HS 1.5.38 or earlier).
- make a habit of adding some hs.WriteLog "DEBUG", ... statements within your problem scripts.
Motion Log
----------------------
Description: Report/chart showing motion sensor events
Requirements:
- Must use Jim Doolittle's Motion Sensor & Dusk/Dawn Sensor Script Package
- Set UseMotionLog to true in doo_logs.ini file (or USER DEFINED area below if you have version HS 1.5.38 or earlier).
Web Log
----------------------
Description: Report/chart showing HomeSeer web activity
Requirements:
- Must be using HomeSeer Web Server
- Set UseWebLog to true in doo_logs.ini file (or USER DEFINED area below if you have version HS 1.5.38 or earlier).
Call Log
----------------------
Description: Report/chart showing phone calls
Requirements:
- Must be using HomeSeer Phone
- Must subscribe to CallerID service
- Must log callerID to HomeSeer log
- Set UseCallLog to true in doo_logs.ini file (or USER DEFINED area below if you have version HS 1.5.38 or earlier).
Doorbell Log
----------------------
Description: Report/chart showing visitors who have rung your doorbell at either your frontdoor or backdoor
Requirements:
- Must have hardware that allows HomeSeer to know when one of your doorbells was rung
- Must have event/script that writes an entry in the HomeSeer log that contains "doorbell".
- Set UseDoorbellLog to true in doo_logs.ini file (or USER DEFINED area below if you have version HS 1.5.38 or earlier).
Garage Door Log
----------------------
Description: Report/chart showing garage door positions
Requirements:
- Must have hardware that keeps track of garage door position
- Must have event/script that writes an entry in the HomeSeer log that contains "garage door".
- Set UseGarageDoorLog to true in doo_logs.ini file (or User Defined Constants area below if you have version HS 1.5.38 or earlier).
Guestbook Log
----------------------
Description: Report showing entries in your HomeSeer Web Guestbook.
Requirements:
- Must use Jim Doolittle's guestbook.asp page
- Must have a table named tblGuestBook added to the UltraLog Microsoft Access database with the following fields:
ID: autonumber
Log_Date: date/time
GuestName: text 50
GuestIP: text 15
GuestComments: memo
Revision History
----------------------
Version 3.5.2
- fixed some Web IP bugs
Version 3.5.1
- the security.asp include file should have been the new misc_functions.asp include file
Version 3.5.0
- Supports an INI file
- Now uses standard includes from Jeff Farmer et. al.
- Phone numbers now have reverse lookup courtesy of Carlos Castillo
- Added garage door report and chart
- Added a report for Motion which was inadvertently left out
- Exclusively uses the GetRows function which is faster than iterating a recordset
Version 3.41 (3.4.1)
- Added missing gifs (oops)
Version 3.40 (3.4.0)
- Initial version released to public
HomeSeer Web Page for UltraLog Discussion
Jim Doolittle
[This message was edited by Jim Doolittle on Wednesday, 26 June 2002 at 08:15 AM.]
[This message was edited by Jim Doolittle on Friday, 28 June 2002 at 08:12 AM.]