Originally posted by pogle
View Post
Announcement
Collapse
No announcement yet.
the Current Cost plug-in is available here
Collapse
X
-
Last edited by Rupp; August 24, 2010, 08:59 PM.
-
Ok... I finally had another chance to load .45. All seems well. I"m not sure what happened the other time I tried, but it's fine this time around.
RobertHS3PRO 3.0.0.500 as a Fire Daemon service, Windows 2016 Server Std Intel Core i5 PC HTPC Slim SFF 4GB, 120GB SSD drive, WLG800, RFXCom, TI103,NetCam, UltraNetcam3, BLBackup, CurrentCost 3P Rain8Net, MCsSprinker, HSTouch, Ademco Security plugin/AD2USB, JowiHue, various Oregon Scientific temp/humidity sensors, Z-Net, Zsmoke, Aeron Labs micro switches, Amazon Echo Dots, WS+, WD+ ... on and on.
Comment
-
Could you help me.
I have tested the Currentcost pluggin but since I have this message in logs:
24/08/2010 23:31:03 Current Cost Error, Exception adding record to the history database: Database is not open
24/08/2010 23:31:03 Current Cost Error adding a record to the history database - see the log for more details.
And the temperature's nerver set. I think the SQLITE database is the probleme but I don't how I can resolve it
Comment
-
HSLog file when Hs started:
24/08/2010 23:43:31 Current Cost Register callback completed
24/08/2010 23:43:31 Plug-In Initializing Plug-in: Current Cost on COM port 6
24/08/2010 23:43:33 Current Cost Initializing Current Cost on COM port 6
24/08/2010 23:43:33 Current Cost Current Cost Startup Complete.
24/08/2010 23:43:33 Plug-In Finished initializing plug-in Current Cost
24/08/2010 23:43:33 Current Cost Opening COM port at 57600 for newer Envi units
24/08/2010 23:43:33 Current Cost Updating ALL projected values
24/08/2010 23:44:05 Current Cost Error, SQL Exception adding record to the history database: SQLite error10 values for 7 columns, Code=Error, Link=
24/08/2010 23:44:05 Current Cost Error adding a record to the history database - see the log for more details.
currentcost.log
24/08/2010 23:44:05 ~ Error, SQL Exception adding record to the history database: SQLite error
10 values for 7 columns, Code=Error, Link=
24/08/2010 23:44:05 ~ CDConnection( aConn )
24/08/2010 23:44:05 ~ Error adding a record to the history database - see the log for more details.
Comment
-
Originally posted by elbarto71 View PostCould you help me.
I have tested the Currentcost pluggin but since I have this message in logs:
24/08/2010 23:31:03 Current Cost Error, Exception adding record to the history database: Database is not open
24/08/2010 23:31:03 Current Cost Error adding a record to the history database - see the log for more details.
And the temperature's nerver set. I think the SQLITE database is the probleme but I don't how I can resolve it
Comment
-
Rate Tables
Rich,
Our electrical company uses a time of day as well as seasonal time of day rates.
i.e.
Summer:
Economy time rates
Mid Peak time rates
Peak time rates
Winter
Economy time rates
Mid peak time rates
Peak time rates
I am able to build the tables, but am not sure how to envoke them as the home summary page always shows the default rate of .13/kwh.
Please advise if there is an easy way to do this. I have created two additional tables in addition to the default, called "Summer" and "Winter" Also it would be nice if we could put a date in to change back and forth between these rate tables based on a date.
Regards
Dave
Comment
-
Dave,
I believe you can actually create an event to use a different table.
I've just started to look into this myself as I have one rate up to 700 kWh/month and another thereafter.
RobertHS3PRO 3.0.0.500 as a Fire Daemon service, Windows 2016 Server Std Intel Core i5 PC HTPC Slim SFF 4GB, 120GB SSD drive, WLG800, RFXCom, TI103,NetCam, UltraNetcam3, BLBackup, CurrentCost 3P Rain8Net, MCsSprinker, HSTouch, Ademco Security plugin/AD2USB, JowiHue, various Oregon Scientific temp/humidity sensors, Z-Net, Zsmoke, Aeron Labs micro switches, Amazon Echo Dots, WS+, WD+ ... on and on.
Comment
-
elbarto,
The error message seems to indicate that the CurrentCost History database does not exist, but if that were the case, then it should have put an entry in the log about trouble trying to create the database too.
Go to your HomeSeer root directory, then into \Data\CurrentCost and you should have a file called History.db. If you do, please delete it and then restart HomeSeer so the plug-in will try to create it again, and check the log for errors creating it.
ThanksRegards,
Rick Tinker (a.k.a. "Tink")
Comment
-
Originally posted by smithdavee View PostRich,
Our electrical company uses a time of day as well as seasonal time of day rates.
i.e.
Summer:
Economy time rates
Mid Peak time rates
Peak time rates
Winter
Economy time rates
Mid peak time rates
Peak time rates
I am able to build the tables, but am not sure how to envoke them as the home summary page always shows the default rate of .13/kwh.
Please advise if there is an easy way to do this. I have created two additional tables in addition to the default, called "Summer" and "Winter" Also it would be nice if we could put a date in to change back and forth between these rate tables based on a date.
Regards
DaveRegards,
Rick Tinker (a.k.a. "Tink")
Comment
-
I have deleted the history.db and after restarted hs the pluging have creatde a new file but the message still again
Current Cost Error, Exception adding record to the history database: Database is not open
Current Cost Error adding a record to the history database - see the log for more details.Last edited by elbarto71; August 26, 2010, 12:50 AM.
Comment
-
log file at start hs:
26/08/2010 00:25:18 Startup Settings Loaded.
26/08/2010 00:25:18 Startup Loading configuration file ...
26/08/2010 00:25:19 System Loading device types file...
26/08/2010 00:25:19 Database Opening (Mode=Read) up HomeSeer database: C:\Program Files\HomeSeer HS2\config\sample.mdb
26/08/2010 00:25:21 Database Loading Devices...
26/08/2010 00:25:23 Load Config 230 total devices loaded.
26/08/2010 00:25:23 Load Config Checking device type settings for all devices...
26/08/2010 00:25:23 Load Config Finished checking device type settings.
26/08/2010 00:25:23 Load Config Loading Events...
26/08/2010 00:25:23 Load Config 18 total events loaded.
26/08/2010 00:25:23 Database HomeSeer configuration database C:\Program Files\HomeSeer HS2\config\sample.mdb has been closed.
26/08/2010 00:25:23 Startup HomeSeer version is: 2.4.0.11
26/08/2010 00:25:23 Startup Starting remoting (Remote client connection monitor)
26/08/2010 00:25:24 Startup Creating Speaker Client Interface Object...
26/08/2010 00:25:24 Startup Initializing phone interface...
26/08/2010 00:25:25 HSPhone HomeSeer Phone Web Interface initializing.
26/08/2010 00:25:25 Startup Restoring Device Status
26/08/2010 00:25:26 Startup Checking for available plug-ins
26/08/2010 00:25:26 Plug-In Found plug-in: BLDatabase, version: 1.0.11.0
26/08/2010 00:25:26 Plug-In Found plug-in: BLEditor, version: 1.0.5.0
26/08/2010 00:25:26 Plug-In Found plug-in: BLOccupied, version: 1.0.17.0
26/08/2010 00:25:28 Plug-In Found plug-in: Current Cost, version: 1.0.0.46
26/08/2010 00:25:28 Plug-In Found plug-in: RFXCOM, version: 14.0.0.62
26/08/2010 00:25:28 Startup Initializing Plug-Ins
26/08/2010 00:25:29 BLOccupied start Register Callback completed
26/08/2010 00:25:29 BLOccupied start BLOccupied version is: 1.0.17.0
26/08/2010 00:25:29 Plug-In Initializing Plug-in: BLOccupied
26/08/2010 00:25:29 BLOccupied start Initializing BLOccupied...
26/08/2010 00:25:29 BLOccupied start Loaded configuration successfully
26/08/2010 00:25:30 BLOccupied start BLOccupied plugin has been initialized
26/08/2010 00:25:30 Plug-In Finished initializing plug-in BLOccupied
26/08/2010 00:25:30 RFXCOM Restricted for use with RFXCOM receivers/transmitters only.
26/08/2010 00:25:30 Plug-In Initializing Plug-in: RFXCOM
26/08/2010 00:25:32 RFXCOM (RecRxChar) receiver #1 successfully initialized to Variable Length Mode on TCP port 192.168.1*******
26/08/2010 00:25:32 Plug-In Finished initializing plug-in RFXCOM
26/08/2010 00:25:32 RFXCOM (XmitRxChar) RFXmitter #1 succesfully initialized on IP:192.168.*******
26/08/2010 00:25:32 Current Cost Register callback completed
26/08/2010 00:25:32 Plug-In Initializing Plug-in: Current Cost on COM port 6
26/08/2010 00:25:34 Current Cost History database has been created.
26/08/2010 00:25:35 Current Cost Initializing Current Cost on COM port 6
26/08/2010 00:25:35 Current Cost Opening COM port at 57600 for newer Envi units
26/08/2010 00:25:35 Current Cost Current Cost Startup Complete.
26/08/2010 00:25:35 Plug-In Finished initializing plug-in Current Cost
26/08/2010 00:25:35 Current Cost Updating ALL projected values
26/08/2010 00:25:35 Plug-In Finished initializing X10 interface
26/08/2010 00:25:35 Plug-In Finished initializing infrared interface 26/08/2010 00:25:36 Web Server Local IP address (subnet) is: 192.168.1.102 (255.255.255.0)
26/08/2010 00:25:36 Web Server UPNP Discovery started
26/08/2010 00:25:36 Web Server Web Server started on port 8080
26/08/2010 00:25:36 Startup Creating ASP.NET application host...
26/08/2010 00:25:41 Startup ASP.NET application host created
26/08/2010 00:25:41 Startup Start automation engine...
26/08/2010 00:25:41 Startup This version of HomeSeer is registered.
26/08/2010 00:25:41 Startup Initializing Speaker Client Interface
26/08/2010 00:25:41 Speech Listening for remote speaker connections on port 8742
26/08/2010 00:25:41 Startup Starting Event Scheduler..
26/08/2010 00:25:42 Web Server Web Server authorized local login successful from: 127.0*******
26/08/2010 00:25:42 Startup Running the Startup.txt Script
26/08/2010 00:25:42 Startup Scripting is OK
26/08/2010 00:25:43 Event Event Trigger "teleinfo"
26/08/2010 00:25:43 Event Running script in background: modules\EDF\scripts\main.vbs
26/08/2010 00:25:43 Event
26/08/2010 00:25:43 Device Control Device: GARAGE CDE LUM GARAGE EXT (A16) OFF
26/08/2010 00:25:43 Event Event Trigger "Meteo LaCrosse"
26/08/2010 00:25:43 Event Running script in background: modules\STATION.LACROSSE\scripts\main.vbs
26/08/2010 00:25:43 Event Event Trigger "Calcul periodique de la CONSO-RECUP eau"
26/08/2010 00:25:43 Event Running script in background: modules\WATER.TANK.CONSO\scripts\main.vbs
26/08/2010 00:25:43 Event Event Trigger "flush memory"
26/08/2010 00:25:43 Event Running script in background: Jon00MemFlush.vben
26/08/2010 00:25:47 Event Event Trigger "Calcul periodique de la RECUP eau"
26/08/2010 00:25:47 Event Running script in background: modules\WATER.TANK\scripts\main.vbs
26/08/2010 00:25:47 Info PH_RFXCharts V1.1.0.10 Startup
26/08/2010 00:25:49 EDF ** Ouverture du port COM5
26/08/2010 00:25:49 Startup Start up complete.
26/08/2010 00:25:54 EDF ******ENREGISTREMENT NOUVELLES DONNEES EDF******
26/08/2010 00:25:55 EDF
26/08/2010 00:25:57 Web Server Web Server authorized local login successful from: 192.168.1.*********
26/08/2010 00:26:00 Event Event Trigger "Calcul periodique de la conso deau"26/08/2010 00:26:00 Event Running script in background: modules\WATER.CONSUMPTION\scripts\main.vbs
26/08/2010 00:26:00 Event Event Trigger "teleinfoSolaire"
26/08/2010 00:26:00 Event Waiting 0 minute(s) 10 second(s) 0 millisecond(s)
26/08/2010 00:26:00 Current Cost Error, SQL Exception adding record to the history database: SQLite error8 values for 7 columns, Code=Error, Link=
26/08/2010 00:26:00 Current Cost Error adding a record to the history database - see the log for more details.
26/08/2010 00:26:00 H2O CONSO ******ENREGISTREMENT NOUVELLES DONNEES H2O CONSO******
26/08/2010 00:26:07 Web Server Web Server authorized local login successful from: 192.168.1.******Last edited by elbarto71; August 26, 2010, 12:49 AM.
Comment
-
Gee without going into updater everyday, how would you know if there is an update to this plugin... wait, perhaps you'll see a posting from someone having issues, then you'll learn about it.
C'mon, isn't there any way a sticky can be placed in the CC plugin section with better yet, release notes?
RobertHS3PRO 3.0.0.500 as a Fire Daemon service, Windows 2016 Server Std Intel Core i5 PC HTPC Slim SFF 4GB, 120GB SSD drive, WLG800, RFXCom, TI103,NetCam, UltraNetcam3, BLBackup, CurrentCost 3P Rain8Net, MCsSprinker, HSTouch, Ademco Security plugin/AD2USB, JowiHue, various Oregon Scientific temp/humidity sensors, Z-Net, Zsmoke, Aeron Labs micro switches, Amazon Echo Dots, WS+, WD+ ... on and on.
Comment
-
Originally posted by langenet View PostGee without going into updater everyday, how would you know if there is an update to this plugin... wait, perhaps you'll see a posting from someone having issues, then you'll learn about it.
C'mon, isn't there any way a sticky can be placed in the CC plugin section with better yet, release notes?
Robert
Comment
-
I didn't see any posting of a new version released here by anyone.. (.46 comes to mind)
I agree if all is working correctly, there may be no reason to upgrade unless a feature has been fixed. In my second evaluation of .45 after a day or so, I started seeing drop outs in the plotting. Again, I went back to .42 and it never re-appeared.
I had specifically gone to the CC forum to see if an update was posted - to no avail...
Our late friend Jim Doolittle had a great forum sticky which would be updated upon any new release of his plugin. More so, you could see in the release notes what changes were made so you could evaluate whether or not to upgrade. In this case, it's hit or miss.
Perhaps it's the structure I'm looking for...
RobertHS3PRO 3.0.0.500 as a Fire Daemon service, Windows 2016 Server Std Intel Core i5 PC HTPC Slim SFF 4GB, 120GB SSD drive, WLG800, RFXCom, TI103,NetCam, UltraNetcam3, BLBackup, CurrentCost 3P Rain8Net, MCsSprinker, HSTouch, Ademco Security plugin/AD2USB, JowiHue, various Oregon Scientific temp/humidity sensors, Z-Net, Zsmoke, Aeron Labs micro switches, Amazon Echo Dots, WS+, WD+ ... on and on.
Comment
Comment