+2
Qualified

Data Loader - Case insensitive lookups for base fields

Athar Siddiqui 9 months ago in Integrations / Connectors updated by Tarun Chawla 9 months ago 1

Currently when we load activities via loader, the process use case sensitivity to validates lookup data in the data file e.g. if an activity type is Coupon FSI and the value in file is coupon FSI, the process will fail. This is true for all the fields which requires validation against master data in Aprimo. Another example is funding mode, if populate fixed amount instead of Fixed Amount in the file process will fail. This take unnecessary time and effort. Like to make validation case in sensitive.

Thanks.

Qualified

Hi Athar, I'm marking this enhancement request as qualified. For the time being I'd suggestion that if these values are coming from another system, to try to match up the casing in that system with Aprimo's casing. If these are being manually entered in a spreadsheet before loading to Aprimo, set up a dropdown in the spreadsheet (which has the additional benefit of ensuring users are picking valid values and won't misspell things either).