SAP Knowledge Base Article - Public

2568268 - Frequently Asked Question on Data Workbench Work Center

Symptom

Below are few commonly asked question and their answers on Data Workbench work center.

Environment

  • SAP Hybris Cloud for Customer.

Resolution


Question 1: How to migrate new set of data into the system using Data Workbench work center?

Answer: To import new data into the system, please follow the below steps:

  1. Go to Data Workbench work center.
  2. Select Import.
  3. Select any Object.
  4. Select Download CSV file.

Add the data in the template then follow the below steps:

  1. Go to Data Workbench work center.
  2. Select Import.
  3. Select any Object.
  4. Select Next.
  5. Upload the template.
  6. The fields would be auto-mapped by the tool as you have selected an object template file. You need to review the mapping before proceeding to next import step.
  7. Select Import.

 

Question 2: How to update/modify the existing records in the system using Data Workbench work center?

Answer: To update the existing data in system, please follow the below steps:

  1. Go to Data Workbench work center.
  2. Select Export View.
  3. Select any Object.
  4. Select Next.
  5. Select Export Data.

Add the values which needs to be modified/updated in the template and then follow the below steps

  1. Go to Data Workbench work center.
  2. Select Update.
  3. Select the Object.
  4. Select Next.
  5. Upload the template.
  6. Select Import.

 

Question 3:How to check the status of import/export in Data Workbench work center?

Answer:You can check the status of your import and export by following the below steps:

  1. Go to Data Workbench work center.
  2. Go to Monitor View.

In this view, you can check the progress/status of the file and also you can download the respective exported file.

 

Question 4:How to upload attachments using Data Workbench work center?

Answer:To upload attachment please follow the below steps:

  1. Go to Data Workbench work center.
  2. Select Import view.
  3. Select Import Attachment.
  4. Select the respective Object.
  5. Select Download manifest file.

You can then fill the template with the path where the attachments are kept and then copy the template to the same folder and then zip the folder.

Note: Please make sure you name of the template as manifest.csv.

  1. Go to Data Workbench work center.
  2. Select Import view.
  3. Select Import Attachment.
  4. Select the respective Object.
  5. Select Next.
  6. Upload the zip file.
  7. Select Import.

 

Question 5:  What is the file size limit when we upload a zip file for attachments in Data Workbench work center?

Answer: The size of the zip file should not exceed more than 100 MB and size of each attachment in it should not exceed 10MB.

 

Question 6:  How to re-use the file which has failed during the import?

Answer: You can download the file from Monitor view and remove the first column Row ID and last column which contains Error and then you can Import the file again using Import view.


Question 7: How the date format should be filled in CSV file while importing?

Answer: The date format should be filled in YYYY-MM-DDTHH:MM format.

 

Question 8: How to delete Task from Monitor View?

Answer: You can select the respective Task and then you can select Remove.

 

Question 9: How to download the file which has value as 001 or 002 in any of the fields while exporting?

Answer:  When you open the file with MS Excel, the leading zeros will be truncated. So, you can open it in any standard text file to keep the leading zeros.

 

Question 10:How to export Attachments using Data Workbench work center?

Answer:  It is not possible to Export Attachment for any object using Data Workbench work center. You can only Import new attachments for an object using the Import View.

 

Question 11: Is it possible to Delete the mapping between Source and Target fields while Importing the file?

Answer:You can Delete the mapping between Source and Target fields by following the below steps:

  1. Select the link between the Source and Target fields.
  2. Right Click.
  3. Select Delete.

OR

  1. Select the link between the Source and Target fields.
  2. Select Delete button in your keyboard.

 

Question 12: Why can't all users view All Tasks under Monitor view in Data Workbench work center?

Answer: Only Key Users have access to All Tasks in Monitor view under Data Workbench work center.

 

Question 13: Is it possible to Uncheck or Nullify the checkbox field for a given Business Object using Data Workbench work center?

Answer: Data Workbench only supports Checking of the checkbox Fields. Nullify/Unchecking of the checkbox is not possible using Data Workbench work center.

 

Question 14: What is the timespan of files on the Monitor Tab?

Answer: The file will automatically disappear from Monitor view after Three months.

 

Question 15: What is the functionality of Ignore Blank Values and Update Blank Values in Update view in Data Workbench work center?

Answer:

Ignore Blank Values: Once you choose this option it will ignore all the blank values provided for a specific field in the csv file and these fields will not be impacted after import.
Update Blank Values: Once you choose this option it will accept all the blank values provided for a specific field in the csv file and these fields will be updated after import.

 

Question 16: Is it possible to enable Duplicate Check in Data Workbench?

Answer: No, Duplicate Check option is not available in Data Workbench. In case of duplicate data, you will receive an error in case the Object ID is existing in the C4C system.


Question 17:
 Is it possible to automate Exports by scheduling an Export job from the Data Workbench?

Answer: No, it is not possible to automate any of the tasks via job from Data Workbench. All the tasks including exports have to be manually triggered.


Question 18:
 Few of the Fields which you have added to the service, do not have In Between filter option at the time of Export.

Answer: This is expected system behavior.


Question 19: Is it possible to change the default import option in Import view, from Complete Business Objects to Individual Objects?

Answer: Currently it is not possible to change the default import option. Since 1711 release of Hybris Cloud for Customer the Complete Business Objects option became the default option for Import view.

 

Question 20: When the Business User selects the radio button Individual Objects in the Import view of Data workbench, the list of objects is not available.

Answer: The import of individual objects involves mappings which the Business User may not be aware of. This can work if a Key User creates a mapping from the Templates view in Data Workbench and the same will be available for the Business Users to use it in Individual import. This reduces the number of steps for Business users.

 

Question 21: How to extract the External Keys for any Objects?

Answer: You may extract the External Keys using the Export view. The external key field is now part of the exported templates for all objects.

 

Question 22: Which object can be used to import Account Contact Relationship using Data Workbench?

Answer: The object Account Contact Relationship is Deprecated in the Import view in Data Workbench.

You may use the object Business Partner Relationship to upload the relationship between Account and Contact.


Question 23: Why do you get an error message "does not contain csv files" while uploading .zip file for Complete Business Objects.

Answer:You need to follow below steps to upload .zip file for Complete Business Objects:

  1. Go to Data Workbench work center.
  2. Select Import View.
  3. Select Complete Business Objects option.
  4. Download the .zip file.
  5. Extract the Templates folder from the zip.
  6. Add the records in the csv files from the Templates folder.
  7. Add the CSV files to a zip folder.
  8. Upload the .zip file in Data Workbench Complete Business Objects Import mode.

 

Question 24: What is the significance of Initial Load mode in the Import view in Data Workbench work center?

Answer: Data can be migrated into SAP Hybris Cloud for Customer in Initial Load mode so that applications react differently, for example by relaxing checks/update number ranges etc.

The same is required to be supported by Data Workbench. The Initial Load mode relaxes the veto checks and reduces errors during initial migration. You may Import data in Initial Load mode to avoid Business Object validations.

Data workbench (DWB) allows Initial Load of data, just as Migration workbench with migration mode context (MWB). To relax the checks during Initial Load (as done in MWB), migration context is set from via DWB User Interface by selecting Initial Load.

By default, the Initial Load switch is set to ON, which sets the migration context during data import.

 

Question 25: Is it possible to use the CSV-Migration-Template, from the migration tool, to import data in the Data Workbench work center?

Answer: No, the Data Workbench tool accepts only templates from the same work center -> downloaded from the button 'Download Metadata' (in the Import view), exported from the Export view (to use in the Update mode) and the templates created in the Templates view.

The CSV-Migration-Template is a special type of CSV document, that differs from a normal CSV template, and can only be used in the Migration tool.

 

Question 26: Not able to find the Monitor/Import/Export/Templates views in the Data Workbench work center

Answer:To activate the Access Rights for the work center you can follow the below steps:

  1. Go to Administrator work center.
  2. Select the Business Users hyperlink.
  3. Select the respective user.
  4. Select Edit and choose the Access Rights option.
  5. In the Work Center and View Assignment tab, expand COD_DATALOADER_WCF view.
  6. Select the respective views and checkmark Assigned to User.
  7. Select Save and Close.

 

Question 27: Is it possible to delete records using the Data Workbench?

Answer: Yes, it is possible to delete some records of transactional data using the Data Workbench. To do this:

  1. Go to Data Workbench;
  2. Access the Export view;
  3. Select the object for which you wish to delete records;
  4. Filter for the desire records and export them;
  5. Download the CSV file from the Monitor;
  6. Edit the CSV and add a column with header "ToBeDeleted" at the end;
  7. For all records that should be deleted, add value "TRUE" in this column;
  8. Save the file and re-upload it to the system using the Update option in the Import view.

Question 28: Post 1808 Upgrade, Per Tenant only one task shows in the status In Progress and remaining tasks go to In Queue status.

Answer 28: It is expected system behavior, it is a new feature introduced post 1808 upgrade.
Only one Task will be processing at a time per Tenant and remaining will go to In Queue status, after completion of In Progress task the next Queued up task will get processed.

Keywords

frequently asked questions, data workbench, faq, import, update, export , KBA , frequently asked questions on data work , data workbench faq , faq on data workbench , faq on dwb , dwb faq , faq dwb , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer add-ins all versions