Announcement

Collapse
No announcement yet.

Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

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

  • desertmark8
    replied
    Jon,
    Thanks, I reloaded the settings.ini with Notepad instead of Notepad +++, restarted HS3, loaded the .Jon00DBsetup.asp url and the Charting Setup Page loaded.
    Thanks,
    Mark

    Leave a comment:


  • jon00
    replied
    Originally posted by desertmark8 View Post
    HI Jon,
    I've installed Charting Utility per the directions (I'm not experienced in programming so I have a question). When I edited the settings.ini, there were 2 files in the config folder (settings and settings.ini.bak) do I modify both or just he settings with out the .ini.bak extension?

    No, you only need to modify settings.ini (with Homeseer shut down). The .bak version is created automatically by HS3. The ScriptingReferences entry you have added looks fine.

    Also, after the edits to HS3, I get to the "Getting started" part, put in the url for web page configuration and the web page comes back blank...

    Please check that you have Jon00DBSetupASP.vben in your scripts folder and Jon00DBSetup.asp, Jon00DBSetup1.asp & Jon00DBSetup2.asp in your html folder.

    Can you elaborate on what you mean by blank i.e do you see the HS3 header bar? Are there any errors in the HS Log?


    I do see the demo graphs in the device management section on HS3 and I can stop the demos running by exiting from the system tray. But I cannot configure to get it running.

    Any idea what I'm doing wrong?
    Thanks,
    Mark
    Please see above in bold. We need the setup pages running correctly.

    Leave a comment:


  • desertmark8
    replied
    Here is my setttings file (with personal info removed):

    [Settings]
    ScriptingReferences=System.Drawing;System.Drawing.dll
    gLastShutdownOK=True
    gFirstTimeRun=False
    gConfigFilename=HomeSeerData.hsd
    gLocLabel=Room
    gLocLabel2=Floor
    bUseLocation2=True
    bLocationFirst=False
    gLongitude=xx
    gLatitude=xx
    SADProc=True
    gWebSvrPort=xx
    RateUpdated=True
    io_interfaces=Z-Wave:,NetCAM:,weatherXML:,OMNI:
    LastDevRef=708
    gLastRunVersion=3.0.0.548
    gLocationSelection=US
    gServerAddressBind=1.1.1.1
    gPhoneEnabled=False
    gSMTPServer=xx
    gSMTPPortNumber=xx
    gSMTPUserName=xx
    gSMTPPassword=xx
    gSMTPUseSSL=True
    gSMTPTo=me.com
    gSMTPDefSubj=My Homeseer
    PagedvRefs=396
    gSMTPDomain=me.com
    COMPort_Omnistat 3:=COM1
    [Display]
    gSelectedGroupWeb=All Groups
    [Cameras]
    hres=640


    Thanks, Mark

    Leave a comment:


  • desertmark8
    replied
    HI Jon,
    I've installed Charting Utility per the directions (I'm not experienced in programming so I have a question). When I edited the settings.ini, there were 2 files in the config folder (settings and settings.ini.bak) do I modify both or just he settings with out the .ini.bak extension?

    Also, after the edits to HS3, I get to the "Getting started" part, put in the url for web page configuration and the web page comes back blank...

    I do see the demo graphs in the device management section on HS3 and I can stop the demos running by exiting from the system tray. But I cannot configure to get it running.

    Any idea what I'm doing wrong?
    Thanks,
    Mark

    Leave a comment:


  • jon00
    replied
    Version 1.1.6 is now available. The majority of the changes relate to a number of feature requests over the last 18 months.

    Changes since 1.1.4:

    Corrected bug with database update mode for 'fixed timer one month referenced to day'
    Added LegendElementPos to the chart style settings. Allows moving the legend to any position on the chart
    Added TitleElementPos to the chart style settings. Allows moving the title to any position on the chart
    Added GridXStyleMajor to the chart style settings. Allows different line styles for the Major X Grid
    Added GridYStyleMajor to the chart style settings. Allows different line styles for the Major Y Grid
    Added GridY2StyleMajor to the chart style settings. Allows different line styles for the Major Y2 Grid
    Added GridXStyleMinor to the chart style settings. Allows different line styles for the Minor X Grid
    Added GridYStyleMinor to the chart style settings. Allows different line styles for the Minor Y Grid
    Added GridY2StyleMinor to the chart style settings. Allows different line styles for the Minor Y2 Grid
    Added AxisYCustomLabels to the chart style settings. Allows you to add your own labels to the Y Axis
    Added AxisY2CustomLabels to the chart style settings. Allows you to add your own labels to the Y2 Axis
    Added Plugin and ASP version numbers to all setup pages
    Added a checkbox to automatically update a chart when making changes to the Chart Creation Setup page
    Added a checkbox to automatically update a selected chart when making changes to the Chart Style Setup page

    Leave a comment:


  • jon00
    replied
    I think you mean post 1380?

    https://forums.homeseer.com/forum/3r...87#post1318687

    There have been no changes recently. Because you are now also using Y2, you may need to turn off the Y2 grids etc and even make the plot for the second repeat database transparent so that you only see the Y plotted. This will probably need a special chart style created for this graph.

    FYI, I do have a new version coming out shortly. This fulfills a number of feature requests and fix for a longstanding bug.

    Leave a comment:


  • langenet
    replied
    Thanks Jon for getting back. While the data looks as I expected, for some reason it's not maintaining my charting style as I showed in post #1374 (page 92). I have not changed the style with this most recent change or does it do this by default with the most recent change?

    Leave a comment:


  • jon00
    replied
    Originally posted by langenet View Post
    Thanks Jon,

    I've implemented your suggestions and even copied data from data1 to data2 for the past 32 days, but my graph style still doesn't look as I expected. Instead I still get the following:

    Click image for larger version

Name:	electric4.png
Views:	201
Size:	116.2 KB
ID:	1320696

    Since my database holds 365 days, is this the issue? - that being I only have 32 days were data1 = data2
    Sorry for the delay. What did you expect? The Y and Y2 axis are repeated correctly?

    Leave a comment:


  • langenet
    replied
    Thanks Jon,

    I've implemented your suggestions and even copied data from data1 to data2 for the past 32 days, but my graph style still doesn't look as I expected. Instead I still get the following:

    Click image for larger version

Name:	electric4.png
Views:	201
Size:	116.2 KB
ID:	1320696

    Since my database holds 365 days, is this the issue? - that being I only have 32 days were data1 = data2

    Leave a comment:


  • jon00
    replied
    I expect you will have to wait until the database has the same data for Data1 and Data2 (Y and Y2) for the period of the chart you wish to show.. Alternatively fix the y/y2 baseline and axis y/y2 maximum to the same values.

    Leave a comment:


  • langenet
    replied
    Originally posted by jon00 View Post

    Go to your chart creation setup page. Under the General settings, you will see "Use Data1", "Use Data2" etc. Whatever two data sources you are using, set one to "Yes - assigned to the Y axis" and the second to "Yes - assigned to the Y2 Axis".
    Jon,

    I gave your suggestion a try but it doesn't achieve the desired results. Here is what I'm seeing...

    Click image for larger version

Name:	electric1.png
Views:	83
Size:	116.7 KB
ID:	1320192

    I take it that your suggestions are correct below?

    Click image for larger version

Name:	electric2.png
Views:	72
Size:	237.6 KB
ID:	1320193Click image for larger version

Name:	electric3.png
Views:	75
Size:	272.8 KB
ID:	1320194

    I'm not sure but the graph style changed and when I reversed my changes, the style of my graph didn't revert back to my original posting.

    Thanks,

    Robert



    Leave a comment:


  • jon00
    replied
    Originally posted by langenet View Post

    Jon,

    Just getting back to this... I get assigning the same data source to a second field (Source 2 data) for example, but I don't understand the part about assigning the Y2 entry part. How is this done?

    Robert
    Go to your chart creation setup page. Under the General settings, you will see "Use Data1", "Use Data2" etc. Whatever two data sources you are using, set one to "Yes - assigned to the Y axis" and the second to "Yes - assigned to the Y2 Axis".

    Leave a comment:


  • langenet
    replied
    Originally posted by jon00 View Post

    Only by assigning the same data source to a second field and assigning that to the Y2 entry.
    Jon,

    Just getting back to this... I get assigning the same data source to a second field (Source 2 data) for example, but I don't understand the part about assigning the Y2 entry part. How is this done?

    Robert

    Leave a comment:


  • jon00
    replied
    Most odd. I really don't know what is different with your system but I do know 100's of people have this working using the same download files as you have.

    Leave a comment:


  • zsima
    replied
    Hi

    I have been starting HS3 by right clicking and running as administrator. and I have been doing the same thing with Jon00DBChartingHS3.exe in Windows explorer. to make sure it is running

    What actually worked this time was instead of right clicking and running , I just double clicked the Jon00DBChartingHS3.exe and than the program started working.

    I'm afraid to shut everything down in case it wont work same way next time.

    Leave a comment:

Working...
X