SAP Knowledge Base Article - Public

2383649 - Can LMS connectors read CSV input files?

Symptom

Can LMS 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."

Environment

SuccessFactors Learning Management System

Resolution

Yes, LMS connectors can read CSV input files. In order to do so, property connector.input.file.format.csv.enable=true needs to be added to the CONNECTORS configuration. Note that file extension still should be .txt but the delimmiter should 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 LMS configuration, it is advised that you consult with a certified implementation partner before performing such change.

Example Steps (Organization Connector)

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

Keywords

.csv format CSV instead of .txt connector connectors TXT comma delimited comma-delimited text , KBA , LOD-SF-LMS-CON , Connectors , How To

Product

SAP SuccessFactors Learning all versions