SAP Knowledge Base Article - Public

2967812 - CSV records in separate columns when exporting from Integration Center

Symptom

When exporting a CSV file from SuccessFactors via Integration Center, the records are in 2 separate column.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Suite

  • Integration Center (IC)

Cause

This is not an error from Integration Center, this is an expected behavior from Excel and it occurs due to a semicolon (;) in the field value.

Resolution

To export the CSV file correctly, go to the Options tab:

  • Output File Type: Simple Delimited;
  • File Delimiter: Semicolon (;);
  • Header Type: Your choice;
  • Footer Type: Your choice;
  • Use Double Quotes - Enable

The output file should be exported as the following image:

See Also

Integration Center (IC) Guide: https://help.sap.com/doc/0c0be9005af14c4f89b986a677bf270f/latest/en-US/SF_Integration_Center.pdf

Keywords

Integration Center, Outbound Integration, CSV, Excel, Semicolon (;), Separate Columns , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HXM Suite all versions

Attachments

Pasted image.png