Why special characters or rosters may not import correctly in GotPhoto

Table of contents

• Overview
• The issue
• The root cause
• The solution
• The takeaway

Overview

Sometimes after importing a roster, names may display incorrectly, imports may get stuck, or the file may not open at all. This is usually caused by file encoding issues that affect how special characters are handled.

The issue

After importing your roster, certain characters may not display correctly in your names list or QR cards. In some cases, the roster import may freeze, or you may be unable to open the list after upload.

The root cause

GotPhoto requires names lists to be saved in UTF-8 format. If your file is in another format, special characters like accented letters or symbols may appear as random icons or question marks. Non-UTF-8 encoding can also cause import errors.

The solution

Before uploading your roster, make sure the file is encoded in UTF-8. Below are instructions for saving in UTF-8 using different tools.

For CSV files

You can save your CSV file in UTF-8 format using a text editor or Excel.

If using Notepad (Windows):

1. Open the CSV file in Notepad.
2. Go to File → Save As.
3. In the Save as type dropdown, select All Files.
4. In the Encoding dropdown, choose UTF-8.
5. Save the file.

If using TextEdit (Mac):

1. Open the CSV file in TextEdit.
2. Go to File → Export As.
3. Under Plain Text Encoding, select Unicode (UTF-8).
4. Save the file.

If using Excel:

1. Open the CSV file in Excel.
2. Go to File → Save As.
3. From the file type dropdown, select CSV UTF-8 (Comma delimited) (*.csv).
4. Save the file.

For Excel files (exporting to CSV)

1. Open the Excel file.
2. Go to File → Save As.
3. Select CSV UTF-8 (Comma delimited) (*.csv) as the file type.
4. Save the file.

The takeaway

Incorrectly displayed names or failed imports usually mean your file is not in UTF-8 format. Always ensure your CSV or Excel file is saved in UTF-8 encoding before uploading to GotPhoto to avoid issues with special characters or failed roster imports.