+- Logic Machine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Scripting (https://forum.logicmachine.net/forumdisplay.php?fid=8)
+--- Thread: modbus device bus_write option modified by scipt (/showthread.php?tid=5745)
modbus device bus_write option modified by scipt - domotiqa - 15.11.2024
Hi,
I had a script I made to generate lots of modbus counter and map device.
I made a mistake in my scipt and all my variable/GA mapped was with bus_write enable.
So I made a script to modify in DB, table modbus_mapping the bus_write mapped object from 1 to 0
My script worked well. And now when I go editing a modbus device and see mapped object, the checkbox are unchecked. However there is still write object on the bus. I tried to restart without difference. Even on ETS side in monitoring I can see the object writed to the bus.
Is there another process I can do ?
Thanks
RE: modbus device bus_write option modified by scipt - admin - 15.11.2024
Provide the script that you've used to update the database.
RE: modbus device bus_write option modified by scipt - domotiqa - 15.11.2024
here
Code:
searchKey='bus_write'
valueSearch='1'
oldValue='1'
newValue='0'
key='bus_write'
mytable='modbus_mapping'
if oldValue =='' then
querySql="UPDATE "..mytable.." SET "..key.." = "..newValue.." WHERE "..searchKey.." like '%"..valueSearch.."%'"
else
querySql="UPDATE "..mytable.." SET "..key.." = REPLACE("..key..", '"..oldValue.."', '"..newValue.."') WHERE "..searchKey.." like '%"..valueSearch.."%'"
end
db:query(querySql)I precise that after my script, if I go to modbus the write option is disabled on all element
RE: modbus device bus_write option modified by scipt - admin - 15.11.2024
You have extra quotes around 0, that's why it doesn't work. The query can be simplified: 'update modbus_mapping set bus_write=0'
Reboot after running it.
RE: modbus device bus_write option modified by scipt - domotiqa - 18.11.2024
ok thank you for helping I will try.