<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" encoding="UTF-8"/>

<xsl:template match="/">
<XMM_Movie_Database>
	<xsl:for-each select="plist/dict/dict">
		<Movie>
			<MovieID>DVDPEDIA<xsl:value-of select="preceding-sibling::key[position()=1]"/></MovieID>
			<Title><xsl:value-of select="string[preceding-sibling::key[1]='Title']"/></Title>
			<Media><xsl:value-of select="string[preceding-sibling::key[1]='Media']"/></Media>
			<Genre><xsl:value-of select="string[preceding-sibling::key[1]='Genre']"/></Genre>
			<Year><xsl:value-of select="date[preceding-sibling::key[1]='Release']"/></Year>
			<Length><xsl:value-of select="string[preceding-sibling::key[1]='Duration']"/></Length>
			<PersonalRating><xsl:value-of select="integer[preceding-sibling::key[1]='MyRating']"/></PersonalRating>
			<xsl:variable name="purchaseDate" select="date[preceding-sibling::key[1]='PurchasedOn']" /> 
			<Purchase><xsl:value-of select="translate($purchaseDate, 'TZ', '')"/></Purchase>
			<Plot><xsl:value-of select="string[preceding-sibling::key[1]='Summary']"/></Plot>
			<Cover><xsl:value-of select="preceding-sibling::key[position()=1]"/>.jpg</Cover>
			<URL><xsl:value-of select="string[preceding-sibling::key[1]='ProductURL']"/></URL>
			<Actors>
				<Actor><xsl:value-of select="string[preceding-sibling::key[1]='Starring']"/></Actor>
			</Actors>
			<Director><xsl:value-of select="string[preceding-sibling::key[1]='Director']"/></Director>
			<Position><xsl:value-of select="string[preceding-sibling::key[1]='Location']"/></Position>
			<Country><xsl:value-of select="string[preceding-sibling::key[1]='Locale']"/></Country>
			<UPC><xsl:value-of select="string[preceding-sibling::key[1]='UPC']"/></UPC>
			<Rating><xsl:value-of select="string[preceding-sibling::key[1]='Rated']"/></Rating>		
			<Seen><xsl:value-of select="date[preceding-sibling::key[1]='LastSeen']"/></Seen>
		</Movie>
	</xsl:for-each>
</XMM_Movie_Database>
</xsl:template>

</xsl:stylesheet>