Search found 4 matches
- Thursday 19 February 2015 21:52
- Forum: Other questions and discussions
- Topic: Add electricity values
- Replies: 21
- Views: 10239
Re: Add electricity values
Hi, I see 2 possibility to solve your issue here : - both value and counter column have to be filled with the appropriate data. ValueN= CounterN - Counter N-1 (be carefull on the unit, compare with my value bellow) - In my case I have one row / day. Try to fill all days between first and last day ...
- Thursday 15 January 2015 20:27
- Forum: Other questions and discussions
- Topic: Add electricity values
- Replies: 21
- Views: 10239
Re: Add electricity values
So after a lot of test I finaly get the good setup. I will paste here is it could help : sqlquery look like this : INSERT INTO `Meter_Calendar` VALUES ('ID of the device','consuption of the day','counter value','day'); INSERT INTO `Meter_Calendar` VALUES ('22','12.7','471.27','2015-01-01'); INSERT ...
- Thursday 15 January 2015 14:34
- Forum: Other questions and discussions
- Topic: Add electricity values
- Replies: 21
- Views: 10239
Re: Add electricity values
Hi, and thanks for this info. this is what I have try. I have first put daily data into meter_calendar but still not appear in the domoticz curve Here my sql statment executed succesfully: insert into meter_calendar values (22, 12,0, "01/01/2015" ), (22, 9,0, "02/01/2015" ), (22, 22,0, "03/01/2015 ...
- Thursday 15 January 2015 13:46
- Forum: Other questions and discussions
- Topic: Add electricity values
- Replies: 21
- Views: 10239
Re: Add electricity values
Hi Jan_nl, All, First post for me and it seams to this forum is well interesting. I have just installed a domoticz db on a raspberry and and wantn now to put water consuption for the past days and month. It is quite similar that your requets and I wonder if you success to update your db as planned ...