Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

[jon00]

The event don't work either.

I'm not sure, but think that i made it wright. This is what i have done:

IF This event is MANUALLY triggered
Select "Control a Device"
From the Drop down select "Utility Jon00 DBChart Chart Manual Update"
Select "Update [Create14]".

Finally run the event, but nothing happens. Even that i create another event, to trigger on 00:00:05 the 1st...

What happens if you run it manually now?

[nunoary]

Nothing happens, there's no changes on the chart.

Note that i run the event just for update the chart (see previous post), should i also try to manually update the database (in my case DBtable7)?



Once again the value (Diff1) was set correctely, like it should, in the Jon00DBChartingData.ini

[Month]

CurrentValue1=809.946
LastValue1=607.426
Diff1=202.52
CurrentValue2=1.62
LastValue2=1.02
Diff2=0.6
CurrentValue3=0.21
LastValue3=0.16
Diff3=0.05
CurrentValue4=0.18
LastValue4=0.14
Diff4=0.04
Last Updated1=01-Feb-18 00:00:01
Last Updated2=01-Feb-18 00:00:01
Last Updated3=01-Feb-18 00:00:02
Last Updated4=01-Feb-18 00:00:03
CurrentValue5=0.09
LastValue5=0.06
Diff5=0.03
CurrentValue6=0.21
LastValue6=0.16
Diff6=0.05
Last Updated5=01-Feb-18 00:00:04
CurrentValue7=0.21
LastValue7=0.16
Diff7=0.05
Last Updated6=01-Feb-18 00:00:05
Last Updated7=01-Feb-18 00:00:06
CurrentValue8=0.01
LastValue8=0
Diff8=0.01
CurrentValue9=0.02
LastValue9=0
Diff9=0.02
Last Updated8=01-Feb-18 00:00:08
Last Updated9=01-Feb-18 00:00:08

[jon00]

Yes, you need to update the database so that the update is recorded. If the data is correctly stored in the ini file, I don't really see the need for it to be updated 5 seconds past midnight for a monthly chart. Surely this could be 5 minutes past etc?

[nunoary]

Ok. I update the database and it worked. I also try, on another monthly graph, only to update the database and it automatically create the graph, without i need to manually create the chart.

You are right about the updated time...i knew I'll change it...

[jeanv]

Getting Event Log Errors 1026 and 1000 When Running Jon00DBChartingHS3.exe

I tried installing Jon00 DB Charting and I keep getting the following 2 errors every time it runs:

I have scoured the Internet and the HomeSeer forums for this. All my other plugins run great. Not sure where to start with this?

Event 1026:

Application: Jon00DBChartingHS3.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.FileNotFoundException
at Jon00DBChartingHS3.Form1..ctor()

Exception Info: System.InvalidOperationException
at ӱ藍섖剆㞨觍详䗝+MyForms.�롴恊�︼㗹牰㌸[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.__Canon)
at 鿲鮁贔ట宩덓.OnCreateMainForm()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplic ationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplic ationBase.DoApplicationModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplic ationBase.Run(System.String[])
at 鿲鮁贔ట宩덓.銢䪾滺☻䊁㡃⪚(System.String[])

and Event 1000

Faulting application name: Jon00DBChartingHS3.exe, version: 1.0.0.0, time stamp: 0x589ef61a
Faulting module name: KERNELBASE.dll, version: 6.1.7601.24000, time stamp: 0x5a4996d4
Exception code: 0xe0434352
Fault offset: 0x0000c54f
Faulting process id: 0x1d90
Faulting application start time: 0x01d39c6978ff0756
Faulting application path: C:\Program Files (x86)\HomeSeer HS3\bin\Jon00DBChart\Jon00DBChartingHS3.exe
Faulting module path: C:\Windows\syswow64\KERNELBASE.dll
Report Id: b77aedd4-085c-11e8-8c52-408d5c7c4b24

[jon00]

Did you copy the 3 Homeseer dll's into the same folder as the exe as per the documentation?

[jeanv]

I truly feel like an idiot! I consider myself fairly detail oriented and I totally missed that in the documentation! There it is, clear as day!!!

Once I copied those three files, it worked... I am a moron...

I thank you for your time... I was literally spooling up a VM to test this on a "clean" homeseer install... I am a dork...

Thank you!!!!

[bdraper]

I truly feel like an idiot! I consider myself fairly detail oriented and I totally missed that in the documentation! There it is, clear as day!!!

Once I copied those three files, it worked... I am a moron...

I thank you for your time... I was literally spooling up a VM to test this on a "clean" homeseer install... I am a dork...

Thank you!!!!

Don't beat yourself up... we've all been there. Glad you got it sorted out. Jon's charting package is incredible.

[Guest]

Want to try this plugin. But do not know what i will chart with it lol.

Can you guys give me some ideas: except for energy consumption?

thanks

[jeanv]

I have a bunch of different sensors that give temperature.. I chart those:

- Zwave Leak sensor has a built in temp sensor
- Current Cost Energy meter has a temp sensor
- Thermostat has a temp sensor
- Oregon Scientific temp sensors
- Elk Alarm Keypads have temp sensors

[bdraper]

Want to try this plugin. But do not know what i will chart with it lol.

Can you guys give me some ideas: except for energy consumption?

thanks

I use Jon's charting plugin to graph all sorts of things... these are a few.

HVAC Usage - Last 14 Days - see this link for more info, https://forums.homeseer.com/showthread.php?t=169671


Power Usage - Last 14 Days


Power Usage kWH - Last 24 hours


Power Usage Amps - Last 24 hours


Sump Pump Levels - see this link for more info https://forums.homeseer.com/showpost...6&postcount=12


Temperature in our Master Bedroom. One of the sensor is in a floor register and measures the temperature coming out of the HVAC unit. The other sensor is in the wall, and for comparison we graph the outside temperature.

[bdraper]

A few more examples...

Water heater temperature. I am testing with a NodeMCU and monitoring the temp of our water heater, top and bottom and both cold and hot water lines.


A graph of the last 7 days for the computer room UPS.


Jon's graphing application is highly configurable, very well documented and extremely useful.

Good luck and let us know if you have any questions.

[theendisnye]

I am doing occupancy across rooms.

Steve

[cbabkirk]

Exporting Data

Jon,

Is there a way to export raw data for a given chart from the database?

-cliff

[jon00]

From the dynamic chart - Yes.

When you display the table showing the metrics, you can click on the Total Datapoints text link to download it in CSV format.