Search found 6 matches
- Saturday 18 February 2023 16:00
- Forum: PHP and all others
- Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
- Replies: 10
- Views: 3204
Re: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
The proces is completely outside domoticz, you need a python interpreter to run the script. I am running domoticz on a raspberry, my dev machine is windows I did it with the following steps - Backup the database -> I have a Domoticz.db on my dev machine - In the prijsplafond.csv, replace all "," by ...
- Saturday 18 February 2023 14:12
- Forum: PHP and all others
- Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
- Replies: 10
- Views: 3204
Re: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
I used the python script below to add the "prijsplafond gas" data as the actual usage of gas in a year before I started measuring (for me 2017) Now I can see in the compare graph whether I use more or less than the prijsplafond. import csv import datetime import sqlite3 domdb = sqlite3.connect ...
- Saturday 11 February 2023 16:53
- Forum: Other questions and discussions
- Topic: Changing Energy graph layout
- Replies: 1
- Views: 179
Changing Energy graph layout
Hi, I am working on an upgrade from my 4.11665 version to the 2022.2 version. For now I am setting it up on a different raspberry so I will have old and new running. Installing and importing the datatase works OK as far as I can see now. Also adding values works as expected. But I have a question on ...
- Friday 23 June 2017 16:14
- Forum: Other questions and discussions
- Topic: Scaling of the Y-axis
- Replies: 0
- Views: 539
Scaling of the Y-axis
I have a temperature + humidity sensor. When showing the graphs the "day graph y-axis values" are set that the full y-axis is used. But for month and especially year, the values are very high low so I get very "flat" graphs. Year actual values are between -6 and + 34, scale is from -24 to +72. Is ...
- Monday 09 January 2017 12:40
- Forum: Other questions and discussions
- Topic: Remove one measurement
- Replies: 4
- Views: 1811
Re: Remove one measurement
Thanks,
Works perfect and the solution proved to be much easier than I expected it to be.
Works perfect and the solution proved to be much easier than I expected it to be.
- Monday 09 January 2017 9:22
- Forum: Other questions and discussions
- Topic: Remove one measurement
- Replies: 4
- Views: 1811
Remove one measurement
Hi, I have a temperature device connected, working OK. Now I have one "bad input" , 62 degrees instead of the (here) normal 5 degrees. This is totally ruining my daily and monthly graph. Is there a way to remove that sample. Doesn't need to be from the UI, I know how to get in the system.