Imports users, matching on the user name and creating or updating user accounts, organizational unit and group memberships.
1. Select the action in the Action field. 2. Point to your data source – a file (CSV or Excel) or a SQL query. 3. Map the source columns to Sapera's fields in the column mapping (see Source fields below). 4. Run Compare to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run Update Sapera to perform the import.
Use the Allow create and Allow update parameters to control whether new rows are created and whether existing ones are updated.
Each row is matched on the user name (Name). Matching users are updated and new ones created – with organizational unit and group memberships. Direction: from file/SQL into Sapera.
Parameter | Explanation |
| When enabled, users that do not already exist are created. |
| When enabled, existing users are updated with the imported values. |
| When enabled, group memberships not present in the import are removed from the user. |
| When enabled, the matched users are deleted instead of created or updated. |
Field | Explanation |
| The display name shown for the user. |
| The user's e-mail address. |
| First group the user is added to as a member. |
| Second group the user is added to as a member. |
| Third group the user is added to as a member. |
| Unique user name that identifies the user and is used to match existing records. |
| The organizational unit the user belongs to. |
| The password assigned to the user. |
See also the overview SyncTool – actions.