We have exported data from On prem oracle EBS server to Google Drive in CSV format. then uploaded data(csv) from Google Drive to Salesforce Cloud. We have faced few Upload error.(Dealers: id value of incorrect type: 4) Kindly guide us how do we rectify the issue.
Data upload error
- Last Post 06 January 2021
As we can see this error occurs in the following tasks: Sales__c, Order_Line_Item__c, Ledger__c.
The issue is most likely related to the mapping that is specified for the Dealer__c field in these tasks. The Dealer__c is mapped to the CSV column named "Dealer Oracle ID".
The Dealer__c field in Salesforce must contain the Id of the corresponding Dealer. Thus, please make sure, that you are sending the correct values from the CSV file to this field.