Pretty new to Hassio after making the change from Domoticz so don’t know my way around yet… I am currently looking for a solution getting my wine cellar data from cellartracker.com into Hassio.
What I want to track is:
- Bottles in my cellar (total amount)
- Bottles divided per country (% per country)
- Total value (sum of price)
- Consumed per month (amount + list of wines)
- Added per month (amount + list of wines)
Cellartracker offers a csv export (read more here) that I’am planning to use. The CSV file contains the following fields:
CellarTrackerId (not unique); Location; Bin, Size; Price; Purchase Date; Vintage; Wine; Country; Region; Type; BeginConsume; EndConsume
My idea is to create a php script that downloads the CSV once an hour and then updates Hassio.
The first part is really simple but I don’t really know how to get the data in Hassio the best way. I was thinking about MQTT but doesn’t really know how to set up the sensor (?) to be able to display the way I want.
Or can Hassio (or any plugin) read the CSV data directly?
Anyone that can point me in the right direction?