Field: User CountryId - Revision history

Cg_pham at 04:38, 19 December 2011

2011-12-19T04:38:35Z

← Older revision		Revision as of 04:38, 19 December 2011
Line 1:		Line 1:
	{{Help_Files_Import_module}}		{{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 ==		== Field: User_CountryId ==

	~~<table width="1189" cellspacing="0" cellpadding="2" border="0" style="border~~-~~collapse:collapse" class="tableintopic">~~		\|- align="left" valign="top"
	~~<tbody><tr>~~		\| width="168" style="border: 1px solid rgb(1, 1, 1);" \|
	~~<td width="168" height="0"></td>~~		Type
	~~<td width="1020" height="0"></td>~~
	~~</tr>~~		\| width="1021" style="border: 1px solid rgb(1, 1, 1);" \|
	~~<tr valign="top"~~ align="left">		Number
	~~<td width="1189" colspan="2" style="border:1px solid #010101;"><h2 class="heading2">Field: User_CountryId</h2>~~
	~~</td>~~		\|- align="left" valign="top"
	~~</tr>~~		\| width="168" style="border: 1px solid rgb(1, 1, 1);" \|
	~~<tr~~ valign="top" ~~align="left">~~		General Description
	~~<td~~ width="168" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Type~~</p>~~
	~~</td>~~		\| width="1021" style="border: 1px solid rgb(1, 1, 1);" \|
	~~<td~~ width="1021" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Number~~</p>~~		Country that the user lives in. Part of address information.
	~~</td>~~
	~~</tr>~~		\|- align="left" valign="top"
	~~<tr valign~~="~~top~~" ~~align~~="~~left~~">		\| width="168" style="border: 1px solid rgb(1, 1, 1);" \|
	~~<td~~ width="168" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~General Description~~</p>~~		Import Group
	~~</td>~~
	~~<td~~ width="1021" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Country that the user lives in. Part of address information.~~</p>~~		\| width="1021" style="border: 1px solid rgb(1, 1, 1);" \|
	~~</td>~~		Address information
	~~</tr>~~
	~~<tr valign~~="~~top~~" ~~align~~="~~left~~">		\|- align="left" valign="top"
	~~<td~~ width="168" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Import Group~~</p>~~		\| width="168" style="border: 1px solid rgb(1, 1, 1);" \|
	~~</td>~~		Business Rules
	~~<td~~ width="1021" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Address information~~</p>~~
	~~</td>~~		\| width="1021" style="border: 1px solid rgb(1, 1, 1);" \|
	~~</tr>~~		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>
	~~<tr valign~~="~~top~~" ~~align~~="~~left~~">
	~~<td~~ width="168" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Business Rules~~</p>~~		\|- align="left" valign="top"
	~~</td>~~		\| width="168" style="border: 1px solid rgb(1, 1, 1);" \|
	~~<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>		Auto mapping
	~~</td>~~
	~~</tr>~~		\| width="1021" style="border: 1px solid rgb(1, 1, 1);" \|
	~~<tr valign~~="~~top~~" ~~align~~="~~left~~">		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:
	~~<td~~ width="168" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Auto mapping~~</p>~~
	~~</td>~~		UK: User_CountryId
	~~<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>~~		DK: Bruger_LandId
	~~<p class="bodytext">~~DK: Bruger_LandId~~</p>~~
	~~<p class="bodytext">~~ ~~</p>~~
	~~</td>~~
	~~</tr>~~		\|- align="left" valign="top"
	~~<tr valign~~="~~top~~" ~~align~~="~~left~~">		\| width="168" style="border: 1px solid rgb(1, 1, 1);" \|
	~~<td~~ width="168" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Validation~~</p>~~		Validation
	~~</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>~~		\| width="1021" style="border: 1px solid rgb(1, 1, 1);" \|
	~~</td>~~		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)
	~~</tr>~~
	~~<tr valign~~="~~top~~" ~~align~~="~~left~~">		\|- align="left" valign="top"
	~~<td~~ width="168" style="border:1px solid ~~#010101~~;"~~><p class="bodytext">~~Notes~~</p>~~		\| width="168" style="border: 1px solid rgb(1, 1, 1);" \|
	~~</td>~~		Notes
	~~<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>~~		\| width="1021" style="border: 1px solid rgb(1, 1, 1);" \|
	~~</tr>~~		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.

			\|}

	~~</tbody></table>~~
	[[Category:Import_module]]		[[Category:Import_module]]

Cg_pham at 04:37, 19 December 2011

2011-12-19T04:37:28Z

@@ Line 1: / Line 1: @@
-[[Category:Import module]]
+{{Help_Files_Import_module}}
-==Field: User_CountryId==
+== Field: User_CountryId ==
-UK: User_CountryId
+<table width="1189" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic">
-DK: Bruger_LandId
+</tbody></table>
-|- align="left" valign="top"
+[[Category:Import_module]]

Cg huyphong at 08:38, 14 December 2011

2011-12-14T08:38:47Z

← Older revision		Revision as of 08:38, 14 December 2011
Line 1:		Line 1:
	[[Category:Import module]]		[[Category:Import module]]
			{{Help_Files_Import_module}}

	==Field: User_CountryId==		==Field: User_CountryId==

Cg huyphong at 03:58, 26 April 2011

2011-04-26T03:58:30Z

← Older revision		Revision as of 03:58, 26 April 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Import module]]

Catglobe: jrfconvert import

2011-03-07T09:09:58Z

jrfconvert import

New page

[[Category:HelpBooks]]

==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

DK: Bruger_LandId
|- align="left" valign="top"
| 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__