Warnings during your data upload

• Multiple worksheets found
• Inconsistent date values
• Sensitive data found
• Duplicate Employee IDs

Multiple worksheets found

Inconsistent date values

Change file format (recommended)

This issue can only occur when trying to upload an Excel file. If you want to ensure no value type errors can occur, we recommend uploading your data in .CSV UTF-8 format instead of Excel. CSV UTF-8 files eliminate the risk of incompatible date formats altogether!

To save an Excel file as CSV UTF-8:

1. Open the file in Excel.
2. Go to the File tab and choose Save As.
3. Select CSV UTF-8 (comma delimited) (*.csv) from the file type drop-down list.
4. Click Save.

Adjust your Excel file

Alternatively, you can go back to your Excel file and make sure only one date value type is consistently used throughout all the variables (e.g. in the columns Birthdate, Date in service, etc.). Select Upload another file, and try the upload again.

Tip! For more information about formatting cells in Excel, please refer to this article (external link).

The new upload is missing previously added columns

Why? The employee data file you're uploading onto My Effectory does not contain all the variables that are currently included in your employee data in the platform. How to resolve? If you removed the variables from your employee data file because you no longer want them to be part of your employee dataset, you can use the checkbox to select them and then confirm by clicking Delete columns. You can then proceed with the rest of your upload normally.

If you do not want to remove the missing variables, you may ignore the warning message and continue the upload by clicking Keep all columns. Your employee data will be updated with the data from the file you're uploading, but the missing columns will remain untouched.

Note: Variables used for the setup of a group structure cannot be deleted! If you want to delete one of these, you must first remove them from the group structures in any of the projects they are being used in.

Sensitive data found

• Religious or philosophical beliefs
• Racial or ethnic origin
• Political opinions
• Trade union membership
• Genetic data, biometric data
• Health data
• Sexual orientation
• Criminal convictions and offences

Duplicate Employee IDs

Why? There were duplicate values found in your Employee ID data field. Employee IDs must be unique, and employees with duplicate values in this field cannot be imported.   How to resolve? You may choose one of the following two options:
Resolve now: You will be shown all the instances of employees with duplicate IDs. For each ID, select the right employee to include in your import. The remaining ones will be excluded.
Resolve later: You will be instructed to download an Excel file containing only the employees to which the warning applies. You will then be able to continue the import of all other employees (the duplicates will be excluded). You can resolve the errors with the duplicates in the file you downloaded and upload them separately at a later moment.