Skip to main content
Question

Send email with content that has been written to sql table

  • November 14, 2017
  • 2 replies
  • 84 views
V
Forum|alt.badge.img

Hi,

I am creating a workbench that executes an sql query (select query) and writes the results to an MS SQL table. I would like to write the contents to an email. I have used the shut down python script before (emailing after workbench has run successfully and writes the number of features written) but I cannot find resources in writing the contents of what has been written to the SQL table. I have four rows and with four fields that gets appended every time the workbench is run.

 

Is there a way to parse these values to the email?

Thank you.

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
What version Workbench? I'm no Py expert but the Emailer Transformer should do the job fairly easy? Attachment or HTML.
M
Forum|alt.badge.img+2
  • markatsafe
  • November 14, 2017

Try the combination of FeatureWriter and SQLExecutor transformers. these can be used to write to your SQL Server database and then read back the rows you need and append them to an email using the Emailer transformer. There is an example of using FeatureWriter and Emailer in the article Using the FeatureWriter Transformer with your Database (featurewriter-final.fmwt). Not exactly your scenario, but it might give you some ideas.

Reply


Helpful Members This Week

Community Stats

31,408
Posts
119,108
Replies
39,030
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.