Description
Changing a column label causes unexpected or blank results with easy import.
Steps to Reproduce
- Navigate to System Definition > Dictionary.
- Add a new column into the table [ast_contract]:
- Type: String
- Column label: Column A
- Max length: 100
- Navigate to [ast_contract].
- Initiate an easy import.
- Download the Excel Template.
- Populate the column named Column A with any value (for example, TEST 1).
- Upload the Excel Template.
- Follow through (Preview Imported Data) and then Complete Import.
This creates the temporary import table and transform map. - Navigate back to System Definition > Dictionary.
- Modify the the label for Column A (from step 2) to Column Z (must be alphabetically after the previous label).
- Navigate to [ast_contract].
- Initiate another easy import.
- Download the Excel Template.
- Populate the column named Column Z with any value (for example, TEST 2).
- Upload the Excel Template.
- Follow through (Preview Imported Data) and then Complete Import (adds new column to the temporary import table and create new transform map).
Column Z is not populated in the new record. Transform map is still mapping u_column_a to u_column_a, but expected behavior should be u_column_z to u_column_a.
Workaround
Delete the column with the old label from the temporary/staging import table. The transform map will then be able to map the correct columns.
Related Problem: PRB683829