CD cataloging software

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I apologize in advance if this is slightly off topic, but I wanted to pose a question for anyone who has compiled their own personal database of Top 40 hits they have on CD.... What kind of software or system do you use?  I would like to assemble a database of every 45 version, LP version, DJ edit, stereo mix, mono mix, import CD, etc. that I currently have in my 4,500+ CD collection for my own personal reference, but am not sure of the best and most efficient way to do this.  I need to purchase a new computer in the next couple of days and am wondering if I should invest some money in the Microsoft Office Professional 2007 product, which contains Access database software.  Or is their a better and less expensive way to go about accomplishing my goal?  I would appreciate any and all input as I'm looking to make my computer purchase in the next day or two.  Thanks!

Edited by Todd Ireland

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Todd Ireland Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 16 October 2004 Location: United States Status: Offline Points: 18	Post Options Post Reply Quote Todd Ireland Thanks(0) Quote Reply Topic: CD cataloging software Posted: 15 December 2008 at 2:03pm
	I apologize in advance if this is slightly off topic, but I wanted to pose a question for anyone who has compiled their own personal database of Top 40 hits they have on CD.... What kind of software or system do you use? I would like to assemble a database of every 45 version, LP version, DJ edit, stereo mix, mono mix, import CD, etc. that I currently have in my 4,500+ CD collection for my own personal reference, but am not sure of the best and most efficient way to do this. I need to purchase a new computer in the next couple of days and am wondering if I should invest some money in the Microsoft Office Professional 2007 product, which contains Access database software. Or is their a better and less expensive way to go about accomplishing my goal? I would appreciate any and all input as I'm looking to make my computer purchase in the next day or two. Thanks! Edited by Todd Ireland

crapfromthepast Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 14 September 2006 Location: United States Status: Offline Points: 16	Post Options Post Reply Quote crapfromthepast Thanks(0) Quote Reply Posted: 15 December 2008 at 4:22pm
	Todd - I just have everything in a giant Excel spreadsheet. I started the spreadsheet in 1990 (!), and 18 years later it's still my go-to reference for finding stuff in the pile of compilation CDs in my basement. It used to be just disc/track, artist, title, Hot 100 peak position/peak date/debut date, and BPM. In recent years, I added a "time" column and a "remarks" column, which has proven pretty helpful. Not pretty, I admit, but it's got over 31,000 titles and still works just fine.

C J Brown Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 27 December 2007 Status: Offline Points: 0	Post Options Post Reply Quote C J Brown Thanks(0) Quote Reply Posted: 15 December 2008 at 4:44pm
	Todd - I have used CD Trustee for the last couple years. I am very happy with the program - it does all that you mention. So far I have compiled about 2000 CD's -38,000 tracks. I am now entering all of my CDR's of promo,mono,or otherwise custom tracks. Next will be my mp3's and then my vinyl. Charlie

Hykker Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 30 October 2007 Location: United States Status: Offline Points: 2	Post Options Post Reply Quote Hykker Thanks(0) Quote Reply Posted: 15 December 2008 at 5:30pm
	I asked a similar question on another board a while back, and most of the responses were along the line of "if you find a good one let me know". I currently use an old DOS database program called Alpha 4. Does the job, but doesn't run very well under Windows XP. I tried importing it into Access, but didn't like the program very much. My brother has a Windows version of Alpha he's not using anymore that he promised to send me. One of these days I'll bug him again. All I use it for is compilation/various artist LPs, EPs, CDs & tapes (yeah, I still have some stuff on reels too). To catalog singles and regular albums is way too big of a project. The intent of the database was not so much to catalog everything I owned, but to make it possible to find stuff that was on some sort of compilation. I set it up with fields for title, artist, media, volume, year, stereo and genre (currently only used to sort Christmas or novelty tunes). If there are multiple versions it's usually noted in the title field. I do not have separate entries for every time I have a particular song...I usually go by the best-sounding one, separate entries for mono & stereo, also LP & CD, but I try not to duplicate entries in a given media. Edited by Hykker

aaronk Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 16 January 2005 Location: United States Status: Offline Points: 92	Post Options Post Reply Quote aaronk Thanks(0) Quote Reply Posted: 15 December 2008 at 6:00pm
	Todd, as you suggested in your first post, I use Microsoft Access (although I'm still running 2000). What I like about it: 1) I can easily import and export data. For example, with some quick "reformatting" of Promo Only's song listing databases, I never have to type each of those tracks in by hand. If I need to export it to MS Excel, it just takes a couple clicks. 2) I feel confident that the program is not going away anytime soon. Microsoft will likely still support Access in the coming years. 3) Anything you can do with MS Access, you can do with your song database --- customized reports, queries, etc. The biggest downside is that you have to type everything in by hand. To my knowledge, there is not an interface that can pull CD info from an online database and import it in. If anyone knows of one, please share! Also, when I set up my database, I created it as a relational database, which is the way Access is intended to be used. Rather than having just one table with all the information included, my database has two tables that are linked together. One table is all of the "album" information, and the other table is the "tracks" that are on each album. Edited by aaronk

Brian W. Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 13 October 2004 Location: United States Status: Offline Points: 3	Post Options Post Reply Quote Brian W. Thanks(0) Quote Reply Posted: 15 December 2008 at 6:19pm
	I would like something that I can just enter the bar code of the CDs and all the information will just pop up. Does anything like this exist? I started an Excel spreadsheet a couple years ago, mainly for my various artist comps, but my original goal of typing at least one CD per day seems to have fallen by the wayside. Plus, when the spreadsheet gets too large, it takes forever to load.

satchdr Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 22 February 2007 Status: Offline Points: 0	Post Options Post Reply Quote satchdr Thanks(0) Quote Reply Posted: 15 December 2008 at 9:40pm
	Todd, I've been using INMAGIC software to catalogue my collection (4,000 CDs, 2,000 LP and over 1,000 45s, etc.) I first began the process back in 1988 or 1989 when INMAGIC was a dos program and when it came out with the windows version, the data file transferred to the updated version without a hitch. The thing that I really like about INMAGIC is that you can build your own unique databases with whatever fields you want within each database. Each of the databases that you set up are very nimbly searchable so you can locate song titles, artists, etc. (basically any type of search you want to do based on the information in the database - and you can combine different search items, so if you wanted to do something weird like each song with the word "love" in the title that was on an album released in 1971, you could ask it to do so and it performs the search pretty much instantaneously.) Then it will allow you to review each record in the search separately. You can also export the databases (although I've had no need to do so.) The other thing that the later versions of INMAGIC will allow is for you to scan photos (e.g. album, 45 or CD covers or 45 or LP labels) and append them to the record. Dan

eriejwg Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 10 June 2007 Location: United States Status: Offline Points: 41	Post Options Post Reply Quote eriejwg Thanks(0) Quote Reply Posted: 16 December 2008 at 4:03am
	There's been a couple programs I've used over the years... Rather than go into detail about each, I've provided links to their downloads so you can decide yourself. 1)Audiograbber 2)Easy CD-DA Extractor 3)Tag & Rename

eriejwg Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 10 June 2007 Location: United States Status: Offline Points: 41	Post Options Post Reply Quote eriejwg Thanks(0) Quote Reply Posted: 16 December 2008 at 4:11am
	Here's another, though I have no experience with it. CaTraxx

davidclark Members Profile Send Private Message Find Members Posts Add to Buddy List Music Fan Joined: 17 November 2004 Location: Canada Status: Offline Points: 18	Post Options Post Reply Quote davidclark Thanks(0) Quote Reply Posted: 16 December 2008 at 8:29am
	Back in the late '80s, I developed a simple application in dBASE III+ to track my music. I included a "Media" file (for LPs, CDs, 45s, etc.), a "Song" file (for songs) and a "Hits" file (for info related to songs that charted), each with the usual fields to store information. In the early 90s, I converted the database to a fully relational MS Access database. I now track much more info for everything, including song version info, on what media songs appear, etc. I use it almost daily, however I do need to manually input everything, not a problem once the initial entry has been complete. For anyone starting out, it wouldn't do you much good, but it serves me very well (designed and constructed by myself). I have personally entered the info, so I know it to be correct (e.g., on what CD is what version of a song, similar to Pat's database), going further to even document the differences in the various song versions. I do know there are programs out there that will scan CDs and populate a database with CD and song info - none by name however.
	dc1