Import time off requests in bulk

Modified on Fri, 13 Jun at 3:47 PM

You can now import time off requests in bulk on behalf of your employees directly into Kenjo, saving time and ensuring consistency across your records.

Few important points to note before you get started,

Any requests created via this method will be marked as "submitted" (i.e. any approvals required will be skipped)

eAU will be skipped if it's enabled for a time off type
Mandatory document attachment will be skipped if it's enabled for a time off type

1. Select Import Type

Navigate to Settings > Data import
Select Time off and click Import
Choose the option Create time off requests and click Next

For DSPs: If you want to use the export file from TSM, read this article.

2. Upload Your File

Select whether the time off requests will be in Days or Hours.
Choose the language for the header columns (based on the import file language)
Click on Download our template, and a file will be downloaded to your system with the data from your account
Fill out the downloaded template
Insert the filled-out template and click Upload

Column headers with * are mandatory for the import.

How to fill in the template

For daily requests

Column headers	How to fill in the template
Work Email *	Pick the employee’s work email from the dropdown options
Time off type name *	Pick a time off type from the dropdown options
From * (YYYY-MM-DD)	Add a From date in the format YYYY-MM-DD
Part of day (From) *	Dropdown options: From start of the day From midday
To * (YYYY-MM-DD)	Add a To date in the format YYYY-MM-DD
Part of day (To) *	Dropdown options: Until midday Until end of the day
Description	Add a description if needed

For hourly requests

Column headers	Notes
Work Email *	Pick the employee’s work email from the dropdown options
Time off type name *	Pick a time off type from the dropdown options
From * (YYYY-MM-DD)	Add a From date in the format YYYY-MM-DD
To * (YYYY-MM-DD)	Add a To date in the format YYYY-MM-DD
Start hour (HH:mm) (Only for same-day requests with custom time)	Add Start hour in the format HH:mm, only for same-day requests with custom time
End hour (HH:mm) (Only for same-day requests with custom time)	Add End hour in the format HH:mm, only for same-day requests with custom time
Description	Add a description if needed

3. Map columns

1	This is the name of the mapped time off type in Kenjo
2	The green check mark indicates that the respective field has successfully been mapped
3	The black x indicates that the field was not mapped Click x to delete the Kenjo field that has been mapped by default Find the correct field via drop-down-menu and select it
4	Check this box to exclude unmapped columns

Click Confirm after mapping is complete.

4. Finalize

Review the file name
Click Finalize import to complete the process

When all data is processed you receive an email of the import. You can also view it in the Data import section, also whether errors occurred.