SAP Knowledge Base Article - Public

2322155 - How to Upload Attachments Using Data Workbench

Symptom

You have a requirement to upload attachments using the Data Workbench work center. This document will guide you on how to achieve this.

Environment

SAP Cloud for Customer

Resolution

Begin by downloading the file for importing the attachments:

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

The downloaded ZIP file will 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.
  • InternalID of the object for which you are importing the attachment (in case you do not have the External Key)
  • 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

  • AccountExternalKey and/or AccountInternalID
  • TypeCode: 10001
  • AttachmentName: Attachment Name
  • Path: Attachment_name.doc

Note: The attachment uploaded will show up in the Attachment tabs, it will not show up as image for Account/Contact.

(Account/Contact image can't be uploaded using Data Workbench.)

If you are importing images for Products and the attachments are all placed in the root folder, then the manifest file will have the below detailsAccountExternalKey and/or AccountInternalID

  • ProductExternalKey and/or ProductInternalID
  • TypeCode: 10011 
  • AttachmentName: Image Name
  • Path: Image.png

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

  1. Go to the Data Workbench work center.
  2. Access the Import work center view.
  3. Select the Attachment radio button.
  4. Search and select the respective object.
  5. Click Next.
  6. Browse for the archive file.
  7. Click Upload.
  8. Click Next.
  9. Click Import.

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

Keywords

attachment import, data workbench , DWB attachments , Product Images , KBA , LOD-CRM-INT-DWB , Data Workbench , AP-RC-DOC , Document Centric Application Service , How To

Product

SAP Cloud for Customer add-ins all versions