The error message here means that you are not able to read the forecaster temperatures from the the Finnish Meteorology Institute’s weather forecast. You most probably do not want to read the weather forecast from Finnish Meteorology Institute anyway?
To narrow things down, you can temporarily modify the rule script so that you don’t calculate the number of hours based on the weather forecast. Instead, just put there a static value like 5 when you’re debugging this:
dh = require('kolapuuntie/date-helper.js');
nibe = require('kolapuuntie/nibe.js');
start = dh.getMidnight('start');
stop = dh.getMidnight('stop');
// Comment out these two lines that fetch the weather forecast and calculate how many hours are needed.
// t = nibe.getForecastTemp(start, stop);
// n = nibe.calculateNumberOfHours(t);
// Temporarily define the number of hours as five.
n = 5;
nibe.determineHours(start, stop, n, 3, 0.1);
You can add a couple of debug messages so that you can see from your logs what is going on.
Add the debug lines like this to get the complete XML response written to your log:
function makeApiCall(start, end, area, token) {
[...]
priceXml = http.sendHttpGetRequest(url, 10000);
console.debug('Complete XML response:');
console.debug(priceXML);
return priceXml;
Add these debug lines to see if the XML to JSON transformation works:
If (when) you modify the javascript files, you need to “refresh” your rules so that openHAB will use the updated versions of the js files. This can be done as follows:
Go to edit the rule that uses the js file
Save the rule
Run the rule
If you don’t go to the edit mode and save the rule, openHAB will use the old version of the JS file it had read to memory before.
Thanks for your efforts to help me out, I managed to get some xml output after changing console.debug to console.log, but somewhere in xml2json there must be a problem, I don’t se any output from extensive console.log in xml2json function. Meybe it wasn’t right to change < to
<
In the xml2jsonfile, I downloaded an copy an pasted xml2json file again and now it works better. However influx db doesn’t contain much data spotprice came up but only one price point
The reason why you’re not seeing more than one value is that your Influx Query is searching for data for “past 1 hour”. Change the range to include tomorrow and you’ll see tomorrow’s spot prices
Thanks again for all your efforts of helping men out. I will be out travelling for next couple of days but wilöl have spotprice fetching rule up an running every hour for the moment I did indeed have more data if I set a different filer .
I did get FMI forecast script to runt but it didnt write an mesurement, and I beleive that thats the reason why nibe and waterboiler script fails theres no temperature forecast. I will probably convert this to my local realtime temperature but thought I will get this nice example up and running before I start modifying to much. And I will also integrate this with my Easee EV wallbox.
The last row means that “between the start midnight and stop midnight, find a 4 hour window when the spot prices are lowest”.
Our hot water consumption does not depend on the outside weather. Four hours should be easily enough to heat the water for the whole day.
1 kWh will be required to heat 864 liters of water by 1 degree
My water heater has a 300 liter tank so it will require 300/864 = 0,347 kWh to raise the water temperature by 1 degree
My water heater is 3 kW so letting it run for 4 hours means 12 kWh
Which means that 12 kWh can raise the water temperature by 12/0,347 = 34,5 degrees
This is easily more than enough because the water heater is “behind” or “after” the Nibe ground source heat pump which pre-warms the water in its 180 liter integrated tank to 48 degrees so the starting point for the water heater is barely ever under 40 degrees.
I’m currently planning to install a couple of DS18B20 temperature sensors to the outer shell of the tank of the water heater so that I could measure how cold / warm the water is already and then determine if I need to allow 1, 2, 3 or 4 hours of heating time for the water heater.
Here’s what I’ve been able to achieve so far. Blue bars is my consumption which I’m able to fetch from the power grid operator and green line are the spot prices. You can see nice consumption peaks when the prices are lowest.
July 26 and 27 were hugely exceptional days in Finland in terms of the spot prices as there was a lot of wind power and at the same time the Baltic countries had planned maintenance in their power grid which meant that they could not import electricity from Finland which they normally do. I think we washed laundry something like 4 or 5 times, cleaned the oven with pyrolysis and so on.
My electricity contract is not directly bound to the Nordpool spot prices (i.e. spot price + margin). Instead, I have a contract which is 14.8 c / kWh +/- “consumption factor”. The consumption factor is calculated as follows:
consumption factor = (A-B) / E, where
A is the sum of consumption * spot price over every hour of the month
B is the total consumption * average price in Nordpool for the month
E is the total consumption of the month
In other words, if I use power on hours which are cheaper than the month’s average spot price, the consumption factor will be negative and decrease the price that I pay of the whole month’s power. With these optimizations this means that the 14.8 c/kWh is effectively a ceiling price that I will have to pay under any circumstances, even if the Nordpool would be at 100c / kWh next winter.
Here’s a 7 day trend for the consumption factor. If I would be able to keep this trend, I would pay 14.8 - 5.9 c / kWh but it’s not going to be that much negative because the July 26-27 was so highly exceptional. But anyway, this I will have a double digit discount to the power bill, which is is quite nice
It seems like I’m having trouble to write measurments to influxdb other OH dta appears to be right but this data just doesn’t get in there. I’ve verified ip and api token org and bucket name but nothing really changes the game. Influx db version 2.3.0 snapshot.
Hi I was perhaps unclear, nothing writes for a certain I only got one days of spot price data even thoug logging looks good. I activated a log for whats written to influx db an theres a value=some price anf a blank anf a epoch time (maybe)
First of all thanks for the great work on this topic. Been testing these rules for a few weeks and they seem to work well. I did however have a possibly similar problem as @Marcus_Carlsson of 2-3 null values in results. Tracked it down to the influxdb query that in my setup seems to add three lines of annonations before the header line in the results. See image
Did a workaround in the influx.js ParCSV function by adding a some more lines to be skipped and has worked fine since. Maybe there is a better way to remove annonations, but this has worked so far.
// Ignore the header row and last empty rows.
//for (let i = 1; i < n-2; i++) { //Added 3 more lines because of annonations
for (let i = 4; i < n-0; i++) {
I agree, grat work. Lucky for me that today with a fresh install openhab in docker container most things really works, but when running water heater rule I get an error as below. And that may be related to lack of waterhetaer_control in Influxdb, weatherrforecast is there and nibe control is there but not waterheater_control in influxdb
And this might have been a real confusion from me, I had combined hourly waterheater script and waterheaterscript. Now all items exist in influxdb, just have to wait until tomorrow and se if boiler turns on/off.
Great that you were able to sort it out! If you don’t want to wait until tomorrow, you can re-run the rule that determines the control values, i.e. this:
@Nanna_Agesen it means that you did not receive a valid XML response from the Entso-E API. Most probably because you did not update your personal access token.
I realized this (that you need your personal access token) was not properly documented in my comment marked as the solution.
I have now updated all js files in the comment marked as the solution with better documentation. I also made some changes to the rule actions. Please delete the rule actions you had previously, re-load all js files and try again.
Note for other users such as @Marcus_Carlsson and others who had previously got their setups working: these updated js files are not compatible with your existing rule actions because I harmonized the architecture of the code slightly. If you already have your stuff working, you can keep the js files and rule actions that you already have. There are no new features or anyhting like that, just small improvements to the structure of the code.
