Domoticz

Hi,

I have a Domoticz system which is controlling around 40 devices...ranging from HiFi to sets of lights. When we are on holiday we use a set of timers to simulate our presence in the house. On return, we reset the timers.

Is there any way of dealing with the timers via a table of some sort...it is very tedious going from one switch---setting its Timer...beck to Switches and so on. It is also error-prone.
Or, is there some kind of spreadsheet to allow an overview of settings..and perhaps their modifications? An overview of the total settings would be a great feature.

I have not been able to find anything on these subjects...which makes me think that perhaps I am doing this the wrong way..some new feature that I am not aware of? Anyway, I should be grateful for any answers to these questions.

George

gbCambridge wrote: ↑Sunday 23 February 2020 12:44 I have a Domoticz system which is controlling around 40 devices...ranging from HiFi to sets of lights. When we are on holiday we use a set of timers to simulate our presence in the house. On return, we reset the timers.
Is there any way of dealing with the timers via a table of some sort...

You can use timerplans [setup] [more options][plans][timer plans] to switch from one set of timers to another one.
While on a timer plan set all the required times and when all set, switch back and forth between the plans as suited.

Hi,

Thanks for that...I was not aware of the Time Plans to switch from one set to another. That does make it simpler than using the backup/restore method.

However, my real problem is getting a clear overview of the various timers for the various devices on one (or more) pages. The idea is that I can see clearly what sets of timer events are set up, so as to better simulate the house being occupied. Right now I have to visit the Timer setting for each device, which stops me getting an overview and makes setting very laborious. A table of devices with the columns showing On/Off settings would do it.
I am thinking that, if this feature is not buried within Domoticz right now, it might available by a few SQL statements...but I see that as a last resort. I had assumed that this problem would be noticed by many DOmoticz users, but apparently no.

George

gbCambridge wrote: ↑Sunday 23 February 2020 16:56 However, my real problem is getting a clear overview of the various timers for the various devices on one (or more) pages.

<domoticz_ip:domoticz_port>/json.htm?type=schedules will show you the timers set for the current timeplan.

Spoiler: show

Code: Select all

{
"result": [
{
"Active": "false",
"Color": "",
"Date": "",
"Days": 4,
"DevName": "Kastenkamer rolluik",
"DeviceRowID": 296,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "",
"Time": "09:01",
"TimerCmd": 1,
"TimerID": 39,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Device"
},
{
"Active": "false",
"Color": "",
"Date": "",
"Days": 32,
"DevName": "Kastenkamer rolluik",
"DeviceRowID": 296,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "",
"Time": "09:31",
"TimerCmd": 1,
"TimerID": 40,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Device"
},
{
"Active": "false",
"Color": "",
"Date": "",
"Days": 64,
"DevName": "Kastenkamer rolluik",
"DeviceRowID": 296,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "",
"Time": "09:41",
"TimerCmd": 1,
"TimerID": 41,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Device"
},
{
"Active": "true",
"Color": "",
"Date": "",
"Days": 128,
"DevName": "Kastenkamer rolluik",
"DeviceRowID": 296,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "2020-02-24 09:45:00",
"Time": "09:45",
"TimerCmd": 1,
"TimerID": 38,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Device"
},
{
"Active": "false",
"Color": "",
"Date": "",
"Days": 4,
"DevName": "Slaapkamer rolluik",
"DeviceRowID": 294,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "",
"Time": "08:58",
"TimerCmd": 1,
"TimerID": 34,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Device"
},
{
"Active": "true",
"Color": "",
"Date": "",
"Days": 32,
"DevName": "Slaapkamer rolluik",
"DeviceRowID": 294,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "2020-02-24 09:15:00",
"Time": "09:15",
"TimerCmd": 1,
"TimerID": 35,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Device"
},
{
"Active": "true",
"Color": "",
"Date": "",
"Days": 64,
"DevName": "Slaapkamer rolluik",
"DeviceRowID": 294,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "2020-02-24 09:30:00",
"Time": "09:30",
"TimerCmd": 1,
"TimerID": 36,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Device"
},
{
"Active": "true",
"Color": "",
"Date": "",
"Days": 128,
"DevName": "Slaapkamer rolluik",
"DeviceRowID": 294,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "2020-02-24 09:59:00",
"Time": "09:59",
"TimerCmd": 1,
"TimerID": 33,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Device"
},
{
"Active": "true",
"Color": "",
"Date": "",
"Days": 256,
"DevName": "Schemerlampen uit",
"DeviceRowID": 5,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "2020-02-24 01:00:00",
"Time": "01:00",
"TimerCmd": 0,
"TimerID": 7,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Scene"
},
{
"Active": "true",
"Color": "",
"Date": "",
"Days": 512,
"DevName": "Schemerlampen uit",
"DeviceRowID": 5,
"IsThermostat": "false",
"Level": 100,
"MDay": 0,
"Month": 0,
"Occurence": 0,
"Randomness": "false",
"ScheduleDate": "2020-02-24 02:00:00",
"Time": "02:00",
"TimerCmd": 0,
"TimerID": 8,
"TimerType": 2,
"TimerTypeStr": "On Time",
"Type": "Scene"
}
],
"status": "OK",
"title": "Schedules"
}

The database table Timers contain all timers and you can select them per Timerplan

Timers
ID|Active|DeviceRowID|Date|Time|Type|Cmd|Level|Color|UseRandomness|TimerPlan|Days|Month|MDay|Occurence

TimerPlans
ID|Name