Tech Tuesday : SmartConnect Update Blank Data
Today’s Tech Tuesday discusses the Update Blank Data feature. This feature can be used from the SmartConnect Mapping window.
This can be used to determine when updating records whether blank data should over-write fields. If Update Blank Data is checked, a blank field mapped to a destination field will cause the destination data store to be updated with the blank value. If Update Blank Data is unchecked, blank fields mapped to destination fields will not cause destination data source information to be over-written with blank values.
By default, Microsoft eConnect and CRM do not send blank data values to the stored procedures so there is no mechanism to remove a blank value once the data has been set. If you need the data to be blank, SmartConnect gives you that option with the Update Blank Data checkbox.
Does this work with CRM Option sets?
This option doesn’t seem to work for us. Blank values are not updated in Destination whether the Update Blank Data is checked or not.
Maryna,
What is your destiantion connector? Different Connectors have different ways to remove values. This video shows more of the methods:
https://www.eonesolutions.com/smartconnect-office-hours-clearing-values-from-destination-fields/
CRM connector doesn’t clear picklist values
There seems to be a flaw in the design of clearing the CRM field by disassociation. If a value being passed by the source is blank, how can I pass the old value for the lookup in the related entities?
The demo for the CRM was not performed so I am not sure how you are able to perform a lookup when the source is passing a blank field. It would be great if the demo actually showed the source and the results of the run.
In the example, if you are to remove a contact via disassociation what does your source looks like? In the demo, the assumption is my source still passes the old value (for the lookup to work) but if I don\’t have it in the source because it was already removed (which is the point of \”updating blank\” value), how else can I associate the old value?