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:
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?
Thanks, I’ve come a bit further regarding “static” values that I know only have X amount of values; for example Total number of bottles is always one number.
But e.g. I would also want to show bottles per different countries in a pie chart or bar graph.
In this case I don’t know how many countries I have represented but I know that each line would consist of Country, Number of bottles, % of bottles of all.
I created a cellartracker Python package https://github.com/mathroule/cellartracker. Now I need to finish the integration of the package in Home Assistant, then open a pull request to add the new integration.
@andreasy I’m a mad wine guy and this post has made me super happy. Do you mind sharing your code with me? I would love to set this up in my HA. Thanks
Coming from Homeseer to Home Assistant, It’s nuts how many integrations there are in HA. This is one I just looked up for the fun of it. Would love to get this running too.
UPDATE: Just installed AppDaemon, going to see if I can use Mathieu’s cool python package to build something.
Stumbled upon this last night and I am absolutely blown away by how awesome and neat this looks. My knowledge of python is really limited though I’d love to get something like this up and running on my Home Assistant. Would love to see some code or a write-up to help other wine lovers like me
Yeah, one of my goals would be not only to summarize my collection but also recommend ready to drink wines by varietal. Would be fantastic when I open up the cellar to get an automatic recommendation.
Just keeping this one going. Another HA and CT user here. I have HA monitoring my wine cellar (ESPHome custom sensors) and would love to have even just the “restaurant” wine list on one all-inclusive Cellar page.
I’m not great with python, but am willing to help test functionality if needed.
A graphical cellar would be nice as well, but I won’t be greedy:)
