Import XML with french characters

Baserow Help
1

Hi !! I’m trying to import an XML file with french characters, but in the preview, special characters mess out.

The actual encoding is UTF-8, I also tried ISO-8859-1 and Windows-1252 but got the same results :confused:

Any idea, to how to work with this?

Thanks by advance :smile:

Capture d’écran 2022-11-17 à 12.00.01
Capture d’écran 2022-11-17 à 12.00.011294×788 138 KB

1 Like
2

@jrmi do you have an idea?

1 Like
3

I have tested a file with accent and indeed the import is broken in this situation. Sorry about that. I’ve filled an issue Encoding issue while importing XML files with accent (#1360) · Issues · Bram Wiepjes / baserow · GitLab.

In the meantime, if you want to import a file with accent I would recommend to use a JSON or CSV format if you can.

You can use a tool like https://jsonformatter.org/xml-to-json to transform your XML in JSON if you have no other way to get a proper JSON format. When using this tool, make sure to save only the rows.row property content like the selected part in this example:

image

Hope it’ll help.

1 Like