Thread Frozen
premium
|
 
hen travelling abroad (especially Belgium, from which I have lots of beers sampled already), I usually make myself a list of all the beers brewed in that country. I know there are Travel Lists, but there you can only see 100 beers at a time, and I simply want to list them all.
Now the biggest problem is, that in order to get a full list of beers from a country (if it has more than 100 of them), is to go through the brewery pages one by one, and copy-paste the data into Excel or similar. Because of the images etc. included in the lists, one also needs to go through the slower "Paste special..." method to get to the raw data.
I just finished one such list, and documented the tedious process in detail here (sorry, it’s a long story):
http://www.iki.fi/say/beerlist/
What I would like to have instead, is the option to list all breweries and beers with the relevant data from a certain country at once, and import it into Excel. It could be a very simple list, like CSV, with no web links or images - just the data that makes sense when printed on paper. I suppose this would also save server load and bandwidth, compared to opening possibly hundreds of brewery pages one by one, or writing a script to do the same.
Of course, there should be some restrictions, like listing USA, England, and Germany by state/province/etc. only, to avoid listing tens of thousands of beers.
And IF the export feature could in some automated and intelligent way resolve the aliases, that would be a big plus...
Cheers,
Seppo
|
Private message 
|
Would love a function like this, have been doing the same and it takes ages, while one query could solve it al...
Ahh come on... please! 
|
Private message
|
Good idea! I hadn’t thought about this before, but when visiting a little-explored country a list of all the beers is really, really useful.
140 lines of Python later I have a list of all Lithuanian beers. 
|
Private message
|
|
very cool, a generator for something like this would rule!
|
Private message
|
Sounds like a good way to data mine this site...
As nifty as such a list could turn out to be (especially in Belgium, IMHO), a lot of the time the gems to be found in a country will actually be from other countries (i.e. Belgian beers and Franken beers in Stockholm where I live, American beers in Denmark etc).
Cheers,
Danko
|
Private message
|
|
