Bulk Upload - Employee Working Patterns
The below article is relating to the bulk upload - Employee Working Patterns which can be found by navigating to:
Administration -> Company -> Bulk Upload
The Employee Working Patterns bulk upload is under the Time and Attendance section here:
Once you've clicked the Employee Working Patterns Bulk Upload button you will be directed to this page:
This page includes:
In the CSV the first column is called employee ID, this setting relates to what you enter in that column, For example if you have used the employee's names in the CSV the employee name option will need to be selected.
Include archived employees in search?
When using name or Works ID method, sometimes you may have multiple instances of the same employee with on active and one archived - if you set this to NO we will not search archived employees when marching and will only search your active employees. If you had 2 active employees of the same name, for example, this setting would make no difference.
CSV file to upload
This is where you will load your CSV when it is ready to upload. Press browse and select the CSV file.
Download help file and instructions
This option will download our bulk upload help file. This includes instructions on how to use each bulk upload and lets you know which columns are mandatory and which are optional, it's important to look at the relevant help file before performing a bulk upload so you can get it right the first time.
Download CSV Model
This option downloads an example template for you to use for the bulk upload with all the headers needed for the bulk upload to be successful.
Editing your CSV:
When you download your sample CSV file it will look like this:
Employee - This field relates to your chosen Employee field on the bulk upload page, if you have chosen employee name this will be the employee's first and last name exactly as they are on NaturalHR, if this is either the system or Works ID, this will be either of those IDs exactly as they are in NaturalHR too. This field is Mandatory and Case Sensitive.
Working Pattern - The name of the working pattern that you're publishing to this employee. This must be exactly as the working pattern is entered in the system. This field is Case Sensitive and Mandatory.
Effective Date - The date that this working pattern starts for this employee. This must be entered in dd/mm/yyyy format. This field is Mandatory.
End Date - The date that this working pattern will end for this employee. This must be entered in dd/mm/yyyy format. This field is Optional if it is not entered the working pattern will be published to the end of the year.
Please Note: This process will remove ALL employee working patterns added for the employee between the dates entered and replace them with the values from your upload file - this cannot be undone so please ensure the dates etc are correct before proceeding.
Please sign in to leave a comment.