Announcement

Collapse
No announcement yet.

Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

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

  • jon00
    replied
    I'm not quite sure what you are doing; however for clarity the URL's for dynamic charting are:

    HS3:
    /Jon00DBCharting.asp

    HS4
    /Jon00DBCharting.html

    If you use /Jon00DBCharting.asp in HS4, you will lose the menu structure at the top.

    Leave a comment:


  • racerfern
    replied
    Something's still not right. I have no problem creating databases, or so it seems. However when I go to charting, I get a blank screen. http://192.168.1.38/Jon00DBCharting.asp

    If I'm in DB setup and I click on Dynamic Charting it goes to the main HS4 view with headers and nothing else.
    http://192.168.1.38/Jon00DBCharting.html

    Same targets as my HS3 machine just a different IP


    Leave a comment:


  • racerfern
    replied
    Apparently, I had some old version of something for the HS4 application. I removed everything related and started over. All's well.

    Note that although the exe file didn't show in the taskbar and the charting would not work, the exe still showed up in task manager. Weird.

    Leave a comment:


  • jon00
    replied
    Originally posted by racerfern View Post
    OK, I narrowed it down. On HS3 I had another program hogging resources. With that problem gone, the charting works fine.

    On the HS4 machine, the Jon00DBChartingHS3.exe keeps closing. I have no idea why.
    Odd. I had the application checked with a HS4 user and it was working fine. How long does it run for? Just check you are using the correct exe as you would exhibit that behavior if using the last HS3 version prior to 1.2.0

    Leave a comment:


  • racerfern
    replied
    OK, I narrowed it down. On HS3 I had another program hogging resources. With that problem gone, the charting works fine.

    On the HS4 machine, the Jon00DBChartingHS3.exe keeps closing. I have no idea why.

    Leave a comment:


  • racerfern
    replied
    I keep getting this error, even after a restart. This is for HS3.
    I did lose all my existing charts, no big deal. So this is starting from scratch.
    Feb-17 18:54:25 Jon00_DBChart Timeout Error: Chart took to long to render

    Leave a comment:


  • racerfern
    replied
    Cool!

    Leave a comment:


  • jon00
    replied
    V1.2.0 runs on both. I've corrected the cross to a tick!

    Leave a comment:


  • racerfern
    replied
    Updated application and web pages to be compatible with both Homeseer 3 & HS4
    but on your website the Homeseer4 is X. Please advise if it will run on both or is there another download I can't find.

    Thanks again for your awesome contributions to the HS community.

    Leave a comment:


  • jon00
    replied
    Version 1.2.0 is now available.

    Changes from V1.1.6:

    Updated application and web pages to be compatible with both Homeseer 3 & Homeseer 4
    Corrected bugs in a couple of the replacement variables.
    Changed BaseLineValue, BaseLineValueSec, AxisYMaximum & AxisYMaximumSec to except decimal values.

    Leave a comment:


  • AZweimiller
    replied
    Great, thanks!

    Leave a comment:


  • jon00
    replied
    Yes, it reads the values from the devices directly.

    Leave a comment:


  • AZweimiller
    replied
    Does this work for devices where I have enabled "Do not log commands from this device"? I wasn't sure if this is where the plugin gets the data that it stores in the DB.

    Leave a comment:


  • jon00
    replied
    Originally posted by feman View Post
    I have been re-arranging my database tables in the jon00dbcharting.db3 file. I was using DBTable1 for collecting data but stopped that process a few weeks ago. This morning I decided to clear out the data in DBTable1.

    I used DB Browser for SQLite to delete the records in DBTable1 and then saved the changes. I then called up jon00dbcharting.asp to check to see if the database structure was still intact and to make sure that the data was gone. So far, so good. Data was gone but the DBTable name I had used and the selections for the sources in DBTable1 were still showing in the drop down boxes used to populate the chart.

    I then called up jon00dbsetup.asp to look at the setup for the DBTable1. I changed the name of DBTable1 back to DBTable1 and then went thru all the SourceXX drop down lists and changed the entry back to "Select to use device value or enter string for other methods". I did that for all six of the sources that were setup in DBTable1.

    I hit the submit button and then called up jon00dbcharting.asp again to see if the selections for DBTable1 were changed. When the page came up the Database drop down list was empty and I could not call up any of the other two DBTables in the file.

    Click image for larger version

Name:	snip_20191203115558.png
Views:	150
Size:	22.9 KB
ID:	1344196
    I have broken something. Any ideas? (before I started this process I copied all of the jon00 config files and the .db3 file into a safe place, so I am not totally hosed.)
    Not really, however open up Jon00DBCharting.ini and check that you have [DBTable1] and that Data1= has an entry, Do the same for [DBTable2], Data1 etc. All database entries must be sequential (starting at 1) and contain a value for Data1.

    Leave a comment:


  • Nacman
    replied
    Originally posted by jon00 View Post
    OK, you are using the dynamic charting page which is setup to view data from any database. You cannot customize this page to suit individual databases. If you want to change the baseline for this chart, open up Jon00DBChartingCreate.ini and look for the section [Create201] at the bottom of the file. You can then modify the BaselineValue=auto to BaselineValue=0 . If you also use the Y2 Axis, change BaselineValueSec=auto to BaselineValueSec=0

    Doing so will mean all other charts displayed will also use 0 as the baseline value.

    The setup described earlier will create individual charts which can be displayed in virtual devices, HSTouch etc customized to your liking.

    Jon....That did the trick. Even though I RTFM, I missed where it is touched on. All is well.

    -RIchard

    Leave a comment:

Working...
X