Character encoding problems when importing test cases in Zephyr Scale from an utf-8 csv

[Olivier Ruis]

I'm having character encoding problems when importing test cases in Zephyr Scale from an utf-8 csv file: french accented letters are replaced by the character �

I'm using a Jira Cloud instance, so I don't think I have any option for advanced character set settings.

Any clue?

[Olivier Ruis · Accepted solution]

So, After investigation I found that the problem of accented letters comes from the Excel "export to CSV" feature. When exporting to CSV from LibreOffice, accented letters are correctly imported.
However there is still a problem with slashs, for example when test data contains URL:

// is transformed to \

single / are removed.

Example:  https://myurl.com/home  is imported as  https:\myurl.comhome

I've tried to escape every slash with a backslash (https:\/\/myurl.com\/home) but it does not solve the problem.

Still investigating. Any idea from the community will be welcome.