Desky Standing Desk (ESPHome) [Works with Desky, Uplift, Jiecang, Assmann & others]

[Mahko_Mahko]

Ok I think that’s progress.

I think the messages can be noisy if you’re not grounded properly. Try adding the ground wire like this. Remove it if anything smokes etc;) I think it is ok.
I assume you are still powering via usb?

After looking at logs for that, also, try changing this to 9.

bytes: 9

Move the desk up or down and post logs again please.

If we do hit a dead end with the rj45 port, you can also try your luck with the rj12 port. It’s even potentially preferable.

Desky Standing Desk (ESPHome) [Works with Desky, Uplift, Jiecang, Assmann & others]

Here’s my bare bones “yaml only” version. People getting started can try this as a basic implementation if they like, and move over to yours for more advanced features. Two goals: Make it easy for newbies to get started (although my weird board config might confuse some) Make it easy for beginners to tweak the sensor if needed (we’ve had some different protocol variants pop up and this reduces reliance on cpp developers). Feel free to borrow the pics etc. I would have done it with a D1 mini…

Desky Standing Desk (ESPHome) [Works with Desky, Uplift, Jiecang, Assmann & others]

Hello again! tl;dr: new: number entities, recommended config here. Inspired by the project actually being used I spent some time on it this weekend Thanks to the information collected by Mahko_Mahko I was able to add two essential commands to my project. Stop command It is now possible to add a stop button and/or use the stop() command in lambdas. In my case the desk stops immediately, so no soft stop unfortunately. (I guess it’s like an emergency break so it’s for security reasons?) …

Also, if you have a multimeter, it’s worth checking you get 5v on the power/gnd desk wires that go to the esp.

[CtrlAltProcrastinate]

So i got this Uppspel IKEA desk and long story short: I’ve built my own little desky, but could not find a suitable enclosure for a USB-C D1 Mini. So i’ve remixed the one from Okham and made a few modifications.

The result is available at Desky Standing Desk DIY Wifi Dongle Enclosure for USB-C D1 mini by CtrlAltProcrastinate - Thingiverse and looks like this:

[Mahko_Mahko]

Nice! Thanks for sharing back!

[f1x6r]

Hi guys. Looking for help integrating my desk into Home Assistant. I have some “Ergostol” with a 000-DH16_V02 board. No control via RJ connector.
I’ve already searched a bit on the Internet and apparently there are no ready-made projects on this topic yet.
As far as I understand, control is via a connector under the screen (I soldered the wires)? Or is this a connector for flashing the controller?

Can you tell me what to read about this? I don’t have much experience yet, so would appreciate any help

Photos of my controller. Maybe it will make things a little clearer

[Mahko_Mahko]

It’s best you start your own thread for this.
This thread is for Desky / Jiecang desks.
@ me once you’ve done that and I’ll offer what I can.
Probably you’ll be starting from scratch with this desk so may well have a lot of exploration and learning to do.

Here is an example of what to post and in that thread is also some common starting points.

Another Desk Motorized Controller

I was researching community for similar or exact manufacturers, but I discovered that mine desk is quite different from others (Uplift, Desky, Jiecang, etc.) Here are some images from my desk motors (black box) and desk controller (display height with buttons) [viber_image_2023-03-14_21-31-27-217] [viber_image_2023-03-02_19-16-21-424] [viber_image_2023-03-02_18-56-22-349] [viber_image_2023-03-02_18-56-22-349] [viber_image_2023-03-02_18-56-22-349] [viber_image_2023-03-02_14-30-35-219] An…

[exx]

This is for a Vari Desk, and works great, thank you for getting me going!

I’ve made a few changes and additions to the code, including making functional minimum and maximum values to stop movement, and added presets for sitting and standing (seemed easier than trying to simulate the physical buttons).

I also had to change the throttle on the height from 200ms to 4ms to overcome an issue whereby the height displayed in HA did not match what was displayed on the desk. It also appears to have made it a bit more accurate now as a full run from standing to sitting stopped EXACTLY where it should have, whereby it was previously off .1-.2".

I originally tried going from 200ms to 100ms and it was better, but still off once in a while. I chose 4ms because of this article: https://www.devmire.com/reverse-engineering-a-standing-desk-for-fun-and-profit/ Specifically, there was a comment in the code that stated “Height should be set in bursts of x ms pulses, as it takes 4ms to read the current height”.

I used an ESP32, Dupont jumpers (male/female), and one of these for pass-thru: Amazon.com: Teansic 2PCS RJ45 Ethernet Dual Female Terminal Breakout Board,3.5mm Pitch 8Pin RJ45 Screw Connector Board Shielded Network Adapter Terminal : Electronics All that’s needed for assembly is a tiny little screwdriver - no soldering!

I’ll be designing an enclosure for it in the near future.

Enjoy!

esphome:
  name: small-desk
  friendly_name: Small Desk
  on_boot:
    priority: -100.0
    then:
    #Request a desk height update after boot.
      - delay: 5s
      - switch.turn_on: wake_desk_and_get_height

esp32:
  board: esp32dev
  framework:
    type: arduino

# Enable logging
logger:

# Enable Home Assistant API
api:

ota:

wifi:
  ssid: !secret wifi_ssid
  password: !secret wifi_password

  # Enable fallback hotspot (captive portal) in case wifi connection fails
  ap:


external_components:
#Fetch ssieb's custom component# https://github.com/ssieb/custom_components/tree/master/components/desky
  - source:
      type: git
      url: https://github.com/ssieb/custom_components
    components: [ desky ]

uart:
  - id: desk_uart
    baud_rate: 9600
    rx_pin: 1

desky:
  id: desk_controller
  timeout: 15s
  height:
    name: Desk Height
    id: desk_height
    accuracy_decimals: 1
    unit_of_measurement: in
    filters:
    - delta: 0.05
    - throttle: 4ms
    - multiply: 0.1
    on_value:
      then:
          #If the value changes, then the desk is moving
        - binary_sensor.template.publish:
            id: desk_is_moving
            state: ON
        - delay: 300ms
          #Assume it's stopped moving if no height changes after a short time.
        - binary_sensor.template.publish:
            id: desk_is_moving
            state: Off
binary_sensor:
  - platform: template
    id: desk_is_moving
    name: "Desk Is Moving"
    filters:
      - delayed_off: 400ms
    #If the desk isn't moving for a bit we better turn off attempts at movement. Poor man's collision detection? 
    on_release:
      then:
        - button.press: desky_stop_desk

button: 
#Stop movement 
  - platform: template
    name: Stop Desk
    id: desky_stop_desk
    on_press:
      then:
        - switch.turn_off: raise_desk
        - switch.turn_off: lower_desk

#Go to height x
  - platform: template
    name: Go To Height x
    id: go_to_preset_height_x
    on_press:
      then:
      #Check if we need to move desk up or down from current position      
        if:
          condition:
          #Current height is more than target height, then move desk down
            lambda: |-
              return id(desk_target_height).state < id(desk_height).state;
          then:
            - switch.turn_on: lower_desk
            - wait_until:
              #Run until the difference between current and target state is < stopping distance 
                condition:
                  lambda: return (id(desk_height).state)<((id(desk_target_height).state) + (id(stopping_distance_in).state));
            - switch.turn_off: lower_desk
          else:
          #Current height is less than target height, move desk up
            - switch.turn_on: raise_desk
            - wait_until:
                condition:
                  lambda: return (id(desk_height).state)>((id(desk_target_height).state) - (id(stopping_distance_in).state));
                  #Run until the difference between current and target state is <0.3cm
            - switch.turn_off: raise_desk

#Go to sitting height
  - platform: template
    name: Go To Sitting Height
    id: go_to_sitting_preset_height
    on_press:
      then:
      #Check if we need to move desk up or down from current position      
        if:
          condition:
          #Current height is more than sitting height, then move desk down
            lambda: |-
              return id(desk_sitting_height).state < id(desk_height).state;
          then:
            - switch.turn_on: lower_desk
            - wait_until:
              #Run until the difference between current and sitting height is < stopping distance 
                condition:
                  lambda: return (id(desk_height).state)<((id(desk_sitting_height).state) + (id(stopping_distance_in).state));
            - switch.turn_off: lower_desk
          else:
          #Current height is less than target height, move desk up
            - switch.turn_on: raise_desk
            - wait_until:
                condition:
                  lambda: return (id(desk_height).state)>((id(desk_sitting_height).state) - (id(stopping_distance_in).state));
                  #Run until the difference between current and sitting height < stopping distance
            - switch.turn_off: raise_desk


#Go to standing height
  - platform: template
    name: Go To Standing Height
    id: go_to_standing_preset_height
    on_press:
      then:
      #Check if we need to move desk up or down from current position      
        if:
          condition:
          #Current height is more than standing height, then move desk down
            lambda: |-
              return id(desk_standing_height).state < id(desk_height).state;
          then:
            - switch.turn_on: lower_desk
            - wait_until:
              #Run until the difference between current and standing height is < stopping distance 
                condition:
                  lambda: return (id(desk_height).state)<((id(desk_standing_height).state) + (id(stopping_distance_in).state));
            - switch.turn_off: lower_desk
          else:
          #Current height is less than target height, move desk up
            - switch.turn_on: raise_desk
            - wait_until:
                condition:
                  lambda: return (id(desk_height).state)>((id(desk_standing_height).state) - (id(stopping_distance_in).state));
                  #Run until the difference between current and standing height < stopping distance
            - switch.turn_off: raise_desk

number:
  - platform: template
    id: desk_target_height
    name: "Target Height x"
    optimistic: true
    unit_of_measurement: in
    min_value: 29
    max_value: 49
    step: 0.1

  - platform: template
    id: lower_limit
    name: "Lower Limit"
    optimistic: True
    unit_of_measurement: in
    min_value: 27
    max_value: 29
    step: 0.1
    restore_value: True
    initial_value: 28

  - platform: template
    id: upper_limit
    name: "Upper Limit"
    optimistic: True
    unit_of_measurement: in
    min_value: 48
    max_value: 50
    step: 0.1
    restore_value: True
    initial_value: 49
  
  - platform: template
    name: "Stopping Distance Offset"
    id: stopping_distance_in
    unit_of_measurement: in
    optimistic: true
    min_value: .1
    max_value: 1
    step: 0.1
    restore_value: true
    initial_value: .4

  - platform: template
    id: desk_standing_height
    name: "Standing Height"
    optimistic: true
    unit_of_measurement: in
    #Limit the range
    min_value: 45
    max_value: 49
    step: 0.1
    restore_value: true
    initial_value: 48

  - platform: template
    id: desk_sitting_height
    name: "Sitting Height"
    optimistic: true
    unit_of_measurement: in
    #Limit the range
    min_value: 28.5
    max_value: 32
    step: 0.1
    restore_value: true
    initial_value: 30

switch:
#wake up the desk and request it sends its height 
  - platform: gpio
    id: wake_desk_and_get_height
    name: "Request Desk Height"
    pin:
      number: 14
      inverted: true
    on_turn_on:
    - delay: 100ms
    - switch.turn_off: wake_desk_and_get_height

#Raise the desk 
  - platform: gpio
    id: raise_desk
    name: "Raise Desk"
    pin:
      number: 4
      # mode: INPUT_PULLUP
      inverted: true
    interlock: lower_desk
    on_turn_on:
    - wait_until:
     #Run until current > upper limit + stopping distance 
        condition:
          lambda: return (id(desk_height).state)>((id(upper_limit).state) - (id(stopping_distance_in).state));
    - switch.turn_off: raise_desk
#Lower the desk 
  - platform: gpio
    id: lower_desk
    name: "Lower Desk" 
    pin:
      number: 5
      # mode: INPUT_PULLUP
      inverted: true
    interlock: raise_desk
    on_turn_on:
    - wait_until:
     #Run until current < lower limit + stopping distance 
        condition:
          lambda: return (id(desk_height).state)<((id(lower_limit).state) + (id(stopping_distance_in).state));
   #Auto off after 15s just in case
    - switch.turn_off: lower_desk

[Mahko_Mahko]

Good to hear. I’ve added Vari Desk to the “works with” list.

[exx]

I’ve noticed that this doesn’t pick up height changes if I operate the desk via the factory control panel. Is that a limitation that can be overcome?

[Mahko_Mahko]

It should.
That is unexpected behaviour.
Do you mean desk height doesn’t change?

[exx]

Correct. If I press the physical button, the desk moves without issue, but the height does not update in the home assistant dashboard. Additionally, when I press the button to retrieve height, nothing happens.

[Mahko_Mahko]

Right. Could you enable uart debug and post some logs while you do both actions please.

logger:
  level: VERBOSE # Uncomment to see UART debug messages 


uart:
  - id: desk_uart
    baud_rate: 9600
    rx_pin: 1 #Labelled TX on my D1mini clone (mislabelled?)
    ##You can uncomment the debug section below to see UART messages.
    # debug:
      # direction: RX
      # dummy_receiver: true
      # after:
        # bytes: 4
      # sequence:     
        # - lambda: UARTDebug::log_int(direction, bytes, ',');

[ssieb (Samuel)]

I’m curious why you are re-implementing the component functionality. There’s a move_to method to automatically move to a specific position.

[ssieb (Samuel)]

I just made some changes to the component that should make it work better. There can be an issue with the ESP sharing the wires with the display unit, so I’ve made it possible for the ESP to be mitm instead. Note that the pin names have been changed because there’s an in and an out for the up and down pins. You also need to configure the tx pin to go to the display. Don’t use the intercept: option. It’s for a future feature to have triggers for the display buttons instead of passing them through, but it’s not implemented yet. Also, don’t invert the pins any more. The code handles that directly.

The new code is in a branch since it hasn’t been tested yet, so if anyone wants to test it, that would be appreciated. If anyone wants to discuss it or finds an issue, please find me on the esphome discord server. It’s easier there.

external_components:
  - source:
      type: git
      url: https://github.com/ssieb/esphome_components
      ref: desky
    components: [ desky ]
    refresh: 1min

You can see the updated README at
https://github.com/ssieb/esphome_components/tree/desky/components/desky

[Mahko_Mahko]

Probably my fault there.

In the early days I was tinkering with doing things outside of your component and my yaml example probably leads people down wrong paths.

@Mahko_Mahko

- platform: template
    name: Go To Desky Height x
    id: go_to_desky_preset_height_x
    on_press:
      then:
      ##Option 1: Uncomment to use Ssieb's move_to componet functions
        # - lambda: id(my_desky).move_to(id(desky_target_height).state*10);  

        
      ##Option 2: Uncomment to use Mahko's lambda alternative 
      #Check if we need to move desk up or down from current position      
        if:
          condition:
          #Current height is more than target height, then move desk down
            lambda: 

[exx]

I saw that, but there were notes in the code about wiring it differently, and I didn’t see a wiring diagram for how I was supposed to wire it, or where the tx/rx wires were supposed to go (from what pin on the RJ45 jack to what pin on the ESP32) so rather than guess and mess it up, I went the other way. I’ll take a look at the readme and see if that helps.

[exx]

Interesting. I went to enable UART debugging this morning, but decided to double-check before doing so, and the value is updating in HA now. I did reboot my HA server last night after an update, maybe it was just a display issue? Not sure, but it’s working now.

[exx]

Yeah, so I took a look at the readme, and while it is certainly concise and well-noted, it references making use of 7 pins - but unless I’ve missed something in this thread, the only wiring diagrams I’ve seen show 6 wires being used. In fact, your code shows to use 7 pins, but that doesn’t leave 2 pins available for power and ground, so now I’m doubly confused! A complete mapping of the RJ45 end would be really appreciated. I’m al electronics n00b - there’s a reason I did this without soldering.

Thanks!

[ssieb (Samuel)]

This uses the same wires, but it puts the ESP in the middle. So instead of tapping into the wire that connects the display and the controller and the ESP on one pin, now the display connects to the ESP on one pin and the controller connects to the ESP on another pin. The wire doesn’t connect from the display to the controller. @Mahko_Mahko if you understand what I’ve done, can you make an updated diagram with the changes?

[Mahko_Mahko]

@ssieb

@Mahko_Mahko if you understand what I’ve done, can you make an updated diagram with the changes?

I’ll see if I can do some doc refreshers and testing over the xmas break. Might make some doc pull requests etc.

Probably there’s a few areas to tidy up and a few feature requests to raise (such as implementing the memory presets in your component).

Testing has been complicated on my side a little by the fact that I use a more customised solution since I also built my own control panel. But I’m probably due to review it all anyway.

I’m pretty sure I still have my original “simple diy dongle” I can try to rewire and keep as a basic test device but I’ll need to put aside a little time. I’ll ping you on Discord to work through anything.

[Mahko_Mahko]

I’m just going to dump some signal sniffing in a few posts to help collate some content to work through some things with ssieb on Discord. A bit easier for larger chunks of text here.

Intial summary (and confirmation of earlier Phord findings).