SAP Knowledge Base Article - Public

2788213 - Error: "E-mail address example@example.com isn't valid. Please check." While Importing Contacts Using Data Workbench

Symptom

You are not aware if the Contacts previously imported exist in your system. Therefore, you want to import new Contacts or update existing Contacts in your system using Data Workbench. In the Upsert mode, upon trying to import Contacts using Data Workbench object Contact, you receive the processing error:

E-mail address example@example.com isn't valid. Please check.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Data Workbench workcenter
  2. Go to Import view
  3. Select the radio button for Individual Object
  4. Go to Upsert tab
  5. Go to Standard Object tab
  6. Search for the Data Workbench object Contact
  7. Select Download
  8. Fill data in the fields
  9. Save the file
  10. Select Next and Browse for the file
  11. Select Upload
  12. Choose Next
  13. Select Import
  14. In the Monitor tab, check for the respective Task ID
  15. The records in the file have the Processing Error

Cause

The message is displayed due to one of the below reasons:

  1. In the import file, the EMail address was provided with inverted commas, that is "example@example.com".
  2. During the upload, the data mapping was missing for EMail

Resolution

Before copy pasting the EMail address to the .csv template, paste the same in a Notepad to see the format of the email address. Ensure that there are no inverted commas in it.

In the second step of import, maintain all the required mapping between Source and the Target Values.

Keywords

EMail, Contact , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer core applications 1.0 ; SAP Cloud for Customer core applications 1.5 ; SAP Cloud for Customer core applications 1305 ; SAP Cloud for Customer core applications 1308 ; SAP Cloud for Customer core applications 1311 ; SAP Cloud for Customer core applications 1402 ; SAP Cloud for Customer core applications 1405 ; SAP Cloud for Customer core applications 1408 ; SAP Cloud for Customer core applications 1411 ; SAP Cloud for Customer core applications 1502 ; SAP Cloud for Customer core applications 1505 ; SAP Cloud for Customer core applications 1508 ; SAP Cloud for Customer core applications 1511 ; SAP Cloud for Customer core applications 1602 ; SAP Cloud for Customer core applications 1605 ; SAP Cloud for Customer core applications 1608 ; SAP Cloud for Customer core applications 1611 ; SAP Cloud for Customer core applications 1702 ; SAP Cloud for Customer core applications 1705 ; SAP Cloud for Customer core applications 1708 ; SAP Cloud for Customer core applications 1711 ; SAP Cloud for Customer core applications 1802 ; SAP Cloud for Customer core applications 1805 ; SAP Cloud for Customer core applications 1808 ; SAP Cloud for Customer core applications 1811 ; SAP Cloud for Customer core applications 1902 ; SAP Cloud for Customer core applications 1905 ; SAP Cloud for Customer core applications 1908 ; SAP Cloud for Customer core applications 1911 ; SAP Cloud for Customer core applications 2002 ; SAP Cloud for Customer core applications 2005 ; SAP Cloud for Customer core applications 2008 ; SAP Cloud for Customer core applications 2011 ; SAP Cloud for Customer core applications 2102 ; SAP Cloud for Customer core applications 2105 ; SAP Cloud for Customer core applications 2108 ; SAP Cloud for Customer core applications 2111 ; SAP Cloud for Customer core applications 2202 ; SAP Cloud for Customer core applications 2205 ; SAP Cloud for Customer core applications 2208 ; SAP Cloud for Customer core applications 2211 ; SAP Cloud for Customer core applications 2302 ; SAP Cloud for Customer core applications 2305 ; SAP Cloud for Customer core applications 2308 ; SAP Cloud for Customer core applications 2311 ; SAP Cloud for Customer core applications 2402 ; SAP Cloud for Customer core applications 2405 ; SAP Cloud for Customer, core applications 2.0