Update blank data (sometimes)
One solution to your issue is that you could make your own SQL connection in a script task. Then in the script, for fields that you want to stay the same, you would query the table and return that value.
Then use that calculation as the input to the field.
so your calculation might look like:
if _CLASSID = “” then
’empty so leave field empty by returning empty string
‘have a class value so use the value from our data
so now your code will either pass empty or else the value from your data.
So there isn’t a direct way to send in a blank in smartconnect other than marking that checkbo- so if you wanted to change the credit card number from xxxx to blank you’d have to map the field and set the ‘update blank data’.
but the interesting thing is, the only thing that really does is wrap the CDATA tag in econnect.
Microsoft talks about using it above.
so if we wanted to send a blank (to overwrite an existing value) then you could make a calculation that returns
as noted in the link. so you could actually just use the calculation and either set the calculation to your field or else return the tag above.
again note that this tag actually forces econnect to use a space and overwrite data. not exactly what you said you were looking to do.
I have a slightly different issue, which has to do with a blank date. I am moving CC info (number and expiry date) from CRM to GP. Not all customers pay with CC which means we don’t have CC info for all of them. My map fails when the CC expiry date is blank. I have tried a few different iterations of the following with no results.
if fn.ISEMPTY(_CC_EXPIRY__C) then
I continue to receive the error: “Failed to convert parameter value from String to a DateTime.”
Do you have any suggestions?
Delano, since the _CC_EXPIRY__C field would be a date field you will need to translate it to a string before using the ISEMPTY function.
You could try the following
If string.IsNullOrEmpty(_CC_EXPIRY__C.ToString()) then
Thank you Lorren, that did it.
Thanks Lorren… I needed this example and it works perfectly.
If you would like to submit an answer or comment, please sign in to the eOne portal.