Forums | MacLife

http://www.herskal.com/apps/TunesToXHTML.zip

I even gave it a name.

TunesToXHTML Readme wrote:

TunesToXHTML version 0.2
Released 1 June 2005
By Ryan E. Hannan, herskal.com

NOTE
This "software" is not for the feint of heart. It requires some skill with spreadsheets and HTML.

SUMMARY
This is a Microsoft Excel spreadsheet that converts a list of artists, albums, and songs to an XHTML 1.1 Strict compliant list (see BUGS below) for use on a webpage. The output generated is in this format:

    Artist
        Album
            Song
            Song
        Album
            Song
    Artist
        Album
            Song
            Song
            Song   

Each song is a link to a search for that track on the iTunes Music Store. Visit herskal.com/music for an example.

SYSTEM REQUIREMENTS
This spreadsheet should work on almost any version of Microsoft Excel for any operating system. However, I've only tested in on MS Excel v.X for Mac OS X. It may work on other spreadsheet applications, but compatibility is not guaranteed.

INSTALLATION AND USE
- Uncompress the zip file.
- Copy TunesToXHTML.xls to your Documents folder or preferred location.
- Generate a list of your music's artists, albums, and songs from your music playing application.
- Open this list in Excel and paste it into the corresponding TunesToXHTML columns.
- If you have more that 2500 songs, be sure to copy the formulas in columns "D" through "M" down to your last song (most of these columns are hidden).
- Copy the content of the cells in Column "E" into your webpage.
- Be sure to add an <ol> or <ul> to the top of the list and a </ol> or </ul> to the bottom of the list in your webpage.
- Check the webpage for special characters that may cause problems (see BUGS). The iTunes Music Store links require these characters to be in hexadecimal form (ie %26). Special characters being displayed on your webpage need to be in the form of a decimal ASCII code (ie & #38;).

BUGS
- Many special characters will cause errors on the W3C's XHTML validator. The spreadsheet will account for spaces and ampersands, but no other special characters. I have been replacing the few that crop up by hand in the code.

LICENSE
You may distribute or alter this spreadsheet. My only request is that you please retain my credit somewhere in this document or the spreadsheet. If you're feeling really generous, you could include a comment in your website's source .

Last edited by reh (2006-05-20 5:55 pm)

In case you don't notice it, I should note that I've assigned a CSS class of "musicAlbums" to the album list and a CSS class of "musicSongs" to the song list.