Starting point When importing employee data into My Effectory, you may encounter warnings in the import process. This article provides detailed information about the four different warnings you may run into and how to resolve them.
There are four different warnings that can appear during your data upload:
- Multiple worksheets found
- Inconsistent date values
- Sensitive data found
- Duplicate Employee IDs
Multiple worksheets found
Why? The Excel file you are trying to upload contains multiple worksheets.
How to resolve? Select the correct worksheet in the drop-down menu, click on Continue, and you will be able to proceed with the upload process.
Inconsistent date values
Why? The Excel file you are trying to upload contains mixed value types within the same column. Mixing strings (text) and date formats in Excel can cause compatibility issues.
How to resolve? There are two ways to resolve this warning:
Adjust your file: Go back to your file and make sure only one date format 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.
Change file format: Alternatively, you may choose to upload your data in CSV format instead of Excel. CSV files eliminate the risk of incompatible date formats.
For more information about formatting cells in Excel, please refer to this article
Sensitive data found
Why? Effectory should not receive any sensitive personal data of employees. However, potentially sensitive data was detected in your employee data file. This may include:
- 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
How to resolve? If this is intentional, you may proceed with your import. Alternatively, you can remove the columns in question. We recommend removing the sensitive data from your file to ensure data privacy and protection.
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.
Note: The option you choose will apply to all duplicates. You may not resolve part of the duplicates immediately and part at a later moment.