Page 1 of 1
Meaning of columns in database tables for MultiMeter
Posted: Tuesday 18 July 2017 11:24
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.
Re: Meaning of columns in database tables for MultiMeter
Posted: Wednesday 19 July 2017 10:07
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;
Re: Meaning of columns in database tables for MultiMeter
Posted: Monday 13 November 2017 22:27
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]);
Re: Meaning of columns in database tables for MultiMeter
Posted: Monday 08 January 2018 21:53
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.
Re: Meaning of columns in database tables for MultiMeter
Posted: Friday 02 February 2018 13:29
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...