Difference between revisions of "Field: User Username"
| Line 1: | Line 1: | ||
{{Help_Files_Import_module}} | {{Help_Files_Import_module}} | ||
| + | == Field: User_Username == | ||
| + | |||
| + | {| width="1189" class="tableintopic FCK__ShowTableBorders" style="border-collapse: collapse;" border="0" cellspacing="0" cellpadding="2" | ||
| + | |- | ||
| + | | width="168" height="0" | | ||
| + | | width="1020" height="0" | | ||
| + | |- align="left" valign="top" | ||
| + | | width="1189" style="border: 1px solid rgb(1, 1, 1);" colspan="2" | | ||
== Field: User_Username == | == Field: User_Username == | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | |- align="left" valign="top" | |
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Type | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | String | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | General Description | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | The user name is a unique value identifying every single user in the system | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Import Group | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | User Information | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Business Rules | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | *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. | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Auto mapping | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | 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 | ||
| + | |||
| + | | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Validation | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | *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) | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Notes | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | 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 | ||
| + | |} | ||
[[Category:Import_module]] | [[Category:Import_module]] | ||
Latest revision as of 06:39, 19 December 2011
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 |
|
|
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 |
|
|
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:
|
