Time Bundle Upload

This integration uploads time bundles.

Connector Overview

Component

Detail

Company Type

Buyer

Supplier

MSP Partner

Version Type

API-A-V1.0

Format

CSV

Prerequisites

Company Details setting must be turned on for Integration – Time Bundle Upload.

User role permission must be turned on for upload data and download data.

User needs 'Enable Time Dashboard' turned ON in the User Profile.

Predecessors

Resource Upload

Time Event Upload

Time Record Upload

Related Connectors

Time Bundle Download

Time Event Upload

Time Event Download

Time Record Upload

Time Record Download

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type

Yes

File Type

If you have a custom connector name for a standard connector, you can use the exact same custom name for the Type header; otherwise, you must use the standard name shown in the Value field.

Time Event Upload

Time Template

Yes

Time Template Code

The Time Template code must be defaulted in this field when upload file is generated. During upload, the Template code must be validated to check the validity of the Time Template. If there are multiple versions of the Time Template, the latest version valid for the specified date on 'Date' column should be picked.

Language

No

Determines the language to be used for values in the file, such as dropdown lists and radio buttons. Column headers always default to the upload user's preferred language.

Arabic (Standard Arabic)
Chinese (Simplified)
Chinese (Traditional)
Dutch (Netherlands)
English (United Kingdom)
English (United States)
French (Canada)
French (France)
German (Germany)
Hebrew (Israel)
Hungarian (Hungary)
Italian (Italy)
Japanese (Japan)
Korean (Korea)
Mongolian (Mongolia)
Polish (Poland)
Portuguese (Brazil)
Portuguese (European)
Russian (Russia)
Spanish (Mexico)
Swedish (Sweden)

Number Format

No

Determines the number format to be used in the file.

This is an optional header value. Determines the number format used in the company. The valid number format values are:

  • “#,##9.99" (Example: "1,234,567.99”)

  • “#.##9,99" (Example: "1.234.567,99”)

  • “#'##9.99" (Example: "1'234'567.99”)

  • “# ##9,99" (Example: "1 234 567,99”)

The quotes are required even if the value does not have a comma in it. If this field isn't included in the header, the default value is "#,##9.99".

Date Format

No

Determines the date format to be used in the file.

The valid date format values are:

  • MM/DD/YYYY

  • DD/MM/YYYY

  • YYYY-MM-DD

If this field isn't included in the header, the default value is MM/DD/YYYY.

Comments

No

Upload comments

This is a comment field containing notes about the upload file.

Immediately following the Header section of the upload is one blank line.

Detail

Field Header Name

Data Type

Field Length

Required?

Value(s)/Format

Description/Use/Field Rules

Modification Type

Text

11

Yes

Valid values are:

  • A

  • U

  • D

Defines action that the system needs to perform.

A = Add

U = Update

D = Delete

Resource ID

TEXT

14

Yes

Valid SAP Fieldglass Resource ID.

Example: ABCDRE00001234

Unique identifier for the resource.

Buyer Reference

Text

200

No. This field is only visible to the Buyer.

Valid Buyer Reference ID.

Buyer created reference. If both the Resource ID and Buyer Reference ID are populated, the Resource ID is treated as the source of truth.

Last Name

Text

200

No

Last name of the Worker as defined in SAP Fieldglass.

First Name

Text

200

First name of the Worker as defined in SAP Fieldglass.

Date

Date

Yes

Date against which the time Record is added.

This field is always needed along with Resource ID for all types of transactions.

Time Attributes

Text

Length depends on the attribute.

Rate Category/UOM: 100

Assignment Title (Code): 14

PO Line Item: 100

Cost Center (Code): 200

Contract Segments

Conditional, based on the Time Template selected.

The time attribute values as specified in the Time Template.

Quantity

Decimal

Time-based: 0–24.

Non time-based: 11 digits and 2 decimals.

Yes

Valid values must be 0 or >0.

The field accepts values in HH:MM or decimals based on the Rate Category / UOM configuration.

Unique Identifier

  • Resource ID

  • Buyer Reference

  • Time Bundle ID

  • Time Bundle detail ID

Assumptions/Tips

  • Only Time Bundles in a Completed or Rejected status can be revised.

  • If a Time Bundle already exist for a specific date and resource, any new time records being added for the same date and resource unlocks the time bundle, revise it, and update it with the extra hours.