You need to sign in to do that
Don't have an account?
CRM Trend
UPSERT using Apex Data Loader
Hi all
I have a query regarding UPSERT functionality of Apex Data Loader.I have a field value in Accounts where i want to change the value to NULL using UPSERT for all the existing records.But when i do that, the value still remains. Cant we update the value to NULL using UPSERT if there is any existing value??
Any help would be highly appreciable!!!
Thanks in Advance
Cheers,
Ward
This problem seems still to exist.
Is it the case that an UPSERT cannot overwrite filled fields with NULL?
Hope to hear from someone.
Thanks!
Are you facing this issue in case of record insertion or update while doing an Upsert?
Ideally, it should work for both!
Cool_D
In our case, when updating, empty fields in the csv would not overwrite existing values. Regardless of the 'send null value' setting.
We solved this in the before Update trigger, here we could check for null/empty values and empty the field via the trigger.
thanks,
jheuvel
Try updating the field to #N/A. This should solve it.