Entitlements given to the employee for each leave type can be updated in Lenvica HRMS using an excel(CSV) file. The count of leaves in credit for each employee will be different as the consumption of leaves would be different for all. In such cases, an option to import from excel file comes in handy for the user to update leave balances of all employees in bulk to Lenvica HRMS.
![Bio-metric Devices Bio-metric Devices](https://lenvica.com/wp-content/uploads/2017/06/attendhrm-face-device.jpg)
Excel(CSV) Template for Leave Import
- Employee ID: Specify the employee id of employees in the first column.
- Attendance Type: The type of leave for which entitlements are to be imported. e.g. Casual Leave, Earned Leave etc
- Year: The leave year for which the entitlement is being updated.
- Carry Forward: Count of leaves that are being carry forwarded from last year.
- January – Decemeber: The columns after the carry forward is for each month in the leave year. You can specify the count of leaves entitled for each month under the corresponding columns.
Entitlements Import
- Use the template and create the excel csv format for the leave entitlements import. Click ‘Import Entitlements’ under the Leave module.
Select the new import format and give a name for the import process. Move to the next screen of the wizard. Specify the file and it’s path in the field ‘File Name’. Check mark the ‘Has header?’ button. Choose the delimiting character radio button ‘Others’ and specify ‘,(comma)’ in the box. You can note that the file contents space in the screen of the wizard will display the contents in the import file selected. Move to the next screen.
Map the fields in the system with the corresponding fields in the file we are importing. Proceed to next screen which displays the columns that will be imported. Click next for the import process to initiate. Move to next screen.
The last screen of wizard give a summary of the import process completed, enlisting the count of records imported into Lenvica HRMS and records with error, if any. Click finish to complete the procedure. Check the ‘Entitlements’ screen under leave module or check the leave reports to see the entitlements given to the employees.
Leave A Comment
You must be logged in to post a comment.