SAP Knowledge Base Article - Public

2465670 - Uploading Target Groups Triggers Following Error Message : You can't add x members due to invalid ID formats. Only letters, numbers, hyphens, and underscores are allowed

Symptom

After uploading target groups the following error message is displayed: "You can't add 2 members due to invalid ID formats. Only letters, numbers, hyphens, and underscores are allowed."

Environment

SAP Sales Cloud

Reproducing the Issue

  1. Go to the Sales Campaign work centre.
  2. Select the Target Groups view.
  3. Open a random target group.
  4. Select the Actions button and choose the Upload from File option.
  5. Click on the Select file button.
  6. Choose the relevant file.
  7. Select the Upload button.
  8. The following error message id displayed: ‘You can't add 2 members due to invalid ID formats. Only letters, numbers, hyphens, and underscores are allowed.’

 

Cause

There are two possible causes here.

Cause 1:

The uploaded file has the wrong format.

Cause 2:

You have maintained member ID's as well as member names.

Resolution

In order to resolve the issue you have to ensure that the used file format is CSV (Comma delimited)(*.CSV). This format supports only member ID.

Keywords

upload, target groups, excel, csv, fail , KBA , LOD-LE-MKT , Marketing , How To

Product

SAP Cloud for Customer add-ins all versions