SAP Knowledge Base Article - Public

3606344 - Breaking Line/Starting New Line for Question and Answer Text When Importing Exam in SAP SuccessFactors Learning

Symptom

  • When creating new Assessment/Exam questions in question library, it is possible to break the line (like pressing Enter to start a new line in Word and Alt + Enter in Excel).
  • However, when using the import function in the Import Data, blank spaces are truncated in questions and answers.
  • The issue is observed when attempting to import data through the Import Data tool in SAP SuccessFactors Learning.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Login to Learning administration
  2. Navigate to System Administration> System Management Tools> Import Data
  3. Select necessary Entity type and import option
  4. Select the desired file to import quiz/question/exam with spaces in excel.
  5. Notice that all the empty spaces are truncated.

Cause

Resolution

To insert text in different lines, mention the text in columns of excel as shown in the example below:

<p>This is the first line</p>
<p></p>
<p>This one is after a line break.</p>

The above text will be displayed as mentioned below in the UI once the file is imported successfully:

"This is the first line

This one is after a line break."

Keywords

New line, Import Data Tool, Assessment, Exam, questions, line break, text formatting. , KBA , LOD-SF-LMS-IMP , Import Data Tool , How To

Product

SAP SuccessFactors Learning all versions