Customer Wizard

×
Menu
  • Using [BLANK] Functionality

Using [BLANK] Functionality

 
You can make fields blank in Oracle by using the [BLANK] functionality in Customer Wizard.
If you wish to override a field in Oracle with a null, you must enter ‘[BLANK]’ in the cell before you upload.  If the cell is left blank in the worksheet the API will not interpret this as a command to remove the value from the database record and the value will persist.
Note - You should not use this functionality on any mandatory field values.
 
 
In the example above the Site Address was downloaded into the first row.  The second row shows how to remove the Site ‘Address3’ value from the database as it will now exist in the Site ‘Address2’ field after upload.
 
Refer to section: