Symptom
We have configured a Custom Column with import key as CUSTOM05.
Requirement is to fetch the UDF CUSTOM05 data into the custom column of the worksheet.
But it is giving blank value in the worksheet.
Environment
Compensation Worksheet
Reproducing the Issue
We have configured a custom field as below with import key as CUSTOM05,
But when we launch the worksheet, it returns a blank value in this column.
Cause
Ideally this configuration should give CUSTOM05 UDF data into the Column of the worksheet for those respective employees.
But we will have to check if "<comp-group id=" is defined. If yes, then import key will not fetch the UDF data.
Resolution
But the workaround for this would be, not to define the import key in the Custom Column.
Once you save this custom column in the Column Designer, there would be a column created in UDF in the format "<GROUPID>_<ColumnID>".
For example if Group ID defintion in the Template is like
<comp-group id="2017"/>
and Column definition in the Column Designer with Column ID = customField4,
Then the UDF Column would be '2017_customField4'. So you will have to populate the data into this column.
You will need to populate/import data into this column of the UDF, so that data from this field will come into the Custom Column of the worksheet for those respective employees.
Keywords
Import Key Custom Column , KBA , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , Problem