Field: User Username

From Catglobe Wiki
Jump to: navigation, search



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