topic Re: [resolved] need help records are inserted/updated in Talend Studio

[resolved] need help records are inserted/updated

Anonymous — Wed, 19 Jun 2013 08:19:06 GMT

Hi,
I need a help to how to send a mail with how many records are inserted/updated in specific table. I design the job but unable to achieve the functionality.
could you please help me.
thx

Re: [resolved] need help records are inserted/updated

alevy — Wed, 19 Jun 2013 08:24:09 GMT

Connect tSendMail with OnComponentOK from the second tOracleOutput or with OnSubjobOK from the first tOracleInput.

Re: [resolved] need help records are inserted/updated

Anonymous — Wed, 19 Jun 2013 08:26:19 GMT

Hi,
In addition, Nb_LINE is used to count the total number of records have been proceed. When inserted item is choosen, there will be a global variale such as ((Integer)globalMap.get("tOracleoutput_1_NB_LINE_INSERTED")) will be avaible, which counts the total number of records have been inserted into database. The same to updated, deleted items.
Best regards
Sabrina

Re: [resolved] need help records are inserted/updated

Anonymous — Wed, 19 Jun 2013 08:30:34 GMT

Hi,
In tsendmail message body i have to use global variable ((Integer)globalMap.get("tOracleoutput_1_NB_LINE_INSERTED")). Could you please help me.

Thx

Re: [resolved] need help records are inserted/updated

Anonymous — Wed, 19 Jun 2013 08:42:55 GMT

Hi,
You can set the expression of body as:
""+((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_INSERTED"))
or
"The total number of processed files is: "+((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_INSERTED")).
String.valueOf((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_INSERTED")) is also Ok.
See my screenshot
Best regards
Sabrina

Re: [resolved] need help records are inserted/updated

Anonymous — Wed, 19 Jun 2013 08:52:35 GMT

Hi sabrina,
Thanks for inputs. however i want to use a single tsendmail component and in that message body i have to use no. of records inserted and no. of records updated. Is it possible?
could you please help me.
Thx

Re: [resolved] need help records are inserted/updated

Anonymous — Wed, 19 Jun 2013 09:01:01 GMT

Hi,

Thanks for inputs. however i want to use a single tsendmail component and in that message body i have to use no. of records inserted and no. of records updated. Is it possible?

no.of record inserted and no. of records updated? How did you set your DB "Action on data" if you want both of them? Could you please elaborate your case with an example with expected output values?
Best regards
Sabrina

Re: [resolved] need help records are inserted/updated

Anonymous — Wed, 19 Jun 2013 09:06:38 GMT

Hi sabrina,
Yes. I want both of them. I set the Action on data on DB is "Update or Insert". So i want to capture no. of records inserted and no.of records updated in tsendmail message body. could you please advise or help me.
Thx,

Re: [resolved] need help records are inserted/updated

Anonymous — Wed, 19 Jun 2013 09:21:25 GMT

Hi,
If you set the Action on data on DB is "Update or Insert", there is a Key schema needed for this table.
Perhaps the tsendmail message body should be :

"The inserted number"+((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_INSERTED"))+"The Updated number"+((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_UPDATED"))

Best regards
Sabrina