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
- Login to Learning administration
- Select necessary Entity type and import option
- Select the desired file to import quiz/question/exam with spaces in excel.
- 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