Field: User CountryId



Field: User_CountryId

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. Below is an example of some IDs and countries of one systems Country table.
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.