Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Joaquin_Lazaro
Partner - Specialist II
Partner - Specialist II

Error loading a XML file

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

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

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

View solution in original post

3 Replies
marcus_sommer

Maybe this is helpful: Re: Re: Caractere inválido em load de XML

- Marcus

Frank_Hartmann
Master II
Master II

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
Partner - Specialist II
Partner - Specialist II
Author

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