3625739 - Import shows more records than the imported amount

Data Impex tool shows an import task with more records than the file that was imported when using CSV file type.

• SAP Sales Cloud V2
• SAP Service Cloud V2

1. Navigate to "Settings" > "All Settings".
2. Access the "Data Import and Export" tool.
3. Select "Create" and choose any entity.
4. Upload a CSV file with e.g. 10 records.
5. Click on the "Import Data" button.
6. Observe that the system displays a total count of e.g. 20 records instead.

The issue occurs due to improper handling of CSV files where a single data entry is inadvertently split across multiple rows. This can happen if new line characters are introduced by the text editor used to create the CSV file.

Ensure that the CSV file is created and formatted correctly:

• Avoid introducing new line characters within a single data entry.
• Identify the incorrect records by cross-referencing the imported data with the original file.
• Delete the incorrect records if necessary. 

CSV File, Import, Data Impex, Importing, Records , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , Problem