Hello. How can we help you?

How to assign shifts under the shift roster, via excel upload?

1) Navigate to “Shift Roster” from “Admin Settings” as illustrated below.

2) Click the “Shift Bulk Upload” button followed by the “Download” button to export the sample CSV file.

3) Please consider the following points while filling the CSV file.

• Please ensure the date format is in YYYY/MM/DD.

• Please provide the working hours for each employee using the given codes, which represent different working days. For instance, if an employee’s shift is from 9:00 AM to 5:00 PM on Monday (a full working day), you would enter it as 0900-1700/1. Here are the codes and their meanings:

Code	Meaning
1	Full Working Day
2	Half Working Day
3	Full Extra Working Day
4	Half Extra Working Day
5	Full Compensatory Off
6	Half Compensatory Off
7	Half Leave
8	Full Leave
9	Weekly Off
10	Holiday

Please check the below example :

Note – Ensure that all 7 days of shifts are correctly added while uploading the csv file.

4) Save the CSV file and upload the same by clicking on the “browse”  label.

5) Once added successfully, click on the “Save” button to upload the CSV file.