Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: put all info from mp3 cdīs in a database...

  1. #1
    Maximum Bitrate Raas's Avatar
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    626

    put all info from mp3 cdīs in a database...

    Hi,

    I was wondering if you guys might have a sollution to this problem..

    Like many off us here Iīm an enthousiastic collector of mp3-files.
    And like 3 years ago, my hard drive became too small so I decided to back-up everything on cd.
    Then came the time I got some bigger hard drives which meant I could put on every mp3-file I owned...
    But then again.. always collecting music.... so the hard drives became too small again..
    I still backed-up everything on cd....
    My mp3-cd collection now consists off over 500 cdrīs
    But Iīm loosing track off everything I have.... (you know the situation where someone askes you if you might have that particular cd or track.. and you know you have it, but you just canīt find it... )

    Iīve deciced that everything I own must be stored in a database (I think I want to use ms-access since thatīs the one Iīm used to)
    But I donīt want to add every single file by hand...

    I was thinking about some software which reads the contents of a cdr, and read all the mp3-info-tags on that cd, and store these in a flat file... after the cd has been read.. the software will show some kind of message.... "please label this cd Number [XXX]"
    I will put the number on the cd.. and continue with the next... this will also have itīs unique number...

    Then.. after all the mp3-cdīs are read into the database, I want to examine the flat-file which has been created in order to īnormalizeī the data... Then I will have a seperate [ARTIST], [ALBUM] and [TRACK] table where everything is organised... These tables will contain the information extracted from the ID3-Tags.. along with the Unique CDR-Number...
    This way.. I can search for an album or a song in the database.. and the database tells me on which exact cdr the song/album is stored.. makes searching alot easier when you have nothing more than "MP3 MUSIC" written on your CD.

    I know that 98% of the information in the ID3-tags is correct, since Iīve always changed them before I burned them on a cdr...

    I always have the tracks of an album in a seperate folder..
    The folder name is always [Artist] - [AlbumTitle]
    The way I store mp3-files is always [Artist] - [AlbumTitle] - [TrackNR] - [TrackTitle].mp3 (only not if album is Various Artist Album, then it is [AlbumTitle] - [TrackNR] - [Artist] - [TrackTitle]

    Of course... the app must have some editing system that I can manually edit/add the entries... but the problem is to fill the database...
    I donīt want to add the 15000+ mp3īs I have right now manually...

    I think this would be a great tool.. many of the other guys I know who are collecting mp3īs are doing the same as I... They are collecting tons and tons of new music.. put them on a cdr for their archive... but donīt have a proper way to manage the archive..

    Any Ideas ? There might be something out there that practically does what I want, but I havenīt found any of them ..

    Thanks in Advance !

    Greetz,

    [Edit] the 500 cdīs do not have ONLY mp3īs on them.. there might be some appz or movies is seperate folders.... Iīm only interested in the mp3-tag-reading part !
    Raas - The Netherlands
    ME: VIA epia m10000, lilliput 7', opus 150w, 80gb<br>
    GF: IBM Thinkpad 380, ext. 3.5 80gb, 40x4, PB-IR

  2. #2
    Maximum Bitrate
    Join Date
    Mar 2001
    Location
    Cincinnati, OH USA
    Posts
    694
    Try http://members.home.nl/fchilli/mp3db/
    I have used it for a while, though the author doesn't work on it anymore. I think it will do what you need.
    http://www.mp3car.com/usersites/Maveric/ M.A.V.I.C. System
    Asus MB, PII 266, 192 MB Ram, 6.8" LCD, 6 Disk CD-ROM, 21 Gig HD, All-in-Wonder Video w/ TV Tuner, Irman, Windows ME, Winamp, Cobra III -- All in a custom acrylic case.

    http://www.mp3car.com/usersites/listings/ MP3car Listings - Please add to it! :)

  3. #3
    Maximum Bitrate Raas's Avatar
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    626
    Hi maveric,

    Thanks for the app !!!
    This is more or less what I want !
    Thanks a lot !

    Greetz,

    Raas
    Raas - The Netherlands
    ME: VIA epia m10000, lilliput 7', opus 150w, 80gb<br>
    GF: IBM Thinkpad 380, ext. 3.5 80gb, 40x4, PB-IR

  4. #4
    Maximum Bitrate
    Join Date
    Oct 2001
    Location
    Ontario, Canada
    Posts
    845
    hehehe...

    I've got at least 120 CDs burnt with MP3s and another 60GB on my computer (over 25,000 in total)... I've found that it's quicker to head onto DC/nap/whatever to re-download the music (most likely in a higher bitrate than I already have anyway) than it is to find the CD that has the music on it

    Sheesh, 700MB just isn't that much anymore. I've got over 200GB of stuff to get off my hard drive, and since HDs are like 2-3x the cost of CDRs, I just end up buying more HD space rather than taking the hours and hours to burn CDs and catalog them and have the hassle of having to find them in order to get access to my stuff. And DVD burners aren't low enough in price yet

    Oh well
    IN DEVELOPMENT -- '96 Mustang, lilliput with PII/450 laptop, custom DC-DC power supply, 60GB; Garmin GPS; 802.11g; compact keyboard, small graphical LCDs, OBDII.

  5. #5
    Constant Bitrate
    Join Date
    May 2002
    Location
    Iowa
    Posts
    139
    500 CD's?

    Holy Maceroni...I thought I had a lot with 50-60 CD's. I can't imagine that...that's like 60,000 - 75,000 songs. I realize some CD's aren't all mp3s but still...hot dang....if you want to unload some of that you can send a few cd's my way, but no country music please
    5% Complete
    Dash Fabrication complete

  6. #6
    Maximum Bitrate Raas's Avatar
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    626
    Telek,

    I see your point... Hard drive space isn't that expensive anymore.. that's right..
    but the problem is..
    I still don't have a broadband connection at my house..
    Most off the stuff is downloaded at work and also a lot off stuff is copied from friends.. so I needed a cheap way to get all the data to my house.. right. ?
    Then again.... 700mb isn't that much.. but it can hold enough for me.. and the cd's are cheap... I think the cd's won't be used for more than 10-20 times in their life span.. it's just to a simple and cheap way to back-up data in case a hard drive crashes.. ohhh boy.. I would really hate to see my movie and apps and mp3 collection to be distroyed just because some hard drive crashed..
    OK.. it takes some time.. doesn't it.. but what the heck.. you don't have to pay your own time... so basically.. it's free..

    Greetz..
    (BTW.... i really have a lot off movies in these cd's so that's my explanation why say 15000 mp3's are scattered over 500 cd's)
    Raas - The Netherlands
    ME: VIA epia m10000, lilliput 7', opus 150w, 80gb<br>
    GF: IBM Thinkpad 380, ext. 3.5 80gb, 40x4, PB-IR

  7. #7
    Constant Bitrate
    Join Date
    May 2002
    Location
    Iowa
    Posts
    139
    i say we start an mp3 CD tree and have Raas start us off by burning us his collection
    5% Complete
    Dash Fabrication complete

  8. #8
    Maximum Bitrate albysure's Avatar
    Join Date
    Dec 2000
    Location
    pittsfield, ma.
    Posts
    685
    i have a file that reads your mp3 list and prints it in excel. let me know if you want it. you can also click on a song and play it from there!

  9. #9
    Variable Bitrate
    Join Date
    Aug 2002
    Location
    longview washington
    Posts
    425
    why not just all chip in for a dedicated webserver somewhere with a few hundred gigs o hd space3 and we all uplaod our mp3's to it and "share" them kinda a private mp3car only server
    we of course would need someway to filter out duplicates and keep the hger quality one's if the same song gets upped by a few people but hmm
    WINNER!!!!
    run-on sentance comp 2002!!
    :)

  10. #10
    Maximum Bitrate Raas's Avatar
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    626
    Originally posted by oddcomp
    why not just all chip in for a dedicated webserver somewhere with a few hundred gigs o hd space3 and we all uplaod our mp3's to it and "share" them kinda a private mp3car only server
    we of course would need someway to filter out duplicates and keep the hger quality one's if the same song gets upped by a few people but hmm
    Now that would be an idea !.. who has the available space/bandwith..
    also..
    if we should have such thing, I think this community would attrack thousands of īmp3-junkiesī like ourselves..

    We have to keep the ip/user/pass very secret, or give each individual user here itīs own account .. that would be the only way to track if someone has made the ftp known to the public, and itīs not private for us guys anymore..

    If I would have the bandwith/space I would put something up.. only thing to do then is mail Aaron or BGoodman for a quick summary of all users here..

    anyone who makes the ftp known to the public, should be punished with the removal of their carputer-setup..

    Albysure: Could you please send me that file to mark at ojcknor dot nl ? I want to look if it stores some procedure I can use in my Access-App. Thanks in Advance !!!


    Greetzzz
    Raas - The Netherlands
    ME: VIA epia m10000, lilliput 7', opus 150w, 80gb<br>
    GF: IBM Thinkpad 380, ext. 3.5 80gb, 40x4, PB-IR

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •