Can't upload Excel Data into SalesForce

One Star

Can't upload Excel Data into SalesForce

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
Moderator

Re: Can't upload Excel Data into SalesForce

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Can't upload Excel Data into SalesForce

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
One Star

Re: Can't upload Excel Data into SalesForce

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