Warning: mysql_connect(): Access denied for user 'mysql_feedback'@'localhost' (using password: YES) in /usr/local/psa/home/vhosts/coin-c.com/httpdocs/CCTunes/inc_rate.php on line 18
I cannot connect to the database because: Access denied for user 'mysql_feedback'@'localhost' (using password: YES)

13. Resources

Downloading all the scripts

These scripts can be found in the package of the application at http://www.coin-c.com/CCTunes/cct-download.html. Surely you could copy and paste everything from this file, but downloading and untarring is a bit safer, since sometimes the whitespace is important.

Resources used in this article

Link Description
http://www.w3.org/TR/xslt#key The XSLT specification. It is the dry stuff, the spec and just the spec.
http://www.jenitennison.com/xslt/grouping/muenchian.html This could be a helpful technique to aid in speeding up the XML parsing we are doing. To be investigated.
http://www.xmldatabases.org/WK/blog/1086?t=item This is the article that tells about how to clean up the property list that iTunes has as an XML file.
http://www.oreillynet.com/lpt/wlg/3130 Nice article about what's in iTunes, and how.
http://www.macosxhints.com/article.php?story=20030429003250559 A tip about how to get images from iTunes, in which the perl hint occurs.

Other Resources

Name Link Description
mp3report http://mp3report.sourceforge.net/ Suppose you have no iTunes XML file, mp3report could be used to generate one. It runs over your collection of mp3 files and does about the same as all these scripts.
AudioHiJack http://www.rogueamoeba.com/audiohijack/ Very good application to record online radio with. Shareware at a nice price.
Doug's AppleScript for iTunes http://www.malcolmadams.com/itunes/index.php Ultimate resource for everything AppleScriptable in iTunes.
ImageMagick http://www.imagemagick.org/ Whatever you need to convert images if GraphicConverter does not seem to do the trick. Available in a weird license, which I think is as free as possible for an image manipulation program that supports a wide range of formats like this one.
Clutter http://www.sprote.com/clutter/ Nice application to get the Artwork in your iTunes. It has not been updated for a while however.
iCatalog http://www.kavasoft.com/iTunesCatalog/ Shareware application that does the same as the scripts in this article. Except, without paying you only get albums from artists starting with letters A-E. Easy workaround: put an A-E in front of all your artists or so? Naaah, just pay or use the scripts here.
iPlaylist http://iplaylist.knownworld.net/index.html Donationware application to publicize your library on a web page that looks like you're in iTunes itself. Does not extract images at all.
itunes2html http://disobey.com/detergent/code/itunes2html.txt Somebody took the perl script approach for converting iTunes playlists to HTML. iPlaylist is based on this.

Document Layout

This document was made with the excellent guide style sheet also used to make the gentoo documentation, with some minor adaptations done by myself.

The XSLT file to generate all of this, is at http://dev.gentoo.org/~swift/local/guide.xsl.

line
Updated $LastChangedDate: 2005-01-07 20:53:38 +0100 (Fri, 07 Jan 2005) $
line
Kristof Van Landschoot
Author

line
Summary: Overview of links and ideas and tools used while creating and using CCTunes.
line
Single-page Version
Copyright 2003-2004 Coin-C bvba. Questions, Comments, Corrections? Email cctunes@coin-c.com.