+ Start a Discussion
CRM TrendCRM 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
 
SuperfellSuperfell
Make sure you've enabled the send null values option in the preferences.
Cool_DevloperCool_Devloper
Hi Simon
 
Thanks for your response. Well i wanted to update a value to NULL using Update or Upsert. i have checked the send NULL value option also in the settings but still the old value is not being updated to NULL.
 
Does that mean that it is not possible to update a value to NULL if it already has a non-null value ???
 
Kindly help!!
 
Thanks again
geis6geis6
This works fine for me if you select the insert null values option.

Cheers,
Ward
jheuveljheuvel

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!

Cool_DevloperCool_Devloper

Are you facing this issue in case of record insertion or update while doing an Upsert?

Ideally, it should work for both!

Cool_D

jheuveljheuvel

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

Solution MasterSolution Master

Try updating the field to #N/A. This should solve it.