Difference between revisions of "Field: Work Setting Id"
Cg huyphong (talk | contribs) |
Cg huyphong (talk | contribs) |
||
Line 1: | Line 1: | ||
[[Category:Import module]] | [[Category:Import module]] | ||
− | | + | {{Help_Files_Import_module}} |
==Field: Work_Setting_Id== | ==Field: Work_Setting_Id== |
Revision as of 09:42, 14 December 2011
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”.
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