Field: Discount Id - Revision history

Cg_pham at 10:28, 16 December 2011

2011-12-16T10:28:34Z

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

	== Field: Discount_Id ==		== Field: Discount_Id ==

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

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| width="168" style="border:1px solid #010101;" \|		\| width="168" style="border:1px solid #010101;" \|
	Type		Type

	\| width="1021" style="border:1px solid #010101;" \|		\| width="1021" style="border:1px solid #010101;" \|
	Integer (FK)		Integer (FK)

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| width="168" style="border:1px solid #010101;" \|		\| width="168" style="border:1px solid #010101;" \|
	General Description		General Description

	\| width="1021" style="border:1px solid #010101;" \|		\| width="1021" style="border:1px solid #010101;" \|
	Discount_Id is used to specify discount systems that preferred users in the system will receive when shopping in Catglobe’s web shop.		Discount_Id is used to specify discount systems that preferred users in the system will receive when shopping in Catglobe’s web shop.

	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| width="168" style="border:1px solid #010101;" \|		\| width="168" style="border:1px solid #010101;" \|
	Import Group		Import Group

	\| width="1021" style="border:1px solid #010101;" \|		\| width="1021" style="border:1px solid #010101;" \|
	Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.<br>[[Image:672.gif]]		Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.<br>[[Image:672.gif]]

	*In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.		*In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.
	*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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!		*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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!



	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| width="168" style="border:1px solid #010101;" \|		\| width="168" style="border:1px solid #010101;" \|
	Business Rules		Business Rules

	\| width="1021" style="border:1px solid #010101;" \|		\| width="1021" style="border:1px solid #010101;" \|
	*The column name should be ‘Discount_Id’ in order to be mapped automatically when checking the ‘Auto Map’ function.		*The column name should be ‘Discount_Id’ in order to be mapped automatically when checking the ‘Auto Map’ function.
	*Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.<br>~~<img width="316" vspace="0" hspace="0" height="95" border="0" align="bottom" alt="" src="~~674.gif~~">~~		*Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.<br>[[Image:674.gif]]<br>
	*In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.		*In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.
	*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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!		*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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!



	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| width="168" style="border:1px solid #010101;" \|		\| width="168" style="border:1px solid #010101;" \|
	Validation		Validation

	\| width="1021" style="border:1px solid #010101;" \|		\| width="1021" style="border:1px solid #010101;" \|
Line 58:		Line 58:
	\|- valign="top" align="left"		\|- valign="top" align="left"
	\| width="168" style="border:1px solid #010101;" \|		\| width="168" style="border:1px solid #010101;" \|
	Notes		Notes

	\| width="1021" style="border:1px solid #010101;" \|		\| width="1021" style="border:1px solid #010101;" \|
	N/A		N/A

	\|}		\|}

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

Cg_pham at 10:27, 16 December 2011

2011-12-16T10:27:19Z

@@ Line 2: / Line 2: @@
 == Field: Discount_Id ==
-<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: Discount_Id</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">Integer (FK)</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">Discount_Id is used to specify discount systems that preferred users in the system will receive when shopping in Catglobe’s web shop.</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">Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.<br><img width="316" vspace="0" hspace="0" height="95" border="0" align="bottom" alt="" src="672.gif"></p><ul class="listbullet"><li class="listbullet">In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”. </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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!</li></ul><p class="bodytext">&nbsp;</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;"><ul class="listbullet"><li class="listbullet">The column name should be ‘Discount_Id’ in order to be mapped automatically when checking the ‘Auto Map’ function. </li><li class="listbullet">Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.<br><img width="316" vspace="0" hspace="0" height="95" border="0" align="bottom" alt="" src="674.gif"></li><li class="listbullet">In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”. </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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!</li></ul><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;"><ul class="listbullet"><li class="listbullet">The number imported to discount must exist in the table ‘Discount’ of the systems database or be NULL or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).</li></ul></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">N/A</p></td></tr>
-</tbody></table>
+{| width="1189" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic"
 [[Category:Import_module]]

Cg_pham at 10:26, 16 December 2011

2011-12-16T10:26:32Z

@@ Line 1: / Line 1: @@
-[[Category:Import module]]
+{{Help_Files_Import_module}}
-==Field: Discount_Id==
+== Field: Discount_Id ==
-[[Image:672.gif]]
+<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: Discount_Id</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">Integer (FK)</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">Discount_Id is used to specify discount systems that preferred users in the system will receive when shopping in Catglobe’s web shop.</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">Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.<br><img width="316" vspace="0" hspace="0" height="95" border="0" align="bottom" alt="" src="672.gif"></p><ul class="listbullet"><li class="listbullet">In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”. </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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!</li></ul><p class="bodytext">&nbsp;</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;"><ul class="listbullet"><li class="listbullet">The column name should be ‘Discount_Id’ in order to be mapped automatically when checking the ‘Auto Map’ function. </li><li class="listbullet">Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.<br><img width="316" vspace="0" hspace="0" height="95" border="0" align="bottom" alt="" src="674.gif"></li><li class="listbullet">In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”. </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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!</li></ul><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;"><ul class="listbullet"><li class="listbullet">The number imported to discount must exist in the table ‘Discount’ of the systems database or be NULL or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).</li></ul></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">N/A</p></td></tr>
-* In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.
+[[Category:Import_module]]

Cg huyphong at 08:25, 14 December 2011

2011-12-14T08:25:44Z

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

	==Field: Discount_Id==		==Field: Discount_Id==

Cg huyphong at 03:44, 26 April 2011

2011-04-26T03:44:51Z

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

Catglobe: jrfconvert import

2011-03-07T08:48:16Z

jrfconvert import

New page

[[Category:HelpBooks]]

==Field: Discount_Id==
[[Image:672.gif]]

* In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.
* 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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Business Rules
| style="border: 1px solid #010101" width="1021" |
* The column name should be ‘Discount_Id’ in order to be mapped automatically when checking the ‘Auto Map’ function.
* Discount can be imported using only number. Numbers are the unique ID on the database for discount and may differ between sites. You should contact your site administrator to know what discounts and related id’s that your site has available. The table below is therefore only an example of the discounts supported in one specific site. Other sites may use different numbers to recognize discounts.[[Image:674.gif]]
* In case the above table was how our discount table looked for a site, we could put in ‘2’ in the excel cell and the discount of the user would be set to “Special discount”.
* 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’ discounts you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing discounts values will be kept but rather that they will be removed!
|- align="left" valign="top"
| style="border: 1px solid #010101" width="168" |
Validation
| style="border: 1px solid #010101" width="1021" |
* The number imported to discount must exist in the table ‘Discount’ of the systems database or be NULL or an error will occur. 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" |
N/A

====
__NOTOC__