External System import CSV : Error with UTF 8 format

[Olivier MAZEN]

Hello there,

I have an issue with special caracter threw the External system import module.

I select the CSV import.

In my CSV source file i upload this row:

Project key;Project name;Project type;Summary;Issue key;Comment
CEGP;Cellule Escalade Grand Public;service_desk;[Import Grafic]3688394;CEGP-1089;Retour FREE le 20/09/09 - G Ollivier _ Reprov envoyé à ce jour, Résolu//Pas revue au 01/10

I specify a configuration file for the mapping (descirb below)

{
"config.version" : "2.0",
"config.project.from.csv" : "true",
"config.encoding" : "UTF-8",
"config.email.suffix" : "@",
"config.field.mappings" : {
"Comment" : {
"jira.field" : "comment"
},
"Project name" : {
"jira.field" : "project.name"
},
"Project key" : {
"jira.field" : "project.key"
},
"Project type" : {
"jira.field" : "project.type"
},
"Issue key" : {
"jira.field" : "issuekey"
},
"Summary" : {
"jira.field" : "summary"
}
},
"config.value.mappings" : { },
"config.delimiter" : ";",
"config.project" : {
"project.type" : null,
"project.key" : "",
"project.description" : null,
"project.url" : null,
"project.name" : "",
"project.lead" : null
},
"config.date.format" : "dd/MM/yy"
}

In advanced option: i set UTF-8 in file encoding field and CSV delimiter to ;

My final result in application is this as a comment:

Retour FREE le 20/09/09 - G Ollivier _ Reprov envoy� � ce jour, R�solu//Pas re�ue au 01/10

I have check several time : my input file is convert to UTF-8 and i still get my special caracter � instead of é.

that's drive me nuts  !

Do you have any idea or point i am missing ?

[Mohamed Benziane · Accepted solution]

Hi @Olivier MAZEN

It seems like if you use the  ISO-8859-1 encoding its working fine

 https://community.atlassian.com/t5/Jira-questions/Import-from-QC-ASCII-convertion/qaq-p/198652

https://community.atlassian.com/t5/Jira-questions/Special-french-characters-import-through-CSV/qaq-p/338423

hope this helps

[Olivier MAZEN]

Hello Mohamed;

thank you very well works like a charm now !

[Olivier MAZEN]

Hello Mohammed,

I face another issue:

input 

02/10 création ticket C20602150

result

02/10 création ticket C20602150

and i used the format ISO-8859-1.

I am style facing error with caracter even with the new format ISO.

Do you have any idea?

Olivier

[Olivier MAZEN]

i found out that my input file have to be in ANSI mode.

sorry for my question.

[Mohamed Benziane]

Hi Olivier,

No worries,i will keep your answer it may help me in the future

Regards