Symptom
This KBA will display how to create or update records via any connector where the delimiter is included within a field.
On the example below, the field delimiter is a pipe character(|) and the same character is included in the title of an item:
CPNT_ID|CPNT_TYP_ID|NOTACTIVE|CPNT_TITLE!##!
TESTITEM|ILT|N|Title | with pipe(|) delimiter included within field !##!
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Populate input file with delimiter contained within a field >
- Run Connector >
- Connector Job fails or does not update as expected as pipe contained within the title field is treated as a delimiter.
Resolution
To make sure the conenctor does not treat the character as a delimiter it is importantto set up both the delimiter property and the escape character property in the connector configuration, and then configure our input file accordingly.
For example, if a pipe (|) character was utilized as the delimiter and a quotation mark as the escape character, we would set the two properties up as follows:
On System Admin > Configuration > System Configuration > Connectors:
connector.input.file.escapeChar="
connector.input.file.columnDelimiter=|
In this instance, the input file would have to look like the following (where pipe (|) delimits or defines where one field ends/starts and a quotation mark (") encloses the field where the same delimiter character is contained within a particular field):
CPNT_ID|CPNT_TYP_ID|NOTACTIVE|CPNT_TITLE!##!
TESTITEM|ILT|N|"Title | with pipe(|) delimiter included within field"!##!
Keywords
Connectors, delimiters, escape, characters, LMS, pipe, quotation, comma, configuration, learning, administration , KBA , LOD-SF-LMS-CON , Connectors , How To