Page 1 of 1

Hvac Historical Usage Information

PostPosted: Thu Apr 08, 2010 3:45 pm
by bschollnick2
Folks,

Please note, this plugin relies on the hvac data being stored in the SQLite3 database. This is an Indigo Professional feature, “Log Device State history to SQLite or PostgreSQL”, please ensure that this is turned on, if you wish to use this plugin.

Here’s a new little treat…

Image

This plugin will graph the Actual thermostat temperature reading, vs AC & Heating set points. This is tested against a venstar t1800, but in theory any thermostat that Indigo supports would work… (But is there any others that Indigo supports?).

In addition, below each graph is a table that contains the raw data. By default, it is hidden, but clicking on the hyperlink will reveal it.

This does support multiple thermostats…..

http://www.schollnick.net/wordpress/home-automation/hvac-historical-usage-for-indigo-4-professional/

Re: Hvac Historical Usage Information

PostPosted: Thu Apr 08, 2010 6:49 pm
by GRWilde
Works great!!

Thanks for producing the plugin.

Re: Hvac Historical Usage Information

PostPosted: Wed Jun 23, 2010 12:33 pm
by CraigM
Can't seem to find the path to the root directory in my browser.

In your example 'entertainmac', what is that? What exactly to I put before :8080/hvac ?

Are there any Indigo Server options [such as allow remote access] that need to to be on?

Thanks

Re: Hvac Historical Usage Information

PostPosted: Thu Jun 24, 2010 10:53 am
by CraigM
I have tried every combo that I can think of, but still can't view any graph data via a browser.

I assume 'entertainmac' is your computer [running Indigo] name.

Also your example shows a dot before the colon [.:] ??

I have tried-

http://Mini:8080/hvac
http://Mini.:8080/hvac

Is my address wrong or are there other prefs [Indigo, OS X] that need to be on or config'd?

FYI - the plugin is working, as the Indigo log is reporting HVAC activity and has dumped a file in my docs directory

Re: Hvac Historical Usage Information

PostPosted: Sat Jun 26, 2010 4:22 pm
by CraigM
Thanks Jay,

http://localhost:8176/hvac/ works like a charm!

The extra dot and the 8080 [in the instructions] were throwing me, and I wasn't aware the IWS default port is 8176

Many thanks for the assist

Also, bschollnick2 should be commended for creating this exceptional plugin :D

Re: Hvac Historical Usage Information

PostPosted: Mon Jun 28, 2010 9:54 am
by jingai
Does Indigo store the fan, compressor, and furnace on/off times in the SQL db when you have the Rev 2 INSTEON adapter? I'm wondering if it would be possible to plot this information on the graph as well.

-j

Re: Hvac Historical Usage Information

PostPosted: Mon Jun 28, 2010 10:14 am
by jamus
jingai wrote:
Does Indigo store the fan, compressor, and furnace on/off times in the SQL db when you have the Rev 2 INSTEON adapter? I'm wondering if it would be possible to plot this information on the graph as well.
-j


Looking at the schema, it doesn't look like it, but I think triggers could b created to set variables that could be plotted.

Re: Hvac Historical Usage Information

PostPosted: Mon Jun 28, 2010 10:19 am
by jingai
jamus wrote:
jingai wrote:
Does Indigo store the fan, compressor, and furnace on/off times in the SQL db when you have the Rev 2 INSTEON adapter? I'm wondering if it would be possible to plot this information on the graph as well.
-j


Looking at the schema, it doesn't look like it, but I think triggers could b created to set variables that could be plotted.


I'm also going to use Benjamin's other script that sets variables for runtimes and when they turn on/off. These are logged in the database when the variables change?

I don't yet have the rev 2 adapter, but it's on order. I'll see what I can work up once it arrives.

It'd be nice to have a daily overview (like his usage plugin, but with this information on it too) to just have a quick visual representation of what went on with the HVAC system for a given day :)

-j

Re: Hvac Historical Usage Information

PostPosted: Mon Jun 28, 2010 10:45 am
by bschollnick2
jingai wrote:
jamus wrote:
jingai wrote:
Does Indigo store the fan, compressor, and furnace on/off times in the SQL db when you have the Rev 2 INSTEON adapter? I'm wondering if it would be possible to plot this information on the graph as well.
-j


Looking at the schema, it doesn't look like it, but I think triggers could b created to set variables that could be plotted.


I'm also going to use Benjamin's other script that sets variables for runtimes and when they turn on/off. These are logged in the database when the variables change?

I don't yet have the rev 2 adapter, but it's on order. I'll see what I can work up once it arrives.

It'd be nice to have a daily overview (like his usage plugin, but with this information on it too) to just have a quick visual representation of what went on with the HVAC system for a given day :)


Overall the script just takes the information from the database... I would need to check the database itself, but if there is a status change message in the log file, then I believe it's in the database... So check your logfile for it, and if it is there, then I would believe it's in the database....

Re: Hvac Historical Usage Information

PostPosted: Mon Jun 28, 2010 11:09 am
by jay (support)
Correct - everything that's written to the log is in the database if you're storing log entries. We're looking into all the devices that support the newer Extended INSTEON commmands, including the new thermostat adaptor, to decide which features we support in future versions. It's likely that we'll support all of the features of the new adaptor, but we haven't yet settled on that list.

Re: Hvac Historical Usage Information

PostPosted: Tue Jun 29, 2010 1:31 pm
by jamus
jay wrote:
Correct - everything that's written to the log is in the database if you're storing log entries. We're looking into all the devices that support the newer Extended INSTEON commmands, including the new thermostat adaptor, to decide which features we support in future versions. It's likely that we'll support all of the features of the new adaptor, but we haven't yet settled on that list.


I must be blind, how do I turn on storing log entries in the sql database?

Re: Hvac Historical Usage Information

PostPosted: Tue Jun 29, 2010 4:13 pm
by jay (support)
On the "Start Local Server..." dialog, check the "Log Device state history to SQLite or PostgreSQL" checkbox. Be sure to click the "Learn more..." link before you try starting it - there is some manual configuration that you need to do first.

Re: Hvac Historical Usage Information

PostPosted: Mon Nov 22, 2010 1:54 pm
by bschollnick2
I have just updated, the Hvac Historical Usage Graph plugin...

http://www.schollnick.net/wordpress/hom ... fessional/

I realized that I didn't directly support Celsius for the graph.

When you update to this version, you will need to add an Indigo Variable called: "hvac_scale" (w/o the quotes)
and set it to be either F or C. F is Farenheit, C would be for Celsius. If this is not set, it will default to Celsius.

That's the only change in this version of the script.