Import vacation balances to keep them all up to date across systems
Core HR > Account Data > Import Data
If you are using your payroll system to calculate leave balances then you might want to import these into Ento.
If you are using Ento to allow to view their balances and to be able to apply for different types of leave then you are going want to routinely export this information from your payroll system then import it into Ento.
Importing vacation balances
To start a new file import, go to Core HR > Account data > Import data and click Create new.
Open the Type dropdown list and select ‘Vacation balances’. This name may change depending on your chosen terminology.
The purple bar under the file selection will then update to include a ‘Click here’ link for downloading a CSV template that includes all the fields necessary to get importing.
Select ‘Create’ as the Mode – this will overwrite the existing Leave balances, so is effectively creating a new balance.
File import format
ID and Leave Balance ID are the required fields (*as indicated by asterisk)
Leave types that can be imported
Name | Data type | Length limit | Example | Mandatory | Description |
Staff ID | String | 20 | ST10001 | Yes |
The ID of the the balance belongs to. Must match a predefined, non-deleted ID.
|
Leave balance ID | String | 20 | LB10001 | Yes |
The ID of the leave balance. Must match a predefined, non-deleted leave balance ID.
|
Balance | Number | 10,0 | 83.76523541 | No |
The current leave balance. Can be have up to 10 decimals.
|
Other ways to import leave balances
If your payroll system exports in a format where there is only one line for each , with a column for each type of leave, you may be better of using update import.
ID and First name are the required fields (*as indicated by asterisk) for import.
Please note this should be run as an Update import, so only the leave balance fields are updated.
More information on preparing and other import files can be found in Importing data overview.
Other relevant articles
Import Data Overview
Leave Type Report
Leave Liability Report