Jon00 Database Charting Utility for Homeseer 3 & Homeseer 4

[Lee_L]

Jon,
I'm having some issues with this plugin. I have it installed, the demo works. But, when I switch over to have it start pulling my data in to a chart, I'm getting stuck. The database file seems to be updating with new data (temperature sensor data) and the chart is created. However, when created, there's nothing displayed. I'm stuck... any advice is greatly appreciated!

[bdraper]

I'm sure it was working. Can you email your latest database file to try here again.

Sure, no problem. I have sent the database.

[jon00]

Jon,
I'm having some issues with this plugin. I have it installed, the demo works. But, when I switch over to have it start pulling my data in to a chart, I'm getting stuck. The database file seems to be updating with new data (temperature sensor data) and the chart is created. However, when created, there's nothing displayed. I'm stuck... any advice is greatly appreciated!

I would have to see your Jon00DBCharting.ini & Jon00DBChartingCreate.ini files before I can assist.

[Lee_L]

I would have to see your Jon00DBCharting.ini & Jon00DBChartingCreate.ini files before I can assist.

Jon00Charting.ini:

[Settings]
Demo=0
MaxDataPoints=8000
GuestView=0
AxisXFormatRange=2=0-1440=M/d HH:mm
ASPXChartStyle=0
[DBTable1]
Name=1
Data1=$dva:C6A178D8-040-Q12
Data1Label=Kitchen Temperature
Data1Multiplier=
Data2=$dva:C6A178D8-015-Q68
Data2Label=Living Room Temperature
Data2Multiplier=
Data3=$dva:C6A178D8-019-Q26
Data3Label=Master Bedroom Temperature
Data3Multiplier=
Data4=
Data4Label=
Data4Multiplier=
Data5=
Data5Label=
Data5Multiplier=
Data6=
Data6Label=
Data6Multiplier=
Data7=
Data7Label=
Data7Multiplier=
Data8=
Data8Label=
Data8Multiplier=
Data9=
Data9Label=
Data9Multiplier=
Data10=
Data10Label=
Data10Multiplier=
Timer=11
PurgeDays=180

Jon00DBChartingCreate.ini:

[Create1]
DBTable=1
ChartStyle=2
ChartPalette=10
TitleText=Inside Temperatures
XAxisText=Time
YAxisText=Temperature
YAxisTextSec=
AxisXFormat=hh:mm:ss
AxisYFormat=
AxisYFormatSec=
UseData1=1
UseData2=1
UseData3=1
UseData4=0
UseData5=0
UseData6=0
UseData7=0
UseData8=0
UseData9=0
UseData10=0
ChartTimeFormat=m
ChartTimeStart=6
ChartTimeFinish=0
BaselineValue=Auto
BaselineValueSec=Auto
AxisYMaximum=Auto
AxisYMaximumSec=Auto
CreateVD=1
AutoUpdate=1
ShowAllValues=1

[jon00]

It looks fine. Do you have the dynamic charting web page running yet. If so, can you see the data in that?

[jon00]

Sure, no problem. I have sent the database.

Using the same download link that I sent you, can you try again please.

[bdraper]

Using the same download link that I sent you, can you try again please.

Nice job, just tried the new version and it displays the values from August 20, the prior day a minute before midnight.

Thanks for your help. Great plugin by the way.

[Lee_L]

It looks fine. Do you have the dynamic charting web page running yet. If so, can you see the data in that?

No sir, it's not working. When I go to http://192.168.1.10:8080/Jon00DBCharting.asp, set the parameters and click "Chart", the screen flashes as if it's doing something, but is blank.



When I click on the "+", I get this error:

[jon00]

No sir, it's not working. When I go to http://192.168.1.10:8080/Jon00DBCharting.asp, set the parameters and click "Chart", the screen flashes as if it's doing something, but is blank.



When I click on the "+", I get this error:

I think I have seen this before. Exit the plugin from the system tray. Then manually run the exe but make sure you are running it as an administrator.

[Lee_L]

I think I have seen this before. Exit the plugin from the system tray. Then manually run the exe but make sure you are running it as an administrator.

Jon, that fixed it!! Thanks!!

So, how do I make the .exe run as an Administrator every time in the Startup script?

[jon00]

Do you run Homeseer as an administrator?

[jon00]

Nice job, just tried the new version and it displays the values from August 20, the prior day a minute before midnight.

Thanks for your help. Great plugin by the way.

Great!

V1.0.15 has a new feature/utility added which can be used to calculate the difference between the current and last values of incremental metrics over pre-defined time periods. Currently I have 5, 10, 15 & 30 mins, 1, 12 & 24 hours, weekly and monthly. These are updated at the specified times referenced to the hour. Examples include Electricity, Gas, Water usage etc.

I'll update the docs this week and make it available to download.

[CinciJeff]

Unable to generate chart - or any data?

Jon,
I can usually track down issues on my own but I'm having a tough time with this one. I set up Jon00DBCharting.ini and Jon00DBChartingCreate.ini and I don't seem to be logging any data. There are no virtual devices created. When I go to the web page /Jon00DBCharting.asp I get a header and the correct data names in the pull-down menus, but when I click the Chart button it times out and gives me a message "Error: Chart could not be created - check the Homeseer log". The log says that it took too long to create the chart.

The plugin version is 1.0.0.0. Here are the contents of the two ini files for your reference. I appreciate any help. Thanks!!

Jon00DBCharting.ini:

[Settings]
Demo=0
MaxDataPoints=8000
GuestView=0
AxisXFormatRange=0-9999999999=M/d HH:mm
ASPXChartStyle=0

[DBTable1]
Name=1
Data1=$dva:05_TS_4_TEMP
Data1Label=LL_Temp
Data1Multiplier=1
Data2=$dva:05_TS_3_TEMP
Data2Label=1st_Flr_Temp
Data2Multiplier=1
Data3=$dva:05_TS_2_TEMP
Data3Label=Master_BR_Temp
Data3Multiplier=1
Data4=$dva:05_TS_1_TEMP
Data4Label=Upstairs_Temp
Data4Multiplier=1

Timer=11
PurgeDays=180

[Timer]
1=15
2=25
3=30
4=45
5=60
6=120
7=180
8=240

Jon00DBChartingCreate.ini:

[Create1]
DBTable=1
ChartStyle=4
ChartPalette=12
TitleText=
XAxisText=
YAxisText=
YAxisTextSec=
AxisXFormat=hh:mm:ss 
AxisYFormat=
AxisYFormatSec=
UseData1=1
UseData2=1
UseData3=1
UseData4=1
UseData5=0
UseData6=0
UseData7=0
UseData8=0
UseData9=0
UseData10=0
ChartTimeFormat=m
ChartTimeStart=60
ChartTimeFinish=0
BaselineValue=Auto
BaselineValueSec=Auto
AxisYMaximum=Auto
AxisYMaximumSec=Auto
CreateVD=1
AutoUpdate=1
ShowAllValues=0
 =
[Create201]
DBTable=1
ChartStyle=201
ChartPalette=12
TitleText=
XAxisText=
YAxisText=
YAxisTextSec=
AxisXFormat=M/d HH:mm
AxisYFormat=
AxisYFormatSec=
UseData1=1
UseData2=0
UseData3=0
UseData4=0
UseData5=0
UseData6=0
UseData7=0
UseData8=0
UseData9=0
UseData10=0
ChartTimeFormat=m
ChartTimeStart=60
ChartTimeFinish=0
BaselineValue=Auto
AxisYMaximum=Auto
BaselineValueSec=Auto
AxisYMaximumSec=Auto
CreateVD=0
AutoUpdate=0
ShowAllValues=0
 =

[jon00]

First off, did you get the demo working?

Also, can you check that you are running the plugin as an administrator (to be sure, stop the plugin and manually start the exe as an administrator).

If that is OK and you are still having problems, open up the database file(jon00dbcharting.db3) in DB Browser for SQLite. Do you see the data logged in the tables?

[bdraper]

Great!

V1.0.15 has a new feature/utility added which can be used to calculate the difference between the current and last values of incremental metrics over pre-defined time periods. Currently I have 5, 10, 15 & 30 mins, 1, 12 & 24 hours, weekly and monthly. These are updated at the specified times referenced to the hour. Examples include Electricity, Gas, Water usage etc.

I'll update the docs this week and make it available to download.

Cool look forward to reviewing the docs. Thanks again