Using Bento and iTunes to log music collection...

Discussion in 'Mac Apps and Mac App Store' started by PinkyMacGodess, Jan 26, 2010.

  1. PinkyMacGodess macrumors 601

    PinkyMacGodess

    Joined:
    Mar 7, 2007
    Location:
    Midwest America.
    #1
    I'd like to use Bento and the iPhone Bento app to help me to keep track of my music and dvd collections so that I don't end up buying cd's over again that I already own.

    The iTunes database is an XML file and so far I haven't had much luck importing it into Bento. Is there another way to get where I want to go? When I was beta testing Bento a few years ago I kept telling their people that having a one or two step import of iTunes information would be a very good idea. Well, they didn't apparently think so as it's now at rev 3 and no iTunes import that I've been able to find.

    Also neither Excel or Numbers will touch the XML file, even after heavy editing.

    Anyone done this with Bento? Is there an easier way?

    Thanks all...
     
  2. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    I just did this:
    1. Select "Music" in the upper left corner of iTunes
    2. Select all music, using Command + A
    3. Right-click on selected files and choose "Check Selection"
    4. File > Library > Export Playlist
    5. Change the .xml to .txt
    6. Save the file (it saved mine as Music.txt)
    7. Right-click on the Music.txt file in Finder
    8. Choose Open With > Microsoft Excel (2008)
    And it looks like this:
    Picture 2.jpg
    You can easily save this in tab-delimited format to import into any database application.
     
  3. PinkyMacGodess thread starter macrumors 601

    PinkyMacGodess

    Joined:
    Mar 7, 2007
    Location:
    Midwest America.
    #3
    That should work wonderfully. I just have to pull the duplicates out and I'm done.

    Thank you!
     

Share This Page