You need to sign in to do that
Don't have an account?
Tolga Sunar
DataLoader upsert operation ignoring Standard ID field
Hello,
I've read that upsert operation accepts the standard ID field as the matching field, or any external ID field if present. However, when I attempt to export some Lead records and directly upsert the generated .csv file into SF, I get the below error:
When I open the .csv file with an editor, ID field is present:
Moreover, when I do the same operation for Account object which has an external ID field, the matching field window has the text "no external ID found, dataloader will use the Id field". But below that text, the external field is selected as the matching field and is greyed out.
Why does DataLoader ignore my standard ID fields? I tried a custom object, and standard ID field is still ignored.
Thanks in advance.
I've read that upsert operation accepts the standard ID field as the matching field, or any external ID field if present. However, when I attempt to export some Lead records and directly upsert the generated .csv file into SF, I get the below error:
When I open the .csv file with an editor, ID field is present:
Moreover, when I do the same operation for Account object which has an external ID field, the matching field window has the text "no external ID found, dataloader will use the Id field". But below that text, the external field is selected as the matching field and is greyed out.
Why does DataLoader ignore my standard ID fields? I tried a custom object, and standard ID field is still ignored.
Thanks in advance.
May be you can try this online data tool..
https://workbench.developerforce.com