Hi everyone,

    I need your help about my xsl file: 

   When I open 2 files with FM, FM does not show data on the table. However, I have full table with data when I remove namespace of the first line of XML file. Please give me some hints about it. I also attach files for testing.

   My original xml file looks like: 

<CompositionPlaylist xmlns="http://www.digicine.com/PROTO-ASDCP-CPL-20040511#">

<Id>urn:uuid:2e57edb1-d897-4d6e-ab98-f8f02a1f8055</Id>

<AnnotationText>DARKNESS_FTR_TEMP_2D_S_EN_51_2K_IOP_OV</AnnotationText>

<IssueDate>2014-09-25T17:50:40-00:00</IssueDate>

<Issuer>CO3</Issuer>

<Creator>ClipsterDCI 4.7.5.2</Creator>

<ContentTitleText>DARKNESS_FTR_TEMP_2D_S_EN_51_2K_IOP_OV</ContentTitleText> 

<ContentKind>feature</ContentKind>

</CompositionPlaylist>

  And I wrote xsl

 

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://www.digicine.com/PROTO-ASDCP-CPL-20040511#">
<xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/>

    <xsl:template match="/">
        <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
            <ERRORCODE>0</ERRORCODE>
        <METADATA>
<!--  PropertyStrings -->
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ID" TYPE="TEXT" />
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="AnnotationText" TYPE="TEXT" />
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="IssueDate" TYPE="TEXT" />
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Issuer" TYPE="TEXT" />
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Creator" TYPE="TEXT" />
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ContentTitleText" TYPE="TEXT" />
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ContentKind" TYPE="TEXT" />

<!--  ReelList -->               

        </METADATA>

        <RESULTSET> 

                          <xsl:for-each select="CompositionPlaylist">

                               <ROW>

                                  <COL><DATA> ......... </COL></DATA>

                                </ROW>

        </RESULTSET>

       </FMPXMLRESULT>
    </xsl:template>
</xsl:stylesheet>

 

 

 

 

test9.xsl

CPL_test.xml

CPL_DARKNESS_FTR_TEMP_2D_S_EN_51_2K_IOP_OV.xml

Well, you know that the issue is with the namespace, so why don't you search for it:

 

Thank you so much. I got it correctly.