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.

Until now I was a happy Datloader.io user as it allowed me on a Mac to insert from CSV and have this wonderful auto mapping feature where a Lookup or Master Detail relation can be pointed to an external Id field.

But...I just reached Dataloader.ios limits. No csv files bigger than 50 MB and with more than 40 MB the Dataloader.io reports an App crash.

The only offline dataloader for Mac that is a little bit more enhanced than Lexiloader seems to be Jitterbit's free Dataloader.

But I have a hard time figuring out how to resolve a lookup relationship with external id fields instead. Is that possible? And how?

share|improve this question
    
The good old lexi-loader also can upsert with external ids. Such a helpful one –  Ralph Feb 25 '13 at 16:17
add comment

1 Answer 1

up vote 4 down vote accepted

When you get to what appears to be the end of the New Upsert Wizard, you will be prompted to "Map & Finish" on a button. Click that, and you'll see a screen where you complete your mapping (see pic below).

Any related objects that have available External Id fields will appear at the top of the right hand list of object fields with a "+" to expand. Expand that to get to your related External Ids.

Mapping to related External Id Fields in Jitterbit

From there drag the field on left to field on right (not tried the other way, but it might work), and you should be set.

share|improve this answer
    
I love Jitterbit. I've demoed it to people who are shocked that it's free. –  Shane McLaughlin Feb 26 '13 at 13:19
add 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.