Timer Display

[gbCambridge]

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

[waaren]

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.

[gbCambridge]

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

[waaren]

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