Loading

Error 'Empty Column is found' in Data Loader

Дата публикации: May 5, 2023
Описание

When you attempt to insert or update records with Data Loader, you may encounter the error "Empty column is found. Would you like to continue?" with a subsequent message "Initialization Succeeded." When you click Yes on these screens, you'll be routed to a blank page.
 
Решение

To resolve this error you will need to ensure that any empty columns are removed from your .csv file.

Note: This error does not mean that you can't leverage blank columns to clear out existing field values on record. It only occurs when an entire column, including its header, is blank. It is still possible to upload blank values into records fields via the "Insert null values" setting in Data Loader, but the column must contain a header. See Configure Data Loader for more details on Data Loader settings.

1. Scroll through you file's columns in Excel and ensure that each one has a header.  It is also best practice to remove any extraneous columns that may not have any data or are irrelevant for the import you're performing.

2. Check for hidden columns in Excel and unhide all the columns to delete any empty columns. See Show or hide columns and rows for more details.

3. Check to ensure that no data is unexpectedly contained in any column/cells to the right of your actual data. You can do so by clicking the spreadsheet header of the first blank column to the right of your data. For example if your data fills the first 5 columns, click the letter F at the top of the 6th column. Scroll all the way to the last column in your file. Hold Shift and click the spreadsheet header of the right most column in your sheet to highlight all of them.  Right click anywhere in the highlighted space and select Delete to remove any unexpected data that may be contained to the right of your actual data in the file.

Once you've confirmed that no entirely empty columns exist and all unnecessary and extraneous columns/data have been removed re-save the file and try loading the CSV again via the Data Loader.

If there are no empty columns this error should not occur again.
 
Номер статьи базы знаний

000386656

 
Загрузка
Salesforce Help | Article