Tell me more ×
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.
up vote 3 down vote favorite
1

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

1 Answer

up vote 6 down vote

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 Feb 20 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 at 16:10
I can't use Informatica as I am on a Mac :-( – Robert Feb 21 at 10:58
Does anybody know when Dataloader.io will support null values?! – Robert Feb 21 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 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.