Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Essex, UK
    Posts
    12

    Angry Unanswered: Probably a dumb question, but....

    Hi all.
    Quick question (long description!), does anyone know if it's possible to import the cdplayer.ini file into a database?

    I've got somewhere around 400 (original) CDs that I use for DJ'ing and it'd be sooo much help if I could just type in a song title and then it'l show me the album name to make finding it easier!
    Obviously every time I shove one in the PC it looks up the track listing on the internet, saving me from typing each song in manually to create the database.

    What I can't get my head round is how to import it as currently the contents of the file are like the section below.

    Oh and before you ask, yes I do use MP3 as well, but take both so when the laptop hangs (as it did last week when using the windows search to find a song at the same time as playing) I can switch to CD until it hopefully reboots. Not only that but I'd need about 300GB of disk space to store it all! :0)

    Any suggestions greatly appreciated.

    Cheers

    Rob

    [3a49a]
    EntryType=1
    artist=Darkness
    title=Christmas Time
    genre=
    numtracks=2
    0=Christmas Time (Don't Let The Bells End)
    1=I Love You 5 Times

    [220fd82]
    EntryType=1
    artist=Madonna
    title=The Immaculate Collection
    genre=
    numtracks=17
    0=Holiday
    1=Lucky Star
    2=Borderline
    3=Like a Virgin
    4=Material Girl
    5=Crazy for You
    6=Into the Groove
    7=Live to Tell
    8=Papa Don't Preach
    9=Open Your Heart
    10=La Isla Bonita
    11=Like a Prayer
    12=Express Yourself
    13=Cherish
    14=Vogue
    15=Justify My Love
    16=Rescue Me

    [1f7ffd1]
    EntryType=1
    artist=Black Eyed Peas
    title=Elephunk
    genre=
    numtracks=16
    0=Hands Up
    1=Labor Day (Its A Holiday)
    2=Lets Get Retarded
    3=Hey Mama
    4=Shut Up
    5=Smells Like Funk
    6=Latin Girls
    7=Sexy
    8=Fly Away
    9=The Boogie hat Be
    10=The APL Song
    11=Anxiety
    12=Where Is The Love?
    13=Third Eye
    14=Rock My Shit
    15=What's Goin Down

    [4027877]
    EntryType=1
    artist=Various Artists
    title=The DJ Box - Disc 1
    genre=
    numtracks=28
    0=The Wedding (Ave Maria)
    1=Starting Over
    2=Third Finger Left Hand
    3=Chapel Of Love
    4=Get Me To The Church On Time
    5=Flash Bang Wallop
    6=Happy Birthday
    7=Happy Birthday
    8=Happy Birthday Sweet Sixteen
    9=Birthday Medley
    10=Happy Birthday To You
    11=21 Today
    12=Jingle Bells
    13=Singalongsanta Medley
    14=White Christmas
    15=Merry Xmas Everybody
    16=Auld Lang Syne
    17=Scotland The Brave
    18=Scotland The Rave
    19=Happy Anniversary
    20=Anniversary Waltz
    21=MOnster Mash
    22=Ghostbusters
    23=The Addams Family
    24=Congratulations
    25=We Are The Champions
    26=Nice One Cyril
    27=Celebration

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Sure...but it needs to be done through VBA coding. For example, a small routine would open and read the INI file. For every new header encountered (i.e.: [3a49a]) a new record is automatically created. The contents under the header are read from the INI file and placed into their respective locations within the new record. This is done until the entire INI file is completely read. If you have 4000 headers, you end up with 4000 records.

    Simple queries can then be created to quickly find the song or songs you want.

    To begin with, you will need to decide what items within the INI file you really want to be contained in a database record (your record format). What items you want in specific tables.

    It really isn't all to difficult. It just requires some coding time.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the queries will, unfortunately, not be simple at all

    if you have one record per album, that means that you must store the track names "sideways" onto that record

    that means that there must be as many fields on the record as the maximum number of tracks

    and that means that when you are searching for a particular track, your query has to be written so that it checks track1, then track2, then track3...

    better to store the album name in one table, and one record per track in a separate track table

    then the queries become very simple


    rudy
    http://r937.com/

  4. #4
    Join Date
    Dec 2003
    Location
    Essex, UK
    Posts
    12

    Talking

    Cheers people, I guess I know what I'll start playing with next then!

    Have a good New Years Celebration!

Posting Permissions

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