How can I set existing attribute values of items to null during import?

Replace the existing attribute values with a predefined value that matches the data type (character, date, date-time, number, and so on) of the values you want to set to null. See the following table for predefined values.

Attribute Type	FBDI	Import Maps (CSV and XML)	ADFDi (Excel)	Item Version 2 SOAP Web Service
Character	#NULL	#NULL	#NULL	xsi:nil="True"
Date	#NULL	#NULL	Not Supported	xsi:nil="True"
Date-time	#NULL	#NULL	Not Supported	xsi:nil="True"
Number	9.99E+125	#NULL	9.99E+125	xsi:nil="True"
Number, with precision X	For precision of X, enter 9, X times. Example for precision of 6: 999999	#NULL	For precision of X, enter 9, X times. Example for precision of 6: 999999	xsi:nil="True"

Note: To nullify all fields of an existing row of a multi-row attribute, you must set the Transaction Type column to DELETE in the FBDI or smart spreadsheet.