xapmcsDatabase is an xAP node that collects xapBSC, weather.report, and xap-x10 schema into an Access or SQL Server database. It is designed as an element of a xAP system that produces sensor data (e,g xapmcs1wire, xapmcsTemp0x, xapmcsWeatherAWS, xapmcsWeatherMSNBC, xapmcsWeatherXML), stores it in a database (xapmcsDatabase), and generates trend charts (xapmcsChart). It does have general purpose application, but it does make some assumptions about the nature of the data to identify discrete vs continuous table structure strategies.
It has a registration mechanism for which the unlock code can be obtained via Private Message for those that are owners of the mcsTemperature plugin.
Change Log
PR1 1.1.22 "R" Reject column added to reduce clutter
PR2 1.1.22 Some selection data lost with very long device lists
PR3 1.1.28 Access database path not corrected reported in UNC format
PR4 1.1.29 No license needed for February
PR5 1.2.0 Weather.Report data not reported in Schema request
PR6 1.2.0 V1.3 xAP UID format
PR7 1.2.6 Store data based upon DisplayText key if present and Text/Level has no decimal
PR8 1.3.0 Accept formats with only one or two components of subaddress field
PR9 1.3.11 User option to identify tables/fields by xAP UID rather than subaddress component
PR10 2.0.0.5 .NET with addition of MySQL and SQLite options
PR11 2.0.0.6 Organize setup page to reduce scrolling
PR12 2.0.0.9 Syntax error when writing data to Access database using INSERT INTO as Qx
PR13 Included xapmcsDatabaseCopy.exe tool to help copy mcsTemperature records to xapmcsDatabase format
PR14 2.0.0.11 Protect database names by changing special characters to underscores
Download available at http://mcssprinklers.com/xapmcsDatabase.zip
V1.3.11 at http://mcssprinklers.com/xapmcsDatabase_V1.zip
It has a registration mechanism for which the unlock code can be obtained via Private Message for those that are owners of the mcsTemperature plugin.
Change Log
PR1 1.1.22 "R" Reject column added to reduce clutter
PR2 1.1.22 Some selection data lost with very long device lists
PR3 1.1.28 Access database path not corrected reported in UNC format
PR4 1.1.29 No license needed for February
PR5 1.2.0 Weather.Report data not reported in Schema request
PR6 1.2.0 V1.3 xAP UID format
PR7 1.2.6 Store data based upon DisplayText key if present and Text/Level has no decimal
PR8 1.3.0 Accept formats with only one or two components of subaddress field
PR9 1.3.11 User option to identify tables/fields by xAP UID rather than subaddress component
PR10 2.0.0.5 .NET with addition of MySQL and SQLite options
PR11 2.0.0.6 Organize setup page to reduce scrolling
PR12 2.0.0.9 Syntax error when writing data to Access database using INSERT INTO as Qx
PR13 Included xapmcsDatabaseCopy.exe tool to help copy mcsTemperature records to xapmcsDatabase format
PR14 2.0.0.11 Protect database names by changing special characters to underscores
Download available at http://mcssprinklers.com/xapmcsDatabase.zip
V1.3.11 at http://mcssprinklers.com/xapmcsDatabase_V1.zip
Comment