SalesForce adding external Id to output

[Anonymous]

Hi,
I've a simple question, on a SalesForce connection (but it's not important).
Let's suppose I've the following csv to import (AccountImport):
- External_Id
- Name
I've to write in an object who have a lookup on account (MyObj):
- Account__c
- Name
Before I do the mapping, I made a lookup to retrive the record Id instead of External_Id to correct write in destination Object (MyObj).
When I have the waste record to write the log, I would to obtain the reference to external Id and not to the original Id.
The chain is:
tSalesForceInput (Account)/ tFileInputDelimited --> tMap --> tSalesForceOutput --> tFileOutputDelimited (error record)
How I can do?
Thank you.

[Anonymous]

Hi,
Could you please elaborate your case with an example with input and expected output values? It seems that you have two input sources?
Best regards
Sabrina

[Anonymous]

Hi,
I try to give you details:
INPUT
CSV to import
- External_Id
- Name
Lookup object (Account)
- External_Id
- Id
OUTPUT
Write on MyObj
- Account__c (id of account, not external id)
- Name
In MyObj I've to write the Id of account, not the external. But in the csv I've the external, so I made a lookup on Account.
I wish a output log who shows error for the record in the following form:
-ExternalId (not Id)
-Name
-Error (or similar)
Thank you,
regards

[Anonymous]

Hi,
Do you mean you want to get the "Error Reject"
Please see the article ErrorReject? If I understand you very well, you can set a inner join in tMap and unchecked "die on error" option to get the "Error Reject".
See my screenshot
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
many thanks for you help.
This seems to be the solution for me.
I'm obtained the error reject, But I don't understand how to map an output file who, at every error, log the message.
Here's my real situation: http://s21.postimg.org/6hh0qtpjb/img_t.jpg
Regards.

[Anonymous]

Hi,

But I don't understand how to map an output file who, at every error, log the message.

I have seen your pic and found there is only one output(Account team). Do you mean you want to log the error into your tfileoutputdelimted_2? If so, you just click tMap and choose "Error Reject" row.
See my pic
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
that's ok, I found this solution few minutes ago.
Now the missing step is that in ErrorReject no record are processed.
In input I've 4 record, and in output only 1 of them (the correct one) is processed and inserted. The other 3 (error) are not stored in the output file.
I'm sure I'm near to the goal!
Thank you.

[Anonymous]

Unfortunately I figured that this is not the solution for me.
This is because I don't care to have the error in the mapping, but only when the record are inserted in the database.
This is because I need to view the error managed by the remote system (SalesForce).
This is possible?
Thanks.

[Anonymous]

Hi,

This is because I don't care to have the error in the mapping, but only when the record are inserted in the database.
This is because I need to view the error managed by the remote system (SalesForce)

Talend provide global variables in the process.
Press ctrl+space to access all the global variables, is that what you need?
See the pic
Best regards
Sabrina

[Anonymous]

Hi,
At the end of process, I need a log file with each record inserted and the error message.
The procedure you suggest is for the error in the component?
Thank you.