[SalesForce] How to delete unwanted values from the new State/Country picklists

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.

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

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:

Thanks for the post Jeremy. It put us on the track to do resolve our problem. We still maintain that SF would better serve its end users by implementing as we suggested in the initial post, but it is what it is . Posting here for the benefit of others who may have run into this kind of problem.

The only problem with get/put is that in order to use get, you must have queried the original field before calling it, else you will get a runtime SOQL error: "SObject row was retrieved via SOQL without querying the requested field: "

Curiously, the put will work regardless.

The way around this is to use Dynamic SOQL Query, something like:

public class ChangeAccountBillingAddress
{
public List<Account> oAccount; 
public Id apCurPage {get; set;}
private String stateFieldName = 'BillingState';
private String countryFieldName = 'BillingCountry';

public ChangeAccountBillingAddress(ApexPages.StandardController controller) 
{
    apCurPage = ApexPages.currentPage().getParameters().get('id');

    if(PickListsEnabled())
    {
        stateFieldName = 'BillingStateCode';
        countryFieldName = 'BillingCountryCode';
    }
    String acctQuery = String.escapeSingleQuotes('select Account.BillingStreet, Account.BillingCity, Account.BillingPostalCode,' +
       stateFieldName + ',' + countryFieldName + ' from Account where Id =:apCurPage');

    oAccount = Database.query(acctQuery);
}


public PageReference ChangeBillingAddress()
{
    String stateVal = oAccount[0].get(stateFieldName);
    if(stateVal != 'IL')
    {
         oAccount[0].BillingStreet = '1060 W Addison St';
         oAccount[0].BillingCity = 'Chicago';
         oAccount[0].put(stateFieldName,'IL');
         oAccount[0].BillingPostalCode = '60613-4566';
         oAccount[0].put(countryFieldName,'US');
         update oAccount;
    }

    PageReference pageRef = new PageReference('/' + apCurPage);         

    pageRef.setRedirect(true);         
    return pageRef;               
}

private boolean PickListsEnabled()
{
     // if Account Billing Address is enabled, assume all addresses are enabled
     //return Account.BillingCountry.getDescribe().getType() == Schema.DisplayType.Picklist;
     Map<String, Schema.SObjectField> M = Schema.SObjectType.Account.fields.getMap();
     return M.containsKey('BillingStateCode');
}

}

The above code will compile and more importantly run correctly on orgs with picklistst enabled or picklists not enabled.