Retrieve used ID and UnitCode from somfy blinds Topic is solved

[Iedipipeau]

Hi,

I'm looking to retrieve the ID and UnitCode from my somfy automatic blinds that I have setup in Domoticz.
Is there any possibility to get those from domoticz?
This in order to prevent that I have to program my blinds again, in case of.

2019-07-24 20_43_44-Domoticz.png (20.23 KiB) Viewed 1465 times

kind regards,

Pieter

[waaren]

I'm looking to retrieve the ID and UnitCode from my somfy automatic blinds that I have setup in Domoticz.
Is there any possibility to get those from domoticz?
This in order to prevent that I have to program my blinds again, in case of.

It's all in the domoticz.db
on the CLI

Code: Select all

sudo cp <domoticz dir>/domoticz.db  workcopy.db
sudo sqlite3 workcopy.db
sqlite> .header on
sqlite> .tables 
sqlite> select Name, ID, DeviceID, Unit from devicestatus where type = 26; -- or if your type is different select them with ID as search key
sqlite> select Name, ID, DeviceID, Unit, type from devicestatus where ID = 292;
sqlite> .quit
sudo rm workcopy.db

[Iedipipeau]

Hi!

Thx a lot for the information.
In fact... stupid me! I had downloaded a backup of the database from domoticz and read it with DBBrowser for SQLlite.
It never came into my mind that the answer was in front of me

2019-07-24 21_27_46-DB Browser for SQLite - C__Users_Pieter_Downloads_Domoticz (2).db.png (19.04 KiB) Viewed 1458 times

Thanks anyway for the command line solution!