Field: Work Setting Id - Revision history

Cg_pham at 04:45, 19 December 2011

2011-12-19T04:45:59Z

Cg_pham at 04:45, 19 December 2011

2011-12-19T04:45:16Z

← Older revision		Revision as of 04:45, 19 December 2011
Line 3:		Line 3:

	==Field: Work_Setting_Id==		==Field: Work_Setting_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: Work_Setting_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">Work setting is a feature used for specifying holidays and weekend days for users. These work settings can be set up using the work settings module. Please refer to these files for more 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">User (Advanced)</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>
			</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">Work setting can be imported using only number. Numbers are the unique ID on the database for work setting and may differ between sites. You should contact your site administrator to know what work settings and related id’s that your site has available. The table below is therefore only an example of the work settings supported in one specific site. Other sites may use different numbers to recognize work settings.<br><img width="316" vspace="0" hspace="0" height="91" border="0" align="bottom" alt="" src="782.gif"></p>
			<p class="bodytext">In case the above table was how our work setting table looked for a site, we could put in ‘8’ in the excel cell and the work setting of the user would be set to “German vacation”. </p>
			<p class="bodytext">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’ work settings 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 work settings values will be kept but rather that they will be removed!</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">The number imported to work setting must exist in the table ‘Work_Setting’ 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).</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">N/A</p>
			</td>
			</tr>

			</tbody></table>

Cg_pham: Replaced content with "Category:Import module {{Help_Files_Import_module}} ==Field: Work_Setting_Id=="

2011-12-19T04:44:42Z

Replaced content with "Category:Import module {{Help_Files_Import_module}} ==Field: Work_Setting_Id=="

← Older revision		Revision as of 04:44, 19 December 2011
Line 3:		Line 3:

	==Field: Work_Setting_Id==		==Field: Work_Setting_Id==
	~~[[Image:782.gif]]~~

	~~In case the above table was how our work setting table looked for a site, we could put in ‘8’ in the excel cell and the work setting of the user would be set to “German vacation”.~~

	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’ work settings 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 work settings 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 work setting must exist in the table ‘Work_Setting’ 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__~~
	~~<!-- imported from file: 496.htm-->~~

Cg huyphong at 08:42, 14 December 2011

2011-12-14T08:42:21Z

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

	==Field: Work_Setting_Id==		==Field: Work_Setting_Id==

Cg huyphong at 04:01, 26 April 2011

2011-04-26T04:01:12Z

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

Catglobe: jrfconvert import

2011-03-07T09:08:19Z

jrfconvert import

New page

[[Category:HelpBooks]]

==Field: Work_Setting_Id==
[[Image:782.gif]]

In case the above table was how our work setting table looked for a site, we could put in ‘8’ in the excel cell and the work setting of the user would be set to “German vacation”.

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’ work settings 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 work settings 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 work setting must exist in the table ‘Work_Setting’ 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__

Field: Work Setting Id - Revision history

Cg_pham at 04:45, 19 December 2011

Cg_pham at 04:45, 19 December 2011

Cg_pham: Replaced content with "Category:Import module ﻿{{Help_Files_Import_module}} ==Field: Work_Setting_Id=="

Cg huyphong at 08:42, 14 December 2011

Cg huyphong at 04:01, 26 April 2011

Catglobe: jrfconvert import

Cg_pham: Replaced content with "Category:Import module {{Help_Files_Import_module}} ==Field: Work_Setting_Id=="