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

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.".

• SAP Service Cloud v2
• SAP Sales Cloud v2

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.

A. Create option was selected, but the file used is from export function.

B. Update option was selected, but the file used is from Download Template function.

C. The CSV file was saved as CSV UTF-8 format.

D. There are commas in one of the extensions field labels. The Data Import parser treats the comma as a column separator, so it interprets this as two separate columns, resulting in a column count mismatch error.

A. When selecting the Create option, the system expects that the user will use the latest template from the "Download template" button. Do 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 selecting the Update method, the system expects that the user will 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. 

D. Commas are not supported within a column name. Please remove the comma from the Extension fields labels in the Extensibility Admin settings. 

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