The import of users is performed in the Admin Panel -> User Management -> Import Users. The import can be performed from CSV and Excel files.
There are two sections on the Import Users page:
| • | System Import Values |
| • | Data Import |
System Import Values
This section determines the default User Group to perform the import to and the status of the imported users.
Data Import
The following settings for the data import are set:
| • | the importing file |
| • | its format (CSV or Excel) |
| • | the field delimiter for the CSV file |
| • | the action to be performed for the new values of the list type: |
o new values can be either added to the database or can be ignored leaving this field empty in the user profile.
The priority of the User Group:
If the user_group field exists in the import file, then
| • | If a defined User Group value exists in the system, the user is assigned to that User Group. |
| • | If a defined User Group value does not exist in the system, or if this field is empty, then |
o If the User Group field value is selected, the user is assigned to that User Group.
o If the User Group field value is NOT selected, the user is not imported.
If the user_group field does NOT exist in the import file, then
| • | If the User Group field value is selected, the user is assigned to that User Group. |
| • | If the User Group field value is NOT selected, the user is not imported. |
Import File Requirements
The first row in the file must contain fields' ids All following rows are filled with the user data.
The username field is mandatory and has to be part of the import file:
| • | The file that has no username field is not imported. In this case, the Admin gets a message saying that the import was not performed due to lack of the username field. |
| • | The user with the empty username field value is not imported. In this case, after the import is performed, Admin gets a message saying that in the imported file there are x rows that have empty username field values. |
The Report
After the import is performed, Admin sees the report informing the amount of imported users as well as the total amount of rows in the import file. If due to some reason not all users were imported, Admin is shown the report specifying the numbers of not imported rows in the file and the error occurred.
