Error WARN in Item Connector

[PTecnico]

Hi for 

I am using the item connector and the system is generating the following error:

I have checked the following notes:

https://help.sap.com/docs/SAP_SUCCESSFACTORS_LEARNING/360d9b368c7b41c3aede8505d0f3bd56/d9a4d1a47cdf4...

https://userapps.support.sap.com/sap/support/knowledge/en/2541612

Regards

[PL1 · Accepted solution]

@PTecnico, about the "connector.input.file.name.tenant.suffix.override" setting, it should only contain the suffix value. For example, the file name is "item_data_abc" > "connector.input.file.name.tenant.suffix.override=abc". Check if the "connector.input.file.format.csv.enable" setting exists in the "CONNECTORS" configuration and if it's "true". If yes, take a look at the KBA 2304614. Make sure that the SFTP user used to place the file in the SFTP path is the same one set in the "connector.ftp.userID" "CONNECTORS" configuration line.

[PTecnico · Accepted solution]

Hi PL1, I have this configuration connector.input.file.name.tenant.suffix.override=my_sufix and the line connector.input.file.format.csv.enable ,

connector.input.default.file.extension=.txt
connector.input.file.processingorder=txt,TXT,csv,CSV,zip,ZIP,xml,XML
item.connector.input.file.multiple=true

And now the error that appear is:

CPNT_ID|CPNT_TYP_ID|REV_DTE|DMN_ID|NOTACTIVE|CPNT_TITLE|DEL_MTH_ID|SUBJ_AREA_1|SUBJ_AREA_2|SUBJ_AREA_3|CONTACT|CPNT_DESC|COMMENTS|CMPL_STAT_ID|CPNT_LEN|AUTO_FILL_ENRL|ENRL_THRESHOLD_DAYS|SCHEDULE_CAN_OVERRIDE_PRICE|RTYP_ID|CPNT_SRC_ID|SAFETY_REL|CREATE_DTE|INIT_NUMBER|INIT_PERIOD_TYPE_ID|INIT_BASIS_TYPE_ID|RETRNG_NUMBER|RETRNG_PERIOD_TYPE_ID|RETRNG_BASIS_TYPE_ID|REV_NUM|REVISER|APPRVR|APPRVD|APPRVL_DTE|MIN_ENRL|MAX_ENRL|PREP_LEN|DEFAULT_PUB_PRICE|LES_PLAN|CREDIT_HRS|CPE_HRS|CONTACT_HRS|STUD_MATS|INST_MATS|CPNT_GOALS|TGT_AUDNC|GRADE_OPT|CHGBCK_METHOD!##!
CVCS00000001|CAPACIT||ABC|ACTIVO|Test||CVCS|||||||||||OPC||||||||||||||||||||||||||||!##!

[PL1 · Accepted solution]

Is there a transform data rule to accept "ACTIVO" as the status value? As per the Course (Item) Data Connector File Columns, the values would be "N" and "Y".

[PTecnico · Accepted solution]

Hi PL1,

I have been able to solve the problem with the following format TXT

CPNT_ID|CPNT_TYP_ID|REV_DTE|DMN_ID|NOTACTIVE|CPNT_TITLE|DEL_MTH_ID|SUBJ_AREA_1|SUBJ_AREA_2|SUBJ_AREA_3|CONTACT|CPNT_DESC|COMMENTS|CMPL_STAT_ID|CPNT_LEN|AUTO_FILL_ENRL|ENRL_THRESHOLD_DAYS|SCHEDULE_CAN_OVERRIDE_PRICE|RTYP_ID|CPNT_SRC_ID|SAFETY_REL|CREATE_DTE|INIT_NUMBER|INIT_PERIOD_TYPE_ID|INIT_BASIS_TYPE_ID|RETRNG_NUMBER|RETRNG_PERIOD_TYPE_ID|RETRNG_BASIS_TYPE_ID|REV_NUM|REVISER|APPRVR|APPRVD|APPRVL_DTE|MIN_ENRL|MAX_ENRL|PREP_LEN|DEFAULT_PUB_PRICE|LES_PLAN|CREDIT_HRS|CPE_HRS|CONTACT_HRS|STUD_MATS|INST_MATS|CPNT_GOALS|TGT_AUDNC|GRADE_OPT|CHGBCK_METHOD!##!
CVCS00000001|CAPACIT|JAN-31-2025 12:00:11|myDomain|Y|Test||CVCS|||||||||||OPC||||||||||||||||||||||||||||!##!

However I want process both file extensions ".txt" and ".csv" extensions delimit by pipe or comma

I have the property configurated as:

connector.input.file.columnDelimiter="|”

connector.input.file.format.csv.enable=true

I have followed the note:

https://me.sap.com/notes/2304614/e

But this not work with format CSV

This is my file in formar CSV

CPNT_ID,CPNT_TYP_ID,REV_DTE,DMN_ID,NOTACTIVE,CPNT_TITLE,DEL_MTH_ID,SUBJ_AREA_1,SUBJ_AREA_2,SUBJ_AREA_3,CONTACT,CPNT_DESC,COMMENTS,CMPL_STAT_ID,CPNT_LEN,AUTO_FILL_ENRL,ENRL_THRESHOLD_DAYS,SCHEDULE_CAN_OVERRIDE_PRICE,RTYP_ID,CPNT_SRC_ID,SAFETY_REL,CREATE_DTE,INIT_NUMBER,INIT_PERIOD_TYPE_ID,INIT_BASIS_TYPE_ID,RETRNG_NUMBER,RETRNG_PERIOD_TYPE_ID,RETRNG_BASIS_TYPE_ID,REV_NUM,REVISER,APPRVR,APPRVD,APPRVL_DTE,MIN_ENRL,MAX_ENRL,PREP_LEN,DEFAULT_PUB_PRICE,LES_PLAN,CREDIT_HRS,CPE_HRS,CONTACT_HRS,STUD_MATS,INST_MATS,CPNT_GOALS,TGT_AUDNC,GRADE_OPT,CHGBCK_METHOD,SHOW_IN_CATALOG,COL_NUM1_VAL,COL_NUM2_VAL,COL_NUM3_VAL,COL_NUM4_VAL,COL_NUM5_VAL,PRICE_CURRENCY_CODE,LEVEL1_SURVEY,LEVEL3_SURVEY,CATALOG_1,CATALOG_2,CATALOG_3,APP_ID,BUILD_USER,BUILD_COMPANY,BUILD_LOC,BUILD_DATE,DEVELOPER_TOOL,CONTENT_ONLINE,LAUNCH_TYPE,PRIMARY_PARAM,OFFLINE_PRIMARY_PARAM,SECONDARY_PARAMS,AICC_SUPPORT,ENABLE_CROSSDOMAIN,ITEM_ONLINE,ITEM_ONLINE_ONLY,REVIEWABLE,DAYS_TO_EXPIRATION,FAIL_STAT_ID,AICC_MAX_NORMAL,MODULE_NAME,MASTERY_SCORE,REMOVE_CPNT_MODULE_FLAG,ESIG_ENABLED,INCLUDE_IN_GOVT_REPORTING,TRAINING_TYPE,LGL_ENTITY_2483_ID,ENABLE_RATING,INCLUDE_PREV_REV_RATING,MODULE_TYPE,CONTENT_WRAPPER_TYPE,EXAM_REVIEW_OPTION,NODE_LEVEL,NODE_NO,OFFLINE_ACCESSIBLE,APP_DMN_ID,APP_DESCRIPTION,APP_NOTACTIVE,APP_TITLE,AUTO_COMPETENCY,THUMBNAIL_URI,FAILURE_ACTION,REPEAT_COUNT,OFFLINE_FILE_PATH,SELF_ENRL,ENABLE_ORDER,APPROVAL_REQD,TAP_DEF_ID,SELF_RECORD_LRNGEVT,SUB_RECORD_LRNGEVT,USE_AICC_WRAPPER,HTML_CPNT_DESC,TRIGGER_CPNT_PASS,TRIGGER_CPNT_FAIL,PARENT_MODULE_NAME,FORCE_ORDER,LOCALE,USER_CAN_WAITLIST,SUPER_ENRL,WITHDRAW_TAP_DEF_ID,WITHDRAW_APPROVAL_REQD,LAUNCH_IN_A_NEW_BWSR_WINDOW,PRODUCTION_READY,SCHED_CAN_OVERRIDE_CAN_POLICY,CANCEL_POLICY_ID,SKIP_CONTENT_STRUCTURE_PAGE,NOTIFY_ASSGMNT_WITHOUT_DUEDATE,USER_CAN_REMOVE_OPT_ASSGNMT
CVCS00000001,CAPACIT,JAN-31-2025 12:00:11,MyDomain,Y,Test2,,CVCS,,,,,,,,,,OPC,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

 What can be the cause?

Regards

[PL1 · Accepted solution]

The KBA 2304614 explains how to process both file extensions. Can you review it again?

[PTecnico · Accepted solution]

Dear

Please correct me if this is wrong, it is my understanding that: 

We have this properties configurated in 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

However when I try of upload the file CSV, the system generate attach error.

And this file CSV containing comma separated values. The system not should generate error , because the structure of the file CSV  containing comma separated values

The note says this:

• 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=|”).

R/ We have this configuration

connector.input.file.columnDelimiter="|"

And the the structure of the file CSV  containing comma separated values

• 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.

R/ We have this configurationin my System

connector.input.default.file.extension=.txt
connector.input.file.processingorder=txt,TXT,csv,CSV,zip,ZIP,xml,XML
item.connector.input.file.multiple=true

Regards

[PL1 · Accepted solution]

I don't see any error in the text. Either way, while "connector.input.file.format.csv.enable" is "true", the files need to be comma delimited.

[PTecnico · Accepted solution]

Hi

When I upload the file TXT and the connector run work fine, but I want onlu use the file CSV, the connector generate the error.

This is my file in format CSV and is separated by coma, however the system is generating the error

CPNT_ID,CPNT_TYP_ID,REV_DTE,DMN_ID,NOTACTIVE,CPNT_TITLE,DEL_MTH_ID,SUBJ_AREA_1,SUBJ_AREA_2,SUBJ_AREA_3,CONTACT,CPNT_DESC,COMMENTS,CMPL_STAT_ID,CPNT_LEN,AUTO_FILL_ENRL,ENRL_THRESHOLD_DAYS,SCHEDULE_CAN_OVERRIDE_PRICE,RTYP_ID,CPNT_SRC_ID,SAFETY_REL,CREATE_DTE,INIT_NUMBER,INIT_PERIOD_TYPE_ID,INIT_BASIS_TYPE_ID,RETRNG_NUMBER,RETRNG_PERIOD_TYPE_ID,RETRNG_BASIS_TYPE_ID,REV_NUM,REVISER,APPRVR,APPRVD,APPRVL_DTE,MIN_ENRL,MAX_ENRL,PREP_LEN,DEFAULT_PUB_PRICE,LES_PLAN,CREDIT_HRS,CPE_HRS,CONTACT_HRS,STUD_MATS,INST_MATS,CPNT_GOALS,TGT_AUDNC,GRADE_OPT,CHGBCK_METHOD,SHOW_IN_CATALOG,COL_NUM1_VAL,COL_NUM2_VAL,COL_NUM3_VAL,COL_NUM4_VAL,COL_NUM5_VAL,PRICE_CURRENCY_CODE,LEVEL1_SURVEY,LEVEL3_SURVEY,CATALOG_1,CATALOG_2,CATALOG_3,APP_ID,BUILD_USER,BUILD_COMPANY,BUILD_LOC,BUILD_DATE,DEVELOPER_TOOL,CONTENT_ONLINE,LAUNCH_TYPE,PRIMARY_PARAM,OFFLINE_PRIMARY_PARAM,SECONDARY_PARAMS,AICC_SUPPORT,ENABLE_CROSSDOMAIN,ITEM_ONLINE,ITEM_ONLINE_ONLY,REVIEWABLE,DAYS_TO_EXPIRATION,FAIL_STAT_ID,AICC_MAX_NORMAL,MODULE_NAME,MASTERY_SCORE,REMOVE_CPNT_MODULE_FLAG,ESIG_ENABLED,INCLUDE_IN_GOVT_REPORTING,TRAINING_TYPE,LGL_ENTITY_2483_ID,ENABLE_RATING,INCLUDE_PREV_REV_RATING,MODULE_TYPE,CONTENT_WRAPPER_TYPE,EXAM_REVIEW_OPTION,NODE_LEVEL,NODE_NO,OFFLINE_ACCESSIBLE,APP_DMN_ID,APP_DESCRIPTION,APP_NOTACTIVE,APP_TITLE,AUTO_COMPETENCY,THUMBNAIL_URI,FAILURE_ACTION,REPEAT_COUNT,OFFLINE_FILE_PATH,SELF_ENRL,ENABLE_ORDER,APPROVAL_REQD,TAP_DEF_ID,SELF_RECORD_LRNGEVT,SUB_RECORD_LRNGEVT,USE_AICC_WRAPPER,HTML_CPNT_DESC,TRIGGER_CPNT_PASS,TRIGGER_CPNT_FAIL,PARENT_MODULE_NAME,FORCE_ORDER,LOCALE,USER_CAN_WAITLIST,SUPER_ENRL,WITHDRAW_TAP_DEF_ID,WITHDRAW_APPROVAL_REQD,LAUNCH_IN_A_NEW_BWSR_WINDOW,PRODUCTION_READY,SCHED_CAN_OVERRIDE_CAN_POLICY,CANCEL_POLICY_ID,SKIP_CONTENT_STRUCTURE_PAGE,NOTIFY_ASSGMNT_WITHOUT_DUEDATE,USER_CAN_REMOVE_OPT_ASSGNMT
CVCS00000001,CAPACIT,JAN-31-2025 12:00:11,MyDomain,Y,Test2,,CVCS,,,,,,,,,,OPC,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

[PL1 · Accepted solution]

There must be something wrong in the "CONNECTORS" configuration. While internally testing it, the connector file is being found and read.