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: 3832

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 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: 3832

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: 188

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 ...
by hreintke
Friday 23 June 2017 16:14
Forum: Other questions and discussions
Topic: Scaling of the Y-axis
Replies: 0
Views: 546

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: 1849

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: 1849

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.