2383649 - Can Learning connectors read CSV input files?

Can Learning connectors read CSV input files?

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP SucessFactors Learning

Yes, Learning connectors can read CSV input files. In order to do so, the connector.input.file.format.csv.enable=true property needs to be added to the CONNECTORS configuration. Note that the file extension can also use .txt but for this, the delimiter used has to be a comma (,). This is because when this property is added, the connector ignores other columns, rows, and escape properties defined.

If this change needs to be done for a specific connector only, then add aaa.connector.input.file.format.csv.enable=true - where aaa is the connector's interface prefix (ex. item).

IMPORTANT: All connectors will pick up files with ".csv" extension according to property "connector.input.file.processingorder=txt,TXT,csv,CSV,zip,ZIP".

However, to process a csv file (containing comma separated values), it can only be achieved by either using the above property or by setting the delimiter to process a comma delimited file (“connector.input.file.columnDelimiter=,”). To process both file extensions, ensure that both ".txt" and ".csv" extensions delimit by the same value within the file E.G pipe or comma (as per connector property  “connector.input.file.columnDelimiter=|”). If the following property "connector.input.file.format.csv.enable=true" both ".csv" and ".txt" files can only be comma delimited regardless of what is set at columnDelimiter connector property.

*Since this is a change to a default Learning administration's configuration, it is advised that you consult with a certified implementation partner before performing such change.

Example Steps (Organization Connector)

1. Go to System Administration >
2. Go to Configuration >
3. Go to System Configuration >
4. Click 'CONNECTORS' to edit it >
5. Add the following line:
   organization.connector.input.file.format.csv.enable=true
   
6. Upload the comma-delimited .txt file to the SFTP location >
7. Run the connector.

lms, learning, administration, successfactors, csv, format, instead, txt, connector, connectors, comma, delimited, comma-delimited, text , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , How To