CSV export encoding issue

Need Help
#1

Hello!

I have an encoding issue when I export to CSV.

In config_export_import.yaml I have:

export:
    fileName: pillet-team
    useList: true
defaultFormatOptions:
        fileFormat: csv
        delimiter: ';'
        enclosure: '"'
        escape: '\'
        encoding: 'utf-8'

Which encodes correctly the first arrow but my value rows are still falsely encoded.

Prénom;"Nom de famille";Fonction;Ordre;"Travail plus chez";Entité
Victor;Hugod;"écrivain";6;0;" "
sdaddas;dasdasdasd;dasdasdad;2;0;" Géotechnique SA"
Sam;Medes;"Géographe";5;0;", Géotechnique SA"
Julien;Leclerc;Cosmonaute;7;;
John;Doe;;4;0;
John;;Chef;1;0;" SA"
chip;Chap;;9;;
Bob;;Chef;3;0;
Bibidsada;"Ne travail plus chez millet";;8;1;" SA"

In my DB is in utf8mb4.

I don’t know where I’m wrong. Thanks for your help!

jd

#2

Hi @Pixinside,

What version of October CMS does this occur?

#3

the latest: October 3.1.8

#4

Try this:

defaultFormatOptions:
    fileFormat: csv_custom
    delimiter: ','
    enclosure: '"'
    escape: '\'
    encoding: 'Windows-1252'
#5

Hello,

Did you find a solution for this encoding issue? I have the same problem and the suggested solution does not do it for me.

Thanks in advance.