Filling out the template

Filling out the Template

To upload data into the system, you need to complete the Excel template for Timesheet Import according to the specified requirements. The structure of the template is fixed: column names, data formats, and field mandatory status cannot be changed.

Each row in the template corresponds to a single work log.

General Rules for Filling

The template must be filled strictly according to the example downloaded from the application. Changing column names, their order, or cell formats is not allowed. All required fields must be completed; otherwise, the file will not pass validation.

When filling out the template, it is important to note that some user identification fields may be left empty, however at least one of them must be provided. The user is determined by the first non-empty value in the following order: UserID, UserFullName. If none of these fields are provided or the user is not found, the row will fail.

Template Columns Description

Column

Description

Format and Constraints

TaskKey

Task key. Used to determine the task to which the work log relates

Maximum 128 characters; required field. The task must exist in the system

DateTimeStart

Work log start date and time

Format YYYY-MM-DD HH:MM:SS (e.g., 2025-10-28 13:00:00); required field

Duration

Work log duration

Positive integer; required field. Value is specified in seconds (e.g., 3600 = 1 hour)

Description

Work log description or comment

Maximum 1500 characters

UserID

Internal user identifier

Maximum 64 characters; primary user identifier. If filled, other identification fields are ignored

UserFullName

User full name

Maximum 121 characters; used if UserID and UserEmail are empty

IntegrationID

Work log integration identifier

Maximum 64 characters. Must be unique. If it matches an existing record, the work log will not be updated

Additional resources:

Timesheet

Tasks

Projects

Users