SAP Knowledge Base Article - Public

3429417 - Error To Import Data "Number of Attributes in The File is Greater Than The Number Of Attributes in The Entity"

Symptom

Error to import data "Number of attributes in the file is greater than the number of attributes in the entity. Use the latest template to ensure correctness.".

Environment

  • SAP Service Cloud v2
  • SAP Sales Cloud v2

Reproducing the Issue

  1. Click on the profile icon.
  2. Go to Settings.
  3. Navigate to 'Import and Export data' screen.
  4. Click on the import button.
  5. Select Create.
  6. Fill the details and click on import data.
  7. Result: Error "Number of attributes in the file is greater than the number of attributes in the entity. Use the latest template to ensure correctness. " Is triggered.

Cause

The template you are using is not the correct one.

Resolution

When you select the Create option, the system expects that you use the latest template from the "Download template" button. You should not use the file from the Export function for creating new data. The file from Export should be used only for Update method.

Please follow the below steps to get the template for inserting new date into the system.

  1. Click on the profile icon.
  2. Go to Settings.
  3. Navigate to 'Import and Export data' screen.
  4. Click on the 'Download template' button to download a fresh template.
  5. Select the entity and download it.
  6. Fill the desired data in the new file and save it.
  7. Click on the import button.
  8. Select Create.
  9. Fill the details and add the new file.
  10. Click on import data.

Note: Do not remove or add any columns to the template when importing new data to the system.

Keywords

Data Import, Insert, Create, Template, Attributes, File , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , How To

Product

SAP Sales Cloud and SAP Service Cloud Version 2 1.0