During an import (users, SmartOrg, attributes), Zest automatically analyzes your CSV file to check its consistency, format, and compliance with business rules.
If an anomaly is detected, the import is blocked to prevent incorrect data from breaking your SmartOrg or making an Employee inaccessible.
Here is the complete list of possible errors, their meaning, and how to quickly fix them.
🔎 1. CSV analysis & validation
These errors concern file quality: column spelling, data format, value type…
| Error code | Purpose |
|---|---|
| CSV_UNKNOWN_COLUMN_OR_ATTRIBUTE | Check for a misspelled column. |
| CSV_MISSING_EMAIL_AND_USERID | Check for missing email and userId. |
| CSV_INVALID_VALUE | Check values in a list field. |
| CSV_INVALID_VALUE_NO_RECO | Check incorrect value without any match. |
| CSV_INVALID_COUNTRY_CODE | Check that the country code is ISO compliant. |
| CSV_INVALID_BOOLEAN_VALUE | Check valid boolean format. |
| CSV_INVALID_DATA_TYPE | Check the data type. |
| CSV_INVALID_EMAIL_FORMAT | Check the email format. |
🧩 2. Integrity & business rules
These errors concern SmartOrg and user consistency
| Error code | Purpose |
|---|---|
| IMPORT_DUPLICATED_EMAIL | Check for duplicate email addresses. |
| IMPORT_DUPLICATED_USERID | Check for duplicate userId. |
| IMPORT_DUPLICATED_SSOLOGIN | Check for duplicate ssoLogin. |
| IMPORT_MANAGEMENT_LOOP | Check that a manager is not managing themselves or creating a loop. |
| IMPORT_MANAGER_NOT_EXISTS | Check that the manager exists. |
| IMPORT_MANAGERID_EQUAL_EMAIL_USERID | Check that managerId is not equal to email/userId. |
| IMPORT_EMAIL_ALREADY_EXISTS | Check whether the email already exists in the database. |
| IMPORT_SUPERADMIN_MISSING_EMAIL | Check that a Super Admin has an email. |
Zest tip:
👉 These errors protect your SmartOrg. They prevent broken structures, which could block data display or disrupt managers.
🧮 3. Errors related to imports by an Administrator
These errors appear when a department or location admin tries to import data outside their scope.
| Error code | Purpose | Standard error message |
|---|---|---|
| IMPORT_ADMIN_PERIMETER_ACCESS_DENIED | Prevent an unauthorized Administrator from performing actions outside their scope. | "You cannot perform actions on {$$}, as you do not have admin rights for this scope. This action is reserved for the Super Admin or the Administrator of the user's original scope." |
| IMPORT_ADMIN_CURRENT_PERIMETER_ACCESS_DENIED | Block an Administrator trying to act on a user outside their current scope. | "You cannot perform actions on {$$}, as you do not have admin rights for this scope. This action is reserved for the Super Admin or the Administrator of the user's original scope." |
| IMPORT_ADMIN_NO_CURRENT_PERIMETER | Prevent actions on users without a defined scope. | "These users do not currently belong to any scope. Only a Super Admin can perform actions on these users." |
| IMPORT_ADMIN_NEW_USER_RANK_DENIED | Check that a standard admin cannot assign a higher role (e.g. Super Admin). | "You cannot assign the role {%%} to a user. Only a Super Admin can perform this action." |
| IMPORT_ADMIN_CHANGE_USER_RANK_DENIED | Check that an admin cannot modify a user’s role without sufficient privileges. | "You cannot modify a user's role (current role: {%%}). Only a Super Admin can perform this action." |
Zest tip:
👉 Delegated imports allow more autonomy for admins, while maintaining full security:
a local admin cannot modify a global Employee.
🧭 Best practices to avoid 90% of errors
- Always use the Zest template file.
- Check the exact spelling of departments and locations.
- Never leave the email, userId, rank, status, lang columns empty.
- Paste as values to avoid Excel formulas.
- Remove empty rows.
- Date format → YYYY-MM-DD (UK).
- Check the consistency of managerId.
- Check for duplicates (email, userId, ssoLogin).
✔️ In summary
This article helps you to:
- quickly understand the source of errors,
- fix the most common issues,
- secure your SmartOrg and Employee data,
- streamline your imports and avoid back-and-forth corrections.