SFDMU Help CenterCan CSV files from the standard Salesforce Data Loader be used with this plugin?
Answer.
Yes, you can. They are mostly compatible, except for the differences listed below.
Using SFDMU to import data exported using Data Loader:
- The Data Loader often generates CSV files with upper-case column names. SFDMU reads source CSV headers case-insensitively and normalizes them to the correct API casing in generated source files.
- Quoted CSV header names are supported, so you do not need to remove double quotes from the header row.
- Consider setting the UTF-8 format in the Salesforce Data Loader settings when exporting to a CSV file.
Using Data Loader to import data exported using SFDMU:
- The CSV file generated by SFDMU is fully compatible with the Salesforce Data Loader.
- Map columns to Salesforce fields using the UI provided by the Data Loader.
- Be aware that the Data Loader cannot handle lookup fields included in the CSV; you should replace lookup values with the corresponding target parent ID values in each row.