topic Re: Can't upload Excel Data into SalesForce in Talend Studio

Can't upload Excel Data into SalesForce

Anonymous — Sat, 16 Nov 2024 10:11:56 GMT

Hello, I tried to upload contacts from an Excel files into SalesForce.
A lot of SF calculated fields are causing issue during the process. I removed all fields from the job error message.
Now, I have a new error:
connecting to socket on port 4017
connected
Exception in component tSalesforceOutput_1
java.lang.NullPointerException
at org.talend.daikon.di.DiIncomingSchemaEnforcer.put(DiIncomingSchemaEnforcer.java:208)
at fpjourne.geneve_clients_0_1.Geneve_Clients.tFileInputExcel_1Process(Geneve_Clients.java:2248)
at fpjourne.geneve_clients_0_1.Geneve_Clients.runJobInTOS(Geneve_Clients.java:2694)
at fpjourne.geneve_clients_0_1.Geneve_Clients.main(Geneve_Clients.java:2551)
disconnected
Anybody could help me giving some hint ?
Thanks
-Vince

Re: Can't upload Excel Data into SalesForce

Anonymous — Mon, 19 Dec 2016 06:48:18 GMT

Hi Vince,
Could you please post your job setting screenshots into forum which will be helpful for us to address your issue?
Best regards
Sabrina

Re: Can't upload Excel Data into SalesForce

TRF — Mon, 19 Dec 2016 08:20:31 GMT

Hi,
The simpler way is to have only string datatype in the input flow of the tSalesforceOutpout component.
However, this is not the cause of the error you encountered.
Give us more about your job (are you using a pre-opened connection ? capture, and so on)
Regards,
TRF

Re: Can't upload Excel Data into SalesForce

Anonymous — Mon, 19 Dec 2016 08:43:01 GMT

Hello, I finally found the error in my mapping. For the UPSERT, I need to map the ID to an external_ID in Salesforce.
Now, it's working
Txs
Cheers
-Vince