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
I looked for something like this last year. I finally gave up and just set up a Excell spreadsheet. I pretty much logged the categories you've mentioned.

PLEASE, learn from my mistake. What ever you use, back it up!

A harddrive crash wiped out everything. I had also kept a category for what I spent on each lp and now that information is long gone. Not that it would have been that useful, but it was good to refer to from time to time.
I don't know your knowledge about software developing. But I made my record database with PHP and MySql. In this way I can access it from every OS with any browser. The following are the fields I am using :

id
Artist_Conductor
Composer
Album_Title
Record_Label
Product_No
Year_Recorded
Year_Produced
Genre
Format
Price
Recv_Grade
Grade
No_of_Discs
Bought
Web
Image
Tech_Rating
Music_Rating
Created
Modified
Comment

Rudy
I too have been cataloging my vinyl, but it never even occured to me look for specific software. Thats what spreadsheets are for and I use Excel. The nice thing about Excel is you can lay it out any way you like, with as much or as little space as your specific catagory requires, and you can play around with fonts, font size and color, bold, underlined, etc. Another nice thing about Excel is you can use as many 'sheets' as you like to organize different catagories of music. Excel 2003, which I use, defaults to three sheets, but you can set it up to as many as you like. If you've not used Excel it is easy enough to figure out the basic functions even though it has levels of complexity most of us will never need or even know about. For example I have used it for making frequency graphs for plotting the in room frequency response of my Talon Khorus loudspeakers. While cataloging your LP's can turn into a huge task (I have well over 1000 LP's) it is actually kind of fun once you get started. It's also a great opportunity to go through albums you may have forgotten about. If you have Microsoft Excel on your computer I can send you a copy of my inventory which you can use as a template if that would help get you started. Just send me a private email.
I'm wondering if Excel is the way to go, relative to Access. How well does Excel allow you to do filtering and create custom lists (or reports). I'm an Excel lover - I've gotten it to do lots of things - but I haven't explored that aspect of its functionality. I would think Access would be better - you could even create a data input form for each record, and other forms to upgrade condition, etc. Comments?