Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (4)
3 Replies
Anonymous
Not applicable
Author

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
TRF
Champion II
Champion II

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
Anonymous
Not applicable
Author

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