InfluKNX

A KNX to InfluxDB metrics logger written in NodeJS.

Listens for configured KNX group addresses and sends the metrics to InfluxDB.
Decodes RAW values seen on the KNX bus to usable values using datapoint definitions with https://bitbucket.org/ekarak/knx.js
Use with NodeJS 8

Installation

npm install

Getting full stack up and running in docker

Get full stack with InfluxDB and Grafana up and running

clone to some local directory
adapt docker-compose.yml to your needs
make sure config.yml is okay
sudo docker-compose up
chown the influxdb volume to uid 65001 (this should be done automatically somehow, not sure how yet)
create database influknx in InfluxDB, for simple setup, no GRANT needed (as service is contained in docker network and isn't exposed, this should be fine)
verify by watching the logs sudo docker-compose logs -f --tail=1
login to grafana http://<ip>:3000 and create the InfluxDB datasource, name it influknxto make sample dashboard work
A sample dashboard can be importer from grafana-examples/sample-dashboard.json

app.js

The actual application that listens to configured datapoints on the bus, decodes values and sends them to InfluxDB.

Values are logged on change only (change compared to last value, done by ekarak/knx)
configured via config.yml

config.yml example

See https://bitbucket.org/ekarak/knx.js/src/master/README-datapoints.md for supported data types. The datatype must match the data type of the group address in KNX ETS.

---
knx:
  gateway_ip: 10.10.0.105 # IP of your KNX gateway
  gateway_port: 3671
influxdb:
  host: influxdb
  # username: influknx
  # password: influknx
  database: influknx

datapoints:
  '7/0/0':                        # KNX group address
    description: 'House (Power)'  # used to generate the influxdb tag, should be unique
    type: 'DPT14'                 # important to select carefully, otherwise you'll get garbage values only!
    measurement: power            # name of the measurement in influxdb, group similar things together
  '7/0/1':
    description: 'Somethingelse2 (Power)'
    type: 'DPT14'
    measurement: power
    name: Somethingelse_Power     # overwrite the tag generated from `description` if you change description
  '7/0/21':
    description: 'Haus (Wirkenergie, T2)'
    type: 'DPT12'
    measurement: energy

dp-testing.js

Test script to make sure you selected the correct DPT (data point type) before actually sending anything to InfluxDB any might messing up your data.

uses the same config.yml config file

csv-importer.js

A simple csv to InfluxDB importer. Can work with 2 column CSV without headers, in the format of <unixtimestamp>,<value> to import existing historical data

Example

node csv-importer.js Haus_Wirkleistung power 38779.hour.csv
# node csv-importer.js <tag> <measurement> <csv file path>

Special Credit

https://bitbucket.org/ekarak/knx.js which is "KNX made easy" imho

marcofl / influknx

readme