topic Re: Error loading a XML file in QlikView

Error loading a XML file

Joaquin_Lazaro — Mon, 03 Oct 2016 11:13:31 GMT

Hello:

I'm trying to data from a XML file, but I get this error message

Found a not valid character

On line number: 11. On column number: 12. System ID: MasVoz%20Demo.xml.

callATC:

LOAD account,

calldate,

cdrHost,

destination,

disposition,

duration,

id,

province,

service,

source,

hasrecord,

played,

hasfax

FROM [MasVoz Demo.xml] (XmlSimple, Table is [callATC])

On line 11 there is this content

<province>móvil</province>

QlikView doesn't like de word móvil ... a word with an accent mark

Is there a keyword or any way for loading XML files with accent mark words ??

I've attached the XML, it could help to test anything.

Thank you very much

Joaquín

marcus_sommer — Mon, 03 Oct 2016 12:38:38 GMT

- Marcus

Frank_Hartmann — Mon, 03 Oct 2016 13:02:02 GMT

try opening the xml file with notepad++ and change encoding to UTF-8 ("convert to UTF-8"). Then save and try again loding the xml with qlikview!

Hope that helps

Joaquin_Lazaro — Mon, 03 Oct 2016 13:17:13 GMT

Hello:

The content of the XML file was in UTF-8 format but I previously saved it in ANSI format.

I have saved the file in UTF-8 format and finally IT WORKS NICE ... just as Frank wrote.

Thanks for you help

Joaquñin