Last domotiga release 1.195

[hplus]

Hi,

In last domotiga release there is a new thermostat feature. It seems great, i had coded a similar (much simpler) feature but it was too much specific to be shared.
Could we have a short explanation on how this works?

Thanks

Hplus

[Andy_Burn]

I'll second this.
Yes please. A short tutorial would be most helpful
Thanks!

Andy

[RDNZL]

I asked Renaud the same question after I merged his code with version 0.1.195, this is his reply (with small editing by me).
He also send a small sql dump with an example thermostat, I have added some screenshots describing this example.

Here is a explanation:
1- First of all, we need required temperatures (CONSTANT) : for example 19° when the heating is on, and 17° when nobody's home or during night.
2- Then we create the heating device (HEATING): it has a temp sensor, and a device (to turn on or off)
3- Then we create a scenario (SCENARII) just to make different behaviour of the thermostat : one for normal week, another one for out of home, ...
4- For each scenario, I use SCHEDULE to define the requested temperature of each heating on a weekly base, for every 1/2 of an hour
5- Using OVERVIEW screen, I can select the active schedule, I can also see the daily schedule, and if needed, I can change temporarily the requested temp (derogation).

Maybe the Heating screen is a little complicated :
- Name is the name.
- Sensor is the device we use to get the measured temperature
- Device is the device that receive On or Off orders, must have option is switchable.
- Offset is used in thermostat to avoid flapping ( in the example : the requested temp is 20, but it will heat on until 23° and then turn off )
- Inverted is to manage devices that turn on with a Off order (like electric radiator)
- Latency is the time the heating need to power on or off
- Regulator is a 2° domotic device used to manage the same heating (the device is used to power on or power off the heating, whereas the regulator is used to power min or power max the heating). If not used, just leave it empty.
- Offset and inverted is the same as for the device
- The last part Offset control is just to check offset values on a little graph.

[klona]

Hi,
very nice new feature. Exactly what I needed. Thanks a lot.

I get an error when creatin a new schedule. In fact table thermostat_schedule_entry do not exist. Am I the only one ?
How can I fix that ?

/klona

[RDNZL]

That table is missing on the db install file, I will fix it.
It is in the upgrade files, so people who upgraded their version have it.

[klona]

Thanks Ron,
Any way to fix that before next release ?

[RDNZL]

You can simply add the table like so:

Code: Select all

$ mysql -u root -p domotiga

CREATE TABLE IF NOT EXISTS `thermostat_schedule_entry` (
  `scenario` bigint(20) unsigned NOT NULL ,
  `heating` bigint(20) unsigned NOT NULL ,
  `day` int unsigned NULL ,
  `time` TIME NULL ,
  `constant` bigint(20) NOT NULL ,
  PRIMARY KEY (`scenario`, `heating`, `day`, `time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

mysql> quit

[klona]

Hi, thanks. Working perfectly with some cleaning in thermostat_schedule because of previous failed attempt to add a schedule

[klona]

Hi,
i am lookign for a way to add thermostat display & control in the web interface.

But i don't see at all where to start ...
Is there any info on how control devices or domotiga object from the web interface ?

/klona