SAP Knowledge Base Article - Public

2322155 - How to Upload Attachments Using Data Workbench Work Center

Symptom

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

Reproducing the Issue

1. Go to Data Workbench work center
2. Select Import view
3. Select Import Attachments
4. Select the respective Object
5. Select Download Manifest File

Resolution

You downloaded the manifest file for a selected object. The data that should be entered are:


1. External Key of the object (node) for which you are importing attachment
2. Type Code defined for an attachment type.
3. Name of the attachment
4. 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: SAP_43091
- TypeCode: 10001
- AttachmentName: Report
- Path: Rep_CA.doc

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

1. Go to Data Workbench work center
2. Select Import view
3. Select Import Attachments
4. Select the respective Object
5. If you have connected the SAP Cloud for Customer system with an external system, and would like to maintain the External ID of this objects in the imported data, you can select the Business System ID of that system.

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.

6. Select Next
7. Browse for the archive file
8. Select Upload
9. Select Next
10. 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

KBA , LOD-CRM , Cloud for Customer , How To

Product

SAP Cloud for Customer 1805 ; SAP Cloud for Customer add-ins 1802 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer add-ins 1705 ; SAP Hybris Cloud for Customer add-ins 1711