Domoticz

Code: Select all

--[[  dzVents script to Parse P1 Smart Meter Electricity value into seperated Meter Readings.

]]--  The following need updated for your environment get the 'Idx' or 'Name' of the Device tab.

local fetchIntervalMins = 1                 -- (Integer) (Minutes, Range 5-60) How often SE file is fetched
local P1data = 4                               -- Electra, P1 Smart Meter device
local idxu1 =  15                                -- Meter Usage low, Virtual device, counter incremental
local idxu2 = 16                                 -- Meter Usage High, Virtual device, counter incremental
local idxr1 = 17                                  -- Meter Return Low, Virtual device, counter incremental
local idxr2 = 18                                 -- Meter Return High, Virtual device, counter incremental
local idxcons = 19                             -- Meter Actual Usage, Virtual device, counter incremental
local idxprod = 20                             -- Meter Actual Production, Virtual device, counter incremental

local ScriptVersion = '0.1.5'

return {
    active = true,
	logging = {
	    -- level = domoticz.LOG_DEBUG,    -- Uncomment this line to override the dzVents global logging setting
		marker = 'SME '.. ScriptVersion
	},
	on = {
		timer = { 'every minute' }
	},
	
	execute = function(domoticz, device)
	          
            -- Get values from device P1Data of the Smart Meter
    	    local SMdata = domoticz.devices(P1data).rawData
    	    
    	    -- Update the device and Debug meassages with the accessory values from table SMdata
            domoticz.devices(idxu1).updateCounter(SMdata[1])
            domoticz.log('Gebruik laag  = '.. SMdata[1], domoticz.LOG_DEBUG)
            domoticz.devices(idxu2).updateCounter(SMdata[2])
	    domoticz.log('Gebruik hoog  = '.. SMdata[2], domoticz.LOG_DEBUG)
            domoticz.devices(idxr1).updateCounter(SMdata[3])
    	    domoticz.log('Levering laag = '.. SMdata[3], domoticz.LOG_DEBUG)
            domoticz.devices(idxr2).updateCounter(SMdata[4])
	    domoticz.log('Levering hoog = '.. SMdata[4], domoticz.LOG_DEBUG)
	    domoticz.devices(idxcons).updateCounter(SMdata[5])
    	    domoticz.log('Actuele verbruik = '.. SMdata[5], domoticz.LOG_DEBUG)
    	    domoticz.devices(idxprod).updateCounter(SMdata[6])
	    domoticz.log('Actuele levering = '.. SMdata[6], domoticz.LOG_DEBUG)
    
    end -- execute
}

Code: Select all

service domoticz stop
cd <domoticz directory>
sudo cp domoticz.db domoticz.keep # make a copy of current database and store it on a safe place
sudo apt install sqlite3 # if you do not have sqlite3 on your system yet
sudo sqlite3 domoticz.db


-- for all devices use the line below these comment lines to copy current status. 
-- Replace xxxx with old device id and yyyy with new device id 
-- zzz is the factor you can use. Don't know for your situation but start with 1 and you will see in the GUI 
-- if that's too low or too high. To increase use 10, 100 or 1000 to decease use 0.1, 0.01 or 0.001

sqlite> update devicestatus set sValue = (select sValue * 10 from devicestatus where id = xxxx ) where id = yyyy; -- Transfer current state to new device


-- for all devices use the line below this comment line to delete short log for new virtual sensors
sqlite> delete from meter where id is yyyy;

-- make a temp copy of the meter_calendar table
sqlite> create table temp as select * from meter_calendar;

-- for all devices use the lines below this comment lines to copy long term history logs for new virtual sensors
sqlite> update temp set devicerowid = yyyy where devicerowid = xxxx;select changes()  -- change ID in temp
sqlite> insert into meter_calendar select * from temp where devicerowid = yyyy;select changes(); -- copy all with new ID from temp
sqlite> update meter_calendar set value = value * zzz where devicerowid = yyyy; -- Adjust values only when needed
sqlite> update meter_calendar set counter = counter * zzz where devicerowid = yyyy; -- Adjust values only when needed

-- You don't need temp table 
sqlite> drop table temp;

sqlite> .quit

sudo service domoticz start