Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

[jon00]

What is the easiest/best way to update the database manually? I have some crazy data logged that messed up my energy graphs.

Via an event. See page 8 in the docs.

[Freddan101]

Sorry, I wasn't clear. I need to delete/update certain values in the database.

[jon00]

I would use DB Browser for SQLite: http://sqlitebrowser.org/ which is under troubleshooting in the docs (page 38).

[Freddan101]

Perfect, thank you. What an easy tool to use.

[peterpc]

I created my 10th chart and can't get it to work.
Made a copy in Jon00DBCharting.ini of [DBTable9] and in Jon00DBChartingCreate.ini a copy of [Create9].
Changed [Create9] in [Create10] and DBTable = 10, but I get chart010.png of 0 kB.
Database is filling with the right values in data10 but chart is not created.
Please advise.

[jon00]

I have no idea what you have done wrong. If you set the 10th chart to the 9th database, do you get an image created? Similarly, if you set the 10th database to the 9th chart, does that show?

[peterpc]

If I change the databases, then image 9 is created with dbase 10, but image 10 is not created with dbase 9.

[jon00]

Please provide a copy your 3 ini files and I will try and see where you have gone wrong. If you don't want to post here, please email to me.

[peterpc]

This are my ini files:

[jon00]

I cannot see anything wrong. Do you use the dynamic web page to display charts? If so, can you display a chart over 24 hours using database 10?

[peterpc]

That is working ok:

[jon00]

The chart you created uses [Create201] in the Jon00DBChartingCreate.ini

To test, I would copy that to [Create10] and set CreateVD=1. See if that works.

[peterpc]

I copied [Create1] over [Create10] to see if that works.
That was working, getting chart 1 and 10 identical.
I then changed the settings in Create10 back to the settings I need by hand, and it was still working.
Really don't know why it went wrong.
Only thing I can think of, is that there was a strange character in the ini file stopping the creation of the charts.
But it is working now!
Thanks for your help.

[mrceolla]

It makes sense, however there is no way to achieve selective scaling from data sources being plotted.

What about this idea? Add a new configuration variable where the user can supply a comma delimited string of data source IDs that they wish to use for the minimum and maximum Y values.

minYSources = 2,3,5,6
maxYSources = 2,3,5,6

You could then calculate the Y axis min and max ahead of time and insert them into BaselineValue and AxisYMaximum (I think those are the right variable names).

Do you think that would be a possibility?

Thanks!

[jon00]

I can try. When would you be available to test?