How do I fix the Duplicate Email Error? #
If you see the error:
Duplicate emails: Smith, John and Hill, Jane are both using john.smith@yahoo.com. Hint: rerun with unique emails
- Edit the emails in your payroll software to use the correct (different) emails. If you do not have unique emails, you can create a fake email e.g. john.smith1@yahoo.com
- Re-export worker details CSV or XLSX file
- Repeat the import process
- Once the import is complete, the unique emails will be used as both the Username and Email in paiyroll®. If you used a fake email, you will need to keep the fake Username, but you can change the Email address back to the original to allow the employee to access the system.
Note: If your import process uses an Excel XLSX format file it is possible to edit the file without needing to edit emails in your payroll software and re-export. If you are using an import process that uses the CSV file format, then you should not use Excel to edit the file as it will corrupt all dates and bank details. In this case, you must use a simple text editor (Wordpad, TextEdit) or LibreOffice which can safely edit CSV files without corruption.