Page 1 of 1
Retrieve used ID and UnitCode from somfy blinds
Posted: Wednesday 24 July 2019 20:48
by 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 1514 times
kind regards,
Pieter
Re: Retrieve used ID and UnitCode from somfy blinds
Posted: Wednesday 24 July 2019 21:09
by waaren
Iedipipeau wrote: ↑Wednesday 24 July 2019 20:48
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
Re: Retrieve used ID and UnitCode from somfy blinds
Posted: Wednesday 24 July 2019 21:32
by 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 1507 times
Thanks anyway for the command line solution!