Hi,
i’m searching for a way to convert the entire database (videodb.xml) into a CSV file to import that in libreoffice calc. i’ve found a template to do this with msxml.exe, but this template only exports some tags and i have not figured out how to add the other tags to the template. this is the template:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://www.w3.org/TR/xhtml1/strict">
<xsl:output method="text" indent="no" encoding="UTF-8"/>
<xsl:template match="videodb">
<xsl:text>Title;Year;IMDB Rating;Genre;Path and Filename</xsl:text>
<xsl:text>
</xsl:text>
<xsl:for-each select="movie">
<xsl:sort select="title"/>
<xsl:value-of select="title"/>
<xsl:text>;</xsl:text>
<xsl:value-of select="year"/>
<xsl:text>;</xsl:text>
<xsl:value-of select="rating"/>
<xsl:text>;</xsl:text>
<xsl:value-of select="genre"/>
<xsl:text>;</xsl:text>
<xsl:value-of select="filenameandpath"/>
<xsl:text>
</xsl:text>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
it’s no problem to add other xml tags that are in the ‘movie’-tag. i have problem to work with the fileinfo tags:
<fileinfo>
<streamdetails>
<video>
<codec>h264</codec>
...
</video>
<audio>
...
</audio>
</streamdetails>
</fileinfo>i think i have to ‘jump’ to the fileinfo tag, then to the streamdetails tag and so on. but how can i do this in the template?