Skip to Content
Author's profile photo Eduard Stelle

SAP Hybris Cloud for Customer – Import Attachments with the Data Workbench

Hi C4C community,

 

This blog post explainins how to import attachments with the Data Workbench. Please make yourself familiar with the SAP Hybris Cloud for Customer Data Workbench User Guide and the Data Workbench FAQ before you start with the import of attachments with the Data Workbench.

 

Steps to perform

1. Navigate to the WCView Import in WoC Data Workbench and select option Import Attachment.

Select an object for which you want to import attachments and download the manifest file for the selected object.

/wp-content/uploads/2016/09/1_1037247.jpg

 

2. Rename the downloaded file to manifest.csv and save it in a folder where the attachments are located that you want to upload.

/wp-content/uploads/2016/09/2_1037248.jpg

 

3. Open the downloaded file in MS Excel to maintain the records.

The header of the CSV file is clubbed in the first column. In order to split it to the columns, select the first column and select function Text to Columns in the Data tab.

/wp-content/uploads/2016/09/3_1037298.jpg

 

4. In the first step of the wizard select file type Delimited, and select Comma as delimiter in the second step. Confirm the wizard by pressing Finish.

/wp-content/uploads/2016/09/4_1037299.jpg

 

Recommendation: Excel tries to interpret your data and apply a format accordingly. In most cases when you are dealing with upload file, you don’t want any formatting. To avoid that, I recommend to select all cells (by clicking on the upper left corner), select option Format Cells in the context menu (right click on any selected cell) and select Category Text in the first tab.

/wp-content/uploads/2016/09/5_1037306.jpg

 

5. Now you can fill the manifest file with the data for your attachments, 1 record per attachment.

Check the Data Workbench User Guide for details on how to use the fields […]ExternalKey and […]InternalID.

/wp-content/uploads/2016/09/6_1037318.jpg

 

TypeCode: Type of the attachment. TypeCode for type Standard Attachment is 10001. If you want to use one of the other type available for Account attachments, check the list of attachment type codes at the end of the blog post.

/wp-content/uploads/2016/09/12_1038304.jpg

AttachmentName: Name shown in the attachment list in C4C.

MimeType: Media type of the attachment file. You can check and maintain the list of allowed MIME types in your C4C tenant in the business configuration activity Allowed MIME Types for Document Upload.

Path: Path to the attachment file relative to the manifest file in the archive, with “/” as path separator.

Example: In my example the attachment file “1000290_attachment1.jpg” is in a subfolder “Files” relative to the manifest file. Therefore I need to specify  the path as “Files/1000290_attachment1.jpg”. If the file would reside next to the manifest file, I would need to specify the path as “1000290_attachment1.jpg”.

 

6. Once all records are maintained, save the file in a CSV format.

In many cases Excel delimits the values in CSV files with a semicolon, but for the Data Workbench the delimiter must be comma. Therefore open the saved file with an text editor (e.g. Notepad), replace all semicolons by commas and save the file.

Note: Name of the manifest file must be “manifest.csv”.

/wp-content/uploads/2016/09/7_1038241.jpg

 

7. Create a zip archive containing the manifest file and the attachments.

Important: The size if the zip archive must not exceed 100 MB, and size of each attachment must not exceed 10 MB.

/wp-content/uploads/2016/09/8_1038242.jpg

 

8. Navigate again to the WCView Import in Worcenter Data Workbench and select option Import Attachment, select the object for which you downloaded the manifest file in step 1 go to the next step.

Upload the zip archive and review the sample records.

/wp-content/uploads/2016/09/9_1038243.jpg

 

9. In the next step you can change the task name of the import run and trigger the import.

 

10. The import runs asynchronously. In order to check the status of the import, navigate to the WCView Monitor.

Once the import run is completed, the status changes from In Process to Finished. You need to refresh the view manually, by pressing the Refresh button.

Inthe list you see the total number of records, successfully uploaded and erroneous records in the import run. In case of errors, you can click on the number to get a list of errors. For details check Data Workbench User Guide.

/wp-content/uploads/2016/09/10_1038244.jpg

 

11. The last step is a spot check if the import really worked. Navigate to the attachments section of the object you specified in the manifest file and check if the file is uploaded correctly and has the specified name.

/wp-content/uploads/2016/09/11_1038245.jpg

 

 

Available Attachment Type Codes

Note: Many type codes can be used only for specific objects. Check in the object if the used type codes are permitted for the object. Otherwise the import will run into an error. In the error CSV file, which you can download from the monitor, you can check the processing error and correct your manifest file.

You can lookup the list in your C4C development tenant with the Repository Explorer in the Cloud Applications Studio (PDI), Data Type: DocumentTypeCode (Namespace http://sap.com/xi/AP/Common/GDT)

 

 

Code Value

Description

10001

Standard Attachment

10002

Original Document

10003

Incident Context

10004

Curriculum Vitae

10005

Policy

10006

Certificate

10007

Skills Profile

10008

Requirements Specification

10009

Summary

10010

Employee Image

10011

Product Image

10012

Thumbnail

10013

Image

10014

Graphical Instruction

10015

Technical Drawing

10016

Business Partner Image

10017

Business Card

10018

Product Specification

10019

Application

10020

Protocol

10021

Job Description

10022

Inspection Instruction

10023

Inspection Method

10024

Sample-Drawing Instruction

10025

Certificate of Analysis

10026

Technical Delivery Terms

10027

Quality Assurance Agreement

10028

Finding

10029

Plain Invoice Text

10030

System Status Information

10031

Product Safety Sheet

10032

Manual Visit Report

10033

Catalog Data

10034

Catalog Pictures

10035

Specification & Results

10036

CAD Viewable

10037

Primary CAD Viewable

10038

Confidential

10039

Incoming Messsage/File

10040

Outgoing Message/File

10041

Technical Service Parameters

10042

Product Requirement Specification

10043

Details for Supplier

10044

Invoice

10045

Deliver Note

10046

Export accompanying document (EAD)

10047

Multimedia

10048

Web Document

10049

Maps

10050

News

10051

Web Page

10052

Maps

10053

Search Engines

10054

DATEV Header File

10055

DATEV Postings File

10056

DATEV Customer Masterdata File

10057

DATEV Supplier Masterdata File

10058

DATEV Account Masterdata File

10059

Manual

10060

FAQ

10061

Best Practice

10062

Manual

10063

Guideline

10064

Declaration File

10065

Itemized List

10066

Proof of Export

10067

Export Message File

10068

Internal Attachment

10069

WEKTRA Help Document

10070

Marketing Information

10071

Project Document

10072

Warehouse Confirmation

10073

IT Administration Script

10074

Contact data

10075

Inventory Notification

10076

Pro Forma Invoice

10077

Quality Assurance Document

10078

Avatar Image

10079

Account-Specific Attachment

10080

Employee-Specific Attachment

10081

House Bank-Specific Attachment

10082

Supplier-Specific Attachment

10083

Tax Authority-Specific Attachment

10084

Centrally Scanned Document

10085

Campaign Export File

10086

Graphical Signature of Seller

10087

Graphical Signature of Buyer

10088

Graphical Signature of Empl. Responsible

10089

Questionnaire Style Document

10091

Analytical Report Subresult

10092

Graphical Signature of Payer

10093

Graphical Signature of Recipient

10094

Graphical Signature of Agent

10095

Graphical Signature of Technician

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Keynes Austin
      Keynes Austin

      Is it possible to mention http URL of the attachment in the "PATH"?
       

      Author's profile photo Former Member
      Former Member

      Hi @eduard.stelle,

      Is it possible to migrate Individual customer photos in this way?

      Nadya

      Author's profile photo Dhruvin Mehta
      Dhruvin Mehta

      Can u try with file name with special character like Ä/ä, Ö/ö, Ü/ü  , We noticed that its not working. We raised it to SAP since we have many eu entities from which we will get files with above special characters . it just doesnt work. SAP suggested to five file name in "Testä.PDF" but still it doesn't work..

      We are trying to get the solution but currently we manually change file names and its getting very difficult since we have a lot of files. I hope SAP provides a solution for this.

      Author's profile photo Kushal Jiwane
      Kushal Jiwane

      Hello,

      Do you know how much size is allowed to upload for attachments? and How many attachments are allowed to upload in one ticket at a time?

      Regards

      Kushal

      Author's profile photo Eduard Stelle
      Eduard Stelle
      Blog Post Author

      Hi,

      The ZIP file size is limited to 100MB and the individual attachment file size is limited to 10MB.

      Documented here: https://help.sap.com/viewer/c52d3ba13f56403ba116560148fd2071/CLOUD/en-US/c55065c05b104724bb4dc9369216784b.html

      You can find all details and limitations of attachment upload in DWB there.

       

      Best regards,

      Eduard