Import Time Card Data from Excel

Overview

The Import from Excel functionality allows users to upload Time Card data from an Excel file directly into the Time Card document.

Starting from Contracting release version 2.1.1.35, a standard Excel import process became available for Time Card documents.

Before release 2.1.1.35, Excel import was not included as standard functionality. If an Excel upload process was required, it could be implemented by creating a customer-specific template or by applying additional customization.

In release 2.1.1.35, the standard import functionality was introduced as a separate extension.

Starting from release 2.1.1.36, the Import from Excel functionality is included in the standard product package and is available directly from the Time Card document grid without additional installation.

Before using the import functionality for the first time, a one-time configuration is required. After the initial setup is completed, the selected settings will be automatically applied to all future imports.

Availability

The Import from Excel functionality is available:

• As a separate extension in Contracting release 2.1.1.35. To enable this functionality, please contact the Hotline Support team.
• As part of the standard product package starting from Contracting release 2.1.1.36.

Initial Configuration

Before performing the first import, configure the following settings.

Configure Date Format

1. Open the Import from Excel settings.
2. Select the required date format from the available options.
3. Save the configuration.

The selected date format will be used by the system to correctly interpret dates in uploaded Excel files.

Configure Time Type Mapping

To ensure that Time Card entries are imported correctly, configure the mapping between:

• Time types used in the Excel file.
• Time types available in the system.

Make sure that all time types that may appear in your Excel files are included in the mapping configuration.

Example:

Import Data from Excel

After the initial configuration has been completed:

1. Open the required Time Card document.
2. Navigate to the document grid - Time Details tab.
3. Select Import from Excel option.
4. Push Download Data From Excel option.
5. Select excel file on computer with Select From Disk and ther push Load option.
6. Select required document lines.

Excel File Requirements

For a successful import, ensure that your Excel file:

• follows the required data structure;
• uses the configured date format;
• contains Time Types included in the Time Type Mapping settings.

A sample Excel template is provided with this user guide and can be used as a reference for preparing your import file.

You can download the Excel template here, fill it in with your Time Card data, and upload the completed file to the system using the Import from Excel functionality.

[

Future Imports

Once the initial configuration has been completed, the system will automatically apply the saved settings during future Excel imports.

No additional configuration is required unless the date format or Time Type Mapping settings need to be updated.

Thank you for being FirstBIT customer!