Meaning of columns in database tables for MultiMeter

Moderator: leecollings

Post Reply
dutchnomad
Posts: 4
Joined: Tuesday 18 July 2017 11:19
Target OS: Raspberry Pi / ODroid
Domoticz version: 4.9700
Location: Netherlands
Contact:

Meaning of columns in database tables for MultiMeter

Post by dutchnomad »

Is there any information available on the meaning of the columns in the database tables MultiMeter and MultiMeter_Calendar. For some I can deduce the meaning but other are elusive.
dutchnomad
Posts: 4
Joined: Tuesday 18 July 2017 11:19
Target OS: Raspberry Pi / ODroid
Domoticz version: 4.9700
Location: Netherlands
Contact:

Re: Meaning of columns in database tables for MultiMeter

Post by dutchnomad »

This I found out from the source code for the table MultiMeter (and I guess it applies to the MultiMeter_Calendar table,but I am not sure):

value1 = powerusage1;
value2 = powerdeliv1;
value3 = usagecurrent;
value4 = delivcurrent;
value5 = powerusage2;
value6 = powerdeliv2;
User avatar
epierre
Posts: 522
Joined: Wednesday 05 March 2014 13:16
Target OS: Linux
Domoticz version:
Location: France
Contact:

Re: Meaning of columns in database tables for MultiMeter

Post by epierre »

the code shows this which is different:
std::stringstream s_powerusage1(splitresults[0]);
std::stringstream s_powerusage2(splitresults[1]);
std::stringstream s_powerdeliv1(splitresults[2]);
std::stringstream s_powerdeliv2(splitresults[3]);
std::stringstream s_usagecurrent(splitresults[4]);
std::stringstream s_delivcurrent(splitresults[5]);
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
twbon
Posts: 3
Joined: Friday 17 March 2017 13:42
Target OS: Raspberry Pi / ODroid
Domoticz version: 3.8153
Location: Zeist, Netherlands
Contact:

Re: Meaning of columns in database tables for MultiMeter

Post by twbon »

The list of dutchnomad fits the charateristics of the data in my database. The order of epierre is not possible in my data.
User avatar
epierre
Posts: 522
Joined: Wednesday 05 March 2014 13:16
Target OS: Linux
Domoticz version:
Location: France
Contact:

Re: Meaning of columns in database tables for MultiMeter

Post by epierre »

anyway who know the table columns values and usage ? I'm stuck with smart meters integration for I can't find any explanation of hte daily values uses...
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: euhen and 1 guest