Import absence

How to import absence registrations and absence allowances.

Import Absence Registrations

Go to Employees in the main menu.
Go to the Absence tab.
Click on the downward arrow icon to import.
Select Import absence registration.
Fill out the Excel file with some suggested fields listed below.

Note

You can download the example Excel file by clicking on the link titled "AbsenceRegistrationExample.xlsx"
- Employee ID: Can be the employee number or e-mail.
- Leave type: Enter the leave type for which an absence needs to be registered in Emply.
- Absence start date: Enter the start date of the leave.
- Absence end date: Enter the end date of the leave.
- Comment: Enter a comment if this needs to be uploaded into Emply.
Caution

Important considerations: The Excel fields should be in "text" format & it is not possible to import half days for absence registrations.
Click on Upload excel- under Import absence registrations- and proceed to upload.
Click on Continue.
Map the Excel fields to Emply values by matching an Emply value from the drop down to the different Excel fields.
Note

Notes to consider:
- Four mandatory elements need to be matched: Employee ID, Leave types, Start date, & End date
- The date format should always match the format of the Excel file, e.g. dd.MM.yyyy, dd-MM-yyyy, etc.
Click on Import.
Absence registration will be added for the employees included in the import files.

Import absence allowances

1. Go to the main menu - Employees.
Go to the Absence tab.
Click on the downward arrow icon to import.
Select Import absence allowances.
Fill out the Excel file- you can download an example Excel file by clicking on the link "AbsenceAllowancesExample.xlsx."

Note

You can download the example Excel file by clicking on the link titled "AbsenceRegistrationExample.xlsx"
- Employee ID: This can be the employee number or e-mail.
- Leave type A: Enter the number of days that should be added for "Leave type A".
  
  The actual leave type this refers to will be mapped in step 5 (see below).
- Leave type B: Enter the number of days that should be added for "Leave type B".
  
  The actual leave type this refers to will be mapped in step 5 (see below).
- Leave type C: Enter the number of days that should be added for "Leave type C".
  
  The actual leave type this refers to will be mapped in step 5 (see below).
Note

The Excel fields should be in "text" format.
Click on Upload excel under Import absence allowances.
Click on Continue.
Match the Excel fields to the Emply values by first choosing whether the days should be added to the current vacation year or the previous one in the top left corner. Then, match an Emply value from the drop down list to the different Excel fields.

Note

At lease two elements need to be matched: Employee ID and leave type.
Click on Import.
The allowances will be added for the employees included in the import files.

Was this article helpful?