Boiler control from MAX! Cube to Drayton Boiler via Raspberry Pi/Vera/Mysensors.

[Stuart Middleton]

Ah, excellent thanks. I've noticed some of the temps have been reporting zero on the hot days. I'll grab it and give it a go.

[Stuart Middleton]

I'm seeing 0.0 readings from radiators for some reason. They were all valid last night but just seem to drop out randomly. Do you know if this is a bug or just the MAX system being a bit crappy? I've not had time to look at the code yet, just thought someone may know.

And while I'm here, I can't get to the graphs on any rooms with a ' in them (i.e. Luke's Room) due to a database error (I'm guessing the DB lookup isn't escaped. :) I'll try and take a look at this at some point over the weekend.


[marog]

This is problem of Max System - very often the temp is sended as 0.0 in comunication with the box

[Stuart Middleton]

BTW, I fixed the ' issue by changing graphing.py to use urllib.unquote() on the room name then replaced a single ' with a double ''. I then had to replace the single ' again for the html print or the page just came out empty.

[stephenmhall]

If they are radiators without wall thermostats 0.0's are usual. It only seems to know when it is at temperature as it crosses the preset threshold. Then it will send out a correct temp.

I have tried to save a copy of the last correct temperature to use until a new one comes in but not managed to get it working yet. I was doing a backward search through the database to find a good temperature but it was taking upwards of 3 seconds a room as my DB is about 56MB now. I tried creating a global dictionary to save them but ended up getting lost in the code :)

I might create a new text file like the variables to save them in as it does annoy me also. If you have wall thermostats its not a problem.

[stephenmhall]

@Stuart-Middleton said:

BTW, I fixed the ' issue by changing graphing.py to use urllib.unquote() on the room name then replaced a single ' with a double ''. I then had to replace the single ' again for the html print or the page just came out empty.

Good find Stuart I will get that into the files on Github.

If you are interested I have a new branch that sends temperatures to Vera if you have one, to populate "Virtual" Thermometers, i.e ones with no hardware. It's pretty easy to add them from the developer page. You can turn the feature on and off in the variables so it will become the main branch at some point.

Stephen

[stephenmhall]

@Stuart-Middleton said:

BTW, I fixed the ' issue by changing graphing.py to use urllib.unquote() on the room name then replaced a single ' with a double ''. I then had to replace the single ' again for the html print or the page just came out empty.

Stuart, I have made changes could you backup your graphing.py and try my one. This should be a link.

Link to graphing.py on Github

This shows you never know what you don't know about Python :) I was manually removing the html %20 spaces and never thought of other non text characters. And didn't know about the urllib functions. Old dog learning new tricks.

Stephen

[stephenmhall]

Stuart
I have added a new table to the DB to store good heating values. I only have one room without a wall thermostat so it is a bit hard for me to test for a 0.0 temp, it seems to work fine if there is a good temp from the room. would you be able to give it a go for me? the main changes are in the database.py and webui.py scripts. in the vera_virtual_thermostats branch.

make sure you back up your current files before you try just in case I breaks it :). your DB too just in case. I tend to make a copy of the whole heating folder onto my PC before using changes on my live system just in case I muck it up.

Stephen

[stephenmhall]

Corrected an error in the webui.py code for the 0.0 temps was causing a crash.

[Stuart Middleton]

I'm going to try and find time to test this later. Just super busy at the moment. Stupid day job! :)

[stephenmhall]

hehe know what you mean, 2 weeks off for me atm, good job as I just noticed the heating has been off for a while, oops.

[stephenmhall]

Another tiny update to fix a problem if any of the temperatures went over 25.5 and buy tiny I mean one extra character of code in a binary format string. yesh.

[Stuart Middleton]

Hey, just got around to trying your fix and there's a little issue. The converted name works for the web page but not for the DB query. I've changed the following line in graphing from

tempData = DB.getTemps(cleanName, currentTime)
to
tempData = DB.getTemps(cleanName.replace(''', "''"), currentTime)

to get it to work. Hope that helps

Now it's all happy I should really get around to connecting it to my boiler instead of just looking at the pretty graphs! :)

[stephenmhall]

grrr, can you send me a copy of your database? I am wondering if it set the room name before the other changes if there is something extra in there.

And just to check, you are replacing one ' (quote) with two of them?

[Stuart Middleton]

Ah, yes. My room names are already set up. Yes, replacing a single quote with two single quotes. I'll PM you my DB. It may have worked if I'd started from scratch.

[Stuart Middleton]

OK, I have no idea how to PM you :)

[Stuart Middleton]

This is my rooms table from the database

1 Living Room 12DA70
3 Hall 137F27
2 Kitchen 12DBCB
5 Master Bedroom 1245D7
4 Landing 12E19F
7 Lara's Room 12DA58
6 Luke's Room 12DA35

[stephenmhall]

LOL me either maybe you cant. You could save it to google drive or dropbox and post a link i think.

[stephenmhall]

kk cheers, I wonder why it is needing 2 quotes? I will have a better look.

[mfalkvidd]

Here is how to open a private chat. Click the persons name at the top of a post. Then click the blue three-dot menu.