Multimeter values issue

Post Reply
User avatar
epierre
Posts: 808
Joined: Wednesday 05 March 2014 14:16
Target OS: Linux
Domoticz version:
Location: France
Contact:

Multimeter values issue

Post by epierre » Sunday 12 November 2017 18:37

Hello,

I'm trying to import half an hour details about electricity consumptions from Linky into domoticz, but there seems to be something wrong I don't understand.

Here is aa request into MultiMeter table:

INSERT INTO 'MultiMeter' (DeviceRowID,Value1,Value2,Value3,Value4,Value5,Value6,Date) VALUES (547,336199, 0,0,0,386,0, '2017-11-11 23:30:00');

But in return API and UI show no or very few of them.

Above 386 is the usage, and 336199 the aggregated counter
ImperiHome & MyDomoAtHome on top of:
868.42Mhz - Vera Lite - Fibaro SS-101, S-211, K-101, FWP - Fortress SSA2
433Mhz - Cubie Domoticz + RFXtrx + Oregon || Foscam 9821W
2,4Ghz - Cubie MySensors Gateway + COV + TempHumidity + Pressure + WaterMeter

User avatar
epierre
Posts: 808
Joined: Wednesday 05 March 2014 14:16
Target OS: Linux
Domoticz version:
Location: France
Contact:

Re: Multimeter values issue

Post by epierre » Monday 13 November 2017 23:03

or maybe some help understanding where the 23:00 values comes from since it is not in the database ?

{
"d" : "2017-11-11 22:00",
"v" : "1714.000"
},
{
"d" : "2017-11-11 23:00",
"v" : "18446744073709551616.000"
},
ImperiHome & MyDomoAtHome on top of:
868.42Mhz - Vera Lite - Fibaro SS-101, S-211, K-101, FWP - Fortress SSA2
433Mhz - Cubie Domoticz + RFXtrx + Oregon || Foscam 9821W
2,4Ghz - Cubie MySensors Gateway + COV + TempHumidity + Pressure + WaterMeter

User avatar
epierre
Posts: 808
Joined: Wednesday 05 March 2014 14:16
Target OS: Linux
Domoticz version:
Location: France
Contact:

Re: Multimeter values issue

Post by epierre » Monday 13 November 2017 23:13

and also why just after inserting in MultiMeter, the system adds a new line with date time of my inserts ?

547|332165|0|0|0|1368|0|2017-11-12 23:30:00
547|100|0|0|0|0|0|2017-11-13 22:10:01
ImperiHome & MyDomoAtHome on top of:
868.42Mhz - Vera Lite - Fibaro SS-101, S-211, K-101, FWP - Fortress SSA2
433Mhz - Cubie Domoticz + RFXtrx + Oregon || Foscam 9821W
2,4Ghz - Cubie MySensors Gateway + COV + TempHumidity + Pressure + WaterMeter

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest