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 or Update.
  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

A. You selected create option, and you are using a file from export function.

B. You selected update option, and you are using a file from Download Template function.

C. You have saved the CSV file as CSV UTF-8 format.

Resolution

A. 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 'Data Import and Export' 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.

B. When you select the Update method, the system expects that you first export the record and use that file to update the necessary data.

  1. Click on the profile icon.
  2. Go to Settings.
  3. Navigate to 'Data Import and Export' screen.
  4. Click on Export button.
  5. Select the entity.
  6. Use the filter to select the wanted records.
  7. Select file type.
  8. Click on Export data.
  9. Open the exported file and perform the changes you want.
  10. Save the file. Then you can go back to  'Data Import and Export' screen and upload the file for Update method.

Note: Do not remove or add any columns to the template when updating data.

C. This encoding is not supported to be imported in the system. Please save the files as just CSV format or xlsx and the import should occur correctly. 

Keywords

Data Import, Insert, Create, Template, Attributes, File, UTF-8, Update , 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