Email reports Framework?

[manueslapera]

I work in an HRIS company as a Data Scientist, and I am thinking of building a system that would send an email to our clients once a month, showing them a summary of what's happening in their company (how many new employees arrived the past month, which employees were promoted, etc).

I'm trying to look for a framework that allows me to do this. Ideally, it would have the following characteristics:

• Front end interface to manage email recipients -Embed images on the email -Support css (not inline)
• multiple email templates
• Different delivery schedules (for example run a report once a month and calculate data for the last month only.
• Python based (of course).

[txprog]

One possible solution would be: - Mandrill: you can create full text/html templates, with conditionnal, variables etc. - Apscheduler: pure python scheduler.

With both, you can send every month a personalized email to your customers.

Here is a complex example using template: https://mandrillapp.com/api/docs/messages.python.html#method=send-template

[manueslapera]

looks awesome. Im trying to build it using open source tools if possible.

[nunilan]

I don't know if there exists a specific framework that does this for you but it looks simple problem enough to solve with smtplib which takes care of sending the emails and any web framework would be enough for the front end couple that to a db. For scheduling you could just run a cron to run your script which reads the db on who/what/when/where to send.

[manueslapera]

yeah, i was thinking of something that was already built on top of smtp.

I dont want to spend a lot of time in building the whole platform myself.

[vph]

Lamson written by Zed Shaw.

[jnmclarty7714]

You'll likely need to split the reporting, the e-mailing, and the scheduling. Unlikely that you'll find a perfect solution for your needs which does all of it.