Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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