Using Bento and iTunes to log music collection...

[PinkyMacGodess]

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...

 

[GGJstudios]

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:

​

You can easily save this in tab-delimited format to import into any database application.

 

[PinkyMacGodess]

That should work wonderfully. I just have to pull the duplicates out and I'm done.

Thank you!