Jump to content

Cataloging your music, databases etc.


DaHun72
 Share

Recommended Posts

I've been putting off cataloging my CD collection for a couple of years but after doing a bit of a clean out I noticed I have heaps of duplicate CDs! So the time is right. I used to put everything into an excel spreadsheet so it would house all the info I wanted eg.

Artist

Title

Year

Label

Label ID

# of CDs

Notes eg. OBI, Bonus Tracks, Digipak etc.

 

Was wondering how everyone else catalogs their collection. There is so much software and apps these days that something good must be available. For instance I tried Libib but after I put in the ISBN I got the correct Artist, Title and Year but that's it. It said foreign label.

 

Would be cool to have something that grabs the artwork, allows for the main info to be put in but also allows notes or tags etc. for additional info.

Link to comment
Share on other sites

Label ID?? What's that? I don't even have label but sometimes which I did.

 

At the moment I just use:

 

Artist

Title

Year

But one day I'd like to add stuff like label, style, male/female vocals etc. But I doubt I ever will...

Link to comment
Share on other sites

Artist, Title and Year would be the minimum requirements.

 

I certainly wouldn't care about things like Record Label or Label ID / Catalogue No.

 

But I do make note of the Music Style and Rating, as those benefit me when looking through a long list of my collection. Depending on what I wanted to listen to, I can quite easily scan through a list of Hard Rock or Melodic Rock or Power Metal (etc.) to see what I've got, rather than browsing my CD shelves where everything is ordered alphabetically by Artist and then Year.

What about keeping a record of something more personal to you, such as Date Purchased? I knew someone who did that as he liked to occasionally see how his tastes in music changed over time.

A spreadsheet is good enough for a list like this, unless you are going to end up cataloguing track listings, for example, where you would need a database for that kind of one-to-many relationship. I expect most of the "office" software packages (e.g. MS Office for Windows) provide spreadsheet and database software if you wanted to make your own, and these days there's plenty tutorials available online to learn how to make a database, which would be the next step up if you've already learnt how to make spreadsheets. Otherwise you're going to be looking at spending money on commercial software, or using internet websites and relying on your chosen one always being available by whoever operates the site.

Link to comment
Share on other sites

Artist, Title and Year would be the minimum requirements.

 

I certainly wouldn't care about things like Record Label or Label ID / Catalogue No.

 

But I do make note of the Music Style and Rating, as those benefit me when looking through a long list of my collection. Depending on what I wanted to listen to, I can quite easily scan through a list of Hard Rock or Melodic Rock or Power Metal (etc.) to see what I've got, rather than browsing my CD shelves where everything is ordered alphabetically by Artist and then Year.

What about keeping a record of something more personal to you, such as Date Purchased? I knew someone who did that as he liked to occasionally see how his tastes in music changed over time.

A spreadsheet is good enough for a list like this, unless you are going to end up cataloguing track listings, for example, where you would need a database for that kind of one-to-many relationship. I expect most of the "office" software packages (e.g. MS Office for Windows) provide spreadsheet and database software if you wanted to make your own, and these days there's plenty tutorials available online to learn how to make a database, which would be the next step up if you've already learnt how to make spreadsheets. Otherwise you're going to be looking at spending money on commercial software, or using internet websites and relying on your chosen one always being available by whoever operates the site.

 

 

I made a database on access with scans and other details-even gossips and other paraphernalia-but only for 800 titles. Tremendous amount of time back then. Now, I'm speculating, it's easy to copy/paste from online sources stuff to your database and then upload it.Personally, I don't have the same passion to do this. I'm happy with my excel (Artist Name-Title-Format- Year).

Link to comment
Share on other sites

I used to keep list of my CDs in a Word document on my PC that I updated as needed, but when my computer crashed and took the list with it I didn't wanna be bothered starting it all over from scratch... lesson learned.

 

Now I use RateYourMusic:

 

https://rateyourmusic.com/~FatFreddysCat

Link to comment
Share on other sites

I did check out collectorz a while back, seemed OK but expensive.

I'd prefer an app over a spreadsheet etc. Something that I can update on my phone, tablet or PC etc. and view anytime knowing it's up to date when a buying opportunity presents itself.

I keep the label info as I've spent a lot of time tracking down the best release of my favorite albums over the last decade to get bonus tracks etc.

Link to comment
Share on other sites

I did check out collectorz a while back, seemed OK but expensive.

I'd prefer an app over a spreadsheet etc. Something that I can update on my phone, tablet or PC etc. and view anytime knowing it's up to date when a buying opportunity presents itself.

I keep the label info as I've spent a lot of time tracking down the best release of my favorite albums over the last decade to get bonus tracks etc.

 

 

In case you are looking for original versions and not counterfeits, I think there's a topic in this site to have a look at.

Link to comment
Share on other sites

I used to keep list of my CDs in a Word document on my PC that I updated as needed, but when my computer crashed and took the list with it I didn't wanna be bothered starting it all over from scratch... lesson learned.

 

Now I use RateYourMusic:

 

https://rateyourmusic.com/~FatFreddysCat

 

 

Nice one, buddy! I think this site is similar, if you get used to the German language for a while (still a very informative one, in case you are looking for first pressings or other versions etc). Still I don't have the mental strength and discipline required to start it!

 

 

https://www.musik-sammler.de/

 

 

 

Btw, I just remembered that an easy one is

 

http://www.discogs.com/

 

 

I have the feeling that this site is gonna stay for a while so it's a cool and easy way to have your collection online (btw, I just realised that I should update my info).

 

2s6newx.png

Link to comment
Share on other sites

I have my cds spread all over the house...I wouldn't even know where to look for half of them let alone trying to catalog them....one of these days when I retire and have time on my hands I will have to deal with this...lol

 

 

 

Yeah, I feel ya buddy. It took me a huge amount of time to arrange my cds in alphabetic order ( usually I catalog them the moment I open a parcel and thus I didn't have to endure the pain of starting from scratch). And then I had to arrange some of them in a clever way for ergonomic reasons ( for example I arranged letters P-S to the level of my eyes to be ready to find and grab for the car stereo). Now I have to show tons of discipline in order to remember putting them back. :tumbsup:

Link to comment
Share on other sites

I'm using Excel and I've been doing it since probably 15 years ago so I never bought a CD twice accidentally, except I bought it from here, amazon, or ebay when it's priced reasonably and sell it to friend or friend's friend for some profits to obtain more CDs :)

 

There are 7 columns, Artist - Title - Year - Rating - Label - Country (CD manufactured in) - Price (price obtained, useful to remember when you want to sell) - Remarks (bonus track, bonus DVD, enhanced, remastered, catalog number, etc).

 

There's a 'Filter' function in Excel so you can use the drop-down mark to show a specific Artist only, or Year only, etc.

 

My CD shelf also was arranged alphabetically by Artist and sorted from the year it's released, so for Bon Jovi, the collection should be stacked s/t, 7800, New Jersey, etc.

 

Another idea is to put another column and put 'Last Played' date so when you have some free time, you can sort this date on Excel to see what albums you haven't spin in like 6 months or more and can be an idea to pull out several Cds from the shelves and spin it :)

 

It's fun I guess and also we're able to see what albums are worth keeping and which one should be sold after a while

Link to comment
Share on other sites

I'm using Excel and I've been doing it since probably 15 years ago so I never bought a CD twice accidentally, except I bought it from here, amazon, or ebay when it's priced reasonably and sell it to friend or friend's friend for some profits to obtain more CDs :)

 

There are 7 columns, Artist - Title - Year - Rating - Label - Country (CD manufactured in) - Price (price obtained, useful to remember when you want to sell) - Remarks (bonus track, bonus DVD, enhanced, remastered, catalog number, etc).

 

There's a 'Filter' function in Excel so you can use the drop-down mark to show a specific Artist only, or Year only, etc.

 

My CD shelf also was arranged alphabetically by Artist and sorted from the year it's released, so for Bon Jovi, the collection should be stacked s/t, 7800, New Jersey, etc.

 

Another idea is to put another column and put 'Last Played' date so when you have some free time, you can sort this date on Excel to see what albums you haven't spin in like 6 months or more and can be an idea to pull out several Cds from the shelves and spin it :)

 

It's fun I guess and also we're able to see what albums are worth keeping and which one should be sold after a while

 

You don't own 'Slippery when wet?' ;)

 

I'd never do it, but I also have thought about that last played thing in the past. It'd be interesting, but you just wouldn't do it. It'd mean that every time you listen to a CD you'd need to document it, lol. That'd be wicked annoying.

Link to comment
Share on other sites

 

I'm using Excel and I've been doing it since probably 15 years ago so I never bought a CD twice accidentally, except I bought it from here, amazon, or ebay when it's priced reasonably and sell it to friend or friend's friend for some profits to obtain more CDs :)

 

There are 7 columns, Artist - Title - Year - Rating - Label - Country (CD manufactured in) - Price (price obtained, useful to remember when you want to sell) - Remarks (bonus track, bonus DVD, enhanced, remastered, catalog number, etc).

 

There's a 'Filter' function in Excel so you can use the drop-down mark to show a specific Artist only, or Year only, etc.

 

My CD shelf also was arranged alphabetically by Artist and sorted from the year it's released, so for Bon Jovi, the collection should be stacked s/t, 7800, New Jersey, etc.

 

Another idea is to put another column and put 'Last Played' date so when you have some free time, you can sort this date on Excel to see what albums you haven't spin in like 6 months or more and can be an idea to pull out several Cds from the shelves and spin it :)

 

It's fun I guess and also we're able to see what albums are worth keeping and which one should be sold after a while

 

You don't own 'Slippery when wet?' ;)

 

I'd never do it, but I also have thought about that last played thing in the past. It'd be interesting, but you just wouldn't do it. It'd mean that every time you listen to a CD you'd need to document it, lol. That'd be wicked annoying.

 

 

lol yeah I slipped on that 'Slippery'

it seems like a hassle at first but if you work with computer everyday, it's very easy to just load up that excel in a minute, type something and save it quick.

Just an idea to spend some free time at home :D

Link to comment
Share on other sites

Oh, you don't need to tell me, mate. I only and only have ever used Excel. Artist, Title & Year at the moment, adding Ratings now and hopefully I get time to add other stuff later. Oh, and Format. I want to add format one day...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

  • 2021 HH Donation Drive

    Please support Heavy Harmonies! The donations goal is the out-of-pocket expenses to run the main site and this board for calendar year 2021.



    78% of donation goal reached.
    Donate Sidebar by DevFuse
  • Posts

    • Looks like I'm the only one who likes Tyler more than Coverdale. Not that I dislike Coverdale, I love the guy's voice, but if I had to choose just one to listen to, I'd go with Tyler, especially his 70's output. I kinda like the sleazy sound just a little bit more than the bluesy sounding voices.
    • It's like how I apologise to the mechanics every time my car breaks down.
    • I reckon it's worth asking the question. 
    • I come in genuine curiosity, but this hospital argument... I'd like clarification. So originally we couldn't do anything because covid was going to kill everyone on earth. Then there was a vaccine and we couldn't do anything until we all got vaccinated. Now we're all vaccinated and the sole reason left that we're still living piece of shit lives is because we don't want to overload the hospitals? Is this the correct read on it? So, if this is true, we've resigned to the truth that is this is how the rest of our lives look? Masks, QR codes, crowd capacities, covid tests if we want to travel interstate, let alone international travel - then we need 87 tests and quarantine every time a new variant pops up, which will be fortnightly, or at the latest, monthly. This is it now, is it? Because if it's not, how does the end of it look? When will it be okay to live again without fear of clogging up the hospitals?  I can only speak for Australia on this part of it, but all we've ever heard about is stopping the strain on the hospitals, but has anyone ever seen it? Would anyone even consider overloaded hospitals as an issue if the media hadn't told us it was an issue? I ask as anyone I know who works in healthcare, and to an extent, even myself, as a medical courier who has worked every single day of the last two years... no one I know, or I, have ever seen any single even remote sign of all this strain on our health system. So, like the rest of this pandemic, is it just another media beat up? All they've done for two years straight is belt fear into us, so is it unreasonable to think this is just another branch from that tree? I'm just sick of daily excuses why our lives are still fucking horrible. Anytime the mere suggestion of return to a "normal" life gets brought up, there's a whole list of media-inspired reasons why we have to continue living in misery.  Anyway, I think that was about it. I'm just in eternal wonder about why we all had to get vaccinated when it hasn't actually changed anything about how covid is viewed and feared. Covid is viewed exactly as it was two years ago. It still governs every aspect of how we live, so all these promises about getting vaccinated so we could go back to a normal life were obviously all bullshit.  I was thinking about Australia's trajectory this morning. So if we keep up this pathetic excuse for an existence - the daily covid rate is around 1300 daily cases - let's call it 1500 daily cases if and when the other states open up. So if we continue on this trajectory, living in paralysed fear of the virus, acting like every case of covid is terminal cancer, we should get past this covid thing in about 15,333 days. So around 42 years. That, of course doesn't allow for population growth, but let's assume the cases go up with population growth proportionately.  So that's the outlook in Australia. In 42 years, we might finally move on from covid, based on our current trajectory? What a future to look forward to! Oh, actually, that doesn't include cases prior to today, so maybe we can get out of this thing in closer to 41 years? Life just got a whole lot brighter right then.    
    • Really nice album cover indeed...but ten for me this last while...yawn...as Jez pointed out they all sound the same,i'd have difficulty picking which track came from which album tbh
    • Yeah it starts off very good then tails off round midway...but the defs have potential and judging by the new tunes could fulfil it...fingers crossed
    • And mine still hasn't been sent...quality service right there  too late to get a refund? lol
    • Yeah Badd Boyz is very good,would be my fav of the three...I really like the Platinum Overdose albums but I know where you're coming from,I also prefer their more melodic/glammy/sleazy side to the metal type stuff
    • Here's what it was for me, I mostly voted on familiarity: 1. I'll be honest, I didn't know who either of these singers were.  Of the two I've only heard music from Harem Scarem so it was Hess for me 2. I like Coverdale's voice more than Tyler's 3. I voted Michaels since I've only heard a handful of Enuff Z'nuff songs and I listen to a lot of Poison.  With such a limited sample size this might change when I hear more Z'nuff but for right now it has to be Michaels 4. Haven't heard a lot of Mason so I voted Jani.  As far as I'm concerned Jani is the full package when it comes to singer-songwriters, he's an absolute Legend 5. Of all of these I feel like this is the least fair comparison, they don't sound even remotely alike to me.  While Pearcy isn't a phenomenal vocalist in the traditional sense, he's so much more distinct in my opinion.  I think Phil's voice could get lost in the shuffle, but when Pearcy sings you KNOW it's Pearcy which is arguably more important in some cases 6. Haven't heard Queensryche with La Torre, so Tate it is 7. Bon Jovi is my favorite band of all time, come at me 8. Same with Tate, I've only heard Great White with Russell so Russ it is 9. I like both versions of Danger Danger for different reasons, but I have to go with Poley for this one 10. Haven't heard anything from Heart I don't think, so Elliot all the way 11. Haven't heard much of Cold Sweat or Cathey, but I do love that first Lynch Mob album. Point Logan! 12. Once again had to look these guys up, but this time I've actually heard one full album from each.  I assumed Bulen was Keeling, but that aside this was probably the closest one for me.  Ended up going for Baton Rouge but if you asked me in a few weeks that might change We should do this again sometime, maybe with guitarists/drummers/bassists/etc?
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.