Home Assistant Cellar Tracker custom integration

The cellar tracker implementation allows you to integrate your Cellar Tracker data in Home Assistant.

Disclaimer

This is an unofficial integration of Cellar Tracker for Home Assistant, the developer and the contributors are not, in any way, affiliated to CellarTracker! LLC.

"CellarTracker!" is a trademark of CellarTracker! LLC

Requirements

• Cellar Tracker account - https://cellartracker.com
• HACS: Home Assistant Community Store - https://hacs.xyz/
• Flex Table Card - Available in HACS or https://github.com/custom-cards/flex-table-card/
• (Optional) secrets.yaml - https://www.home-assistant.io/docs/configuration/secrets/

Installation

The integration should be available in HACS under Custom Integration, if that is not the case, just add manually the repository:

• Repository: https://github.com/ahoernecke/ha_cellar_tracker
• Category: Integration

Configuration:

Add your CellarTracker! username and password in secrets.yaml:

cellar_tracker_username: YOUR_USERNAME
cellar_tracker_password: YOUR_PASSWORD

Then go to configuration.yaml and add:

cellar_tracker:
  username:  !secret cellar_tracker_username
  password:  !secret cellar_tracker_password

Dashboard visualization

To create a new dashboard for CellarTracker! go to Configuration -> Dashboards -> Add a new dashboard (the following is just a suggestion)

To populate your Dashboard:

Glance Card Visualization

type: glance
entities:
  - entity: sensor.cellar_tracker_total_bottles
  - entity: sensor.cellar_tracker_total_value

Bottles by Country

type: custom:flex-table-card
title: Bottles by Country
entities:
  include: sensor.cellar_tracker_country*
columns:
  - name: Country
    data: sub_type
  - name: Count
    data: count
  - name: Percentage
    data: '%'
    modify: parseFloat(x).toFixed(0)
    suffix: '%'
  - name: Average Value
    data: value_avg
    prefix: €  #change here according to your currency
    modify: parseFloat(x).toFixed(0)
sort_by: count-

Bottles by Producer

type: custom:flex-table-card
title: Bottles by Producer
entities:
  include: sensor.cellar_tracker_producer*
columns:
  - name: Producer
    data: sub_type
  - name: Count
    data: count
    modify: parseFloat(x)
  - name: Percentage
    data: '%'
    modify: parseFloat(x).toFixed(0)
    suffix: '%'
  - name: Average Value
    data: value_avg
    prefix: €  #change here according to your currency
    modify: parseFloat(x).toFixed(0)
sort_by: count-

Bottles by Vintage

type: custom:flex-table-card
title: Bottles by Vintage
entities:
  include: sensor.cellar_tracker_vintage*
columns:
  - name: Vintage
    data: sub_type
  - name: Count
    data: count
  - name: Percentage
    data: '%'
    modify: parseFloat(x).toFixed(0)
    suffix: '%'
  - name: Average Value
    data: value_avg
    prefix: €  #change here according to your currency
    modify: parseFloat(x).toFixed(0)
sort_by: count-

Bottles by Varietal

type: custom:flex-table-card
title: Bottles by Varietal
entities:
  include: sensor.cellar_tracker_varietal*
columns:
  - name: Varietal
    data: sub_type
  - name: Count
    data: count
  - name: Percentage
    data: '%'
    modify: parseFloat(x).toFixed(0)
    suffix: '%'
  - name: Average Value
    data: value_avg
    prefix: €  #change here according to your currency
    modify: parseFloat(x).toFixed(0)
sort_by: count-

Contribute

Feel free to contribute by opening a PR, issue on this project