SAP Knowledge Base Article - Public

3589223 - How To Update Mutli-Value Fields Using Data Import And Export Tool In Sales & Service Cloud

Symptom

There is requirement to mass update data in the system. Some fields have more than one value, and needs to be updated via the tool.

Environment

SAP Sales & Service Cloud V2

Reproducing the Issue

  1. Download the relevant template from the Data Import and Export Tool.
  2. Open the template and add the data as required in the Excel File.
  3. There is a field with type ARRAY that can have more than one value.
  4. It is not known how to update multiple values for this field.

Cause

Multiple values need to be separated by a semicolon.

Resolution

For example, It is required to update values "AAA" and "BBB" for a specific field.

The solution would be to maintain the value as AAA;BBB in the file.

Keywords

Import, ARRAY, Multi Value, Sales, Service, Excel, Template, Values, Data , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , Problem

Product

SAP Sales Cloud and SAP Service Cloud Version 2 all versions