Meaning of columns in database tables for MultiMeter

Post Reply
dutchnomad
Posts: 5
Joined: Tuesday 18 July 2017 11:19
Target OS: Raspberry Pi
Domoticz version:
Contact:

Meaning of columns in database tables for MultiMeter

Post by dutchnomad » Tuesday 18 July 2017 11:24

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: 5
Joined: Tuesday 18 July 2017 11:19
Target OS: Raspberry Pi
Domoticz version:
Contact:

Re: Meaning of columns in database tables for MultiMeter

Post by dutchnomad » Wednesday 19 July 2017 10:07

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: 809
Joined: Wednesday 05 March 2014 14:16
Target OS: Linux
Domoticz version:
Location: France
Contact:

Re: Meaning of columns in database tables for MultiMeter

Post by epierre » Monday 13 November 2017 23:27

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: 4
Joined: Friday 17 March 2017 14:42
Target OS: Raspberry Pi
Domoticz version: 3.8153
Location: Zeist, Netherlands
Contact:

Re: Meaning of columns in database tables for MultiMeter

Post by twbon » Monday 08 January 2018 22:53

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: 809
Joined: Wednesday 05 March 2014 14:16
Target OS: Linux
Domoticz version:
Location: France
Contact:

Re: Meaning of columns in database tables for MultiMeter

Post by epierre » Friday 02 February 2018 14:29

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: No registered users and 1 guest