Best practices for import jobs in Data Loader
This reference guide outlines best practices for importing records, including file format requirements, header specifications, date formatting, and file size limitations.
-
The import file should be a CSV, UTF-8 format.
-
Ensure that the file does not contain duplicate or empty headers.
-
The first row of the file should contain column headers.
-
Ensure that all the date fields are rightly formatted. The supported date formats are available in the Data Dictionary.
-
A maximum file size of 1GB is allowed.
-
Make sure that the IsMarker Column is mapped right when importing records in a nested object. For example, Standalone Invoices, Payment Schedules etc.
-
When loading records in Accounts and Contact, perform the following:
-
Change the associated communication profile for Migration to Silent.
-
Change the Batch to a Batch that is created for migration.
-
-
Accounts and Contact will be created in Active state.