I'm trying to insert users pulled from one org to another org using Data Loader. The user CSV file has the Federation Id as column, pulled from the source org.
Here is the error for the failed records:
"The specified Federation ID already exists for this organization: SAML Federation ID"
I verified all the user records to make sure that this users doesn't exist in the Org to which I'm inserting.
I haven't tried this, but according to this site: http://www.interactiveties.com/b_bulk_api_nulls.php
If you use blank values (not #N/A) for the fields in the spread sheet pertaining to updates, then the fields should not get updated for the update records.
If you use this in conjunction with an upsert based on either the id or an external id, then that should help you out.
I will put 2 scenarios over here. I have created following csv file to upload data into my org, where
External Site IdisExternal Id(unique is not selected)
External Site keyisExternal Idand alsounique
Scenario 1:
By default, Batch size of dataloader is "200"
So, if we perform upsert based on External Site Id or External Site Key, then in both the cases, Salesforce will try to process both the records in single batch and it will throw the error "Duplicate External Ids"
Scenario 2:
Change batch size to "1"
Perform upsert based on External Site Id or External Site Key, then in both the cases, Salesforce will try to process both the records in two different batches and successfully uploads the data.
2 things to be noted here:
You will NOT receive any errors during upload. both of the records will be processed.
Most importantly, Salesforce will update data with latest record that has been updated. So, in SFDC we will find single record (here the last record) with External Site Id
Best Answer
As you already verified that their is no duplicate user inserted in that case or use detail page you find field Federation Id. This is a unique field for user object. So two records cannot be same
FederationId. So there is a use case that your old users exist in the org has samefederationIdas newly inserted user.Note: You sholud also check deactive users. there might you will find the user with same federationId. You need to remove that.