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 ;)