Domoticz

Thugbear wrote: ↑Monday 03 February 2020 10:49 Now I'm trying to find a way that i can adjust the values already recorded, so i can get my history working properly. Any ideas how to do that with for example DB Browser for SQLite?

sudo sqlite3 domoticz.db 
select * from Meter_Calendar Where Value >220000000;
update Meter_Calendar set value = 1182 where (DeviceRowID = 440 and Date ='2020-02-01'); 

klin34970 wrote:Hello,
thx akamming for your script, I didn't have to do it from scratch. I had to improve it.
I received 1 day ago, 10 NAS-WR01Z and same problem for all.

During my investigation, sometimes domoticz.data[device.name].max() return nil.
In this case, it's a error and negative value will be written.
Here is my little changes:

Code: Select all

return {
    
    on = { 
       devices = { 
           "Spa kWh Meter" -- add your to be corrected neo coolcam kwh meter here 
       }
    },
        
    logging =   {   
        level     =   domoticz.LOG_DEBUG,
        marker    =   "NEO Coolcam kWh Fix"      
    },
    data = {
             ["Spa kWh Meter"] = { history = true, maxItems = 10 } -- add your to be corrected neo coolcam kwh meter here
    },
    
    execute = function(domoticz,device)
        domoticz.log("device["..device.name.."] was changed to ["..device.state.."]",domoticz.LOG_DEBUG);
        
        domoticz.log("total is "..device.WhTotal..", usage="..device.usage,domoticz.LOG_DEBUG)
        if (device.WhTotal>0) then
            domoticz.log("adding to history",domoticz.LOG_DEBUG)
            domoticz.data[device.name].add(device.WhTotal)
        else
            local CorrectedWhTotal=0
            if (domoticz.data[device.name].max()) then
                CorrectedWhTotal=domoticz.data[device.name].max()
            end
            device.updateElectricity(device.usage,CorrectedWhTotal).silent()
            domoticz.log("Negative number, correcting WhTotal from "..device.WhTotal.." to "..CorrectedWhTotal,domoticz.LOG_DEBUG)
        end
        
    end
}

I also delete all negatives values from Database.

Code: Select all

sqlite3 domoticz.db
DELETE FROM Meter WHERE value < 0;

BEFORE


AFTER

SchulieBug wrote: ↑Wednesday 27 May 2020 10:58 I do have the same issue and have implemented the script mentioned in this topic. However, when I look in the database, Meter table, I see large negative numbers in the Value field (not anymore in the usage). How do I get rid of these false values?

As an example:
Meter table value large negative.jpg

What can I do to get rid of these values (besides dropping the Neo Coolcam's)?

Bolten88 wrote: ↑Wednesday 17 June 2020 9:45 Wich application are you using here?

SchulieBug wrote: ↑Wednesday 17 June 2020 9:50

Bolten88 wrote: ↑Wednesday 17 June 2020 9:45 Wich application are you using here?

Export the database from within Domoticz and open it with SQ Lite Database Browser Portable (download it here)