Announcement

Collapse
No announcement yet.

Xapms1wire Switch graphing?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Xapms1wire Switch graphing?

    I am currently using MCS temperature to store and graph temperatures and other data. I ended up using Xamps1wire to collect my 1-wire data because it supported the 1-wire hub that I had. I map the data to homeseer devices using Mcsxap, and then MCS temperature reads them as mapped virtual devices.

    I have configured a couple of Temperature devices in Xamps1wire to be switches which I want to track in MSC temperature, but have been unable to figure out how. I believe the issue is that there is no device string value for these switches in the Homeseer device and it is the String value that MSC temperature looks at.

    Can anyone suggest a workaround for this issue?

  • #2
    For device types of relay and switch mcsTemperature looks at DeviceStatus change events from HS to populate the database table. A table is created for each device of these types. You can look at the database table to see if any data is being collected.

    Comment


    • #3
      I've had issues recently (last few months) with all of the devices mapped over to MCSTemperature. I've compacted/cleaned DB. It didn't help. I saw the same issue come up in some earlier posts (maybe last year?).

      Just tried it again and seeing the following in HS Log.

      9/25/2010 9:18:04 PM mcsTemperature TemperatureASP 10 second Timeout On Pending ASP Request with pending level 2
      9/25/2010 9:18:06 PM mcsTemperature FormatTemperatureScreen on line 7670 Object variable or With block variable not set
      9/25/2010 9:18:06 PM mcsTemperature TemperaturePage: on line 400 Object variable or With block variable not set
      9/25/2010 9:25:18 PM mcsTemperature TemperatureASP 10 second Timeout On Pending ASP Request with pending level 2
      9/25/2010 9:25:25 PM mcsTemperature FormatTemperatureScreen on line 5530 Object variable or With block variable not set
      9/25/2010 9:25:25 PM mcsTemperature TemperaturePage: on line 400 Object variable or With block variable not set
      9/25/2010 9:30:27 PM mcsTemperature TemperatureASP 10 second Timeout On Pending ASP Request with pending level 2
      9/25/2010 9:30:45 PM mcsTemperature FormatTemperatureScreen on line 7540 Object variable or With block variable not set
      9/25/2010 9:30:45 PM mcsTemperature TemperaturePage: on line 400 Object variable or With block variable not set
      Attached Files
      Last edited by Pete; September 25th, 2010, 09:34 PM.
      - Pete

      Auto mator
      Homeseer 3 Pro - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e 64 bit Intel Haswell CPU - Mono 6.4X
      Homeseer Zee2 (Lite) - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e - CherryTrail x5-Z8350 BeeLink 4Gb BT3 Pro - Mono 6.4X

      X10, UPB, Zigbee, ZWave and Wifi MQTT automation.

      Comment


      • #4
        What the message means is that a second browser request was received before the first one finished and 10 seconds was allowed for the first to complete when the second request was made. The other messages are just a result of aborting the original request.

        Access works well for small databases, but as it gets large the query times can become long. How big is your database?

        Comment


        • #5
          Its around 250 Mb. I cut it down to only include 2009. Before that it was around 1GB and went back to 2005. I sometimes get a graph; but mostly do not.
          - Pete

          Auto mator
          Homeseer 3 Pro - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e 64 bit Intel Haswell CPU - Mono 6.4X
          Homeseer Zee2 (Lite) - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e - CherryTrail x5-Z8350 BeeLink 4Gb BT3 Pro - Mono 6.4X

          X10, UPB, Zigbee, ZWave and Wifi MQTT automation.

          Comment


          • #6
            Pete, I increased the timeout in the attached. See if it makes any difference.
            Attached Files

            Comment


            • #7
              Will give it a try.

              9/26/2010 11:04:19 AM Plug-In Found plug-in: mcsTemperature, version: 6.1.0.27
              Just clicking MCSTemperature button once and waiting and looking at logs on the console. I did notice though when running a query on the data via my laptop / Access there were about 8000 records and the query too a while.

              Its been about 4 minutes or so and it worked for humidity. I then went to temperature. Same results as before with a blank graph.

              9/26/2010 11:11:22 AM - mcsTemperature - TemperatureASP 10 second Timeout On Pending ASP Request with pending level 2
              9/26/2010 11:13:52 AM - mcsTemperature - FormatTemperatureScreen on line 7840 Object variable or With block variable not set
              9/26/2010 11:13:53 AM - mcsTemperature - TemperaturePage: on line 400 Object variable or With block variable not set
              Attached Files
              Last edited by Pete; September 26th, 2010, 11:21 AM.
              - Pete

              Auto mator
              Homeseer 3 Pro - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e 64 bit Intel Haswell CPU - Mono 6.4X
              Homeseer Zee2 (Lite) - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e - CherryTrail x5-Z8350 BeeLink 4Gb BT3 Pro - Mono 6.4X

              X10, UPB, Zigbee, ZWave and Wifi MQTT automation.

              Comment


              • #8
                The periods ending in "ly" (e.g. weekly) will be very slow since it is processing every record in the database. I would not think there is much valve in running these queries very often since it just provides an average of all of your data. The "week" rather than "weekly" will typically be more usefull as it provides visibility into seven days of data.

                Comment


                • #9
                  Thanks Michael. Will give it a try.
                  - Pete

                  Auto mator
                  Homeseer 3 Pro - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e 64 bit Intel Haswell CPU - Mono 6.4X
                  Homeseer Zee2 (Lite) - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e - CherryTrail x5-Z8350 BeeLink 4Gb BT3 Pro - Mono 6.4X

                  X10, UPB, Zigbee, ZWave and Wifi MQTT automation.

                  Comment


                  • #10
                    Repair-compact of DB

                    This morning utilizing the plugin only I did the compact / rebuild of the DB to the last 30 days (have backups).

                    It took a while but now DB is down to less than 100 megs and queries are much faster.

                    9/27/2010 6:29:45 AM mcsTemperature Data sample discarded because database schema is being adjusted
                    9/27/2010 7:08:45 AM mcsTemperature Data sample discarded because database schema is being adjusted
                    9/27/2010 8:32:08 AM mcsTemperature C:\Program Files\HomeSeer 2\mcsTemperature.mdb compaction complete
                    I see data integers now on the queries but still no graphs or values under Avg, Min or Max.

                    If I do a query on two months then I get data. (doesn't make sense to me).
                    Attached Files
                    - Pete

                    Auto mator
                    Homeseer 3 Pro - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e 64 bit Intel Haswell CPU - Mono 6.4X
                    Homeseer Zee2 (Lite) - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e - CherryTrail x5-Z8350 BeeLink 4Gb BT3 Pro - Mono 6.4X

                    X10, UPB, Zigbee, ZWave and Wifi MQTT automation.

                    Comment


                    • #11
                      The query is dependent upon the size of the chart so the software knows how to quantize to the duration of a pixel. The debug output should include the SQL query being used and it should shed light on it.

                      Comment


                      • #12
                        Thanks Michael, will turn on debug.

                        Attached is debug / snapshot.
                        Attached Files
                        Last edited by Pete; September 27th, 2010, 03:52 PM.
                        - Pete

                        Auto mator
                        Homeseer 3 Pro - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e 64 bit Intel Haswell CPU - Mono 6.4X
                        Homeseer Zee2 (Lite) - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e - CherryTrail x5-Z8350 BeeLink 4Gb BT3 Pro - Mono 6.4X

                        X10, UPB, Zigbee, ZWave and Wifi MQTT automation.

                        Comment


                        • #13
                          The query for the table is below. Since everything was 0 it seems to indicate there is no data of value for month of Aug and Sep for s9600000014CAB326HKH, sDC00000014C88C26H, sDC00000014C88C2MB and sF22000000E741C126CBH. The data is being grouped in 4 hour intervals. It would be appropriate to actually look at the fields in Temperture table of the database to confirm.
                          Code:
                          SELECT (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") AS SampleDate, Max(s9600000014CAB326HKH) AS Temp FROM Temperature WHERE s9600000014CAB326HKH<>0 AND SampleDate >= #2010-07-27 16:00# AND SampleDate < #2010-09-27 16:00# GROUP BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") ORDER BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00")
                          
                          SELECT (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") AS SampleDate, Max(sDC00000014C88C26H) AS Temp FROM Temperature WHERE sDC00000014C88C26H<>0 AND SampleDate >= #2010-07-27 16:00# AND SampleDate < #2010-09-27 16:00# GROUP BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") ORDER BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00")
                          
                          SELECT (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") AS SampleDate, Max(sDC00000014C88C2MB) AS Temp FROM Temperature WHERE sDC00000014C88C2MB<>0 AND SampleDate >= #2010-07-27 16:00# AND SampleDate < #2010-09-27 16:00# GROUP BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") ORDER BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00")
                          
                          SELECT (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") AS SampleDate, Max(sF22000000E741C126CBH) AS Temp FROM Temperature WHERE sF22000000E741C126CBH<>0 AND SampleDate >= #2010-07-27 16:00# AND SampleDate < #2010-09-27 16:00# GROUP BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") ORDER BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00")
                          The query for the graph returns a date range that is larger than the software was expecting so the graph aborted. I would need to look at the source to see why. mcsTemperature.ini contains the settings for chart size.

                          Code:
                          9/27/2010 3:42:00 PM 56520.43 | mcsTemperature Debug | Chart SQL=SELECT (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00") AS StartDate, Max(s9600000014CAB326HKH) AS Q1, Max(sDC00000014C88C26H) AS Q2, Max(sDC00000014C88C2MB) AS Q3, Max(sF22000000E741C126CBH) AS Q4 FROM Temperature WHERE SampleDate >= #2010-07-27 16:00# AND SampleDate < #2010-09-27 16:00# GROUP BY (Format([SampleDate],"yyyy/mm/dd ") & Right("00" & CStr(Int(Hour([SampleDate])/4)*4),2) & ":00")
                          
                          9/27/2010 3:42:01 PM 56521.96 | mcsTemperature Debug | Data Elements=372, Data Names=4
                          9/27/2010 3:42:01 PM 56521.96 | mcsTemperature Debug | Draw CD Chart X axis dataIndex limit of 372 exceeded with 374 for index 9 and time delta of 4

                          Comment


                          • #14
                            Thank-you for having a look see.

                            Doing a quick query of the data to see if there is data there (checked yesterday before I compressed DB and there was data).

                            There is data in the four aforementioned fields.

                            Zipped db and ini file to send via email. Its 10Mb.

                            I've attached a quickie query.
                            Attached Files
                            Last edited by Pete; September 27th, 2010, 10:35 PM.
                            - Pete

                            Auto mator
                            Homeseer 3 Pro - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e 64 bit Intel Haswell CPU - Mono 6.4X
                            Homeseer Zee2 (Lite) - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e - CherryTrail x5-Z8350 BeeLink 4Gb BT3 Pro - Mono 6.4X

                            X10, UPB, Zigbee, ZWave and Wifi MQTT automation.

                            Comment

                            Working...
                            X