Skip to main content
  • Home
  • Forums
  • FME Form
  • Authoring
  • How to do email filtering inside shutdown python script and also exporting the result in sql server DB table?
Question

How to do email filtering inside shutdown python script and also exporting the result in sql server DB table?

M
Forum|alt.badge.img

 

Dear everyone, I have an shutdown python scripts which basically sends email to admin after one datadownload has been succeed or failed. My existing py script is as follows:

 

I now want to impose one "if" condition before email generate, if my user name is "A" and email is "A@nnn.com" then email will not generate.. I have ended my script as follows but it did not work, FME server shows me error.

 

if nutzer != 'A' AND user_mail != 'A@nnn.com':

 

smtpserver = smtplib.SMTP(smtpServerAdress,smtpPort)

 

smtpserver.ehlo()

 

smtpserver.starttls()

 

smtpserver.ehlo

 

smtpserver.sendmail(emailFrom, emailTo, msg.as_string())

 

smtpserver.close()

 

 

...............

 

Did I have done some mistakes?

 

 

And another issue is, I want to also store the result inside sql server DB , how i can write the right script before'send mail?

 

Thanks

Muqit

6 replies

takashi
Contributor
Forum|alt.badge.img+21
  • takashiContributor
  • Contributor
  • November 23, 2018

The "and" operator should be lower case, and appropriate indentations are required for the code block within the if statement, as in:

if nutzer != 'A' and user_mail != 'A@nnn.com':
    smtpserver = smtplib.SMTP(smtpServerAdress,smtpPort)
    smtpserver.ehlo()
    smtpserver.starttls()
    smtpserver.ehlo
    smtpserver.sendmail(emailFrom, emailTo, msg.as_string())
    smtpserver.close()
M
Forum|alt.badge.img
takashi wrote:

The "and" operator should be lower case, and appropriate indentations are required for the code block within the if statement, as in:

if nutzer != 'A' and user_mail != 'A@nnn.com':
    smtpserver = smtplib.SMTP(smtpServerAdress,smtpPort)
    smtpserver.ehlo()
    smtpserver.starttls()
    smtpserver.ehlo
    smtpserver.sendmail(emailFrom, emailTo, msg.as_string())
    smtpserver.close()

Thanks a lot. 

Cann you please also tell me if I could transfer this results into one sql server DB table?
takashi
Contributor
Forum|alt.badge.img+21
  • takashiContributor
  • Contributor
  • November 25, 2018
mjoarder_pln wrote:

Thanks a lot.

Cann you please also tell me if I could transfer this results into one sql server DB table?

I have no experience having connected to an MS SQL Server database with Python script, so cannot help you. It would be better to post a new question specific to the matter.

david_r
Evangelist
  • david_rEvangelist
  • November 26, 2018

Rather than using the shutdown script for this, I would really recommend replacing the workspace writers with FeatureWriters and chain an Emailer and a SQLServer writer to the Summary port.

This way you'll have no Python code to write or maintain.

nielsgerrits
VIP
Forum|alt.badge.img+53
david_r wrote:

Rather than using the shutdown script for this, I would really recommend replacing the workspace writers with FeatureWriters and chain an Emailer and a SQLServer writer to the Summary port.

This way you'll have no Python code to write or maintain.

This. We use the Emailer transformer a lot in our Server Workspaces.

M
Forum|alt.badge.img
david_r wrote:

Rather than using the shutdown script for this, I would really recommend replacing the workspace writers with FeatureWriters and chain an Emailer and a SQLServer writer to the Summary port.

This way you'll have no Python code to write or maintain.

Thanks david_r for your suggestions. I have successfully connected custom python and third party packages with FME workspace and also fme server and getting all the required results in sql server table.

Kind regards

Muqit

Reply


Helpful Members This Week

Community Stats

30,980
Posts
117,401
Replies
38,760
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.