This KBA is to demonstrate how to configure the mapping of additional custom columns to a connector file in LMS.
If this is not configured correctly and error may occur preventing the column from being updated.
SAP SuccessFactors Learning Management System (LMS) - All Supported Versions
If this is not configured correctly an error can occur in the error log:
Column doesn't exists :COL_NUM"X"_VAL in tables [pa_conn_stud_user, pa_conn_student]
Where X is the custom column number.
When we talk about mapping new custom columns to a connector file we are simply saying that we want to add additional column/header fields to our input file to reflect custom columns that have already been created in the LMS UI and are not already defined in the Connectors Workbook.
Custom columns are created in the LMS to capture data for an entity in the form of Columns or fields that do not already exist in the system by default. Such columns/fields can be added to entities such as Item, User, Curriculum or Scheduled Offering.
While most of these custom columns can be updated by their respective connector, only the Item and User Connectors currently allow for the mapping of additional custom columns in their corresponding input files. All the other connectors do not currently allow for more custom columns to be mapped other than those already mapped by default and listed in the Connector Workbook*.
*This includes the user_extended_data input file which is processed by the SF User Connector but whose input file is configured and mapped separately.
Mapping Additional Custom Columns (for User & Item Connectors Only)
- When mapping additional custom columns to the user and item connectors the first step is to manually create them in the system.
- This is done in System Admin > Custom Columns > Item/User.
- Call these columns whatever you desire but it is important to take note of the column number.
- Once you have these column numbers you are ready to map in the Connector Configuration file.
- Additional columns are constructed in the following way: user.field.customcolumn.<col_num>=<field mapping from input file>
- The col_num is the custom column number as set up in the LMS. The field mapping from the input file is the input field that you are mapping to this custom column.
- For example, if you want to add custom columns 200, 300, 400, and 500 to the User or Item Connector then you would add the following to the properties file:
- User Connector (user_data file)
user.field.customcolumn.200=<field mapping from input file>
user.field.customcolumn.300=<field mapping from input file>
user.field.customcolumn.400=<field mapping from input file>
user.field.customcolumn.500=<field mapping from input file>
- SF User Connector (user_data file)
sfuser.field.customcolumn.200=<field mapping from input file>
sfuser.field.customcolumn.300=<field mapping from input file>
sfuser.field.customcolumn.400=<field mapping from input file>
sfuser.field.customcolumn.500=<field mapping from input file>
- Item Connector (item_data file)
item.field.customcolumn.200=<field mapping from input file>
item.field.customcolumn.300=<field mapping from input file>
item.field.customcolumn.400=<field mapping from input file>
item.field.customcolumn.500=<field mapping from input file>
It is important to remember that mapping additional custom columns is only supported by the three connectors referenced above. Attempting to map additional custom columns (other than those referenced in the Connectors Workbook) to any other connector in the same way as above will result in unexpected errors or erroneous updates. This is because there are currently no validation checks in place in the code base for their associated input files other than for those columns referenced in the Connectors Workbook.
This also means that custom columns created by admins (other than the default 15 custom columns) cannot be used in the copy rule.
LMS; Custom Columns; Mapping; Connectors; Connector Configuration; Item Connector; User Connector , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , How To