I am trying to import a custom object which has 18 digit id, even though it is 18 digit id, the import fails, & Error log say 15 digit id (seems like SF convert my 18 digit id into 15 digit which is highly unlike).As my column is already 18 digit, converting into standard 18 digit is not a solution. Please help how to import successfully.
Even in Data Loader, Even though I have External Id field in Journal object, Data loader is saying NO external ID fields defined. And, when I tried importing, 18 digit ID is converted into 15 digit, & error log saying 15 digit ID is not valid (last 3 letter from 18 digit is automatically discarded during import operation in both Data Loader, & Data Import Wizard).
Is there any implication of Match By filter during the mapping (if all related fields exist in next step) that might throw the error?I have exported all data from previous SF org by Data Export wizard, & all app & custom objects from previous org are moved to new org by unmanged packaging. I have tried both Data Loader, & Data Import Wizard.
Best Answer
When trying to use an ETL tool to get data into salesforce using External Id's you need to use the UPSERT operation. Then you will be able to match against the external Id field
When using the 18 character ID the case does not matter. If using a 15 character Id the case DOES matter. Salesforce will automatically convert the 18 character ID to the proper case sensitive 15 character ID. so do not worry about that at all.
As for the external ID field not showing up in dataloader, ensure that the FLS for the field is such that you have Edit access to the field
The error message you have presented in your question means that the Journal object IDs do not start with
a00Check the URL of an existing Journal record and see what it starts with.