2. analog
  3. 1163533190

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

Showing 1 response by rgordonpf

rgordonpf
82 posts
 
I have 8,000 LPs of which 75% are classical. I am currently using Visual FoxPro, though when I get the time I will switch over to FileMaker. You could use any spreadsheet or other flat file data base. However, you will have a lot of redundancy, paarticularly if you have a lot of classical albums. Since the files are small, performance will not suffer. However, you will need a lot of extra key strokes to enter the same amount of data versus a relational data base. For many of the fields in my data bases I have choices set up (mono/stereo) (33 1/3/45) (classical/movie/show/rock/pop) so that just one click is required to enter the data. If you are familiar with a relational data base such as MS Access and you have a more than 1,000 albums I would think you could save yourself a lot of data entry time by using the relational data base.

Fields In Manufacturer File:
Record Label
Secondary label (Shaded Dog/White Dog/Dead Dog, etc.)
Stamper Number
Manufacturer's Number
Genre (movie/classical/rock, etc.)
Price
Artist
Title
Key (for linking data bases)
Condition
Speed
Number of disks

Fields in Album File
Stereo or Mono
Composer
Title
Conductor
Orchestra
Year
Filed under
Category (solo violin, violin concerto, guitar, wind, etc.
Performer
Key
More to discover