Search found 6 matches

by hreintke
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 ...
by hreintke
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 ...
by hreintke
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 ...
by hreintke
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 ...
by hreintke
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.
by hreintke
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.