SAP Knowledge Base Article - Public

3736939 - CSV File Import is shown as completed but the change is not reflected

Symptom

CSV File import via Data Import and Export tool shows completed but in the total count it displays 0 records. Besides that, the change is not reflecting in the system.

Environment

SAP Sales and Service Cloud Version 2

Reproducing the Issue

  1. Open Data Import and Export view.
  2. Click on import button.
  3. Select create.
  4. Select the Entity.
  5. Uncheck complete entity.
  6. Enable simulation mode.
  7. File type as CSV.
  8. Select the file.
  9. Click on import data.

Cause

CSV Formatting issue. When the file is opened with text editor such as Notepad, it's possible to note the CSV file was saved with semicolon separators and enclosing double quotes instead of a comma-delimited format, so the data import tool processed 0 records.

Resolution

  • Open the source file in a plain text editor and review the raw data. If there are semicolons and enclosing double quotes, the format is incorrect.
  • Re-save or export the file as CSV (Comma delimited (.csv)), ensuring fields are separated by commas.
  • Do not save the file as UTF-8.
  • Re-run the import with the corrected CSV.
  • If the issue persists, try importing an Excel file type or export the CSV using a different spreadsheet application and import again.

Keywords

data impex, import completed 0 records, zero records imported, csv, comma delimited, semicolon, double quotes, encoding, utf-8, entity, data import, service cloud v2, csv formatting , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , Problem

Product

SAP Sales Cloud and SAP Service Cloud Version 2 all versions ; SAP Service Cloud Version 2 all versions