Special Characters in CSV import

Special Characters in CSV import

When importing asset data using the CSV format, SDP does not properly process special characters such as the Umlaute in German or accented characters. Trying to import CSV files which have been stored in the Unicode format (UTF-8, e.g.) result in SDP displaying the message that the language is unsupported.

SOLUTION:

Store your CSV file in the Unicode format (UTF-8). Edit your CSV file using a Hex editor (that is an editor which shows the content of the file as Bytes or Octets and not as characters). Remove the first three bytes which declare the file to be an Unicode UTF-8 file.

Using this procedure I have been able to import assets with the related user names with all special characters.






                  New to ADSelfService Plus?