When exporting a CSV file from SuccessFactors via Integration Center, the records are in 2 separate column.
SAP SuccessFactors HCM Suite
- Integration Center (IC)
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.
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:
Integration Center (IC) Guide: https://help.sap.com/doc/0c0be9005af14c4f89b986a677bf270f/latest/en-US/SF_Integration_Center.pdf
Integration Center, Outbound Integration, CSV, Excel, Semicolon (;), Separate Columns , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To