Inventory of vinyl - what software do you use?


I am finally going to inventory my records this winter, or so I hope. I am wondering what software applications other Audiogoners use for this task. A specialized vinyl inventory program? MS Access or other database program? Also, what categories do you find most useful to keep a record of, besides Artist and Album name, condition of vinyl, record label, etc.?

I am not looking forward to this task but it is necessary, I think. I have been putting it on the back burner for way too long, out of pure laziness. I would like user-friendly software, with the ability to sort by field.

Please tell me what you use!

Holly
oakiris
"Using a spreadsheet you construct from scratch is a horrible idea. Why would you want to type all of that in when it has already been done?"

Has it been done? I bet not. If so I sure would like to know where I can find it. I believe the topic was vinyl inventory, not CD. The programs mentioned here seem to be useful for a CD database, but limited or nonexistant for LP's. And of the databases that do exist for vinyl do they differentiate all of the different labels and pressings of a specific title? Even if it did, by the time you search through several data bases to find your specific pressing and then fill in the fields you probably would have spent much more time than it would have taken to type in the information yourself. No matter what you do inventories require work and spreedsheets are a useful tool.

I guess it depends on what you are trying to accomplish with your inventory. The reason I like a spreedsheet is because it gives me the ability to arrange my collection alphabetically and it's all on a single page I can easily scroll through and print out if need be. Having a separate screen shot for each title is just not useful to me and requires too much work to look through.
Fully agree with 4 yanx. I use CDTrustee for all CD's and records as well. It not only fills in a relational database, but alows searches on many attributes, produces reports, CD covers etc. The functionality is way beyond what you can do in Excel. It is a 10 year product with strong support and continual improvement.
I created my database in MS Access. It was easy to set up and I've added several fields over the years.

I also purchased a data program for my Palm Pilot that could import from MS Access and keep an updated copy of my record data base with me at all times. It comes in handy when I'm browsing record stores.
Herman - are you still using the Kix Music Master program you wrote about in that thread you linked? Has it gotten any easier to use? I just went to their site where it was stated that they had basically lost the ability to search for vinyl because the database they had linked to was taken over by another company which eliminated the web search function.

Though at some point I would like to inventory my CDs as well, my vinyl inventory takes precedence at this point - I have more vinyl than I have CDs, and I probably haven't even looked at some of it for quite a few years. :-o I will, however, check into CDTrustee, as recommended by 4yanx & Zargon.

I might as well make this another winter project, cataloguing all of my audio software!

Holly
I guess it depends on what you are trying to accomplish with your inventory.

Point taken. My main focus was artist, title, media to keep from buying duplicates, which is very differnt from cataloging multiple pressings of the same thing.

As for Kix and freedb I was unaware of that situation. When I tried it it found the vast majority of my albums with some minor editing. I could search an artist and just pick the titles from a list that was returned.

Looks like a different story now.