|
|
|
Field: User_Username
|
|
Type
|
String
|
|
General Description
|
The user name is a unique value identifying every single user in the system
|
|
Import Group
|
User Information
|
|
Business Rules
|
- If there is not a User name column specified, User name mask can be used as an alternative method.
- User name mask is any legal character (a-Z, 1-2, underscore and dash) followed by the key/tag {0}. This tag will be replaced by the ID of the newly created user. Example of a user name mask is 'CoolUser{0}'.
- If even User name mask is not supplied, then the default mask in the system – that is ‘CAT{0}’, will be used as the user name mask for all imported Users, where {0} is the newly created Id of imported user in the system.
- New user name is created only when you are not updating an existing user in your database.
- The field used to identify updates of existing user is user_id. In other words, if user_id is specified in your excel then the user name will not be used.
|
|
Auto mapping
|
In order to ensure auto mapping then the column name in the Excel must fit with the given name in import. This name is language dependent as shown:
UK: User_Username
DK: Bruger_Brugernavn
|
|
Validation
|
- Imported user name may not exist in database already (must be unique). Error type: ERROR (the import job will not be allowed to be executed)
- User names may not contain the characters [ / ] and [ . ]. Error type: ERROR(the import job will not be allowed to be executed)
- User names should be between 6 and 50 characters. Error type: ERROR(the import job will not be allowed to be executed)
|
|
Notes
|
If you are importing to a new user and the user name is empty a user name will automatically be created for the user.
As explained above, the priority of which user names will be applied are:
- Highest: Existing users will always keep their existing user name
- Second: New users will get a user name based on mapped column
- Third: New users will get a user name based on mask
- Last: New users will get an system generated user names
|
