Domoticz

yara009 wrote: ↑Sunday 17 January 2021 19:16 is it possible in dzVents (or dzVents+JSON) to edit group "GRP001" and fill it with all switches?

json.htm?type=deletescene&idx=1
json.htm?type=addscene&name=testScene&scenetype=0
json.htm?type=command&param=addscenedevice&idx=7&isscene=true&devidx=495&command=On&level=100&color=&ondelay=300&offdelay=400

yara009 wrote: ↑Sunday 17 January 2021 23:30 I still have two problems, can you help me please?

1)
This is OK (group id=13, device id=37):
/json.htm?type=command&param=addscenedevice&idx=13&isscene=false&devidx=37&level=100&ondelay=30&offdelay=30

This is not working:
/json.htm?type=command&param=deletescenedevice&idx=13&devidx=37

domoticz.settings['Domoticz url'] .. '/json.htm?type=command&param=addscenedevice&idx=19&isscene=false&devidx=800&command=On&level=100&color=&ondelay=6&offdelay=11' 

yara009 wrote: ↑Monday 18 January 2021 9:46 But, I still have problem with removing devices from group.
Problem is here:
/json.htm?type=command&param=deletescenedevice&idx=37

idx=37 is not ID of device, but internal ID of device in group. But I can not find, how to get this ID from dzVents.

local scriptVar = 'getGroupDevices'

return
{
    on =
    {
        timer =
        {
            'at 04:13',  -- daily at a quiet time
        },
        devices =
        {
            'groupTrigger', -- for test / development
        },
        httpResponses =
        {
            scriptVar .. '*',
        },
    },

    logging =
    {
        level = domoticz.LOG_DEBUG, -- set to Error when all ok
        marker = scriptVar,
    },

    data =
    {
        myGroups =
        {
            initial = {},
        },
    },

    execute = function(dz, item)

        local function getGroupDevices(group)
            groupURL = dz.settings['Domoticz url'] .. '/json.htm?type=command&param=getscenedevices&isscene=false&idx=' .. group.idx
            
            dz.openURL(
            {
                url = groupURL,
                callback = scriptVar .. '(' .. group.name .. ')'
            })
        end

        local function makePersistent(t, groupName)
            local devices = {}
            if t and #t > 0 then
                for _, rec in ipairs(t) do
                    devices[rec.Name]  = { realID = rec.DevRealIdx, groupDeviceID = rec.ID } 
                end
                dz.data.myGroups[groupName] = devices
            else
                dz.data.myGroups[groupName] = {}
            end
        end
        
        if item.isHTTPResponse and item.json then
            -- dz.utils.dumpTable(item.json.result)
            makePersistent(item.json.result, item.trigger:match('%b()'):sub(2,-2))
        elseif item.isHTTPResponse then
            dz.log('Problem with http request ' .. item.trigger, dz.LOG_ERROR)
            dz.log(item, dz.LOG_DEBUG)
        else
            dz.groups().forEach(function(group)
                getGroupDevices(group)
            end)
        end
    end
}

gschmidt wrote: ↑Thursday 21 January 2021 15:57 This way the script, which creates all your Groups and Scenes and includes the appropriate devices and their settings, can always be used.

waaren wrote: ↑Thursday 21 January 2021 16:24

gschmidt wrote: ↑Thursday 21 January 2021 15:57 This way the script, which creates all your Groups and Scenes and includes the appropriate devices and their settings, can always be used.

Sorry I don't understand the question. Can you please elaborate ?

What do you mean with 'the script ...'

gschmidt wrote: ↑Thursday 21 January 2021 16:33 Is it possible to create a dzVents script which creates Groups and Scenes and adds all intended devices with their appropriate settings?
If so, is it also possible to add devices based on their name and not idx number?

/json.htm?type=scenes
/json.htm?type=command&param=getscenedevices&idx=<scene ID>;isscene=<true / false>
/json.htm?idx=<scene ID>&type=scenetimers
/json.htm?type=command&param=getsceneactivations&idx=<scene ID>

/json.htm?type=addscene&name=<scenename>&scenetype=<0 / 1>
/json.htm?type=command&param=addscenetimer&idx=<scene ID>&active=<true / false>&timertype=<type>&date=<>&hour=<>&min=<>&randomness=<>&command=<>&level=<>&days=<>
/json.htm?type=command&param=addscenedevice&idx=<scene ID>&isscene=<true / false>&devidx=<deviceindex>&command=<command>[&level=<dim level>][&hue=<hue level>][color=<color JSON>][&ondelay=<delay in seconds>][&offdelay=<delay in seconds>]
/json.htm?type=command&param=addscenecode&sceneidx=<scene ID>&idx=<device ID>&cmnd=<command>

waaren wrote: ↑Thursday 21 January 2021 17:45

gschmidt wrote: ↑Thursday 21 January 2021 16:33 Is it possible to create a dzVents script which creates Groups and Scenes and adds all intended devices with their appropriate settings?
If so, is it also possible to add devices based on their name and not idx number?

Yes that is possible; but quite complex and how often does this happen?
It would be much easier to take a backup of the database and manually edit the tables
Scenes, SceneDevices and SceneTimers before copying them back.
(the relation between device-ID and device name can be retrieved from the deviceStatus table)

In case you want to try with a script, you would need below API calls

To get the information:

Code: Select all

/json.htm?type=scenes
/json.htm?type=command&param=getscenedevices&idx=<scene ID>;isscene=<true / false>
/json.htm?idx=<scene ID>&type=scenetimers
/json.htm?type=command&param=getsceneactivations&idx=<scene ID>

For restoring it:

Code: Select all

/json.htm?type=addscene&name=<scenename>&scenetype=<0 / 1>
/json.htm?type=command&param=addscenetimer&idx=<scene ID>&active=<true / false>&timertype=<type>&date=<>&hour=<>&min=<>&randomness=<>&command=<>&level=<>&days=<>
/json.htm?type=command&param=addscenedevice&idx=<scene ID>&isscene=<true / false>&devidx=<deviceindex>&command=<command>[&level=<dim level>][&hue=<hue level>][color=<color JSON>][&ondelay=<delay in seconds>][&offdelay=<delay in seconds>]
/json.htm?type=command&param=addscenecode&sceneidx=<scene ID>&idx=<device ID>&cmnd=<command>

Also see this wiki page

gschmidt wrote: ↑Saturday 23 January 2021 10:02 I also like the option of modifying the domoticz database with a texteditor, but I guess the new idx numbers still need to be looked up? Most of the time users keep the names of devices when they are replaced, but they always get a different idx number

backupDatabase=/home/pi/domoticz/backups/daily/backup-day-12-domoticz.db # change to real name of backup
currentDatabase=/home/pi/domoticz/domoticz.db  # change to real name of current database

sudo service domoticz stop
sudo cp $currentDatabase safeCopy.db # just to be sure
sudo cp $currentDatabase dz.db

sudo sqlite3 dz.db "ATTACH DATABASE \"$backupDatabase\" AS backup;
CREATE TABLE ConversionHelper AS SELECT * FROM backup.devicestatus;
CREATE VIEW Conversion AS SELECT a.ID New, b.ID Old, b.Name Name FROM DeviceStatus a, ConversionHelper b WHERE a.Name = b.Name;
UPDATE SceneDevices SET DeviceRowID = (SELECT c.New FROM conversion c WHERE c.Old = DeviceRowID );
DROP VIEW Conversion;
DROP TABLE ConversionHelper;"

sudo mv dz.db domoticz_converted.db

echo Scene devices converted
echo Check database and if OK replace current domoticz database with domoticz_converted.db
echo and start domoticz 

waaren wrote: ↑Saturday 23 January 2021 12:16

gschmidt wrote: ↑Saturday 23 January 2021 10:02 I also like the option of modifying the domoticz database with a texteditor, but I guess the new idx numbers still need to be looked up? Most of the time users keep the names of devices when they are replaced, but they always get a different idx number

Should not be that complicated if you kept the same names.

Below bash script would do it for you

Code: Select all

backupDatabase=/home/pi/domoticz/backups/daily/backup-day-12-domoticz.db # change to real name of backup
currentDatabase=/home/pi/domoticz/domoticz.db  # change to real name of current database

sudo service domoticz stop
sudo cp $currentDatabase safeCopy.db # just to be sure
sudo cp $currentDatabase dz.db

sudo sqlite3 dz.db "ATTACH DATABASE \"$backupDatabase\" AS backup;
CREATE TABLE ConversionHelper AS SELECT * FROM backup.devicestatus;
CREATE VIEW Conversion AS SELECT a.ID New, b.ID Old, b.Name Name FROM DeviceStatus a, ConversionHelper b WHERE a.Name = b.Name;
UPDATE SceneDevices SET DeviceRowID = (SELECT c.New FROM conversion c WHERE c.Old = DeviceRowID );
DROP VIEW Conversion;
DROP TABLE ConversionHelper;"

sudo mv dz.db domoticz_converted.db

echo Scene devices converted
echo Check database and if OK replace current domoticz database with domoticz_converted.db
echo and start domoticz 

gschmidt wrote: ↑Saturday 23 January 2021 12:43 Does the UPDATE SceneDevices command also contain the group devices or is that a different command: GroupDevices?

waaren wrote: ↑Saturday 23 January 2021 14:44

gschmidt wrote: ↑Saturday 23 January 2021 12:43 Does the UPDATE SceneDevices command also contain the group devices or is that a different command: GroupDevices?

It is the same. Domoticz groups and scenes information is kept in one table: Scenes
The relation between devices and groups / scenes is also kept in one table: SceneDevices