SAP Knowledge Base Article - Public

3267044 - Integration Center is breaking the lines incorrectly if the field has a long text as a value

Symptom

You have created an Integration Center Job to create a CSV file to be consumed by other application or solution and you have noted that when the CSV file is generated, it is breaking the lines incorrectly even when using different text editors.

Environment

  • Your integration center job is scheduled as Output File Type as CSV
  • The field causing the problem mus have a long text field such as the example below
    "Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source."

Reproducing the Issue

  1. Go to Integration center
  2. Create a job to export any data which contains long text fields
  3. Click in Save > Export Preview
  4. Note that even if you open with apps like Notepad++ or Sublime Text, the file seems to have broken lines

Cause

Incorrect Output File Type

Resolution

Please make sure that you are using True CSV

  1. In your integration, click in edit;
  2. In the first session "Options", change the Output File Type to "True CSV"
  3. Save and re-schedule your integration

Keywords

KBA , LOD-SF-INT-INC , Integration Center , How To

Product

SAP SuccessFactors HXM Suite all versions