Sonoff DW2 wifi - Home Assistant Switch to Binary, and get last state when unavaliable

FelisucoVFR · January 27, 2021, 10:42pm

Thanks a lot David!
I could finally make mine work with just a little of work with the marks, quotes, etc.

Note the extra if’s to receive the Closed and Opened instead of on or off.
At sensors.yaml:

  - platform: template
      door_open_garaje_laststate:
        friendly_name: Puerta Garaje
        value_template: >-
          {% if states('binary_sensor.sonoff_1001039bba') == 'on' %}
            {{'Open'}}
          {% elif states('binary_sensor.sonoff_1001039bba') == 'off' %}
            {{'Closed'}}
          {% else %}
            {% if states('sensor.sonoff_dw2_get_last_state') == 'on' %}
                {{'Open'}}
            {% elif states('sensor.sonoff_dw2_get_last_state') == 'off' %}
                {{'Closed'}}
            {% else %}
                {{ states('sensor.sonoff_dw2_get_last_state') }}
            {% endif %}
          {% endif %}

and just after that:

# To find the last 'healthy' state from the SonOff DW2 Wifi
  - platform: sql
#    db_url: !secret db_url. Not needed if the standard one is used
    queries:
      - name: sonoff_dw2_get_last_state
        query: 
          SELECT state
          FROM states
          WHERE entity_id like '%binary_sensor.sonoff_1001039bba%'
          AND state NOT IN ('unavailable', 'unknown')
          ORDER BY Last_Updated desc
          LIMIT 1;
        column: state

Then, calling the “sensor.door_open_garaje_laststate” inside the lovelace entity card, it made the magic.

I must add I have discover just right now, my DW2 Wifi is refreshing its status by itself. It takes >30’ but it refresh.
I will keep it in observation, but If this is true, not sure if it worth all this extra code.
For fun of course, I have enjoy a lot, but I love simple codes when possible…

Anyway, I have only one DW2 wifi which I will keep. Now with battery in % and this retain state, it is great. I have got another DW2 but RF which is going direct to garbage as it has no state, just send state when opening (now it is just in my desk to know when the kids ‘borrow’ my pens).
I have try the SonOff Zigbee SNZB-04 together the bridge and these are perfect. No issues to install. Never loose the state but they refresh their status enough quick enough in some seconds/minutes after a reset. Battery last 5 times the DW2 one and they are 3/4 of the size.

Freddy_Vossen · January 28, 2021, 10:45pm

Sorry for the late answer, the documentation of alexxIT says that it is only in the cloud available.
In the main time I have connected to the cloud and directly after connect the DW2 is available.

KTibow · January 29, 2021, 1:19am

You can publicly expose your HA instance without Nabu Casa.

Vini_DB · February 12, 2021, 8:28am

HEllo.

Guys, just update to latest HA version and the Sonoff DW2 will work perfectly without any additional configuration.

I’m using HACS integration and now my DW2 is working perfeclty. Selection_641

DUM · February 13, 2021, 7:26pm

Hola, where did you write this code, to convert the battery level to %?
I’m using HACS integration: Battery State Card / Entity Row
As you can see in the following picture, just the first one fails. The one with a Sonoff DW2 entity.
bateria

KTibow · February 15, 2021, 2:57pm

What do you mean?

FelisucoVFR · February 15, 2021, 4:10pm

Battery percentage is a “new sensor” you have to add.
That code will go at configuration.yaml or in sensors.yaml if you have that file “included” in the configuration.yaml
So you can choose to use any of them.
Just note I don’t know the Min voltage to be 0% so I just took 2v as 0% and 3v as 100%

Probably will need to adjust to 2.2 or little more. Let’s see when stops working in a few months.

FelisucoVFR · February 15, 2021, 4:24pm

Here you can see, after a reboot, all sensors related to DW2 become unavailable except the one coming from the sql, saved as last state.

nckslater · March 18, 2021, 3:14pm

I can’t for the life of me register the DW2 RF as closed with the Ewelink app.

Add - Alarm and open the door. This is fine.

But when I click ADD when open then shut the door it doesn’t register…

Any ideas?

Thanks

Nava · July 4, 2021, 6:19pm

Hello Good afternoon, I would like to know how I can integrate the DW2 wifi device in home assistant, thank you, I am trying but there is no way.

dogo_uk · July 4, 2021, 6:36pm

You will need to install GitHub - hacs/integration: HACS , follow the instructions. and then it finds the sensor automatically

Regards

Nava · July 4, 2021, 6:55pm

I have the hacs installed but I already have an ewelink switch in homeasistant, these if it detects them but the DW2 wifi does not, I have created a sensors.yaml and I have written the FelisucoVFR code
Felix, what’s up, but there is no way, I understand that in cloud mode, two devices at the same time does not work? Thanks

Nava · July 4, 2021, 9:04pm

It seems to me that this device the DW2 wifi fails more than a fairground shotgun, in the app it works perfectly but in the home assistant it is worth it, at least to me, it will be a matter of looking for another brand that does not have problems, thanks to all for the answers, a hug.

FelisucoVFR · June 2, 2022, 9:33am

Sorry about the very very late respond. Sure this is useless now…
Two sensors work perfect but each of them need it’s own code with different names. That’s all.
I still have it working and I have to say it is reliable. Since last AlexxIT versions as integration it is even easier as you already have the voltage as a separate sensor, so no need that template.
After near two years working I have to say their batteries last near a year.
My only complain is about the size. Rest is good for me.

DUM · September 3, 2022, 12:25pm

Excuse me to come back with this thread, but after the last upgrades, the % for the battery level doesn’t work anymore, and I’m going nuts.
What I’m trying now is as follow, but doesn’t work, any ideas, please:

# Bateria del sensor PuertaEntrada
template:
  - sensor:
    - name: "PuertaEntrada_battery_perc"
      unit_of_measurement: "%"
      value_template: "{{ ((states('sensor.sonoff_1000e0e148_battery_voltage')-2)|float/0.01)|round(1) }}"

DUM · September 3, 2022, 7:07pm

I solved this way:

  - platform: template
    sensors:
      puertaentrada_battery_perc:
        friendly_name: "PuertaEntrada_battery_perc"
        unit_of_measurement: "%"
        value_template: "{{ ((states('sensor.sonoff_1000e0e148_battery_voltage')|float-2)/(0.01)|float)|round(0) }}"

Guilherme_Gimenes · January 2, 2023, 1:41pm

you got the voltage, and then voltage -2 … and then / 0.01

but there´s no relation between voltage and battery level…

for example, my voltage is 2,581 … using your math, my battery level is 58%… no it´s not… i just replaced the batteries…they are 100%

DUM · February 2, 2023, 6:13pm

how did you solve it?
I know my solution wasn’t exact but an aprox. at least

Guilherme_Gimenes · February 3, 2023, 3:43pm

I didn’t… still no solution… DW2 used to have a battery-level entity…but not anymore… I don’t know why it was deprecated

but your math is wrong…like I said…there´s no relationship between voltage and battery level.

maybe with tasmota…

FelisucoVFR · February 23, 2024, 9:39pm

Just in case someone is still interested:

    door_garaje_pct_battery:
      friendly_name: Batería puerta garaje PCT
      unit_of_measurement: "%"
      value_template: >-
        {% set minvdc = 2.25 %} # Minumum voltage 0%
        {% set maxvdc = 2.80 %} # Max voltage 100%
        {% if states('sensor.puerta_garage_battery_voltage')|float < minvdc %}
          0.0
        {% elif states('sensor.puerta_garage_battery_voltage')|float > maxvdc %}
          100.0
        {% else %}
          {{ ( 100/(maxvdc-minvdc) * ((states('sensor.puerta_garage_battery_voltage')|float - minvdc)))|round(0) }}
        {% endif %}
      device_class: battery

@Guilherme_Gimenes It can be linear, logaritmic or whatever, but there is always a relation.