topic Re: Problem updating empty string using componenet "tSalesforceOutputBulk" in Talend Studio

Problem updating empty string using componenet "tSalesforceOutputBulk"

Anonymous — Sat, 16 Nov 2024 11:04:30 GMT

Hi, i am having trouble when an empty string comes in a .csv file. The thing is that the "tSalesforceOutputBulk" (see attached file) component puts a "#N/a" in the bulk file when a value is empty (see attached file), but doesn't do it for all the columns defined in the .csv.
Does anybody has an idea why this happens?

Re: Problem updating empty string using componenet "tSalesforceOutputBulk"

Anonymous — Thu, 27 Aug 2015 10:53:16 GMT

Hi,
Does this issue repro also on tSalesforceOutput? Have you tried to replace all "" with null to see if it is OK?
Best regards
Sabrina

Re: Problem updating empty string using componenet "tSalesforceOutputBulk"

_AnonymousUser — Thu, 27 Aug 2015 15:45:50 GMT

Hello,
I've experienced the same behavior. If you replace "" by null, this does not happen. Both methods worked at the end ('#N/a' string is not written in Salesforce), but the main difference in the result is:
- using "" the existing value of a field we're updating in Salesforce will not be overwritten (nulled out)
- using null, the existing value of a field we're updating in Salesforce will be overwritten (nulled out)
Nikola

Re: Problem updating empty string using componenet "tSalesforceOutputBulk"

Anonymous — Mon, 31 Aug 2015 15:28:04 GMT

Hi, thank you for your responses. The thing is that have to process 7 delimited files (more than 150 columns in total). So when u say "replace "" by null", what is the best and fastest way to apply this for all the columns defined in the delimited files? I tried using the"default" propertie with "null" and "#N/A" in: tmap, TSalesforceOutputBulk and TSalesforceBulkExec). But it stills doesnt update a null value in Salesforce.
This is one of the files that i have to process.

"#N/A" value on tsalesforceoutputbulk schema.

Re: Problem updating empty string using componenet "tSalesforceOutputBulk"

Anonymous — Wed, 02 Sep 2015 18:47:55 GMT

I set "#N/A" value on tfileinputDelimited schema and it worked. I still don't know why tSalesforceOutputBulk doesn't do that.
Thanks for your help!