Vivino : a cellar wine management in HA

Share your Projects!
1

Hi,

It’s not a real project for the moment but a nice idea I think…
Due to GDPR, we can get through the website a CSV with a list of bottle already drunk or whose who are in the cave.

I will probably transform the CSV into a json file and find a way to add each object into HA.
Thanks of that, it can be possible to use Alexa or google home or snips to do some requests as : “which wine i can drink with beef ?”

The major issues are :

  • how to simply add many objects of a json file in HA ?
  • how to display a list of many same objects in HA without describing them exactly in groups.yaml ?
2 Likes
2

i think its a better way to use automations or appdaemon to inspect the csv or the json and then do the things you like with it.

HA isnt really something you want to use as a database (a list of wines is just a db table)
but it is something to use to inspect a db.

if you still want that, you could use appdaemon to inspect your csv and let it create a sensor for every wine you have in the list.
you could add attributes for stuff like which wine goes with what kind of food
and you could set the sensor to values like: available, 12 left, all gone, etc.

you also can create and manipulate groups from appdaemon, so that would be solved too.

but it needs a little python programming. doing it in yaml would be difficult and time consuming.

3

Hello Doune, how is your project? I am also interested by adding my wine cellar on HA.

4

Also looking for this. Would be a great addition

5

Same here!

6

hi,

Vivino changed its way to give you access to your data. I’m not able anymore to do what I’ve set up in the past. :frowning:

7

It’s not Vivino, but I thought I would share how I am getting around not having this data in HA in case anyone else is interested: Wine fridge tracking dashboard

At least this way our data won’t be gate kept in the Vivino walled garden.

8

I have a wine tracking local website that I have integrated into home assistant if this better fits your requirements.

See here:

I have not put in reminders but that would be a good addition as well as a few queries to get more information out.

Hope this helps someone if this solution does not meet your needs.

9

Thanks for sharing - I did see that.

I was already using grocy for managing our chores and tracking other consumables (vitamins, razors, toothpaste etc), so it was the path of least resistance for me.