Open and change device database for renaming devices?

[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?

[SweetPants]

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.

[freijn]

Can you please give me a longer hint ? ( How to ? perhaps? )

I am very interested too

THanks !

[SweetPants]

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

[freijn]

Wauw !! Superfast response

Many thanks..

Every tried to connect directly on the running domoricz ?
is there no port available ?

[Egregius]

You can use adminer on a live system