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
- Go to the Sales Campaign work centre
- Go to the Target Group work center view
- Open a Target Group
- Select "Upload From File" in the Actions
- Select a file
- 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
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
SAP Knowledge Base Article - Public