1 2 Previous Next 15 Replies Latest reply on Nov 1, 2015 7:46 AM by APIcoder

    XML Import: SAXParseException: unable to read data from file...

    dyb

      I'm trying to import data from XML. I constantly get the error:

      SAXParseException: unable to read data from file (Occurred in an unknown entity, at line 0, column 0.)

       

      This is my sample XML:

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
      <ucd xmlns="http://www.unicode.org/ns/2003/ucd/1.0">
         <repertoire>
            <char cp="0000" age="1.1" na="" JSN="" gc="Cc" ccc="0" dt="none" dm="#" nt="None" nv="NaN" bc="BN" bpt="n" bpb="#" Bidi_M="N" bmg="" suc="#" slc="#" stc="#" uc="#" lc="#" tc="#" scf="#" cf="#" jt="U" jg="No_Joining_Group" ea="N" lb="CM" sc="Zyyy" scx="Zyyy" Dash="N" WSpace="N" Hyphen="N" QMark="N" Radical="N" Ideo="N" UIdeo="N" IDSB="N" IDST="N" hst="NA" DI="N" ODI="N" Alpha="N" OAlpha="N" Upper="N" OUpper="N" Lower="N" OLower="N" Math="N" OMath="N" Hex="N" AHex="N" NChar="N" VS="N" Bidi_C="N" Join_C="N" Gr_Base="N" Gr_Ext="N" OGr_Ext="N" Gr_Link="N" STerm="N" Ext="N" Term="N" Dia="N" Dep="N" IDS="N" OIDS="N" XIDS="N" IDC="N" OIDC="N" XIDC="N" SD="N" LOE="N" Pat_WS="N" Pat_Syn="N" GCB="CN" WB="XX" SB="XX" CE="N" Comp_Ex="N" NFC_QC="Y" NFD_QC="Y" NFKC_QC="Y" NFKD_QC="Y" XO_NFC="N" XO_NFD="N" XO_NFKC="N" XO_NFKD="N" FC_NFKC="#" CI="N" Cased="N" CWCF="N" CWCM="N" CWKCF="N" CWL="N" CWT="N" CWU="N" NFKC_CF="#" InSC="Other" InPC="NA" blk="ASCII" isc="" na1="NULL">
               <name-alias alias="NUL" type="abbreviation"/>
               <name-alias alias="NULL" type="control"/>
            </char>
          </repertoire>
      </ucd>
      

       

      This is my XSL:

      <?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="unicodeCodePoint_cp" TYPE="TEXT"/>
                      <FIELD NAME="unicodeAge_age" TYPE="TEXT"/>
                      <FIELD NAME="unicodeGeneralCategory_gc" TYPE="TEXT"/>
                      <FIELD NAME="unicodeBlock_blk" TYPE="TEXT"/>
                      <FIELD NAME="unicodeName_na" TYPE="TEXT"/>
                      <FIELD NAME="unicodeNameLegacy_na1" TYPE="TEXT"/>
                      <FIELD NAME="unicodeScript_sc" TYPE="TEXT"/>
                      <FIELD NAME="unicodeScript_scx" TYPE="TEXT"/>
                  </METADATA>
                  <RESULTSET>
                      <xsl:for-each select="ucd/repertoire/char">
                      <ROW>
                          <COL>
                              <DATA><xsl:value-of select="ucd/repertoire/char/@cp"/></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select="ucd/repertoire/char/@age"/></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select="ucd/repertoire/char/@gc"/></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select="ucd/repertoire/char/@blk"/></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select="ucd/repertoire/char/@na"/></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select="ucd/repertoire/char/@na1"/></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select="ucd/repertoire/char/@sc"/></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select="ucd/repertoire/char/@scx"/></DATA>
                          </COL>
                      </ROW>
                      <xsl:for-each>
                  </RESULTSET>
              </FMPXMLRESULT>
          </xsl:template>
      </xsl:stylesheet>
      

       

       

      What am i missing?

        1 2 Previous Next