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 racerfern View Post
    No joy, I just replaced the nine files with the ones from the zip that I downloaded again and same result.
    I also just upgraded to 4.0.1.31 and same result.
    Ok, lets go back to the basics. Do you see the plugin startup messages in the log?
    Jon

    Comment


      I'm seeing this after the last startup.

      2/19/2020 20:24:50 HomeSeer Error Loading script Jon00DBChartingASPX.vben :File not found: Jon00DBChartingASPX.vben

      Comment


        Originally posted by racerfern View Post
        I'm seeing this after the last startup.

        2/19/2020 20:24:50 HomeSeer Error Loading script Jon00DBChartingASPX.vben :File not found: Jon00DBChartingASPX.vben
        I've checked and it is in the download zip. There are two scripts in the zip that need to be installed.
        Jon

        Comment


          I''ll get back to you not at that PC right now.

          Comment


            Working now. Something in Windows security wouldn't overwrite the existing file. I had to delete and then copy. Sorry to bother you but all's well on the other side of the pond, for now.

            Comment


              Issue again, nothing changed except that I've installed a couple of interim betas. v4.0.1.39

              The chart will not render, too much time to render

              Comment


                And of course after thinking about this, Jon00dbchartinghs3.exe starts and then does not stay running in the background. Not sure why.

                Comment


                  Originally posted by racerfern View Post
                  And of course after thinking about this, Jon00dbchartinghs3.exe starts and then does not stay running in the background. Not sure why.
                  I can only see that happening if you are not using the latest version which is for HS3 & HS4.
                  Jon

                  Comment


                    We're all good once again, it was not being run with administrator access. Thanks.

                    I do have an issue with displaying a graph. I want min=0 max=8000 but no matter what I do the graph shows a range that just leaves a bit of space top and bottom. I did read the doc and added "#" before the max. But I realize now that's to correct numbers outside of the acceptable range.

                    I want the graph below to have a Y axis from 0 to 8000. What am I missing?
                    Click image for larger version

Name:	Screen Shot 03-01-20 at 03.39 PM.PNG
Views:	173
Size:	67.3 KB
ID:	1367413

                    Comment


                      You cannot change it. Because you are using the dynamic charting, it has to be set to auto to allow the large variation of charts being displayed from the various databases.
                      Jon

                      Comment


                        I just installed this Plugin. I have one database for now. I have 2 temp sensors logging data every minute on a timer. I have a couple questions.

                        1. is there a way to estimate how big the database file will get over time?
                        2. I read that you can only delete the last database. What happens latter when I have let's say 4 databases and I want to delete one of the first 3?

                        Thanks
                        Jim

                        Comment


                          1) I can't answer that because it depends on the number of tables being recorded and purge settings per table. What I can say it that you should not have an issue with size and by default, all databases are purged after 180 days (can be changed in settings).

                          2) There is only one database so you can't delete it. Individual tables within the database cannot be deleted (apart from the last one) but you can purge their size to one day it if you want. Just reuse unused tables at a later date.

                          FYI, I would recommend you record your temperatures on device value change rather than every minute as this will fill the database with unnecessary data.
                          Jon

                          Comment


                            I changed to record on device value change. I must a little confused how the database works. If I click on New Database, that creates another table in the ini file to record another 10 devices?

                            Thanks
                            Jim

                            Comment


                              Originally posted by jbfoster View Post
                              I changed to record on device value change. I must a little confused how the database works. If I click on New Database, that creates another table in the ini file to record another 10 devices?

                              Thanks
                              Jim
                              Ini file settings are for configuration. The actual data is stored in a single SQLite database.
                              Jon

                              Comment


                                I know I'm missing something very simple, but I can't seem to find the instructions on how to install and configure this. I downloaded the zip file from http://jon00.me.uk/ (redirected to an IP) and extracted all of the files into the matching directories in HS4. I can see a new "device" in the devices view that has "Utility | Jon00 DemoDBChart" on one line and "Chart Manual Update" below it. Clicking on the Chart Manual Update shows what appears to be the standard device fields, but I can't figure out how to configure anything. Am I missing a installation document page or a walkthrough somewhere?

                                Comment

                                Working...
                                X