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:

  1. Open the CSV file in Notepad++. On the lower right corner, you will see the current format (likely ANSI)
  2. In the Encoding menu, select Convert to UTF-8.
  3. Select Save as... and change the type from Normal text to All types.