SAP Knowledge Base Article - Public

2741200 - Unable to Upload Members in Target Groups via Upload From File due to an error: Please check delimiter; they are either wrong or missing. Only semicolon, comma or tabulator are allowed.

Symptom

  • You are unable to upload members in a Target Group by using "Upload From File" in Target Group due to error messages.
  • Error message: Please check delimiter; they are either wrong or missing. Only semicolon, comma or tabulator are allowed.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Sales Campaign work centre
  2. Go to the Target Group work center view
  3. Open a Target Group
  4. Select "Upload From File" in the Actions
  5. Select a file
  6. Click Upload

Result: Unable to upload the file and add members due to error message.

Cause

  • The Header allows the system to ascertain where the IDs are originating from in the system
  • The ";" (semi-colon) is important to allow the system to isolate, and read the IDs. Without this separation you will be faced with the error
  • It can also be because of the format of the file used

Resolution

  • You may verify the symbols used to isolate the values (",",";") to address the inconsistencies in the content
  • You may also adjust the format ensuring that the used file format is CSV (Comma delimited)(*.CSV). This format supports only member ID
  • See the Resolutions on the KBA 3612133 - Unable to Update Members in Target Group By Using Microsoft Excel Add-In

See Also

  • KBA 2452922 - Target Group is Created without Members via Microsoft Excel Add-In
  • KBA 2465670 - Unable to Upload Members in Target Groups via Upload From File
  • KBA 3612133 - Unable to Update Members in Target Group By Using Microsoft Excel Add-In

Keywords

target group, excel, csv, format, incorrect, members, upload from file, error, Please check delimiter; they are either wrong or missing. Only semicolon, comma or tabulator are allowed , KBA , LOD-CRM-MKT-TG , Target Groups , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions