Location Upload

Connector Overview

Component	Detail
Company Type	Buyer
Version Type	API-V1.0 API-A-V1.0 BULK-FULL-V1.0
Format	CSV
Prerequisites	Company plug-ins must be turned on for Integration – Location Upload. User role permission must be turned on for Upload Data and Download Data.
Predecessors	Sites
Related Connectors	Site Upload

File Formatting

Header

Component	Required?	Definition/Use	Notes	Value
Type	Yes	Upload file type	If you have a custom connector name for a standard connector, you may use the exact same custom name for the Type header; otherwise, you must use the standard name shown in the Value field.	Location Upload
Transaction	No	Only applicable for the API-V1.0 version. Transaction type	Transaction type. The valid type names are: True: If any record errors, the entire upload fails. False: Only records that are in error fail. Remaining records are committed successfully. If this field is not included in the header, the default value will be True.
Send Notification?	No	Determines whether normal messaging workflow should be followed.	This flag is used to control sending notifications to users. The valid values are: True – If the value set to True, email will be sent. False – If the value is set to False, email will not be sent. If this field is not included in the header, the default value will be True.
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 is not included in the header, the default value will be "#,##9.99".
Language	No	Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers will always default to the upload user's preferred language.	The valid language values are: 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)
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

Column Header Name	Data Type	Field Length	Required?	Value(s)/Format	Description/Use/Field Rules
Modification Type	Char	1	Yes, for Delete only.	Valid Values Are: A U D Blank (no value)	A – Add U – Update D – Delete Blank – When an existing value is entered, SAP Fieldglass identifies it as an update. When a new value is entered, SAP Fieldglass identifies it as an Add.
Code	Text	100	Yes		Code for the Work Location. Must be unique for each site.
Name	Text	200	Yes, for Add only.		Name of the work location.
Site Code	Text	100	Yes, for Add only.	Valid SAP Fieldglass site code.	Site code associated with the work location. Entered values are ignored if Site Association = All.
Site Association	Text	100	Conditional	Valid values are: Single Multiple All	Associates sites to a location. Enable at least one sub-configuration for the company configuration Use multiple locations. If field left blank, defaults to Single. If All is selected, then any value entered in the Site Code column will be ignored as the location will be associated to all current sites and any sites added in the future. If All is selected during an Update modification type, then individual associations will be removed and this will associate it to all current sites and any sites added in the future.
Description	Text	1000	No		Optional text description of the work location.
Address 1	Text	600	No		Line 1 of the Location’s address.
Address 2	Text	600	No		Line 2 of the Location’s address.
City	Text	50	No		City where the Location is located.
State/Province	Text	50	No		State/province where the Location is located.
Country	Text	50	Yes, for Add only.	Valid values are: USA GBR CAN	Country code for the country where the location is located. For USA, zip code and state are mandatory.
Zip/Postal Code	Text	20	No		Zip code/postal code of the site.
[c] Location Custom Field Name	Text	200	Yes, if the custom field is mandatory. No, if the custom field is optional.	Depends upon the custom field type	Any custom field associated with the Location module. The custom field name should be prefixed with ‘[c]’. For example, custom field name: ‘L Custom Field 1’ should be ‘[c] L Custom Field 1’. Valid values of the custom field are configured during the setup of the SAP Fieldglass system. Do not include this field if it is not being used.

Unique Identifier

Code field

Assumptions/Tips

This is an upload that can be used from the buyer side only.
This upload allows a list of work locations for the buyer company to be added or updated from SAP Fieldglass. It supports the following:
- Adding a new work location.
- Updating an existing work location.
- Deleting (Close) an existing work location.
The utility validates the work location code, name, site, and other fields in the same way as application side while uploading. Such as:
- When adding a new work location or updating an existing work location, all the required fields must be filled in with content.
- When updating an existing work location, check if the site is allowed to be updated. Make sure the site code is a valid site in the system.
- Before deleting (close) an existing work location, check if it is allowed to be closed.