SAP Knowledge Base Article - Public

3284706 - Invalid UUID String Error When Trying to Import Data

Symptom

You are trying to import data to the system using the Data Import tool.

However, after trying to import any entity you receive the following error message in the Excel file:

Error: "Invalid UUID String: ABC"

ABC represents the incorrect value that was inserted in a field from the file.

Environment

  • SAP Sales Cloud v2
  • SAP Service Cloud v2

Cause

The error is appearing because the value added for the field is not valid. It should be in the UUID format.

For example: 00163a03-551b-1ed2-af92-926b6853eaf7 is a valid UUID format, not the display ID 10000XX. 

Resolution

The affected field only support UUID format, so this value should be maintained in the import file.

You can get UUID of any entity from exported data:

  1. Go to Settings.
  2. Enter Data Import and Export view.
  3. Click on Export button.
  4. Select affected entity.
  5. Apply a filter.
  6. Click on Export data.

Then from the exported file, you can get UUID / ID of the entity filtered.

*(Contact can use Export contacts, owner can use Export for employee, for example) 

Keywords

Data Import, Invalid UUID String , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , How To

Product

SAP Sales Cloud and SAP Service Cloud Version 2 all versions