3204684 - CSV Output File Genereated from Integration Center Breaking the Subsequent Fields After the Field "File Content" in Excel - Recruiting Management

When generating a CSV output file from Integration Center and opening it in Excel, all subsequent fields after the File Content field are being moved to the next rows. Here's an example:

As you can see in the example, the fields after "File Content" were moved to the row 5.

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

SAP SuccessFactors Recruiting Management

The field "File Content" represents the attachment file in a Base64 encoding scheme. Depending on the file extension and size, the value for the "File Content" can have a extremely high number of characters that will be representing the file. Excel only supports 32,767 characters per cell and if the number of characters exceeds this limit, the subsequent fields will be incorrect displayed due to this limitation from Excel side.

For more details on the limits and characteristics from Excel, you can refer to the following document: https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

Since the issue is not caused by SuccessFactors, the workaround would be removing the "File Content" field from the integration or using a different tool to manage the CSV file.

To validate the character size from exported "File Content" field, you can open the CSV using Notepad or Notepad++ and copy the value to a character counter tool. If the length exceeds 32,767, this will the root cause.

CSV, integration, center, breaking, row, moving, replacing, excel, format, formatting, incorrect, incorrectly, order , KBA , LOD-SF-RCM , Recruiting Management , LOD-SF-INT , Integrations , Problem