If you find that special characters are not importing correctly, it is very likely due to a file format issue. ACME Import accepts a comma separated values (csv) file in UTF-8 format. If your file contains special characters (such as accents) and the format is not UTF-8, you may see results such as � instead of a grave accent, acute accent, circumflex, cedilla, tilde, etc.
How to resolve
You can re-import the customer and membership to correct the issue by following these steps:
- Open the CSV file in Notepad++. On the lower right corner, you will see the current format (likely ANSI)
- In the Encoding menu, select Convert to UTF-8.
- Select Save as... and change the type from Normal text to All types.