Announcement

Collapse
No announcement yet.

Jon00 Database Charting Utility for Homeseer 3

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