Women in Technology

Hear us Roar

  Cleaning iTunes
Subject:   getting cd track names?
Date:   2003-01-20 14:50:55
From:   anonymous2
thank you brian, and you also doug (mentioned in this article) for providing useful information and scripts to take advantage of all that itunes has to offer.

i was wondering if there's a way to insert a cd, have the cddb retrieve the cd info, and export the cd's info as text to an appleworks, filemaker pro, or mysql database? i would like to keep a database record of the cds i already have, but don't want to have to import all my cds to the itunes library just to export a song list. is there a solution that anyone can think of?


Full Threads Oldest First

Showing messages 1 through 4 of 4.

  • getting cd track names?
    2003-01-20 17:25:26  dougadams [View]

    We have some AppleScripts that can export track data to AppleWorks and FMP. They are located on this page: <http://www.malcolmadams.com/itunes/scripts/scripts03.shtml>
  • brian d foy photo getting cd track names?
    2003-01-20 15:01:01  brian d foy | O'Reilly AuthorO'Reilly Blogger [View]

    Inserting the CD and retrieving the track information is pretty easy already, although you can get hung up if the CDDB returns more than one match.

    Once you see the CD in iTunes (not importing it, just playing), you should be able to go through the tracks and grab the information that you need. You could use AppleScript or Perl's Mac::iTunes.
    Once you can access the playlist, just dump the information to a tab-delimited file (since most things can read tab delimited text easily).

    Once you have that file, you can use Filemaker's "File>Import...", or mysqlimport. I am not sure about the database facilities in AppleSccript, but you could leave off the intermediate file with Perl and connect directly to mysql (or most other databases).

    All you have to do is turn that description into a script of some sort. Good luck!
    • getting cd track names?
      2003-01-26 05:35:08  anonymous2 [View]

      I'm sorry but I just can't figure out how to access and/or change the data for a CD that has not been imported into the library. The CD that is inserted does not show up in the Applescript's list of user playlists, and if I try to use audio CD playlist, it gives me a not very helpful error, like it can't get the name of the audio CD or it can't get the track of the audio CD.

      I'd really appreciate it someone could post just a fragment of a script that shows how to grab and modify the CD track info.
      • getting cd track names?
        2008-07-04 14:16:26  slates01 [View]

        I have lots CDs with tracks 1,2,3.... but no names how can I access a database to get the CD names