I exported an Account from one sandbox with the intention of inserting it into another (i.e. I am copying data between orgs). This is a simple CSV file with two lines: the first has the field names (header row), the second is the data for the Account.
When data loader attempts to load it, the record errors out because Name is missing. However, it is there in the fourth field, plain as day. When I select the CSV file, data loader shows the fields and Name is there.
Header:
"ID","ISDELETED","MASTERRECORDID","NAME",...
Data:
"","false","","Test Data",...
How do I resolve this error? Is it procedural on my part? Bug in data loader? Is there a better way of copying data between orgs?
Best Answer
Please TRY to use jitterBit data loader just as an alternative and if it still errors out then it confirms that there is something wrong with the file or the mapping file.
use the same data to create via UI, so it confirms whether the data in the file/mapping file is correct or NOT.
If the data load using JitterBit loader works then it is not a bug with salesforce.