XML Parsing error, please help

[ordepzerep]

Hello,

I'm a newbee in the programing world, and I'd really apreciate if someone could help me solve this dubt I've being having for several weeks.

I have a filemaker database with music information, so I created an xsl file in order to export music data from filemaker to an xml file.

So when I though I had it done, file maker gave me the
following error when using the data export script I created:

XML Parsing error
Expected end of tag "MUSICNET_COMPONENT"
Line Number: 89
Colum number: 11

This is the code from the XSL file I created for exporting music data in XML format from filemaker:

<?xml version='1.0' encoding='UTF-8' ?>
<xsl:stylesheet version='1.0' xmlns:xsl='

http://www.w3.org/1999/XSL/Transform'

xmlns:fm='

http://www.filemaker.com/fmpxmlresult'

exclude-result-prefixes="fm">
<xslutput version='1.0' indent="yes" method='xml' />
<!-- CDSTracks::CDID -->
<!-- UPC/EAN -->
<!-- CDSTracks::AlbumName -->
<!-- Release date -->
<!-- Label -->
<!-- Label code -->
<!-- Album price -->
<!-- pLine-->
<!-- cLine-->
<!-- Sale Restriction -->
<!-- cd Artist-->
<!-- CDSTracks::Artist -->
<!-- CDSTracks::ISRC track -->
<!-- CDSTracks::TrackName -->
<!-- CDSTracks:iscNumber -->
<!-- CDSTracks::TrackNum -->
<!-- CDSTracks::TotalTime -->
<!-- CDSTracks::trackPrice -->
<!-- CDSTracks::© Property -->
<!-- CDSTracks::bitrate -->
<!-- CDSTracks::format -->
<!-- CDSTracks::fileName -->
<!-- CDSTracks::© Year -->
<!-- CDSTracks::Composer -->
<!-- CDSTracks:ublisher -->
<!-- CDSTracks::trackPriceEur -->
<!-- CDSTracks::Writer -->
<!-- imageFormat -->
<!-- imageWidth -->
<!-- imageHeight -->
<!-- ImageFileName -->
<!-- Genre1 -->
<!-- CDSTracks::laguage -->
<!-- lenguacd -->
<!-- tipo -->
<!-- CDSTracks::file_n -->
<!-- gen_emusic -->
<!-- sub_gen_emusic -->
<!-- Release date telefonica -->
<!-- CDSTracks::totalTracks -->
<!-- Release date od2 -->
<!-- CDSTracks::CD total time -->
<!-- CDSTracks::minutos_segundos -->
<!-- CDSTracks::total_segundos -->
<!-- country_code_type -->
<!-- CDSTracks::hora_minutos_segundos -->
<!-- MDLD catalogue num -->
<!-- genre3 -->
<!-- genre2 -->
<!-- Genre_Musicnet -->
<xsl:template match="/">
<DATA xmlns:fo="

http://www.w3.org/1999/XLS/Format">

<xsl:for-each select="./fm:FMPXMLRESULT/fm:RESULTSET/fm:ROW">
<!-- LOOP THROUGH THE MAIN RECORDS FOR EACH ALBUM -->
<MUSICNET_COMPONENT>
<MUSICNET_COMPONENT_CODE><xsl:value-of select="./fm:COL[2]/fmATA" /></MUSICNET_COMPONENT_CODE>
<COMPONENT_TYPE>ALBUM</COMPONENT_TYPE>
<CORP_CODE>MDL</CORP_CODE>
<LABEL_CODE><xsl:value-of select="./fm:COL[5]/fmATA" /></LABEL_CODE>
<CD_BURN_RIGHT>
<VALUE>TRUE</VALUE>
<TERRITORY_CODE>WW-MN</TERRITORY_CODE>
</CD_BURN_RIGHT>
<BUNDLE_RESTRICTION>
<VALUE>FALSE</VALUE>
<TERRITORY_CODE>WW-MN</TERRITORY_CODE>
</BUNDLE_RESTRICTION>
<METADATA>
<TYPE>RELATED_UPC</TYPE>
<VALUE><xsl:value-of select="./fm:COL[2]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>ARTIST</TYPE>
<VALUE><xsl:value-of select="./fm:COL[11]/fmATA" /></VALUE>

<METADATA>
<METADATA>
<TYPE>TITLE</TYPE>
<VALUE><xsl:value-of select="./fm:COL[3]/fmATA" /></VALUE>
</METADATA>
<TYPE>CLINE</TYPE>
<VALUE>(C) <xsl:value-of select="./fm:COL[9]/fmATA" /></VALUE>
</METADATA>
</METADATA>
<TYPE>CLINE</TYPE>
<VALUE>(C) <xsl:value-of select="./fm:COL[8]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>DURATION</TYPE>
<VALUE><xsl:value-of select="./fm:COL[42]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>GENRE</TYPE>
<VALUE><xsl:value-of select="./fm:COL[50]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>IMAGE_TYPE</TYPE>
<VALUE>FRONT_COVER</VALUE>
</METADATA>
<METADATA>
<TYPE>RELEASE_DATE</TYPE>
<VALUE><xsl:value-of select="./fm:COL[41]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>TRACKS</TYPE>
<VALUE><xsl:value-of select="./fm:COL[40]/fmATA" /></VALUE>
</METADATA>
<xsl:for-each select="./fm:COL[12]/fmATA">
<xsl:variable name="rowNum" select="position()" />
<!-- LOOP THROUGH THE RELATED PORTAL ROWS FOR THE TRACKS -->
<MUSICNET_COMPONENT>
<MUSICNET_COMPONENT_CODE><xsl:value-of select="./fm:COL[2]/fmATA" />_01_0<xsl:value-of select="./fm:COL[16]/fmATA" /></MUSICNET_COMPONENT_CODE>
<COMPONENT_TYPE>TRACK</COMPONENT_TYPE>
<DIGITAL_AVAILABILITY>
<BEGIN_DATE><xsl:value-of select="./fm:COL[41]/fmATA" /></BEGIN_DATE>
<TERRITORY_CODE>WW-MN</TERRITORY_CODE>
</DIGITAL_AVAILABILITY>
<STREAM_RIGHT>
<VALUE>TRUE</VALUE>
<TERRITORY_CODE>WW-MN</TERRITORY_CODE>
</STREAM_RIGHT>
<DOWNLOAD_RIGHT>
<VALUE>TRUE</VALUE>
<TERRITORY_CODE>WW-MN</TERRITORY_CODE>
</DOWNLOAD_RIGHT>
<METADATA>
<TYPE>DISC_NUMBER</TYPE>
<VALUE>01</VALUE>
</METADATA>
<METADATA>
<TYPE>DURATION</TYPE>
<VALUE><xsl:value-of select="./fm:COL[43]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>GENRE</TYPE>
<VALUE><xsl:value-of select="./fm:COL[49]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>ISRC</TYPE>
<VALUE><xsl:value-of select="./fm:COL[13]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>PARENTAL_ADVISORY</TYPE>
<VALUE>FALSE</VALUE>
</METADATA>
<METADATA>
<TYPE>PERFORMER</TYPE>
<VALUE><xsl:value-of select="./fm:COL[12]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>RELEASE_DATE</TYPE>
<VALUE><xsl:value-of select="./fm:COL[41]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>TITLE</TYPE>
<VALUE><xsl:value-of select="./fm:COL[14]/fmATA" /></VALUE>
</METADATA>
<METADATA>
<TYPE>TRACK_NUMBER</TYPE>
<VALUE>0<xsl:value-of select="./fm:COL[15]/fmATA" /></VALUE>
</METADATA>
</MUSICNET_COMPONENT>
</xsl:for-each>
</MUSICNET_COMPONENT>
</xsl:for-each>
</DATA>
</xsl:template>
</xsl:stylesheet>

I've tryed to change the position of </MUSICNET_COMPONENT> without any success. It may be obvious to some experienced programmers, but, for real, I have no clue where the error is nor how can I solve it? I would really apreacite your help on this one,

Thanks for your help in advance.

 

[tsuji]

[1] You have this orphan closing tag.
[tt]
... etc etc
</METADATA>
<TYPE>CLINE</TYPE>
<VALUE>(C) <xsl:value-of select="./fm:COL[8]/fmATA" /></VALUE>
[red]</METADATA>[/red]
... etc etc
[/tt]
But it may be the other </METADATA> depends on what you really mean for.

[2] You may need to use utf-16 for the prolog of xsl.

 

[ordepzerep]

thank you for your answer, i didn't notice that... I'll give it a try.