Most pick list values are uploaded via the Pick List Value Upload Connector. This makes it much easier to configure, add, remove, or update pick lists as needed- especially when there are hundreds of values to be maintained.
In order to configure this pick list, we would take the file you see here and upload it into our organization's tenant in SAP Fieldglass. When the file loads successfully, the configuration details for this pick list will look exactly the same as we saw in the UI.
1 | The Type of upload is entered as the Pick List Value Upload. This lets the application know what kind of data you’re loading into system. In this case, values for a pick list are being uploaded. A Pick List Value Upload cannot occur until a pick list is first configured, which can be done with a Pick List Configuration Upload Connector. There are several types of Pick Lists in SAP Fieldglass based on what type of value should be populated. When creating a Pick List, it is mandatory to choose one. Here are four of the most commonly used: - Custom Field Source is used to provide a list of Active items that exist in the tenant, like users or job posting templates.
- Custom Field Pick List is used to provide a list of Buyer-defined items for a custom field.
- Custom Field Segmented Pick List is used to provide a Segmented Pick List for a custom field. You can set up valid combinations of data to limit the user's choices for each segment of the custom field.
- Integration Pick List is used to create a Pick List for use in Integrations.
|
2 | The first value in the Pick List column/section is the name of our pick list: Reason for Job Posting. |
3 | All the values underneath the Name comprise the list of valid values in the application. The values listed here match the values in the Values section of the Pick List details. |
Segmented Picklist Upload
The upload file for a Segmented Pick List includes the same header values as the Pick List upload file:
1 | The Name of the Pick List is the first value listed in the upload file. |
2 | The Pick List Type indicates the type of pick list that this data object represents. In this case, the pick list type is a Custom Field Segmented Pick List. The pick list type is determined when the pick list is configured using the Pick List Configuration Upload Connector. The Pick List Type does not correspond to the Type value listed in the Values connector. Instead, the Type value in the connector indicates the manner in which SAP Fieldglass should process the data in the connector. |
3 | A Delimiter separates the data items in the Pick List Values Upload connector so SAP Fieldglass can process the data correctly. As illustrated here, a semicolon is used to separate the values to indicate which value in each row corresponds to a Region, and which represents a Finance Contact. |
4 | Segment Headers represent the columns in the Values list. They identify the values that appear in the respective columns. The number and names of the Segment Headers are configured when initially setting up the pick list using the Pick List Configuration Upload connector. The number of segment headers listed here should match the number indicated in the Number of Segments section of the pick list details. |
5 | Unlike the values in a standard pick list, values listed under Pick List Values represent the segments. The data in the connector is presented by row, but in a single column. The values are presented in the order in which the segment headers are listed and are separated by the chosen delimiter. In this example, the first value represents the Region and the second value is the associated Finance Contact, with the values separated by a semicolon. |