Field: Work Setting Id

From Catglobe Wiki
Revision as of 10:08, 7 March 2011 by 127.0.0.1 (talk | contribs) (jrfconvert import)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



Field: Work_Setting_Id

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