danielbayerlein/sepicker

📊 Monitoring for the STIEBEL ELTRON Heat Pump

sepicker

📊 Monitoring for the STIEBEL ELTRON Heat Pump

Table of Contents

• Requirements
• Installation
  • Cron Job
  • Database
  • Grafana (optional)
• Config
  • CAN bus
    • Example
    • Description
  • Data
    • Example
    • Description
  • Database
• Resources
• License

Requirements

• Python 3.11
• MySQL
• Grafana (optional)
• Raspberry Pi + CANable (or similar devices)

Installation

• Download the latest release

  wget https://github.com/danielbayerlein/sepicker/releases/latest/download/package.zip

• Unzip the package

  unzip package.zip

• Install the dependencies

  pip3 install -r requirements.txt

Cron Job

To collect the data every x minutes, it's necessary to create a cron job. This is an example to query the data every two minutes:

*/2 * * * * /home/pi/sepicker/bin/sepicker

Database

Execute the seed file via MySQL command line or copy the query into your MySQL shell.

Grafana (optional)

With Grafana you can create your own dashboard with widgets or use the existing template.

Config

The configuration for the CAN bus and for the data to be queried is located in config.yml. The database configuration is located in .env.

CAN bus

File: config.yml

Example

can:
  interface: can0
  sender: 680

Description

• interface: CAN bus interface
  • can0
• sender: Sender ID
  • 680

Data

File: config.yml

See http://juerg5524.ch/data/ElsterTable.inc for the indexes.

Example

data:
  - name: AUSSENTEMPERATUR
    index: 180.000c
    format: dec_val
  - name: QUELLENTEMPERATUR
    index: 180.01d4
    format: dec_val
  - name: FEHLER
    index: 180.0001

Description

• name: Name for the data point
  • AUSSENTEMPERATUR
• index: Receiver and Register separated by a dot
  • 180.000c
• format (optional):
  • dec_val
  • mil_val
  • little_endian

Database

File: .env

Rename the .env.example file to .env or create it with the following content:

DB_DATABASE=heat-pump
DB_HOST=127.0.0.1
DB_USER=root
DB_PASSWORD=

Resources

• http://juerg5524.ch/list_data.php
• https://github.com/andig/goelster
• https://github.com/Andy2003/heat-pump-api

License

Copyright (c) 2020-present Daniel Bayerlein. See LICENSE for details.