Environment
Novell Service Desk 7 AMIE Import
Situation
MFSD with db on MSSQL 2008 (language Latin)
AMIE Import .csv file with french characters presents with diamond question mark
.csv cell showing french character:
After AMIE import presented in MFSD;
![csv file in French language](https://support.microfocus.com/kb/knova/images/NumeroFrench.png)
AMIE Import .csv file with french characters presents with diamond question mark
.csv cell showing french character:
Numéro élément |
After AMIE import presented in MFSD;
![csv file in French language](https://support.microfocus.com/kb/knova/images/NumeroFrench.png)
Resolution
Use an editor to convert the csv file to UTF-8 format.
Use the converted file for the AMIE import.
After converting the .csv file to UTF-8 presented in .csv file:
After AMIE import presented in MFSD;
![After AMIE import represented properly](https://support.microfocus.com/kb/knova/images/NumeroFrench2.png)
Use the converted file for the AMIE import.
After converting the .csv file to UTF-8 presented in .csv file:
Numéro élément |
After AMIE import presented in MFSD;
![After AMIE import represented properly](https://support.microfocus.com/kb/knova/images/NumeroFrench2.png)
Cause
Text translation.