Announcement

Collapse
No announcement yet.

Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

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

  • 123qweasd
    replied
    Check HS / Docs folder, all of Jon00's PI use the same folder to store user guides.

    Leave a comment:


  • duanecr
    replied
    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?

    Leave a comment:


  • jon00
    replied
    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.

    Leave a comment:


  • jbfoster
    replied
    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

    Leave a comment:


  • jon00
    replied
    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.

    Leave a comment:


  • jbfoster
    replied
    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

    Leave a comment:


  • jon00
    replied
    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.

    Leave a comment:


  • racerfern
    replied
    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

    Leave a comment:


  • jon00
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • racerfern
    replied
    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

    Leave a comment:


  • racerfern
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • jon00
    replied
    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.

    Leave a comment:


  • racerfern
    replied
    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

    Leave a comment:

Working...
X