Meaning of columns in database tables for MultiMeter
Moderator: leecollings
-
- 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
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.
-
- 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
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;
value1 = powerusage1;
value2 = powerdeliv1;
value3 = usagecurrent;
value4 = delivcurrent;
value5 = powerusage2;
value6 = powerdeliv2;
- 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
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]);
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
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
-
- 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
The list of dutchnomad fits the charateristics of the data in my database. The order of epierre is not possible in my data.
- 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
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
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
Who is online
Users browsing this forum: euhen and 1 guest