This article covers the following topics:
- About CSV Import warning messages
-
Import preview: most common warning messages
- No changes were found in XXX.csv
- Employee not found
- Duplicated employee
- EmptyRowError
- No 'id' column was found in the CSV file
- No 'email' column was found in the CSV file
- Duplicated value: email
- Duplicated value: id
- "This row does not contain the same number of values as columns in the CSV"
- "Updating an employee's status from `active` to `pendingActivation` is not supported"
About CSV Import warning messages
This section lists the most common warning messages that are shown before the confirmation of the CSV import and that will prevent you from going forward with the upload.
This list is not to be intended as exhausting, rather the intention is to list the most common warnings and how to behave when encountering them.
Import preview: most common warning messages
No changes were found in the XXX.csv
WHY
The message "No changes were found in XXX.csv", shown in the screenshot below, means that the system does not see any differences between the current situation on the platform and the CSV file.
The reason could be one of the following:
- The file is empty.
- The file was saved in a format that is not recognized by the system.
|
|
WHAT TO DO
Check if your file is not empty or if your spreadsheet has multiple sheets, delete all but the one that has the employee data.
Check if the file has been saved as CSV UTF-8 (Comma delimited), if not select this type of file when saving your CSV.
Employee not found
WHY
The message "Employee not found", shown in the screenshot below, means that the system cannot find a match between the id in the CSV and the id in the GAN system.
The reason could be one of the following:
- The id is either wrong or misspelled.
- The id does not exist on the platform.
NB: Please note that this type of warning will be shown ONLY for Update Employees Information and Archive Employees.
For Add Employees imports, all accounts must be new accounts, hence none of accounts should be found on the system.
For Replace Employees List imports, the system would automatically add a new account if the employee's id was not found.
|
|
WHAT TO DO
Check if the correspondent row in your CSV (in the example above row 2) contains a typo. If this is not the case, the account could have been registered in the system with another id. You will need to retrieve this id in order to update the specific account.
Another scenario could be that the account for the employee was never added to the system:
- In case of a Archive Employees import: you will have to remove the specific row from the CSV and try the upload again.
- In case of a Update Employees Information import: you will have to remove the specific row from the CSV and if needed add it to a different spreadsheet. You will end up with two CSVs: one for the Update Employees Information import and one for the Add Employees import.
Duplicated employee
WHY
The message "Duplicated employee", shown in the screenshot below, means that the account you are trying to add already exists in the GAN platform.
The reason could be one of the following:
- The id is the same as the id of an already existing account.
- The email is the same as the email of an already existing account.
NB: Please note that this type of warning will be shown ONLY for the import Add employees.
For the Update Employees information and Replace Employees list imports, accounts that are identified as already existing on the platform, will be updated.
For Archive Employees imports, the system needs to have correspondence between the id column in the CSV and the id in the platform.
|
|
WHAT TO DO
Check the row that was highlighted in the import preview (in the example above, row 2) and :
- Change the id and/or the email of the account is wrong
- or Remove the row from the CSV file. You will be able to update the already existing account with a Update Employees Information import.
EmptyRowError
WHY
The message "EmptyRowError", shown in the screenshot below, means that the system does not see any differences between the current situation on the platform and the CSV file.
The reason is due to an empty row in your CSV.
|
|
WHAT TO DO
Check the row the Import preview is referring to (in the above example row 1) and delete it.
No 'id' column was found in the CSV file
WHY
The message "No 'id' column was found in the CSV file", shown in the screenshot below, means that the system does not find the id column in the CSV file.
The reason could be one of the following:
- The label of the id column is misspelled.
- The id column is missing.
|
|
WHAT TO DO
Check if your CSV has an id column, and if so, Check if your CSV has an id column, and if so, check if the label of the column is spelled lower case (id).
If the id column is missing, you should add the column and populate its cells.
No 'email' column was found in the CSV file
WHY
The message "No 'email' column was found in the CSV file", shown in the screenshot below, means that the system cannot find the email column.
The reason could be one of the following:
- The label of the email column is misspelled.
- The email column is missing.
|
|
WHAT TO DO
Check if your CSV has an email column, and if so, check if the label of the column is spelled lower case (email).
If the email column is missing, you should add the column and populate its cells.
Duplicated value: email
WHY
The message "Duplicated value: email", shown in the screenshot below, means that the CSV contains two rows with the same email address.
NB: The email address is a unique value, the system will not allow multiple accounts to use the same email address.
|
|
WHAT TO DO
Check the CSV file for duplicated email addresses and remove/change one of the duplicated values.
Duplicated value: id
WHY
The message "Duplicated value: id", shown in the screenshot below, means that the CSV contains two rows with the same id.
NB: The id is an unique value, the system will not allow multiple accounts to use the same id.
|
|
WHAT TO DO
Check the CSV file for duplicated ids and remove/change one of the duplicated values.
This row does not contain the same number of values as columns in the CSV
WHY
The message "This row does not contain the same number of values as columns in the CSV", shown in the screenshot below, means that a row in the CSV contains more values than the other rows.
|
An example of an extra value is shown below, the column has no label, however the cell for row 2 has a value: |
WHAT TO DO
Check the row the preview is referring to (in the example above, row 2) and remove the extra values.
"Updating an employee's status from `active` to `pendingActivation` is not supported"
WHY
The message "Updating an employee's status from `active` to `pendingActivation` is not supported", shown in the screenshot below, means that you are trying to unarchive (setting an account to pendingActivation) an active account.
NB: Only archived accounts can be set to pendingActivation status.
|
|
WHAT TO DO
Check the row the preview is referring to (in the example above, row 2) and remove the value under the status column.