SAP Knowledge Base Article - Public

2322155 - How to Upload Attachments Using Data Workbench Work Center

Symptom

You have a requirement to upload Attachments using Data Workbench work center. This document will guide on how you can achieve it.

Environment

  • SAP Cloud for Customer.

Reproducing the Issue

  1. Go to the Data Workbench work center.
  2. Select the Import view.
  3. Select the Attachment radio button.
  4. Search and select the respective Object.
  5. Click on the Download button.

Resolution

You downloaded the .zip folder containing the field definition and manifest files from the respective object. The data that should be entered is:


  • ExternalKey of the object (node) for which you are importing attachment.
  • AttachmentTypeCode defined for an attachment type.
  • AttachmentName: Name of the attachment.
  • FilePath: Path from the root within the archive file.

Example:
If you are importing the Attachments of a Account, and the attachments are all placed in the root folder, then the manifest file will have the below details

  • CorporateAccountExternalKey: XYZ
  • TypeCode: 10001
  • AttachmentName: Attachment Name
  • Path: Attachment_name.doc

Ensure that the name the manifest file will be manifest.csv. It is case sensitive.

  1. Go to the Data Workbench work center.
  2. Select Import view.
  3. Select the Attachment radio button.
  4. Search and select the respective Object.

Note:
This ID represents the system that contains the external key to internal key mapping. If this ID mapping does not exist in the SAP Cloud for Customer system, then data will not be imported. If you select a Business System ID, then you must have a new column named ExternalKey in the CSV file with the External ID of each of the records. If the External Key does not exist for the imported data, then a new ID mapping will be generated.

  1. Select Next.
  2. Browse for the archive file.
  3. Select Upload.
  4. Select Next.
  5. Select Import.

The system displays a message on the status of the import. You can go to the Monitor view, and check the status of your import.

Keywords

attachment import, data workbench , KBA , LOD-CRM-INT-API , OData API (C4C Only) , How To

Product

SAP Cloud for Customer add-ins 1808 ; SAP Cloud for Customer add-ins 1811 ; SAP Cloud for Customer add-ins 1902