How to import UTF 8 correct

[tommyjensen]

I have a .csv text file generated on HP Service Manager running on AIX. The file has been transferred as a text file via WINSCP to windows and then uploaded to ServiceNow.

Danish national characters is not imported correctly.

Windows Notepad displays the characters correctly.

Specifying UTF8 as characterset when importing in excel sheet the characters displays correct.

How do I ensure that UTF8 is used when I upload the file to ServiceNow ?

[ernyei · Accepted solution]

You have to specify the encoding in the data source properties.

See:

Data Sources - ServiceNow Wiki

[tommyjensen]

Thanks, that worked. I look for a field like that but was looking for field names such as encoding or charset not properties.

[Community Alums]

I think the old wiki article links are not working. I was also facing the same issue but was not sure to use exactly what value in the properties field:

There are two ways here:

1. Change the Import/Export properties (This will be applicable to all data sources. Not recommended) -

Navigate to Import Export under System properties -> Scroll down and check for Import Charset under Import Properties (CSV format). Here, the default value is windows-1252. For UTF-8, you have to enter charset=utf-8

2. Add the properties in the respective Data Source (Recommended)-

Usually, this error happens with LDAP data sources. So, you can navigate to the respective data source, check for the properties field on the form, if it is not there, add it through form layout. For UTF-8, you have to enter charset=utf-8 in the properties field.

Please mark this as helpful, if it answers your questions.