topic Re: insert table in email in Talend Studio

insert table in email

Anonymous — Mon, 05 Jun 2017 17:32:22 GMT

I want to send email though talend in which i want to insert a table. This table comes from data processing activity in which i join two mySQL tables and sort the data based on a column. How can i send this result in email body with a fixed salutation and signature?

I have read https://community.talend.com/t5/Design-and-Development/resolved-need-to-send-the-data-of-tLogRow-to-tSendMail/td-p/70061

and

https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/td-p/100984

however these examples are for sending results directly from DB without any processing. Below is what i have done so far.

Re: insert table in email

TRF — Mon, 05 Jun 2017 19:42:30 GMT

Hi,
Regarding your job, tSendMail is not connected with any other component, so it will start at the same time as tMysqlInput and for sure, will not give you the expected result.
So, connect these 2 components using trigger onSubjobOk.
Now, I suppose the result is built in tJavaRow using global variables.
So you just have to reuse these variables in tSendMail to get the expected message, perhaps using html for a friendly presentation.
If you have some difficult to get what you want, share details for each component configuration.

Re: insert table in email

Anonymous — Tue, 06 Jun 2017 10:03:56 GMT

The only problem i am facing is that i can't see onSubJobOk option, rest i understand how to do.

Re: insert table in email

TRF — Tue, 06 Jun 2017 10:05:47 GMT

You need to connect the 1st component with onSubJobOk, you cannot connect an other one.

Re: insert table in email

Anonymous — Tue, 06 Jun 2017 10:09:17 GMT

Where exactly is first component? tMysqlinput1, tMysqlinput2, tMap1, tSortrow1, tJavarow or tSendemail? I assume that you're talking about tSortrow1 and tJavarow. And again which component should be connected with which component as onsubjob1? and what connection type for second one?

Re: insert table in email

TRF — Tue, 06 Jun 2017 10:16:59 GMT

The 1st one is the green one, tMysqlInput in your case.

Re: insert table in email

Anonymous — Tue, 06 Jun 2017 10:30:37 GMT

Now i can't connect between tMySqlInput1 and tMap1 through subjob. I even tried with tJoin and its not working either.

Re: insert table in email

TRF — Tue, 06 Jun 2017 10:40:21 GMT

Of course you cannot!

You just have to connect tMysqlInput_1 to tSendMail_1 using onSubjobOk to be sure tSendMail_1 will start after the variables you use to construct the email will be populated.

Also rearrange the job design, move tMysqlInput_2 on top of tMap_1, then move tSendMail_1 to the left (where is actually tMysqlInput_2).

Re: insert table in email

Anonymous — Tue, 06 Jun 2017 10:44:20 GMT

Can you post a screenshot or flow chart?

@TRF wrote:

Of course you cannot!

You just have to connect tMysqlInput_1 to tSendMail_1 using onSubjobOk to be sure tSendMail_1 will start after the variables you use to construct the email will be populated.

Also rearrange the job design, move tMysqlInput_2 on top of tMap_1, then move tSendMail_1 to the left (where is actually tMysqlInput_2).

post a screenshot? or flow design?

Re: insert table in email

TRF — Tue, 06 Jun 2017 10:50:09 GMT

should look like this:

Sorry for the quick and dirty design!

Re: insert table in email

Anonymous — Tue, 06 Jun 2017 15:29:33 GMT

Not sure why it isn't working. here is my revised workflow desgin

Here is tJavarow code.

Error message
Execution failed : Job compile errors 
At least job "test" has a compile errors, please fix and export again.
Error Line: 1457
Detail Message: Status cannot be resolved or is not a field
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

Re: insert table in email

TRF — Tue, 06 Jun 2017 15:45:28 GMT

Click on Code tab, check for errors in source code using red rectangle(s) on the right side

Re: insert table in email

cterenzi — Tue, 06 Jun 2017 20:35:46 GMT

Detail Message: Status cannot be resolved or is not a field

This usually indicates a reference to a flow variable that's not defined. Check the spelling/capitalization of the tMap output field you're referencing.