Field: Currency - Revision history

Cg_pham at 10:24, 16 December 2011

2011-12-16T10:24:59Z

← Older revision		Revision as of 10:24, 16 December 2011
Line 1:		Line 1:
	{{Help_Files_Import_module}}		{{Help_Files_Import_module}}

			== Field: Currency ==



			{\| width="1189" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic"
			\|-
			\| width="168" height="0" \|
			\| width="1020" height="0" \|
			\|- valign="top" align="left"
			\| width="1189" colspan="2" style="border:1px solid #010101;" \|
	== Field: Currency ==		== Field: Currency ==

	~~<table width="1189" cellspacing="0" cellpadding="2" border="0" style="border~~-~~collapse:collapse" class="tableintopic">~~		\|- valign="top" align="left"
	~~<tbody><tr>~~		\| width="168" style="border:1px solid #010101;" \|
	~~<td width="168" height="0"></td>~~		Type
	~~<td width="1020" height="0"></td>~~
	~~</tr>~~		\| width="1021" style="border:1px solid #010101;" \|
	~~<tr~~ valign="top" align="left">		String/Number
	~~<td~~ width="~~1189" colspan="2~~" style="border:1px solid #010101;"~~><h2 class="heading2">Field: Currency</h2>~~
	~~</td>~~		\|- valign="top" align="left"
	~~</tr>~~		\| width="168" style="border:1px solid #010101;" \|
	~~<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 #010101;" \|
	~~<td~~ width="1021" style="border:1px solid #010101;"~~><p class="bodytext">~~String/Number~~</p>~~		The currency that a user uses in the system. Currency is mainly used in Catalogue module.
	~~</td>~~
	~~</tr>~~		\|- valign="top" align="left"
	~~<tr~~ valign="top" align="left">		\| width="168" style="border:1px solid #010101;" \|
	~~<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">~~The currency that a user uses in the system. Currency is mainly used in Catalogue module.~~</p>~~		\| width="1021" style="border:1px solid #010101;" \|
	~~</td>~~		User Information
	~~</tr>~~
	~~<tr~~ valign="top" align="left">		\|- valign="top" align="left"
	~~<td~~ width="168" style="border:1px solid #010101;"~~><p class="bodytext">~~Import Group~~</p>~~		\| width="168" style="border:1px solid #010101;" \|
	~~</td>~~		Business Rules
	~~<td~~ width="1021" style="border:1px solid #010101;"~~><p class="bodytext">~~User Information~~</p>~~
	~~</td>~~		\| width="1021" style="border:1px solid #010101;" \|
	~~</tr>~~		*Currency can be imported using both number and string. Numbers are the unique ID on the database for currency and may differ between sites. You should contact your site administrator to know what currencies your site has available. The table below is therefore only an example of the currency supported in one specific site. Other sites may use different numbers to recognize currencies so it is generally best to use Character which is a unique identification. <br>[[Image:639.gif]]<br>
	~~<tr~~ valign="top" align="left">		*In case the above table was how our currency table looked for a site, we could put in ‘2’ or ‘Euro’ in the excel cell and the currency of the user would be set to Euro. Please notice that you must use same mapping of currency in all records of this column when importing. User cannot mix mapping using Number (ID) and character in the same import!
	~~<td~~ width="168" style="border:1px solid #010101;"~~><p class="bodytext">~~Business Rules~~</p>~~		*To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ currencies you are forced to update all of the users in your excel. The system will not recognize NULL as an acceptable value and instead update the existing users to get the default system currency and overwrite their existing currency.
	~~</td>~~
	~~<td~~ width="1021" style="border:1px solid #010101;"~~><ul class="listbullet"><li class="listbullet">~~Currency can be imported using both number and string. Numbers are the unique ID on the database for currency and may differ between sites. You should contact your site administrator to know what currencies your site has available. The table below is therefore only an example of the currency supported in one specific site. Other sites may use different numbers to recognize currencies so it is generally best to use Character which is a unique identification. <br>~~<img width="211" vspace="0" hspace="0" height="114" border="0" align="bottom" alt="" src="~~639.gif"><~~/li><li class="listbullet"~~>In case the above table was how our currency table looked for a site, we could put in ‘2’ or ‘Euro’ in the excel cell and the currency of the user would be set to Euro. Please notice that you must use same mapping of currency in all records of this column when importing. User cannot mix mapping using Number (ID) and character in the same import! ~~</li><li class="listbullet">~~To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ currencies you are forced to update all of the users in your excel. The system will not recognize NULL as an acceptable value and instead update the existing users to get the default system currency and overwrite their existing currency.~~</li></ul></td>~~		\|- valign="top" align="left"
	~~</tr>~~		\| width="168" style="border:1px solid #010101;" \|
	~~<tr~~ valign="top" align="left">		Auto mapping
	~~<td~~ width="168" style="border:1px solid #010101;"~~><p class="bodytext">~~Auto mapping~~</p>~~
	~~</td>~~		\| width="1021" style="border:1px solid #010101;" \|
	~~<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>~~		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 class="bodytext">~~UK: Currency~~</p>~~
	~~<p class="bodytext">~~DK: Valuta~~</p>~~		UK: Currency
	~~<p class="bodytext">~~ ~~</p>~~
	~~</td>~~		DK: Valuta
	~~</tr>~~
	~~<tr~~ valign="top" align="left">
	~~<td~~ width="168" style="border:1px solid #010101;"~~><p class="bodytext">~~Validation~~</p>~~
	~~</td>~~		\|- valign="top" align="left"
	~~<td~~ width="1021" style="border:1px solid #010101;"~~><ul class="listbullet"><li class="listbullet">~~The value imported to currency (either number or character (ISO code) must exist in the table ‘currency’ of the systems database or an error will occur. Error type: ERROR (the import job will not be allowed to be executed). ~~</li><li class="listbullet">~~If number and currency-code is mixed in one excel column, then the system will try to convert iso-code to id number. If some cells do not follow the chosen method they will be considered as ‘empty’ and ‘DefaultCurrencyForImportedUser’, as described in the ‘web.config’file, will be used as the currency of the imported user.~~</li></ul></td>~~		\| width="168" style="border:1px solid #010101;" \|
	~~</tr>~~		Validation
	~~<tr~~ valign="top" align="left">
	~~<td~~ width="168" style="border:1px solid #010101;"~~><p class="bodytext">~~Notes~~</p>~~		\| width="1021" style="border:1px solid #010101;" \|
	~~</td>~~		*The value imported to currency (either number or character (ISO code) must exist in the table ‘currency’ of the systems database or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).
	~~<td~~ width="1021" style="border:1px solid #010101;"~~><ul class="listbullet"><li class="listbullet">~~If the value in your excel cell is empty, the system will use the ‘DefaultCurrencyForImportedUser’ setting, as described in the ‘web.config’ help file, as the currency of the imported user.~~</li></ul></td>~~		*If number and currency-code is mixed in one excel column, then the system will try to convert iso-code to id number. If some cells do not follow the chosen method they will be considered as ‘empty’ and ‘DefaultCurrencyForImportedUser’, as described in the ‘web.config’file, will be used as the currency of the imported user.
	~~</tr>~~
			\|- valign="top" align="left"
			\| width="168" style="border:1px solid #010101;" \|
			Notes

			\| width="1021" style="border:1px solid #010101;" \|
			*If the value in your excel cell is empty, the system will use the ‘DefaultCurrencyForImportedUser’ setting, as described in the ‘web.config’ help file, as the currency of the imported user.

	~~</tbody></table>~~		\|}

	[[Category:Import_module]]		[[Category:Import_module]]

Cg_pham at 10:24, 16 December 2011

2011-12-16T10:24:19Z

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

Cg huyphong at 08:24, 14 December 2011

2011-12-14T08:24:49Z

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

	==Field: Currency==		==Field: Currency==

Cg huyphong at 03:36, 26 April 2011

2011-04-26T03:36:08Z

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

Catglobe: jrfconvert import

2011-03-07T08:49:07Z

jrfconvert import

New page

[[Category:HelpBooks]]

==Field: Currency==
[[Image:639.gif]]
* In case the above table was how our currency table looked for a site, we could put in ‘2’ or ‘Euro’ in the excel cell and the currency of the user would be set to Euro. Please notice that you must use same mapping of currency in all records of this column when importing. User cannot mix mapping using Number (ID) and character in the same import!
* To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ currencies you are forced to update all of the users in your excel. The system will not recognize NULL as an acceptable value and instead update the existing users to get the default system currency and overwrite their existing currency.
|- 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: Currency

DK: Valuta
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Validation
| style="border: 1px solid #010101" width="1021" |
* The value imported to currency (either number or character (ISO code) must exist in the table ‘currency’ of the systems database or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).
* If number and currency-code is mixed in one excel column, then the system will try to convert iso-code to id number. If some cells do not follow the chosen method they will be considered as ‘empty’ and ‘DefaultCurrencyForImportedUser’, as described in the ‘web.config’file, will be used as the currency of the imported user.
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Notes
| style="border: 1px solid #010101" width="1021" |
* If the value in your excel cell is empty, the system will use the ‘DefaultCurrencyForImportedUser’ setting, as described in the ‘web.config’ help file, as the currency of the imported user.
__NOTOC__