Assign Null Values during Field Mapping
It is possible to assign null values to fields on the Import Assistant's Field Mapping page. This assignment causes the value for any existing fields to be set to an empty value.
-
Null values are useful when a field has been assigned a default value that you do not want to propagate across all of the records that you are importing.
For example, if you are a sales representative and enter a lead record in the UI, the Sales Rep field automatically defaults to be you. The Import Assistant uses the same default values that would be assigned through the NetSuite user interface, so if you are a sales representative and import 10,000 lead records, the Sales Rep field automatically defaults to be you for all imported leads. This behavior may not be preferred for such a large volume of leads.
-
Null values also are useful for fields with no values in CSV files. For imports that update NetSuite data, you can set fields with no values in CSV files to null instead of enabling the Overwrite Missing Fields advanced option. For more information, see Overwrite Missing Fields.
To provide a null value for a field on the Field Mapping page, click the edit icon in its row to open a popup, and choose the Set Value to Null option. This option is available only for fields that can have null values.