Page 1 of 1

Multimeter values issue

Posted: Sunday 12 November 2017 17:37
by epierre
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

Re: Multimeter values issue

Posted: Monday 13 November 2017 22:03
by epierre
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"
},

Re: Multimeter values issue

Posted: Monday 13 November 2017 22:13
by epierre
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