5 Replies Latest reply on Apr 27, 2016 7:11 AM by beverly

    How can I import an xml without having to remove the xmlns reference at the start of the XML

    brendan_mc

      I have figured out the XSTL section and can import the XML if I remove the xmlns= part of the first tag. Can I add something to the xslt so I do not need to remove the xmlns reference? Below is a simple example of the file.

       

      XML FILE

      -------------

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
      <Project xmlns="http://schemas.microsoft.com/project">
                  <ProjectID>Test DData</ProjectID>
      </Project>

       

       

       

       

      XSTL FILE

      --------------

      <?xml version='1.0' encoding='UTF-8'?>
      <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
        <xsl:template match="/">
      <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
      <METADATA>
      <FIELD NAME="Group_ID" TYPE="TEXT"/>
      </METADATA>
      <RESULTSET>
        <ROW>
      <COL>
      <DATA><xsl:value-of select="Project/ProjectID" /></DATA>
      </COL>
      </ROW>
      </RESULTSET>
      </FMPXMLRESULT>
        </xsl:template>
      </xsl:stylesheet>