You might see the following error when uploading users in a CSV file, especially if their names contain accented characters or non-Latin characters:
This file is not encoded as UTF-8, and so we can't process it correctly
This issue occurs if the file you uploaded is encoded in a non-Unicode character set. Because we don't know what locale your computer is in, it's impossible for Connect to know what characters are supposed to be represented in the CSV file. The solution is to convert your file to a UTF-8 encoded Unicode character set, which provides an unambiguous representation of all possible characters.
To convert this file, a number of different programs can be used. We've provided instructions for Microsoft Excel and Sublime Text.
Using Microsoft Excel
To convert a CSV file to UTF-8 in Microsoft Excel, follow these steps.
- Open the CSV file in Excel using "File -> Open" in the normal way
- Click "File -> Save as..."
- Choose "CSV UTF-8 (Comma delimited) (.csv)"
- Click "Save".
- Upload this new file to Connect instead of your existing one. It should upload without issue and all special characters in your user's names should be preserved.
Using Sublime Text
To convert a CSV file to UTF-8 in Sublime Text, follow these steps.
- Open the CSV file in Sublime Text using "File -> Open"
- Save the file using "File -> Save with encoding -> UTF-8". (note - this will actually overwrite your file with the UTF-8 encoded version. If you wanted to keep the original, make sure to make a copy beforehand).
- Upload your file again to Connect. It should upload without issue and all special characters in your user's names should be preserved.