Import NULL Support


Imports now handle NULL values. In database-speak, NULL is a value that is not an value. For comparison, blank is a value that can replace an existing entry and make it blank. Importing NULL does not replace an existing or default entry. This is handy if you want one import mapping that sometimes replaces a default address, or price, and sometimes does not.


This feature automatically handles NULL values coming from external data sources, such as Cloud Services or using the Web API.

This Solution describes its use. (6565)






Imports now handle NULL values. To import a NULL value simply include the text "NULL" in the data being imported. If the value being imported is "NULL" it will not be imported and will not replace any exisitng or default entry.

This feature automatically handles NULL values coming from external data sources, such as Cloud Services or using the Web API.

To create an import file use "NULL" where you do not want a value imported. In the pictured example, Custom Date and Employee fields are being updated. For Customer Code "6146" we still want "Sean" assigned but do not want to replace the current Follow-Up Date, so we enter "NULL".



Related:

Rules for Line Item Imports