Välj en organisation
Extra line breaks are added to the rich text fields of Knowledge object when importing CSV by Dataloader v60 or higher
Publiceringsdatum: Apr 2, 2026
Beskrivning
Extra line breaks are added to the rich text fields of Knowledge object when importing CSV by Dataloader v60 or higher.
In Dataloader v59, LF is converted to blank space. This behavior change leads to add the extra line breaks to the rich text fields because of the following reasons:
1) New Lightning Article Editor add spaces between <p> tag when adding line breaks in rich text field.
UI:
Data:
----
<p>test1</p> <p>test2</p> <p>test3</p>
----
2) When exporting this data by Dataloader (version is not related), spaces (20) are converted to LF (0A).
"<p>test1</p>
<p>test2</p>
<p>test3</p>"
3) And when importing this data by Dataloader v60 or higher, LF is converted to <BR> tag which leads to extra line breaks.
UI:
Data:
----
<p>test1</p><br><p>test2</p><br><p>test3</p>
----
Lösning
Dataloader contains a config property sfdc.load.preserveWhitespaceInRichText that causes the line breaks to be converted into BR tags.
"sfdc.load.preserveWhitespaceInRichText" is a read-only property that's set to true by default. So, if you set it to false in config.properties file (making sure that data loader is not running when you modify config.properties file), you will get intended behavior.
You upload two kinds of texts in RTF field:
- Text containing HTML formatting - in this case you explicitly want to control formatting. Setting "sfdc.load.preserveWhitespaceInRichText=false" supports this case.
- Text with tabs, line breaks, and such - in this case you hasn't explicitly specified formatting but preserve your whitespaces. Setting "sfdc.load.preserveWhitespaceInRichText=true" supports this case. It is the default setting.
Ytterligare resurser
Knowledge-artikelnummer
004633920
Löste denna artikel ditt problem?
Berätta för oss vad vi kan förbättra!
