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)
|
|
|
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:
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:
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:
|
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.