...

View Full Version : iTunes Album List



mark87
01-04-2006, 05:04 PM
Don't suppose anyone knows a way I can create a listing of the albums I have in iTunes?

I've found stuff like http://spark.is-a-geek.net/itunesxhtmlplaylist/ but it insists on listing all of the songs, not just the albums.

Antoniohawk
01-05-2006, 04:43 AM
If you've got a mac, this might work.

[http://forums.ipodlounge.com/showthread.php?threadid=103441]

If not, I'll try to help ya out some more tomorrow. Gotta hit the sack.

mark87
01-05-2006, 09:55 AM
Thanks, but unfortunately I don't have a mac.

Antoniohawk
01-05-2006, 04:44 PM
If you have excel, then I know of another way to do it. Open up your library in iTunes, show only the name of the song and album, select all, copy. Paste the results in an excel spreadsheet. Then follow this guide on deleting duplicate entries.

[http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo01/html/o2k0601.asp]

This will leave you with one copy of each album name.

mark87
01-05-2006, 04:48 PM
Thanks I might give it ago, I found something earlier which basically automated the whole process, but I use OpenOffice not Excel so it didn't work.

I'll have a look and see if it will still work.

mark87
01-05-2006, 05:02 PM
Done it !

What I did (for anyone else wanting to do it) -

Copy whole iTunes listing.
Paste into OpenOffice Spreadsheet.
Delete all columns except Artist and Album.
Go to Data > Filter > Standard Filter.
Click 'More >>' button.
Tick 'No duplication'.

:)

mark87
01-05-2006, 05:25 PM
Sorry for the triple post but just want to make sure it gets seen!

Now I have another problem...

OpenOffice saves as HTML ... 3.2. In table form as well (which I suppose is semantic but each cell has been styled in HTML!

Anyone know how I can convert an Excel/OO spreadsheet into 'good' HTML?

---------- EDIT ----------

I had a cunning idea which worked in the end....

http://www.markaylward.co.uk/blogimages/iTunes_OOo_List.PNG

Then copied and pasted. :p

Antoniohawk
01-05-2006, 10:09 PM
Awesome. I'm glad that you got it to work. :)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum