MQTT into Home Assistant

glider51glider51
in Local MQTT

For me this is the holy grail, I have my LIVE SMETS-2 meter data (electricity usage and solar export) in Home Assistant. (I'm so excited! Big High Five and THANKYOU to all at Glow / Hildebrand who made this possible)

My Home Assistant knowledge in near minimal so I invite any HA experts to jump in and correct me, but for those at my level or below, this is how I got there:

A Glow IHD running v1.8.12 software (I believe you need V1.8.12 for MQTT support?)

Home Assistant 2022.6 (2022.6 this months release and has new support for MQTT)

The Mosquito MQTT Broker running on my Home Assistant hardware (its a standard add on see: settings/ add-ons)

MQTT is configured on the Glow IHD (very easy)

Optional: I have added the Visual Studio Code Server to HA (settings/ add-ons) or you use the File Editor add-on to edit the configuration.yaml file


You then need to "sense" the MQTT data in Home Assistant

The basic configuration is to edit configuration.yaml and add a section for mqtt (See below) and then you pickup/ use the sensor values as you want in the Home Assistant GUI

[The interface for this forum is basic so the indent spacing in the following may be mangled]

The following demonstrates picking up the Glow data from MQTT

mqtt:

sensor:

  - name: "Metered Current Consumption"

    state_topic: "glow/441793504B6D/SENSOR/electricitymeter" #Need SECRET

    unit_of_measurement: "kW"

    value_template: "{{ value_json.electricitymeter.power.value | round(1) }}"

    device_class: energy

    state_class: total_increasing

  - name: "Metered Export Reading"

    state_topic: "glow/441793504B6D/SENSOR/electricitymeter" #Need SECRET

    unit_of_measurement: "kWh"

    value_template: "{{ value_json.electricitymeter.energy.export.cumulative | round(1) }}"

    device_class: energy

    state_class: total_increasing

  - name: "Metered Import Reading"

    state_topic: "glow/441793504B6D/SENSOR/electricitymeter" #Need SECRET

    unit_of_measurement: "kWh"

    value_template: "{{ value_json.electricitymeter.energy.import.cumulative | round(1) }}"

    device_class: energy

    state_class: total_increasing

  - name: "Metered Unit Price"

    state_topic: "glow/441793504B6D/SENSOR/electricitymeter" #Need SECRET

    unit_of_measurement: "GBP"

    value_template: "{{ value_json.electricitymeter.energy.import.price.unitrate | round(3) }}"

  # Glow Device State Info

  - name: "Glow Han Status"

    state_topic: "glow/441793504B6D/STATE"

    value_template: "{{ value_json.han.status }}"

  - name: "Glow Han RSSI"

    state_topic: "glow/441793504B6D/STATE"

    value_template: "{{ value_json.han.rssi }}"

    unit_of_measurement: "dBm"

  - name: "Glow Software Version"

    state_topic: "glow/441793504B6D/STATE"

    value_template: "{{ value_json.software }}


Tips:

You can check the syntax of your yaml is correct from: developer tools / yaml / configuration validation

You can quickly (re)load the MQTT sensor(s) from developer tools / yaml / YAML config reloading / Manually configured MQTT entities

More/ Advanced:

If you are worried about sharing your config files and the ID of your glow device you can uses secrets.yaml and some thing like:

state_topic: !secret glow_MQTT_topic_electricitymeter

where glow_MQTT_topic_electricitymeter

is

glow_MQTT_topic_electricitymeter: "glow/441793504B6D/SENSOR/electricitymeter"

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsSAAALEgHS3X78AAAB3ElEQVQ4jY2TPWhTURTH/+e8l7QNJg0qCJpCSdEnONTFDk5udfILs9mS6iJYpI4VnURXUcRJrFG3gm3tXLpIxaUUIVA/iLRJayQ2Nk1q7cu99zjUF/JhQv7jOff/O+fcwyERAQAQEaoVjsdOirgP93L+W5svJpeq8xVfPWD/yPkepekBWbjETl8nM0h9XtkRV72xLbmdn5hJ/xdw4OaVkC6U7oBwg6MRH0d7fGTbQDoLIYKUXa2/rO5C6SdWOHh/4/HrLQCwvZZUoZi2Dh/ysdPbRZ0dNeOQCMj2WXTiaMCUtsdUKn0dQHcNAEZCVr+DViJjYAW6/NqI34txS0eVIqEwRgfONMTbApyORDE3PIbF9dX2AKPHTyESCFbMExeGMTL9EguZVHuAxY3vmBscwtkjfS3NTQELuQzi72bwaGAQ8elEUzNQtQUiLsmf3X3eCt/n1uBMPQUy2bqSDCIuNXQgjHnJ5kzTUt47rUQY8w0AG2ZcLX/bkc2t5m5mlJdTv22Y8QZAPjGbBPHl8oePRb2yruu9BjBu8msRGrF8YjZZGb3+mA5ePee4ip9xoKOfj/UGSRuYtR/b+ldxyW/paz+fv/0EtLhGT91DF2NgubtXnu4VXk1N1vzFP99f037PUFbu4yIAAAAASUVORK5CYII= There was an error displaying this embed.

HA Experts: Anything I can do better, please?

Share on Twitter

Comments

  • glider51glider51

    Sorry I forgot to add something about the MQTT topic.

    in the line:

    state_topic: "glow/441793504B6D/SENSOR/electricitymeter"

    I believe 441793504B6D is the id for the Glow device. You will need an MQTT client or similar to get the exact topic name your device is using.

    Share on Twitter
  • borpinborpin

    @glider51

    [The interface for this forum is basic so the indent spacing in the following may be mangled]

    you can use the 3 backticks to insert code.

    value_template: "{{ value_json.electricitymeter.power.value | round(1) }}"

    Why do you round this? It will either round up or down as it stands. If you want just the integer part use int(0) (although a default of zero may cause problems with the accumulator).

    Share on Twitter
  • glider51glider51 
    ```value_template: "{{ value_json.electricitymeter.power.value | round(1) }}"

    >>Why do you round this?

    Because for my own preference I I don't want the number to 3DP or for the kWh daily/monthly/ all time usage I only want 1DP.

    Share on Twitter
  • glider51glider51

    So I have been working with HA a lot more recently and I went back to clean up / check my MQTT coding. There were in fact one or two bits missing and I tided it up if anyone want to to reuse it:

    The secret is in the form:

    glow_MQTT_topic_electricitymeter: "glow/44xxxxxxxxxx/SENSOR/electricitymeter"

    Replace xxxxxxxxxx with your own device ID (if you are not going to be sharing you code with anyone you can code it directly into state_topic below

    I pickup the mqtt definitions from configuration.yaml as:

    mqtt: !include mqttsensors.yaml

    [I continue in the next post as this forum would not not let me post the whole thing in one go]

    Share on Twitter
  • glider51glider51

    So mqttsensors.yaml is:

    #mqtt: is the context from the configuration.yaml file
sensor:
  #glow/<UID>/SENSOR/electricitymeter
  #power
  - name: "Metered Current Consumption"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    unit_of_measurement: "W"
    device_class: power
    state_class: measurement
    icon: mdi:meter-electric-outline
    value_template: "{{ value_json.electricitymeter.power.value | float * 1000 |int }}"

    #export
  - name: "Metered Export Reading"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    unit_of_measurement: "kWh"
    device_class: energy
    state_class: total_increasing
    icon: mdi:home-export-outline
    value_template: "{{ value_json.electricitymeter.energy.export.cumulative | float |round(1) }}"

    #import
  - name: "Metered Import Reading"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    unit_of_measurement: "kWh"
    device_class: energy
    state_class: total_increasing
    icon: mdi:home-import-outline
    value_template: "{{ value_json.electricitymeter.energy.import.cumulative | float | round(1) }}"

  - name: "Metered Import Today"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    unit_of_measurement: "kWh"
    device_class: energy
    state_class: measurement
    icon: mdi:home-import-outline
    value_template: "{{ value_json.electricitymeter.energy.import.day | round(1) }}"

  - name: "Metered Import This Week"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    unit_of_measurement: "kWh"
    device_class: energy
    state_class: measurement
    icon: mdi:home-import-outline
    value_template: "{{ value_json.electricitymeter.energy.import.week | round(1) }}"

  - name: "Metered Import This Month"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    device_class: energy
    state_class: measurement
    unit_of_measurement: "kWh"
    icon: mdi:home-import-outline
    value_template: "{{ value_json.electricitymeter.energy.import.month | round(1) }}"
    Share on Twitter
  • glider51glider51 
      - name: "Metered Unit Price"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    unit_of_measurement: "pence" #Default is GBP, see below
    device_class: "monetary"
    icon: mdi:home-import-outline
    value_template: "{{ value_json.electricitymeter.energy.import.price.unitrate | float *100 | round(1) }}"
    #unit_of_measurement: "GBP"
    #value_template: "{{ value_json.electricitymeter.energy.import.price.unitrate }}"

  - name: "Metered Standing Charge"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    unit_of_measurement: "pence" #Default is GBP, see below
    device_class: "monetary"
    icon: mdi:currency-gbp
    value_template: "{{ value_json.electricitymeter.energy.import.price.standingcharge | float *100 | round(1) }}"
    #unit_of_measurement: "GBP"
    #value_template: "{{ value_json.electricitymeter.energy.import.price.standingcharge }}"

    #Timestamp
  - name: "Metered Timestamp"
    state_topic: !secret glow_MQTT_topic_electricitymeter
    device_class: "timestamp"
    icon: mdi:clock-outline
    value_template: "{{ value_json.electricitymeter.timestamp }}"

  # Glow Device State Info
  - name: "Glow Han Status"
    state_topic: "glow/441793504B6C/STATE"
    icon: mdi:set-center
    value_template: "{{ value_json.han.status }}"

  - name: "Glow Han RSSI"
    state_topic: "glow/441793504B6C/STATE"
    device_class: signal_strength
    unit_of_measurement: "dBm"
    icon: mdi:signal
    value_template: "{{ value_json.han.rssi }}"

  - name: "Glow Software Version"
    state_topic: "glow/441793504B6C/STATE"
    icon: mdi:information-variant
    value_template: "{{ value_json.software }}"


    Share on Twitter
Sign In or Register to comment.