Skip to main content

Hi All,

I have seen some community articles and even Salesforce help articles: Data Loader behavior with Bulk API enabled using 'Insert null values' (salesforce.com)

which specify how to make field values null while using the <Bulk Api> option of data loader.

However, I am not able to make it work, am not sure if it works at all.

 

1. I have tried with csv where field values were blank, and it did not work.

2. I have tried with CSV where field values were explicitly mentioned as <#N/A>, it failed with following error

Error converting value to correct data type: For input string: "#N/A".

 

If anyone was able to make it work, your detailed insights would be helpful.

Thanks

3 réponses
  1. 14 juin, 22:14

    I had this same question -- please note that the question is explicitly regarding using the Bulk API, which you have to turn off to utilize the "Insert Null Values" option in Dataloader. I run into CPU timeout issues when I run it with the Bulk API turned off. 

     

    The answer is that you can enter "#N/A" into the cells you want to be made blank, as would be returned from an unmatched value in a VLOOKUP. One response I found said to enter "#.N/A" and the period may be a typo. Do not use a period.  

     

    TL;DR -- Enter "#N/A" to overwrite data in a field when using Bulk API in Dataloader.