Migrate time off data from TSM

This article will guide you through the process of importing TSM time off request data into Kenjo using the bulk upload feature.

TABLE OF CONTENT

• Basics
• Step 1: Select Import Type
• Step 2: Upload Your File
• Step 3: Map Your Data
• Step 4: Map Time Off Types
• Step 5: Finalize Import

Basics

Kenjo allows you to import historical time off request data via a TSM export. This is particularly useful for maintaining compliance, ensuring accurate records, and facilitating a smooth transition from systems.

Before you initiate the migration, it’s important to understand how we transform the data from TSM and how historical data will appear in Kenjo after the migration. 

Note: The file for time off data and attendance data is the same. Check out how to download it here. 

Example:

• Information from the TSM export file looks like this:

Kenjo processes this data like this:

• Employee 2 has an approved hourly paid time off of 8 hours on Friday 21st March 2025 
• The time off entry belongs to the paid time off (PTO) type vacation (Urlaub)

Once you perform the migration, Kenjo does the following: 

• maps the Employee # to the Employee ID field in Kenjo to identify the respective employee
• creates an inactive policy under the mapped time off category
• creates a time off request with the following aspects:

Full day hourly requests	number of hours = value under PAID TIME OFF column in the file
Status	is submitted (i.e. already approved)
Description	value under SITE NAME column in the file

Step 1: Select Import Type

• Navigate to Settings > Data import
• Select Time off and click Import
• Choose the option Migrate with TSM export and click NEXT

Step 2: Upload Your File

• Select the language of your file’s header columns (e.g. English).
• Drag and drop your TSM export file (CSV/XLSX format) or select it from your computer.
• Click UPLOAD once the file is attached.

Step 3: Map Your Data

In this step, you don't need to take any action. If the correct export file was uploaded in the previous step, Kenjo converts the time-off data from TSM into our system format and allows you to continue the import. 

If there is an error on this step, please check if you have the right file from TSM. 

• Click Confirm to proceed to next step

Step 4: Map Time Off Types

Kenjo will map Paid time off types identified from the file to the time off types available in Kenjo. For unmapped time off types you need to select the correct time off type using the drop-down menu. 

Note: In France, PRIME D'INTERVENTION is skipped, as this is handled as an Attendance category in Kenjo.

• Click Confirm after mapping is complete.

Step 5: Finalize Import

• 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.