Page 1 of 1
Open and change device database for renaming devices?
Posted: Friday 26 May 2017 16:27
by renerene
I have to change dozens of device names and I don't want to use the slow web interface.
Is there a way to open the database (ssh?) and edit the names in a text editor or database program?
Re: Open and change device database for renaming devices?
Posted: Friday 26 May 2017 17:59
by SweetPants
renerene wrote:Is there a way to open the database (ssh?) and edit the names in a text editor or database program?
You can try a SQlite editor.
Re: Open and change device database for renaming devices?
Posted: Friday 26 May 2017 20:37
by freijn
Can you please give me a longer hint ? ( How to ? perhaps? )
I am very interested too
THanks !
Re: Open and change device database for renaming devices?
Posted: Friday 26 May 2017 20:49
by SweetPants
freijn wrote:Can you please give me a longer hint ? ( How to ? perhaps? )
I'm running linux and use Sqliteman
I general do:
1) Stop domoticz and make a backup of domoticz.db
2) copy domoticz.db to your system
3) slitleman domoticz.db
4) Open Tables->devicestatus
5) Change 'Name' like you want
6) Commit changes to the database
7) copy domoticz.db to your RPI
8) Start Domoticz
Re: Open and change device database for renaming devices?
Posted: Friday 26 May 2017 20:55
by freijn
Wauw !! Superfast response
Many thanks..
Every tried to connect directly on the running domoricz ?
is there no port available ?
Re: Open and change device database for renaming devices?
Posted: Friday 26 May 2017 21:52
by Egregius
You can use adminer on a live system
