Difference between revisions of "Field: User CountryId"

From Catglobe Wiki
Jump to: navigation, search
Line 1: Line 1:
−
[[Category:Import module]]
+
{{Help_Files_Import_module}}  
−
{{Help_Files_Import_module}}
 
  
−
==Field: User_CountryId==
+
== Field: User_CountryId ==
−
[[Image:611.gif]]
 
−
|- align="left" valign="top"
 
−
| style="border: 1px solid #010101" width="168" |
 
−
Auto mapping
 
−
| style="border: 1px solid #010101" width="1021" |
 
−
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
+
<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">
 +
<td width="1189" colspan="2" style="border:1px solid #010101;"><h2 class="heading2">Field: User_CountryId</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">Number</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">Country that the user lives in. Part of address information.</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">Address 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;"><p class="bodytext">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><img width="316" vspace="0" hspace="0" height="192" border="0" align="bottom" alt="" src="611.gif"></p>
 +
</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_CountryId</p>
 +
<p class="bodytext">DK: Bruger_LandId</p>
 +
<p class="bodytext">&nbsp;</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;"><p class="bodytext">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)</p>
 +
</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">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.</p>
 +
</td>
 +
</tr>
  
−
DK: Bruger_LandId
+
</tbody></table>
−
|- align="left" valign="top"
+
[[Category:Import_module]]
−
| style="border: 1px solid #010101" width="168" |
 
−
Validation
 
−
| style="border: 1px solid #010101" width="1021" |
 
−
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"
 
−
| style="border: 1px solid #010101" width="168" |
 
−
Notes
 
−
| style="border: 1px solid #010101" width="1021" |
 
−
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.
 
−
__NOTOC__
 
−
<!-- imported from file: 498.htm-->
 

Revision as of 05:37, 19 December 2011



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.
Below is an example of some IDs and countries of one systems Country table.
<img width="316" vspace="0" hspace="0" height="192" border="0" align="bottom" alt="" src="611.gif">

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.
Retrieved from "http://wiki.catglobe.com/index.php?title=Field:_User_CountryId&oldid=21030"