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