Cataloging a collection

[scimitar]

I have been trying to catalog which whisky's I have as my collection is now pushing the 300 point.
I was wondering if anyone knows of any software that actually works for our sort of use. The wine type software available just doesn't fit right for this. Would really love it if could store a photo along with the information about each bottle.

If anyone has any advice / links would help a great deal.

Regards
Scimitar

[irishwhiskeychaser]

xcel is jsut as good as anything but you probably have needed to use that from the start .... ah well

[corbuso]

I have been trying to catalog which whisky's I have as my collection is now pushing the 300 point.
I was wondering if anyone knows of any software that actually works for our sort of use. The wine type software available just doesn't fit right for this. Would really love it if could store a photo along with the information about each bottle.

If anyone has any advice / links would help a great deal.

Regards
Scimitar

File Maker Pro is working very well for that, and you could do the same with Microsoft access.
Otherwise, to same extend, Iview media could be used for this kind of work, if the photographic aspect is heavy and important for you.
Regards
Corbuso
...........
http://www.whisky-news.com

[vitara7]

i have a collection of 550+ bottles and the way i do it it through excel in a simple speadsheet form.

i also have a picture of each bottle that i hyperlink into excell so click the bottle name, and you see the picture.

[jcasazza]

is it possible to post the file so others can download it?

I am not very good at makeing excel spreadsheets

[corbuso]

i have a collection of 550+ bottles and the way i do it it through excel in a simple speadsheet form.

i also have a picture of each bottle that i hyperlink into excell so click the bottle name, and you see the picture.

Good idea, but the problem with excel, is that is you move the file or the folder, the link is broken and you can not export or share it with someone else (or only the text)...

[vitara7]

ive never tried to export it or that, but i did move all the pictures one time into another drive, and it found them all right away themselfs without me having to rename file paths or that, which was a relief.

[mikeymad]

Ganga and I use an excel spreadsheet that we have built up over the years. It has everything. I tried to imbed images, but it made the file way too big, but I never thought of having an link to the image. That is a good idea that I will have to explore.

Ours looks like this: sorry for the big picture.



You will see all the standard fields and then a bunch of tabs for the different states of the bottles. The listing is just a summary line that we use for posting or sharing the list.

Cheers,

[scimitar]

Thanks to all for the ideas.
Looks like its the excel route for me as it should be easy to create and maintain, that and I dont want to learn Access.

Regards
Scimitar

[vitara7]

good luck, it takes a wee bit of time to create and then takes picture of every bottle you have, but its worth it in the end

[Deactivated Member]

Almost like a malt fanatic's 'dirty magazine'. Some great ideas.

[Jan]

Very well organized, Mikey - like it a lot.

Hmmm... think I will expand my simple list into something similar.

Do the listing section get filled out automatically ?

[mikeymad]

Do the listing section get filled out automatically ?

Thanks....

Yes, the listing section (the format is based on the Malt Maniacs matrix) is auto generated based on the other fields. There are some other tricks here and there, that just took some time. I would like to automate some other things as well.

I also setup a pivot table in a testing tab that gives me some counts for the sealed stock and the rated distilleries. It helps out when looking at new purchases.




Cheers,