Loading

Insert null value in a field with Data Import Wizard

Fecha de publicación: Oct 13, 2022
Descripción

Data Import Wizard ignores empty cells in a CSV file.

Instead of clearing the value of the field in your organization, it treats the empty field as though you do not want to make any changes to that field. 
Solución
 
Warning
Always back up your data before performing any data operation. See Export Backup Data from Salesforce or Export Data for more details. It is recommended to run a test with a small subset of records to ensure the operation was successful through manually opening and verifying that the corresponding records are correct in Salesforce.

To set a field value to null or erase the current value, fill out the column corresponding to the record and field to be updated with #N/A. The exceptions are a checkbox where you have to use 0 for unchecked values and lookup fields as the Import Wizard cannot null a lookup (must use an API tool like the Data Loader).

For example, your CSV file may look like:
 
ContactIDDoNotCallTitle
005xxxxxxxxx0Ta0#N/A
005xxxxxxxxx1ZT1Salesforce Administrator


You may refer to the Bulk API Developer Guide - Valid CSV Record Rows document for more details.

For inserting/updating field with null values using Data Loader, refer to Change record values to blank or null with Data Loader.
 
Número del artículo de conocimiento

000382170

 
Cargando
Salesforce Help | Article