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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog