Smart Metering - SE PowerTag and Smartlinks SI D

[domotiqa]

I should not be good enought !

I try this on script to change the units and multiplier

Code:

query = 'SELECT * FROM modbus_mapping WHERE "address" = 3203'
for _, mapping in ipairs(db:getall(query)) do
     db:update('value_multiplier', 0.001)
      db:update('units', 'kWh')
end

query = 'SELECT * FROM modbus_mapping WHERE "address" = 3059'
for _, mapping in ipairs(db:getall(query)) do
     db:update('value_multiplier', 0.001)
      db:update('units', 'kW')
end

doesn't work for me !

---

I should not be good enought !

I try this on script to change the units and multiplier

Code:

query = 'SELECT * FROM modbus_mapping WHERE "address" = 3203'
for _, mapping in ipairs(db:getall(query)) do
     db:update('value_multiplier', 0.001)
      db:update('units', 'kWh')
end

query = 'SELECT * FROM modbus_mapping WHERE "address" = 3059'
for _, mapping in ipairs(db:getall(query)) do
     db:update('value_multiplier', 0.001)
      db:update('units', 'kW')
end

doesn't work for me !

I also try to edit the DB in backup file current.db and backup.db

changing the record (editing the units change from w to kw and value_multiplier from null to 0.001

try to reload the backup ! But device are all erase ! I edit with dbbrowser for sqlite