Hvac Historical Usage Information

Posted on
Thu Apr 08, 2010 3:45 pm
bschollnick2 offline
Posts: 1355
Joined: Oct 17, 2004
Location: Rochester, Ny

Hvac Historical Usage Information

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/

------
My Plugins for Indigo (v4, v5, and v6) - http://bit.ly/U8XxPG

Security Script for v4 - http://bit.ly/QTgclf
for v5 - http://bit.ly/T6WBKu

Support Forum(s) - http://www.perceptiveautomation.com/userforum/viewforum.php?f=33

Posted on
Thu Apr 08, 2010 6:49 pm
GRWilde offline
User avatar
Posts: 173
Joined: Nov 15, 2005
Location: Los Angeles

Re: Hvac Historical Usage Information

Works great!!

Thanks for producing the plugin.

George Wilde

Posted on
Wed Jun 23, 2010 12:33 pm
CraigM offline
Posts: 578
Joined: Oct 28, 2007

Re: Hvac Historical Usage Information

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

Posted on
Thu Jun 24, 2010 10:53 am
CraigM offline
Posts: 578
Joined: Oct 28, 2007

Re: Hvac Historical Usage Information

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

Posted on
Sat Jun 26, 2010 4:22 pm
CraigM offline
Posts: 578
Joined: Oct 28, 2007

Re: Hvac Historical Usage Information

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

Posted on
Mon Jun 28, 2010 9:54 am
jingai offline
Posts: 127
Joined: Apr 03, 2007

Re: Hvac Historical Usage Information

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

Posted on
Mon Jun 28, 2010 10:14 am
jamus offline
Posts: 179
Joined: Dec 01, 2007

Re: Hvac Historical Usage Information

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.

Posted on
Mon Jun 28, 2010 10:19 am
jingai offline
Posts: 127
Joined: Apr 03, 2007

Re: Hvac Historical Usage Information

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

Posted on
Mon Jun 28, 2010 10:45 am
bschollnick2 offline
Posts: 1355
Joined: Oct 17, 2004
Location: Rochester, Ny

Re: Hvac Historical Usage Information

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....

------
My Plugins for Indigo (v4, v5, and v6) - http://bit.ly/U8XxPG

Security Script for v4 - http://bit.ly/QTgclf
for v5 - http://bit.ly/T6WBKu

Support Forum(s) - http://www.perceptiveautomation.com/userforum/viewforum.php?f=33

Posted on
Mon Jun 28, 2010 11:09 am
jay (support) offline
Site Admin
User avatar
Posts: 18200
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Hvac Historical Usage Information

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.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Tue Jun 29, 2010 1:31 pm
jamus offline
Posts: 179
Joined: Dec 01, 2007

Re: Hvac Historical Usage Information

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?

Posted on
Tue Jun 29, 2010 4:13 pm
jay (support) offline
Site Admin
User avatar
Posts: 18200
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Hvac Historical Usage Information

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.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Mon Nov 22, 2010 1:54 pm
bschollnick2 offline
Posts: 1355
Joined: Oct 17, 2004
Location: Rochester, Ny

Re: Hvac Historical Usage Information

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.

------
My Plugins for Indigo (v4, v5, and v6) - http://bit.ly/U8XxPG

Security Script for v4 - http://bit.ly/QTgclf
for v5 - http://bit.ly/T6WBKu

Support Forum(s) - http://www.perceptiveautomation.com/userforum/viewforum.php?f=33

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 5 guests