[SalesForce] State and Country Picklist Causing Issues with Import

I'm tried to import Accounts into an instance with Country Picklists enabled and running into issues.

If the country of the record is not the country set as Default in SFDC State and Country Picklist setting, it doesn't recognize the Country code Qand the record inserts fail.

Anyone else experience the same problem?

-Quade

Best Answer

I tried out Jitterbit 5.0.3.8 on my sandbox instance which has state and country picklists enabled

With no default country enabled

Test data was two rows - One specifying BillingCountry as Denmark, the other as DK.

enter image description here enter image description here enter image description here enter image description here

As you can see, the row that mapped DK to BillingCountry failed as expected. Jitterbit (free) won't let you map to BillingCountryCode as far as I can see; In fact, you can't even query on the column BillingCountryCode (!)

I repeated the test with a default country = Argentina

Results exactly the same as above

Now, I changed the Integration Value (thanks @Carolyn) to DK from Denmark

enter image description here

In this case, the row mapping 'Denmark' to BillingCountry fails but the row mapping 'DK' to BillingCountry succeeds.

However, with DataLoader (I used V30), you can map ISO country codes to BillingCountryCode.

This input worked fine and created valid Denmark Accounts in both cases:

enter image description here

enter image description here

Related Topic