Book a Demo

Author Topic: error import xml data  (Read 4074 times)

GINO

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
error import xml data
« on: August 16, 2011, 12:58:33 pm »
when I import glossary xml with chinese font
I get the error message as below
Quote
Error:
Code =0xc00ce513
Source = Line:11; Char:46
Error Description = Whitespace is not allowed at this location.

does anybody can help me
below is my xml data
Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<RefData version="1.0" exporter="EA.25">
  <DataSet name="Project Glossary" table="t_glossary" filter="Term='#Term#' and Type='#Type#'" stoplist=";GlossaryID;">    
    <DataRow>
      <Column name="Term" value="SPECIAL QUOTATION "/>
      <Column name="Type" value="ALL"/>
      <Column name="Meaning" value=" [ch36939][ch36027][ch30340][ch35336][ch31639][ch33287][ch25910][ch21462],[ch30342][ch26377][ch19968][ch23450][ch30340][ch20381][ch25818],[ch21450][ch33337][ch20844][ch21496][ch30340][ch36939][ch36027][ch34920] (TARIFF),[ch20294][ch32771][ch24942][ch21040][ch24066][ch22580][ch29376][ch27841] or [ch21516][ch26989][ch31478][ch29229] or [ch29986][ch21697][ch30340][ch23395][ch31680]. "/>
      <Column name="GlossaryID" value="43"/>
    </DataRow>
    <DataRow>
      <Column name="Term" value="CONFERENCE & NON-CONFERENCE "/>
      <Column name="Type" value="ALL"/>
      <Column name="Meaning" value=" [ch32147][ch29151][ch21516][ch19968][ch33322][ch32218][ch30340][ch21508][ch36650][ch33337][ch20844][ch21496],[ch28858][ch36991][ch20813][ch21516][ch26989][ch38291][ch38477][ch20729][ch31478][ch29229],[ch30772][ch22750][ch24066][ch22580][ch34892][ch24773],[ch20035][ch21332][ch35696][ch21046][ch23450][ch20849][ch21516][ch30340][ch36939][ch20729][ch21450][ch36939][ch36865][ch26781][ch20214]. "/>
      <Column name="GlossaryID" value="44"/>
    </DataRow>  
  </DataSet>
</RefData>


KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
Re: error import xml data
« Reply #1 on: August 16, 2011, 01:15:37 pm »
"&" is a special character in XML. Replace it with "&amp;"

Code: [Select]
<Column name="Term" value="CONFERENCE &amp; NON-CONFERENCE "/>
« Last Edit: August 16, 2011, 01:16:57 pm by KP »
The Sparx Team
[email protected]

GINO

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: error import xml data
« Reply #2 on: August 16, 2011, 02:10:46 pm »
dear sir
I get it, thank your kindly help

Quote
"&" is a special character in XML. Replace it with "&amp;"

Code: [Select]
<Column name="Term" value="CONFERENCE &amp; NON-CONFERENCE "/>