Difference between revisions of "Field: Work Setting Id"
Cg huyphong (talk | contribs) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{Help_Files_Import_module}} | |
| − | | ||
| − | ==Field: Work_Setting_Id== | + | == Field: Work_Setting_Id == |
| − | |||
| − | 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”. | + | {| 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: Work_Setting_Id == | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Type | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Integer (FK) | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | General Description | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | 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. | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Import Group | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | User (Advanced) | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Auto mapping | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | 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: | ||
| + | |||
| + | |- align="left" valign="top" | ||
| + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | Business Rules | ||
| + | |||
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
| + | 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>[[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! | 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" | |- align="left" valign="top" | ||
| − | | style="border: 1px solid | + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | |
Validation | Validation | ||
| − | | style="border: 1px solid | + | |
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
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). | 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" | |- align="left" valign="top" | ||
| − | | style="border: 1px solid | + | | width="168" style="border: 1px solid rgb(1, 1, 1);" | |
Notes | Notes | ||
| − | | style="border: 1px solid | + | |
| + | | width="1021" style="border: 1px solid rgb(1, 1, 1);" | | ||
N/A | N/A | ||
| − | + | ||
| − | + | |} | |
| + | |||
| + | [[Category:Import_module]] | ||
Latest revision as of 05:45, 19 December 2011
Field: Work_Setting_Id
Field: Work_Setting_Id | |
|
Type |
Integer (FK) |
|
General Description |
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. |
|
Import Group |
User (Advanced) |
|
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: |
|
Business Rules |
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. 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! |
|
Validation |
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). |
|
Notes |
N/A |
