We currently have some processes under development to load data via data loader into the account table.
There are some columns that may be null from a source database and we want to pass the nulls into SF.com. While there is a setting to allow null values that can be set in the config files the process through batch and manual data loader upserts is placing a 0 where the source data value in the csv file blank.
How can we truly pass and replace existing data with nothing?
For instance,
Our Billing system has 3 phone number columns. There are values in 1 of the 3. All three are mapped to phone columns in the account table. If SF.com has a value in 1 column but not the other two we would like to see the account with blank values in the other two phone columns.
Data Loader is currently passing in a 0 but the csv file does not contain a 0 in these columsn.
Any assistance would be greatly appreciated. We are at the 11th our of testing and just found this bug.
We currently have some processes under development to load data via data loader into the account table.
There are some columns that may be null from a source database and we want to pass the nulls into SF.com. While there is a setting to allow null values that can be set in the config files the process through batch and manual data loader upserts is placing a 0 where the source data value in the csv file blank.
How can we truly pass and replace existing data with nothing?
For instance,
Our Billing system has 3 phone number columns. There are values in 1 of the 3. All three are mapped to phone columns in the account table. If SF.com has a value in 1 column but not the other two we would like to see the account with blank values in the other two phone columns.
Data Loader is currently passing in a 0 but the csv file does not contain a 0 in these columsn.
Any assistance would be greatly appreciated. We are at the 11th our of testing and just found this bug.
We have been able to connect ODI (Oracle Data Integrator) tool to a Salesforce Developer account and perform a reverse engineering process to load salesforce objects' data models into ODI.
We have developed an apex class with a web service method to call another batch apex class method available in the Salesforce developer account.
Our requirement is to call the web service method (hence the batch apex) from ODI. In salesforce, we have downloaded the partner.wsdl and generated the wsdl file for global apex class which contains the web service method. In ODI, there is a tool called ODiInvokeWebService which can be used to call a wsdl file. When we referenced the wsdl file for the apex class and invoke the method which will call the batch apex, we are having the following error message in ODI:
com.sunopsis.wsinvocation.SnpsWSInvocationException: INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session
at com.sunopsis.wsinvocation.client.a.a.d.requestReply(d.java)
at com.sunopsis.graphical.wsclient.f.b(f.java)
at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java)
at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:662)
at com.sunopsis.wsinvocation.client.a.a.d.requestReply(d.java)
at com.sunopsis.graphical.wsclient.f.b(f.java)at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java)
at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:662)
The issue is that, we are also able to initiate a login using the partner.wsdl in ODI but we do not know how to pass the session ID value to the global apex class wsdl. The only method in the global apex class wsdl available to call from ODI, is the web service method to call the batch apex. There is no login method as such as in partner.wsdl.
Can you please tell us a way to create a valid session which will allow us to call the batch apex in Salesforce?
