Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

I'm uploading records with the amazing dataloader.io and have a hard time to upload some records with NO value for optional fields. What do I have to put in those fields?

  • #N/A
  • 'null'
  • NULL
  • ''
  • ""
  • 0

Is there a definite guide or reference document that answers this?

share|improve this question
add comment

1 Answer 1

Inserting null values is an option that you need to manually set for the api call. Once you set that option you just leave the cells empty and it will null out any fields where the cell is empty.

In dataloader.io you set this option here: null setting

That option is greyed out for me and from the dataloader.io discussion boards it looks like they haven't implemented this feature yet so you may have better luck using the regular dataloader to do this. With the regular data loader you do this here: enter image description here

share|improve this answer
    
I can't use the standard dataloader as it does not allow me to auto-relate fields like the dataloader.io does. –  Robert Sösemann Feb 20 '13 at 16:05
1  
@RobertS You might want to look at the free informatica data loader. I know it has auto-mapping for fields/columns with the same name and supports inserting null values. –  Greg Grinberg Feb 20 '13 at 16:10
    
I can't use Informatica as I am on a Mac :-( –  Robert Sösemann Feb 21 '13 at 10:58
    
Does anybody know when Dataloader.io will support null values?! –  Robert Sösemann Feb 21 '13 at 10:59
1  
@RobertS Have you tried Jitterbit data loader? I know it works on mac and I believe it supports auto-relation. –  Greg Grinberg Feb 21 '13 at 14:52
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.