3687981 - item_competency_data import fails with csv format, processes only with txt format

During the "item_competency_data" import for mapping attributes to Learning items, the import works only when the file is in txt format and When using csv format, the records are not processed, and the completion status shows "WARN - NO RECORDS".

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

SAP SuccessFactors Learning

1. Goto learning administration
2. Search for Download Connector Template and Download the item data connector
3. Fill the item Competency data to update Attribute and Prepare the "item_competency_data" file with learning item and attribute details and save it in csv format.
4. Now Prepare a blank "item_data" file with mandatory headers and save it in csv format as per https://help.sap.com/docs/successfactors-learning/importing-courses-with-learning-item-connector/course-competency-header-mapping-file-columns 
5. Place both files in the SFTP folder.
6. Run the item connector.
7. Observe the completion status showing "WARN - NO RECORDS" and the files not being processed.

• The connector configuration does not include the property "item.itemcompetency.connector.input.file.format.csv.enable=true", which is required to process csv files for "item_competency_data".
• Since we are trying to map the competency to the item data it is necessary to have the above configuration in the connector property.

Firstly make sure all the Configuration to read the CSV input files are set as per the mentioned KBA: 2383649 - Can Learning connectors read CSV input files? - SAP for Me 

1. Now Navigate to System Admin > Configuration > System Configuration > Connectors.
2. Add the following connector property:

• • "item.itemcompetency.connector.input.file.format.csv.enable=true".

2304614 - Different Types of Extensions for Connector Files in Learning - SAP for Me

learning, administration, successfactors, item_competency_data, csv format, txt format, WARN - NO RECORDS, SAP SuccessFactors Learning, item connector, SFTP folder, connector configuration, file processing, attribute mapping, Item_data , KBA , LOD-SF-LMS-CON , Connectors , Problem