Announcement

Collapse

Contacting HomeSeer This Week

HomeSeer is open and operational this week. All orders are being processed and shipped as usual. However, some staff are working from home. If you need to contact HomeSeer for support or customer service, please use our Email or Chat options. https://homeseer.com/contact-us/
See more
See less

Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

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

  • It sounds like your data source was not outputting a numerical value.
    Jon

    Comment


    • Min/Max range - Feature Request

      I have a few devices that occasionally report bad values. For example, my house meter occasionally reports a single KW reading in the tens of thousands. This really messes with the graph range. My Insteon thermostat occasionally reports 0 degrees too.

      Would it be possible to have optional settings to throw away values that fell outside of a min/max range?

      Just curious if others have this issue as well.
      Mike

      Comment


      • Yes I can add that easily....
        Jon

        Comment


        • You are da man Jon00! I am so getting tired of editing databases.
          Mike

          Comment


          • Mike,

            I've sent you a new version to try.
            Jon

            Comment


            • Is it not possible to use a devices reference ID:

              Data1=$dvr:386 for the data source?

              The chart001.png is being updated, but it's just a big X for the picture (chart) when opened.
              RJ_Make On YouTube

              Comment


              • If you go to the device management page and look at the properties of the device with that reference, what is it's device value?
                Jon

                Comment


                • 386
                  RJ_Make On YouTube

                  Comment


                  • Hmmmmm.. If I use Jon00DBCharting.asp the data is there.. and the chart gets created... So looks like this is a problems with the chart001.png....
                    RJ_Make On YouTube

                    Comment


                    • How long have you been recording the info in the database? Does it show up on the dynamic chart web page selecting a suitable time span?
                      Jon

                      Comment


                      • Originally posted by ServiceXp View Post
                        Hmmmmm.. If I use Jon00DBCharting.asp the data is there.. and the chart gets created... So looks like this is a problems with the chart001.png....
                        So what do you have for the following values:

                        ChartTimeStart=
                        ChartTimeFinish=
                        ChartTimeFormat=
                        Jon

                        Comment


                        • 1st pic is what the data looks like using Jon00DBCharting.asp, 2nd is inside HS3
                          Attached Files
                          RJ_Make On YouTube

                          Comment


                          • Originally posted by jon00 View Post
                            So what do you have for the following values:

                            ChartTimeStart=
                            ChartTimeFinish=
                            ChartTimeFormat=

                            ChartTimeStart=2
                            ChartTimeFinish=0
                            ChartTimeFormat=m
                            RJ_Make On YouTube

                            Comment


                            • Right, so you are trying to create a chart for the last 2 minutes.

                              If you want to show something similar to the web page, you need a time span of 12 hours i.e.


                              ChartTimeStart=720
                              ChartTimeFinish=0
                              ChartTimeFormat=m
                              Jon

                              Comment


                              • Sorry, I see it is over the last 4 days so you would need:

                                ChartTimeStart=4
                                ChartTimeFinish=0
                                ChartTimeFormat=d
                                Jon

                                Comment

                                Working...
                                X