More actions
No edit summary |
No edit summary |
||
| 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 04: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:
|