SAP Knowledge Base Article - Public

3587104 - Incorrect number of records in import count

Symptom

Incorrect number of records in Data Import count. For example, in the import file there was one record but the import is completed with error showing more than 10 records in the count.

Environment

SAP Sales Cloud and SAP Service Cloud Version 2

Cause

The root cause for the issue is that it was used a CSV (Comma-separated values) file and on the lines there was content added between commas ',', which causes issues to the CSV format. Example of scenario: In the import of emails commas were added to the HTML content field.

Resolution

In such scenarios, it's necessary to use the excel (.xlsx) format for import.

Keywords

Import, Email, Comma, Incorrect, Number, Count , 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