Field: User CountryId
Field: User_CountryId
<tbody> </tbody>Field: User_CountryId |
|
Type |
Number |
General Description |
Country that the user lives in. Part of address information. |
Import Group |
Address information |
Business Rules |
One user has only one country. User can either insert or update this value when importing. To update this field for existing users, you must select a User_Id column in step 1 of the import wizard and the value of this column will be used to determine which user’s record to update. Country can be imported using only numbers. Numbers are the unique ID on the database for country and may differ between sites. You should contact your site administrator to know what countries your site has available. The table below is therefore only an example of the countries supported in one specific site. Other sites may use different IDs to recognize countries so it is generally a necessity to get the full list of countries and their IDs exported. |
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_CountryId DK: Bruger_LandId
|
Validation |
ID must be in the list of [Id] values in Country table in database. If imported value is not a number or a valid [Id] value, then an error message will be shown to let the user know. Error type: ERROR (the import job will not be allowed to be executed) |
Notes |
Country is also used in import phone number to specify the country code of imported phone. Please refer to this help file for more information. |
