Behavior:
When importing a CSV in DocuWare via Autoindex, apostrophes are being replaced with "’" in DocuWare.
Solution:
This behavior occurs when the character used as an apostrophe is a "right single quotation mark" character (’).
This is a universal issue with character encodings and is not specific to DocuWare. If you open the CSV in Microsoft Excel, you will see the same result. When opening the CSV file in Excel, the right single quotation mark character is converted into the "’" symbol. DocuWare simply reads the CSV as is. This is because Excel opens the CSV file using the default Windows encoding (Windows-1252); hence, the character is encoded as per the Windows-1252 character set.
To resolve this, rename the CSV to a TXT file, open the file in Excel, then re-import the CSV file from within Excel using the "Import data from text file" and choose a UTF encoding. Alternatively, you can use the apostrophe character (') instead of "right single quotation mark" (’) in the CSV. When the file has been reencoded or the "right single quotation mark" has been changed to an apostrophe, Autoindex will bring in the data properly.
KBA is applicable to Cloud and On-premise Organizations.
