Search code examples
itunesxslt-2.0xslt

Extracting information from ITunes Music Library XML with XSLT?


I need to extract information from iTunes Music Library.xml file. Since the xml is in the form of plist it has become a bit cumbersome.

I want to get list of all Track IDs from a specific playlist whose "Playlist ID" I have.

For example, An iTunes Playlist looks like below.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
    <key>Playlists</key>
    <array>
        <dict>
            <key>Name</key><string>Library</string>
            <key>Master</key><true/>
            <key>Playlist ID</key><integer>4053</integer> <!--Ex:4053 I have.-->
            <key>Playlist Items</key>
            <array>
                <dict>
                    <key>Track ID</key><integer>2413</integer>
                </dict>
                <dict>
                    <key>Track ID</key><integer>2083</integer>
                </dict>
                <dict>
                    <key>Track ID</key><integer>2081</integer>
                </dict>
                <dict>
                    <key>Track ID</key><integer>6798</integer>
                </dict>
                         </array>
                   <dict>
                   <!-- Here another playlist will start. with diff playlist ID -->
            <array>

</dict>
</plist>

You can check your Itunes Music Library.xml for details.

Basically, What I need is this. (a) Given Playlist ID (here 4053), print all the Track Ids values (here: 2413,2083,2081,6798) under that playlist.

My attempt:

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text" /> 

<xsl:template match="/"> 


<xsl:for-each select="plist/dict/array/dict">

    <xsl:choose>
        <xsl:when test="child::integer[preceding-sibling::key[1]='Playlist ID']=4053"> 
           <!-- condition is not working fine, Below lines are working fine -->
        <xsl:for-each select="plist/dict/array/dict/array/dict">
            <xsl:value-of select="child::integer[preceding-sibling::key[1]='Track ID']"/>
            </xsl:for-each>
        </xsl:when>
    </xsl:choose>


</xsl:for-each>

</xsl:template>

</xsl:stylesheet>

Can any experts on XSLT help me out here. I will be very glad.


Solution

  • I was making a silly mistake and caught it. The path inside the for-each loop should be relative. I am posting the answer may be it may help somebody later.

    <?xml version="1.0" encoding="ISO-8859-1"?>
    
    <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    
    <xsl:output method="text" /> 
    
    <xsl:template match="/"> 
    
    
    <xsl:for-each select="plist/dict/array/dict">
    
        <xsl:choose>
            <xsl:when test="child::integer[preceding-sibling::key[1]='Playlist ID']=4053"> 
            <xsl:for-each select="array/dict"> <!--**This should be relative**-->
                <xsl:value-of select="child::integer[preceding-sibling::key[1]='Track ID']"/>
                </xsl:for-each>
            </xsl:when>
        </xsl:choose>
    
    </xsl:for-each>
    
    </xsl:template>
    
    </xsl:stylesheet>
    

    Thanks.