SAP Knowledge Base Article - Public

3612133 - Unable to Update Members in Target Group By Using Microsoft Excel Add-In

Symptom

  • Unable to update Members in a Target Group by using Microsoft Excel Add-On due to error message(s)
  • Error message: Changing Target Group ID not possible; field is read-only
  • Error message: Only list complete transmission (LCTI) allowed for TARGET_GROUP-MEMBER - MEMBER_CTI

 "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Sales Campaign work center
  2. Go to the Target Groups work center view
  3. Click New from Microsoft Excel in More
  4. Download a file
  5. Open the file
  6. Put the Target Group ID, that you want to add additional members, in the Target Group ID field (e.g. ID 1234)
  7. Add a few members
  8. Click Save data to Workbook

Result: Unable to add the members due to an error message.

Cause

Microsoft Excel Add-In is only for creating new Target Groups and not for updating members in existing Target Groups.

Resolution

To add additional members in existing Target Groups, use Upload From File in a Target Group.

  1. Go to the Sales Campaign work center
  2. Go to the Sales Campaign work center view
  3. Open Target Group (e.g. ID 1234)
  4. Click Upload From File in Actions
  5. Select Exclude Column Header
  6. Click Select File
  7. Upload a file *It needs to be csv file with specific format. See examples below.

See Also

  • KBA 2452922 - Target Group is Created without Members via Microsoft Excel Add-In
  • KBA 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.
  • KBA 2465670 - Unable to Upload Members in Target Groups via Upload From File
  • SAP Community

Keywords

target group, excel add-in, excel add-on, excel, csv, members, unable, can't, cannot, update, upload, Changing Target Group ID not possible, field is read-only, TARGET_GROUP-MEMBER , KBA , LOD-CRM-MKT-TG , Target Groups , Problem

Product

SAP Cloud for Customer core applications all versions

Attachments

Pasted image.png
Pasted image.png