Announcement

Collapse
No announcement yet.

Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

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

    Originally posted by jon00 View Post
    If you have issues getting it to work, please let me know.

    Hi Jon, thanks again - this is GOLD :-)

    I added this to an hourly event and it seems to be working so far when I run it manually (although I haven't gone through a 24 hour cycle so the daily usage hasn't updated yet).
    One issue I'm having is that the hourly event doesn't seem to be firing automatically. I'm using "The event will automatically trigger once per hour from the top of the hour at.." with "0 hours 0 min 0 sec". I assume this means the event should fire at the top of every hour with zero offset but it hasn't run all day. Nothing in my logs either. Other events are triggering fine. Here is a screenshot - any ideas?
    Attached Files

    Comment


      Just change your first condition to:

      The event will automatically trigger from the top of the hour every hour.

      It should work fine after that.
      Jon

      Comment


        Control of Legend Font?

        Jon00,
        Is there any ability to control the size, weight, or color of the Legend Font. Mine is always black, rather small, and light weight--sometimes unreadable.
        Thanks,
        BobSpen

        Comment


          arrgh what am i doing wrong?

          I want a chart that will make either a dot at the right x asis ( being weight) each time i step on the scales.

          using fitbitseer it updates the virtual device and when that value changes I have a script that tells the charting utility to update the database with the new value and also updates the charts. i expected to see a nice plot over the past few days but this is what i get ( see chat image )

          here are my config files for this:

          [DBTable5]
          Name=Zac Weight
          Data1=$dvr:180
          Data1Label=Weight
          Data2=
          Data2Label=
          Data3=
          Data3Label=
          Data4=
          Data4Label=
          Data5=
          Data5Label=
          Data6=
          Data6Label=
          Data7=
          Data7Label=
          Data8=
          Data8Label=
          Data9=
          Data9Label=
          Data10=
          Data10Label=
          Timer=
          PurgeDays=90


          and the create info:
          [Create5]
          DBTable=4
          ChartStyle=2
          ChartPalette=12
          TitleText=Zac Weight 2
          XAxisText=[date]
          YAxisText=Weight
          AxisXFormat=MM/dd/yy
          AxisYFormat=D
          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=150
          AxisYMaximum=250
          CreateVD=1
          AutoUpdate=1



          And finally the chart style

          [ChartStyle2]
          Width=600
          Height=400
          ResizeXY=300,200
          BorderSkinStyle=2
          BorderlineColor=Silver
          BorderlineDashStyle=6
          BorderlineWidth=6
          ChartBackgroundColor=White
          ChartBackgroundSecondaryColor=Gainsboro
          ChartBackgroundGradientStyle=7
          PlotType=5,5,5,5,5,5,5,5,5,5
          PlotColor=
          PlotBorderWidth=2,2,2,2,2,2,2,2,2,2
          DrawingStyle=2,2,2,2,2,2,2,2,2,2
          MarkerType=4,4,4,4,4,4,4,4,4,4
          MarkerColor=red,red,red,red,red,red,red,red,red,red
          ShowValues=0,0,0,0,0,0,0,0,0,0
          Markersize=5,5,5,5,5,5,5,5,5,5
          Markerstep=1,1,1,1,1,1,1,1,1,1
          TitleFontSize=14
          TitleFontWeight=1
          Font=Sans Serif
          ChartAreaBackgroundColor=AntiqueWhite
          ChartAreaBackgroundSecondaryColor=
          ChartAreaBackgroundGradientStyle=2
          ChartAreaPosition=
          ChartBorderlineDashStyle=6
          ChartBorderlineColor=Black
          ChartBorderlineWidth=0
          ShowLegend=1
          LegendPosition=2
          LegendBackGroundColor=Transparent
          GridColor=Thistle
          AxisXColor=Thistle
          AxisYColor=Thistle
          AxisXLabelColor=
          AxisYLabelColor=
          AxisXDataColor=
          AxisYDataColor=
          AxisFontSize=12
          AxisFontWeight=3
          AxisXInterval=1
          AxisYInterval=1
          AxisYMaximum=
          AxisXTextRotation=
          AxisYTextRotation=
          AxisXTextSize=
          AxisYTextSize=
          AxisYTextSizeSec=
          AxisXTextFontWeight=
          AxisYTextFontWeight=
          AxisYTextFontWeightSec=
          AxisTextFont=
          3DEnable=1
          3DInclination=30
          3DRotation=20
          3DWallWidth=10


          anyone see what im doing wrong??
          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


            Originally posted by jon00 View Post
            Just change your first condition to:

            The event will automatically trigger from the top of the hour every hour.

            It should work fine after that.
            Thanks that fixed it. Looks like I misinterpreted the meaning of the trigger...

            Comment


              Originally posted by BobSpen View Post
              Jon00,
              Is there any ability to control the size, weight, or color of the Legend Font. Mine is always black, rather small, and light weight--sometimes unreadable.
              Thanks,
              BobSpen
              Legend Color is supported. Looks like I need to update the docs (it is mentioned in the change log for V1.0.4 at the end of the docs.)

              Add LegendColor=XXXX to your ChartStyle in the Jon00DBChartingStyle.ini
              Jon

              Comment


                Originally posted by collegeboyslive View Post
                I want a chart that will make either a dot at the right x asis ( being weight) each time i step on the scales.

                using fitbitseer it updates the virtual device and when that value changes I have a script that tells the charting utility to update the database with the new value and also updates the charts. i expected to see a nice plot over the past few days but this is what i get ( see chat image )

                anyone see what im doing wrong??
                This is difficult to diagnose as it really depends on what you have recorded in the database.

                First thing, bring up the dynamic web page to show charts (page 5 in the docs) and then select the correct database with dates for the last 7 days. What does that look like?

                If you press the + on the top right of the page, you will be able to view the database entries.

                Also, try changing ChartTimeFormat=D to ChartTimeFormat=d
                Last edited by jon00; August 20, 2015, 02:55 AM.
                Jon

                Comment


                  ok this is crazy

                  ok i followed what you said jon, and getting really weird data see image

                  i checked and double checked that the device ID ia 180 and im referencing
                  Data1=$dvr:180

                  in the charting ini file

                  what IS going on?? i even made another one and the same thing happens , the value on the fitbit weight device part are correct, all my power charts work just fine for monitoring and charting power usage, it almost looks like its getting those values instead of the weight values. in fact a comparison of the 2 chart numbers shows indeed it is , when i click on the + the data is the same see 2nd post with the data showing , 2 tables but at top it clearly says 1 selected
                  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


                    odd

                    chart showing 2 tables but above only 1 (out of 1) selected
                    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


                      To confirm, the device reference number of your FitbitSeer device is 180?

                      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!
                      Last edited by jon00; August 20, 2015, 07:07 AM.
                      Jon

                      Comment


                        yes it is 180 and i posted a pic below of all the data for you to see
                        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


                          Zac,

                          Things don't add up here. From your config below, you should be looking at Weight not Weight 3:

                          [DBTable5]
                          Name=Zac Weight
                          Data1=$dvr:180
                          Data1Label=Weight
                          Jon

                          Comment


                            Sorry Jon, i had just changed the names before i grabbed the next screen pic, I had made a new one and wanted to make sure that all were different, i now have them labled 1 2 and 3 to make it easyer for me, here is the entire charting ini


                            [Settings]
                            Demo=0
                            MaxDataPoints=6000
                            GuestView=0
                            AxisXFormatRange=0-9999999999=M/d HH:mm

                            [DBTable1]
                            Name=House Power
                            Data1=$dva:cbl-pwr
                            Data1Label=CBL
                            Data2=$dva:apt-pwr
                            Data2Label=Apartment
                            Data3=
                            Data3Label=
                            Data4=
                            Data4Label=
                            Data5=
                            Data5Label=
                            Data6=
                            Data6Label=
                            Data7=
                            Data7Label=
                            Data8=
                            Data8Label=
                            Data9=
                            Data9Label=
                            Data10=
                            Data10Label=
                            Timer=13
                            PurgeDays=30

                            [DBTable2]
                            Name=AC run Time
                            Data1=$dva:003D228A-002-Q5
                            Data1Label=Run
                            Data2=
                            Data2Label=
                            Data3=
                            Data3Label=
                            Data4=
                            Data4Label=
                            Data5=
                            Data5Label=
                            Data6=
                            Data6Label=
                            Data7=
                            Data7Label=
                            Data8=
                            Data8Label=
                            Data9=
                            Data9Label=
                            Data10=
                            Data10Label=
                            Timer=13
                            PurgeDays=7

                            [DBTable3]
                            Name=CBL POwer Past 24
                            Data1=$dva:cbl-pwr
                            Data1Label=Watts
                            Data2=
                            Data2Label=
                            Data3=
                            Data3Label=
                            Data4=
                            Data4Label=
                            Data5=
                            Data5Label=
                            Data6=
                            Data6Label=
                            Data7=
                            Data7Label=
                            Data8=
                            Data8Label=
                            Data9=
                            Data9Label=
                            Data10=
                            Data10Label=
                            Timer=13
                            PurgeDays=7

                            [DBTable4]
                            Name=Zac Weight 1
                            Data1=$dvr:180
                            Data1Label=Weight
                            Data2=
                            Data2Label=
                            Data3=
                            Data3Label=
                            Data4=
                            Data4Label=
                            Data5=
                            Data5Label=
                            Data6=
                            Data6Label=
                            Data7=
                            Data7Label=
                            Data8=
                            Data8Label=
                            Data9=
                            Data9Label=
                            Data10=
                            Data10Label=
                            Timer=
                            PurgeDays=180

                            [DBTable5]
                            Name=Zac Weight 2
                            Data1=$dvr:180
                            Data1Label=Weight
                            Data2=
                            Data2Label=
                            Data3=
                            Data3Label=
                            Data4=
                            Data4Label=
                            Data5=
                            Data5Label=
                            Data6=
                            Data6Label=
                            Data7=
                            Data7Label=
                            Data8=
                            Data8Label=
                            Data9=
                            Data9Label=
                            Data10=
                            Data10Label=
                            Timer=
                            PurgeDays=90

                            [DBTable6]
                            Name=Zac Weight 3
                            Data1=$dvr:180
                            Data1Label=Weight 3
                            Data2=
                            Data2Label=
                            Data3=
                            Data3Label=
                            Data4=
                            Data4Label=
                            Data5=
                            Data5Label=
                            Data6=
                            Data6Label=
                            Data7=
                            Data7Label=
                            Data8=
                            Data8Label=
                            Data9=
                            Data9Label=
                            Data10=
                            Data10Label=
                            Timer=
                            PurgeDays=90

                            [Timer]
                            1=15
                            2=25
                            3=30
                            4=45
                            5=60
                            6=120
                            7=180
                            8=240
                            detail of setup in profile. Link to videos of my projects there as well. Over 300 scripts running every min and counting

                            Comment


                              The weights in the device value don't seem to match the weights in the database. Until that is addressed we cannot continue. How are you triggering the database updates BTW?
                              Jon

                              Comment


                                Originally posted by jon00 View Post
                                Legend Color is supported. Looks like I need to update the docs (it is mentioned in the change log for V1.0.4 at the end of the docs.)

                                Add LegendColor=XXXX to your ChartStyle in the Jon00DBChartingStyle.ini
                                Jon00,
                                Any hope for size and weight(future feature add)?

                                Thanks,
                                Bob

                                Comment

                                Working...
                                X