Difference between revisions of "Field: User Username"
Cg huyphong (talk | contribs) |
|||
| Line 1: | Line 1: | ||
| − | + | {{Help_Files_Import_module}} | |
| − | {{Help_Files_Import_module}} | ||
| − | ==Field: User_Username== | + | == Field: User_Username == |
| − | [ / ] and [ . ]. Error type: ERROR(the import job will not be allowed to be executed) | + | <table width="1189" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic"> |
| − | + | <tbody><tr> | |
| − | + | <td width="168" height="0"></td> | |
| − | + | <td width="1020" height="0"></td> | |
| − | + | </tr> | |
| − | + | <tr valign="top" align="left"> | |
| − | If you are importing to a new user and the user name is empty a user name will automatically be created for the user. | + | <td width="1189" colspan="2" style="border:1px solid #010101;"><h2 class="heading2">Field: User_Username</h2> |
| + | </td> | ||
| + | </tr> | ||
| + | <tr valign="top" align="left"> | ||
| + | <td width="168" style="border:1px solid #010101;"><p class="bodytext">Type</p> | ||
| + | </td> | ||
| + | <td width="1021" style="border:1px solid #010101;"><p class="bodytext">String</p> | ||
| + | </td> | ||
| + | </tr> | ||
| + | <tr valign="top" align="left"> | ||
| + | <td width="168" style="border:1px solid #010101;"><p class="bodytext">General Description</p> | ||
| + | </td> | ||
| + | <td width="1021" style="border:1px solid #010101;"><p class="bodytext">The user name is a unique value identifying every single user in the system</p> | ||
| + | </td> | ||
| + | </tr> | ||
| + | <tr valign="top" align="left"> | ||
| + | <td width="168" style="border:1px solid #010101;"><p class="bodytext">Import Group</p> | ||
| + | </td> | ||
| + | <td width="1021" style="border:1px solid #010101;"><p class="bodytext">User Information</p> | ||
| + | </td> | ||
| + | </tr> | ||
| + | <tr valign="top" align="left"> | ||
| + | <td width="168" style="border:1px solid #010101;"><p class="bodytext">Business Rules</p> | ||
| + | </td> | ||
| + | <td width="1021" style="border:1px solid #010101;"><ul class="listbullet"><li class="listbullet">If there is not a User name column specified, User name mask can be used as an alternative method. </li><li class="listbullet">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}'.</li><li class="listbullet">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. </li><li class="listbullet">New user name is created only when you are not updating an existing user in your database. </li><li class="listbullet">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.</li></ul></td> | ||
| + | </tr> | ||
| + | <tr valign="top" align="left"> | ||
| + | <td width="168" style="border:1px solid #010101;"><p class="bodytext">Auto mapping</p> | ||
| + | </td> | ||
| + | <td width="1021" style="border:1px solid #010101;"><p class="bodytext">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: </p> | ||
| + | <p class="bodytext">UK: User_Username</p> | ||
| + | <p class="bodytext">DK: Bruger_Brugernavn</p> | ||
| + | <p class="bodytext"> </p> | ||
| + | </td> | ||
| + | </tr> | ||
| + | <tr valign="top" align="left"> | ||
| + | <td width="168" style="border:1px solid #010101;"><p class="bodytext">Validation</p> | ||
| + | </td> | ||
| + | <td width="1021" style="border:1px solid #010101;"><ul class="listbullet"><li class="listbullet">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)</li><li class="listbullet">User names may not contain the characters [ / ] and [ . ]. Error type: ERROR(the import job will not be allowed to be executed)</li><li class="listbullet">User names should be between 6 and 50 characters. Error type: ERROR(the import job will not be allowed to be executed)</li></ul></td> | ||
| + | </tr> | ||
| + | <tr valign="top" align="left"> | ||
| + | <td width="168" style="border:1px solid #010101;"><p class="bodytext">Notes</p> | ||
| + | </td> | ||
| + | <td width="1021" style="border:1px solid #010101;"><p class="bodytext">If you are importing to a new user and the user name is empty a user name will automatically be created for the user. </p> | ||
| + | <p class="bodytext">As explained above, the priority of which user names will be applied are:</p> | ||
| + | <ul class="listbullet"><li class="listbullet">Highest: Existing users will always keep their existing user name</li><li class="listbullet">Second: New users will get a user name based on mapped column</li><li class="listbullet">Third: New users will get a user name based on mask</li><li class="listbullet">Last: New users will get an system generated user names</li></ul></td> | ||
| + | </tr> | ||
| − | + | </tbody></table> | |
| − | + | ||
| − | + | [[Category:Import_module]] | |
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 05:39, 19 December 2011
Field: User_Username
<tbody> </tbody>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:
|
