Field: User Username



Field: User_Username

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