This usually happens when you are using another language such as Italian or German. You get special unique characters. The solution is as follows:
The mapper loads the CSV file according to the Java default encoding(I guess it
is US-ASCII), but some characters are replaced because the CSV file is encoded
in UTF-8 and contains non-ASCII characters.
Workaround for this issue is to specify the option "-Dfile.encoding=UTF-8" to
the batch file (run.bat) of the Sheet Mapping Designer as shown below :
start java -Dfile.encoding=UTF-8 -Xmx500m -DCM=no
Author: Neal Wang
Attachment: