Difference between revisions of "Field: User CountryId"
(jrfconvert import) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{Help_Files_Import_module}} | |
| − | + | ||
| + | == Field: User_CountryId == | ||
| + | |||
| + | {| 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_CountryId == | ||
| + | |||
| + | |- 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);" | | ||
| + | Number | ||
| + | |||
| + | |- 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);" | | ||
| + | Country that the user lives in. Part of address information. | ||
| − | |||
| − | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| − | | style="border: 1px solid | + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | |
| + | Import Group | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Address 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);" | | ||
| + | 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.<br>Below is an example of some IDs and countries of one systems Country table.<br>[[Image:611.gif]]<br> | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
Auto mapping | Auto mapping | ||
| − | | style="border: 1px solid | + | |
| − | 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: | + | | 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_CountryId | UK: User_CountryId | ||
DK: Bruger_LandId | DK: Bruger_LandId | ||
| + | |||
| + | | ||
| + | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| − | | style="border: 1px solid | + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | |
Validation | Validation | ||
| − | | style="border: 1px solid | + | |
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
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) | 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) | ||
| + | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| − | | style="border: 1px solid | + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | |
Notes | Notes | ||
| − | | style="border: 1px solid | + | |
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
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. | 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. | ||
| − | + | ||
| − | + | |} | |
| + | |||
| + | [[Category:Import_module]] | ||
Latest revision as of 05:38, 19 December 2011
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. |
|
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. |
