Symptom
This KBA explains the different types of Extension files that can be used for connectors.
Environment
SAP SuccessFactors Learning
Resolution
Connector will accept below 4 types of extension files:
- txt,TXT
- csv,CSV,
- zip,ZIP,
- xml,XML
To accept these extension types, add the settings below by navigating to System Admin > Configuration > System Configuration > Connectors
connector.input.default.file.extension=.txt
connector.input.file.processingorder=txt,TXT,csv,CSV,zip,ZIP,xml,XML
item.connector.input.file.multiple=true
IMPORTANT: All connectors will pick up files with ".csv" extension according to property "connector.input.file.processingorder=txt,TXT,csv,CSV,zip,ZIP"
- Processing a csv file (containing comma separated values) can only be achieved by either setting the delimiter to process a comma delimited file (“connector.input.file.columnDelimiter=,”) or by using the following connector property "connector.input.file.format.csv.enable=true".
- 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.
See Also
KB article 2383649 - FAQ- CSV file for the connectors instead of .txt
Keywords
type, csv, zip, xml, txt, format, order, sf, success factors, LMS , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-CON , Connectors , How To