Search found 470 matches

by rrozema
Wednesday 01 March 2023 20:18
Forum: Heating/cooling
Topic: Switch off ventilation unit by WiFi
Replies: 4
Views: 988

Re: Switch off ventilation unit by WiFi

Hello, I am new to the forum and have a simple question. I own a Zehnder ConfoAir unit with a Perilex plug with a Sa 1-3v switch. The switch had 3 levels (low, medium, high speed) and has 3 wires. I would like to be able the switch the fan totally off using a mobile device. If this requires ...
by rrozema
Wednesday 01 March 2023 19:45
Forum: Utility
Topic: enphase envoy with (HTTP) interface
Replies: 156
Views: 145126

Re: enphase envoy with (HTTP) interface

@gizmocuz, what can I do to make the individual inverters show up as devices in Domoticz? I've tried restarting Domoticz, clearing the browser cache, de-activating the enphase hardware and re-activating it. The ip, port, user name and password I entered are correct: if I go to my envoy's inverters ...
by rrozema
Wednesday 01 March 2023 19:31
Forum: Utility
Topic: enphase envoy with (HTTP) interface
Replies: 156
Views: 145126

Re: enphase envoy with (HTTP) interface

@benedict & @JustDude: Because a picture sometimes says more than a 1000 words: I think gizmocuz asks you to go to the device and press it's 'Aanpassen' button to open this screen: Capture.JPG Then change the value after "Type:" to "Levering" for the solar production (if it's not like that yet), and ...
by rrozema
Wednesday 01 March 2023 11:10
Forum: Z-Wave
Topic: Fibaro FGR223 Roller Shutter 3 physical buttons cannot control the slats angle?
Replies: 8
Views: 886

Re: Fibaro FGR223 Roller Shutter 3 physical buttons cannot control the slats angle?

You need to go through the options on your shutter 3's node in the z-wave panel. There you can set the behaviour of the shutter 3. One of the things you can set is the type of physical switch(es) you connected to the shutter 3. I am not sure which exact settings will result in the behaviour you're ...
by rrozema
Wednesday 01 March 2023 2:00
Forum: Z-Wave
Topic: Fibaro FGR223 Roller Shutter 3 physical buttons cannot control the slats angle?
Replies: 8
Views: 886

Re: Fibaro FGR223 Roller Shutter 3 physical buttons broken by update to 2023.1?

Physical button operation can not be interfered by Domoticz other than via settings in the device itself: physical buttons will even work when no controller is present at all. andrejh's problem must therefor be something in the z-wave node's options. Did you try re-calibrating your shutter 3?
by rrozema
Monday 27 February 2023 19:47
Forum: Utility
Topic: enphase envoy with (HTTP) interface
Replies: 156
Views: 145126

Re: enphase envoy with (HTTP) interface

Hello @rrozema and @Redbora In the latest stable 2023.1 and from beta 14777 (See: https://www.domoticz.com/wiki/Domoticz_version_table_V2022.2) the P1 device has been removed from the Enphase hardware. The reason has been, that P1 Smart Meter device is intended for a P1 Smart Meter. That makes ...
by rrozema
Monday 27 February 2023 12:48
Forum: Utility
Topic: enphase envoy with (HTTP) interface
Replies: 156
Views: 145126

Re: enphase envoy with (HTTP) interface

Hi, I just noticed that my enphase panels no longer pass their information into Domoticz after I upgraded to 2023.1. All enphase devices are shown in Domoticz with red title bars and show no more updates since the update. Capture1.JPG I have the Domoticz standard hardware for installed: Capture2 ...
by rrozema
Monday 27 February 2023 12:27
Forum: Utility
Topic: enphase envoy with (HTTP) interface
Replies: 156
Views: 145126

Re: enphase envoy with (HTTP) interface

When i do a curl on my envoy Ip i get. Is there somebody with a solution. groet Jan I think this is what I have read about in other threads: not sure about the details but I think you need to go into the settings page in Domoticz, open the 'Security' tab, and there enter both 127.0.0.1;192.168.x.y ...
by rrozema
Monday 27 February 2023 12:07
Forum: Utility
Topic: enphase envoy with (HTTP) interface
Replies: 156
Views: 145126

Re: enphase envoy with (HTTP) interface

Hi, I just noticed that my enphase panels no longer pass their information into Domoticz after I upgraded to 2023.1. All enphase devices are shown in Domoticz with red title bars and show no more updates since the update. Capture1.JPG I have the Domoticz standard hardware for installed: Capture2.JPG ...
by rrozema
Saturday 18 February 2023 18:14
Forum: PHP and all others
Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
Replies: 10
Views: 1630

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 rrozema
Saturday 18 February 2023 14:31
Forum: PHP and all others
Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
Replies: 10
Views: 1630

Re: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond

Cool,
I have some questions if you please?

- how do you execute the python script? Do you do that from within Domoticz or do you use some external program?
- i am not familiar with python, what exactly is the result of your script?
by rrozema
Tuesday 14 February 2023 13:24
Forum: PHP and all others
Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
Replies: 10
Views: 1630

Re: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond

I added the values for the prijsplafond itself into the queries, using the tables I imported earlier into deviceRowID 1984 (eletric) and 1983 (Gas): For electric the query is: select t2.date_start, t2.Counter1_start as [Verbruik Daltarief Meterstand start], t2.Counter3_start as [Verbruik ...
by rrozema
Tuesday 14 February 2023 12:59
Forum: PHP and all others
Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
Replies: 10
Views: 1630

Re: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond

Why don't you use the same JSON calls as the graphs use, or use the counter values from the report? Please show me how. I know how to do queries, not how to use those json calls. But also: the counter values from the report are not for a specific date range as far as I know. This query takes the ...
by rrozema
Tuesday 14 February 2023 12:18
Forum: PHP and all others
Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
Replies: 10
Views: 1630

Re: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond

I also imported the prijsplafond values, as published on rijksoverheid.nl into the meter_calendar table for 2 dummy devices. I did this by creating the dummy devices, find their device ID and then running the following queries: For the Gas prijsplafond values: insert into Meter_Calendar (DeviceRowID ...
by rrozema
Tuesday 14 February 2023 12:07
Forum: PHP and all others
Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
Replies: 10
Views: 1630

Re: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond

Why don't you use the same JSON calls as the graphs use, or use the counter values from the report? Please show me how. I know how to do queries, not how to use those json calls. But also: the counter values from the report are not for a specific date range as far as I know. This query takes the ...
by rrozema
Tuesday 14 February 2023 11:18
Forum: PHP and all others
Topic: SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond
Replies: 10
Views: 1630

SQL to query Gas and Electricity usage over specific date range for the Dutch PrijsPlafond

Here's another query I wrote to query the domoticz.db. I switched to a new energy provider to make better use of the Dutch prijsplafond. My old contract ended January 27th 2023, so I wanted to see how much Gas and electricy was used between January 1st, 2023 and the January 27th, 2023, to verify if ...
by rrozema
Tuesday 03 January 2023 14:10
Forum: Other questions and discussions
Topic: Enable copying log from webinterface
Replies: 7
Views: 724

Re: Enable copying log from webinterface

Unfortunately the default is still that you cannot select logs to copy-paste them. Found how to solve it: (make a backup (of at least that file) first! I am not to be held responsible if you mess up) find your www folder for domoticz (default for rpi: ~/domoticz/www) open your index.html, find ...
by rrozema
Tuesday 03 January 2023 0:37
Forum: Z-Wave
Topic: OpenZWave removed from build checks
Replies: 16
Views: 1945

Re: OpenZWave removed from build checks

I'm not sure if it's ozw, but their z-wave is still within the same executable. But what's more important (to me at least) is that their implementation is more advanced. In openhab you can not only control z-wave devices, you can also have the controller behave as a z-wave device. This enables me f ...
by rrozema
Monday 02 January 2023 19:28
Forum: Z-Wave
Topic: Zwave rollershutters not responding
Replies: 2
Views: 414

Re: Zwave rollershutters not responding

Next time, instead of resetting the non-responding device, use the 'Refresh Node Info' ("Vernieuw Node Info") button to have Domoticz re-query the node for its device definitions. That way the device will not get a new ID, but Domoticz will re-connect all existing devices to it or create new ones ...
by rrozema
Monday 02 January 2023 17:28
Forum: Z-Wave
Topic: OpenZWave removed from build checks
Replies: 16
Views: 1945

Re: OpenZWave removed from build checks

That will be time I will have to leave Domoticz for openHAB then... Hope it will take some more time as I'm not done setting up my test system yet. But it gets forced upon me like this, I will have to say "so long and thanks for all the fish"...