Announcement

Collapse
No announcement yet.

Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

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

    Go to that device and check the device value. What do you see?

    Finally, how are you triggering the database for updates? At the moment it is updating every 1-4 minutes? I cannot believe your weight is changing that much every minute or so!
    it looks like the database is pulling information from the power database in table 1 ?

    also the power device ( which seems to work just fine is a $dva the fitbit i cant do that as its greyed out so im using the $dvr , im wondering if this has any bearing on it
    detail of setup in profile. Link to videos of my projects there as well. Over 300 scripts running every min and counting

    Comment


      this is how im manually triggering the update ( not i have added extra updates as i am testing those extra tables so try to fix the issue
      Attached Files
      detail of setup in profile. Link to videos of my projects there as well. Over 300 scripts running every min and counting

      Comment


        Go to the dynamic chart web page again and set the date time for the last 7 days. Select zac weight 1 only and create a line chart without data points. Can you then post the chart here.
        Jon

        Comment


          ok that seemed to produce the correct results as expected
          Attached Files
          detail of setup in profile. Link to videos of my projects there as well. Over 300 scripts running every min and counting

          Comment


            Getting closer.

            A column chart is not going to be very successful. Looking at the update frequency, this is every 10 minutes. So for a 7 day column chart, you would have 6 X 24 X 7 = 1008 columns! It would look a complete mess.

            For the moment, try a line chart with these settings:


            [Create5]
            DBTable=4
            ChartStyle=4
            ChartPalette=12
            TitleText=Zac Weight 1
            XAxisText=[date]
            YAxisText=Weight
            AxisXFormat=MM/dd/yy
            AxisYFormat=
            UseData1=1
            UseData2=0
            UseData3=0
            UseData4=0
            UseData5=0
            UseData6=0
            UseData7=0
            UseData8=0
            UseData9=0
            UseData10=0
            ChartTimeStart=7
            ChartTimeFinish=0
            ChartTimeFormat=d
            BaselineValue=170
            AxisYMaximum=230
            CreateVD=1
            AutoUpdate=1
            Jon

            Comment


              Originally posted by BobSpen View Post
              Jon00,
              Any hope for size and weight(future feature add)?

              Thanks,
              Bob
              Yes, I'll add this to the next version.
              Jon

              Comment


                A column chart is not going to be very successful. Looking at the update frequency, this is every 10 minutes. So for a 7 day column chart, you would have 6 X 24 X 7 = 1008 columns! It would look a complete mess.
                wait? i followed your initial instructions for only setting it to manual update when the weight gets changed form fitseer? not sure where its updating every 10 mins? OH i see, that was earlier data i since made it a manual update
                detail of setup in profile. Link to videos of my projects there as well. Over 300 scripts running every min and counting

                Comment


                  Originally posted by jon00 View Post
                  Yes, I'll add this to the next version.
                  Thanks Jon00, I will appreciate that!!!
                  Bob

                  Comment


                    V1.0.11 Released

                    V1.0.11 Changes:

                    Relating to Jon00DBChartingStyle.ini and Jon00DBChartingStyleDemo.ini:

                    Added LegendFontSize (Adjust the legend font size) - User feature request
                    Added LegendFont (Change the font of the legend) - User feature request
                    Added LegentFontWeight (Adjust the font weight of the legend text) - User feature request

                    Relating to Jon00DBChartingCreate.ini and Jon00DBChartingCreateDemo.ini:
                    Added 'autolock' feature to lock primary & secondary axis together (i.e. use the same scale) - User feature request

                    Relating to Jon00DBCharting.ini and Jon00DBChartingDemo.ini:
                    DataXMaxValue can now set the database to either the max value specified or the last known good value.
                    DataXMinValue can now set the database to either the min value specified or the last known good value.

                    Other:
                    Corrected bug with tray icon exit function.
                    Updated documentation.

                    As before, additional entries to the ini files will need to be added manually and are not included as part of the config files in the download zip.
                    Jon

                    Comment


                      Best practices?

                      Team,

                      I was hoping to learn from your experience..

                      Scenario: 9 temperature sensors


                      Option #1 all sensors in 1 TABLE

                      [DBTable4]
                      Name=DB-Temperatures
                      Data1=$dtnr:211||1
                      Data1Label="Temp 1"
                      Data2=$dtnr:212||1
                      Data2Label="Temp 2"
                      Data3=$dtnr:213||1
                      Data3Label="Temp 3"


                      Option #2 each sensor in a separate table

                      [DBTable4]
                      Name=DB-Temperature1
                      Data1=$dtnr:211||1
                      Data1Label="Temp 1"

                      [DBTable5]
                      Name=DB-Temperature2
                      Data1=$dtnr:212||1
                      Data1Label="Temp 2"

                      [DBTable6]
                      Name=DB-Temperature3
                      Data1=$dtnr:213||1
                      Data1Label="Temp 3"


                      NOTE: these are all written every full hour.

                      Maybe there are specific advantages to one or the other (reporting options, performance, storage, etc,etc.)

                      Tnx!
                      DJ

                      Comment


                        The only {performance} issue I can see with having all sensors in one table is the time it takes to generate a chart would be longer than the time it takes to generate a chart for a single sensor, even this may not be that much longer.

                        However why would you want to have to look at multiple charts, when you can see all sensors on a single chart (unless the sensor value ranges are extremely different).
                        Mike

                        Comment


                          Originally posted by mwaite View Post
                          The only {performance} issue I can see with having all sensors in one table is the time it takes to generate a chart would be longer than the time it takes to generate a chart for a single sensor, even this may not be that much longer.

                          However why would you want to have to look at multiple charts, when you can see all sensors on a single chart (unless the sensor value ranges are extremely different).
                          Kind of makes sense... And you can display 1 item if the table contains multiple sensor data.. Tnx for sharing your ideas!

                          Comment


                            Request: table names instead of numbers

                            Team,

                            When you control the Jon00-DB-Charting device to update a table, you see the:
                            Table list
                            [DBTable1]
                            [DBTable2]
                            [DBTable3]
                            [DBTable4]
                            [DBTable5]
                            [DBTable6]

                            Would it be possible to get the table names instead of the table numbers?

                            Like
                            FrontdoorOpen
                            TempOffice
                            TempAttic
                            EnergyWater
                            EnergyGas

                            Cheers
                            DJ

                            Comment


                              FEATURE REQUEST: "minor" grid lines

                              jon00,
                              I'd like to request the addition of "minor" gridlines with control over color and line width and distinctive axis markers(different than the "major" grid markers-maybe shorter?). I have had an excellent experience with this product and hope you can continue to add features like this.

                              Thank you,
                              Bob

                              Comment


                                Hi Jon,

                                I am sure I have made a simple mistake but for the life of me I can't get the DB charting to work, at first I thought it might be because i had the demo mode set but I have since turned that off, and although the application is running, and the values are changing nothing gets stored to a database or graphed.

                                Is there anything that jumps out to you with the following settings that might be the culprit?

                                PHP Code:
                                [Settings]
                                Demo=0
                                MaxDataPoints
                                =2000
                                GuestView
                                =1
                                AxisXFormatRange
                                =0-9999999999=d/M HH:mm
                                [DBTable1]
                                Name=1
                                Data1
                                =$dva:Jon00-SNMP-003
                                Data1Label
                                =WAN Outgoing Traffic
                                Data2
                                =$dva:Jon00-SNMP-002
                                Data2Label
                                =WAN Incoming Traffic
                                Data3
                                =$dva:Jon00-SNMP-005
                                Data3Label
                                =Gateway Outgoing WLAN
                                Data4
                                =$dva:Jon00-SNMP-004
                                Data4Label
                                =Gateway Incoming WLAN
                                Data5
                                =$dva:Jon00-SNMP-007
                                Data5Label
                                =Garage Outgoing WLAN
                                Data6
                                =$dva:Jon00-SNMP-006
                                Data6Label
                                =Garage Incoming WLAN
                                Data7
                                =$dva:Jon00-SNMP-009
                                Data7Label
                                =Study Outgoing WLAN
                                Data8
                                =$dva:Jon00-SNMP-008
                                Data8Label
                                =Study Incoming WLAN
                                Data9
                                =$dva:Jon00-SNMP-012
                                Data9Label
                                =NAS Outcoming Traffic
                                Data10
                                =$dva:Jon00-SNMP-011
                                Data10Label
                                =NAS Incoming Traffic
                                Timer
                                =12
                                PurgeDays
                                =180
                                [DBTable2]
                                Name=2
                                Data1
                                =$dva:ArduinoBoard:2Rom:15F953D9A514D7
                                Data1Label
                                =Outside Greenhouse Temperature
                                Data2
                                =$dva:ArduinoBoard:2Rom:37F1BD26275B34C8
                                Data2Label
                                =Inside Greenhouse Temperature
                                Data3
                                =
                                Data3Label=
                                Data4=
                                Data4Label=
                                Data5=
                                Data5Label=
                                Data6=
                                Data6Label=
                                Data7=
                                Data7Label=
                                Data8=
                                Data8Label=
                                Data9=
                                Data9Label=
                                Data10=
                                Data10Label=
                                Timer=12
                                PurgeDays
                                =180
                                [DBTable3]
                                Name=
                                Data1=
                                Data1Label=
                                Data2=
                                Data2Label=
                                Data3=
                                Data3Label=
                                Data4=
                                Data4Label=
                                Data5=
                                Data5Label=
                                Data6=
                                Data6Label=
                                Data7=
                                Data7Label=
                                Data8=
                                Data8Label=
                                Data9=
                                Data9Label=
                                Data10=
                                Data10Label=
                                Timer=
                                PurgeDays=180
                                [Timer]
                                1=15
                                2
                                =25
                                3
                                =30
                                4
                                =45
                                5
                                =60
                                6
                                =120
                                7
                                =180
                                8
                                =240 
                                PHP Code:
                                [Create1]
                                DBTable=1
                                ChartStyle
                                =13
                                ChartPalette
                                =5
                                TitleText
                                =
                                XAxisText=
                                YAxisText=Kbps
                                AxisXFormat
                                =d/M hh:mm 
                                AxisYFormat
                                =
                                UseData1=1
                                UseData2
                                =1
                                UseData3
                                =1
                                UseData4
                                =1
                                UseData5
                                =1
                                UseData6
                                =1
                                UseData7
                                =1
                                UseData8
                                =1
                                UseData9
                                =1
                                UseData10
                                =1
                                ChartTimeStart
                                =48
                                ChartTimeFinish
                                =0
                                ChartTimeFormat
                                =H
                                BaselineValue
                                =0
                                CreateVD
                                =1
                                AutoUpdate
                                =1
                                 
                                =
                                [
                                Create201]
                                DBTable=1
                                ChartStyle
                                =201
                                ChartPalette
                                =12
                                UseData1
                                =1
                                UseData2
                                =1
                                UseData3
                                =1
                                UseData4
                                =1
                                UseData5
                                =1
                                UseData6
                                =1
                                UseData7
                                =1
                                UseData8
                                =1
                                UseData9
                                =1
                                UseData10
                                =1
                                BaselineValue
                                =Auto
                                CreateVD
                                =0
                                AutoUpdate
                                =0
                                ChartTimeStart
                                =2015/10/05 00:00:00
                                ChartTimeFinish
                                =2015/10/30 16:34:00 
                                Many Thanks!
                                HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

                                Facebook | Twitter | Flickr | Google+ | Website | YouTube

                                Comment

                                Working...
                                X