Add holidays with excel

Login to SPARC and open HR Leave menu, You will see below screen. 

1. Click on Holiday List button. You will see below screen.
   
2. Click on Download Template Excel button, An Excel file will be downloaded which will look like below.
3. Enter holiday date in the Holiday date[DD-MMM-yyyy] column of Excel.
4. Enter occasion in the Ocasion column of Excel. Save this file after making all entries.
5. click on Upload Holiday Excel. You will see below screen.
6. click on Choose File button and select the Excel file you saved in step 4.
7. Click on Upload button. andAll waitvalid itentries in the uploaded Excel file will uploadbe all holidays from templatedupdated and an willExcel downloadfile one Status excelwith name -`Update status of uploaded data for holidays template.xlsxxlsx' will be downloaded to track failed/successsuccessful upload.entries Rightin nowthe onuploaded yourExcel SPARC-file. All valid uploaded entries will appear in HR Leave screen all holidays will be visible like below screen shot.below.

   

   
   
8. After adding new holidays, Column holiday and Restricted Holiday will be cross. To declare it's  a holiday or Restricted holiday select either one based on location. In case if that occasion neither a Holiday or Restricted Holiday cross both of them.
9. click on save to save changes you made.

                                                                                                   - END -