Page 1 of 1

Manually set IDX?

Posted: Sunday 20 December 2015 18:42
by strelniece
Hi,

is it possible to change the IDX manually?

Why?

I have sensors via tellstick and want to send the data to Domoticz, via node-red and MQTT. Since the sensors has a one ID in tellstick and another in Domoticz, I have to do a conversion, in node-red-

Of course it would be much easier to change the IDX in Domoticz. Haven't found a straightforward way to do it, does anyone know if it's at all possible?

(Change it in tellstick seems even more impossible...)

Re: Manually set IDX?

Posted: Monday 21 December 2015 9:20
by gizmocuz
You could backup your database from the settings page, then open the database in a editor like 'SQLite Expert Personal Edition'
then change the IDX values in the 'DeviceStatus' table
When doing so, i would also clear all log tables (Meter/Multimeter/....) or change also the IDX value there as well

Depending on the amount of devices, maybe best todo this in the node-red script, making one lookup table, easy to extend later