寻找具有数据库后端的电子邮件/报告模板引擎 - 为最终用户 [英] Looking for an email/report templating engine with database backend - for end-users
问题描述
我们有很多客户，我们也要发送月度发票。现在，我正在管理一个代码库，对我们的客户数据库和计费数据库执行SQL查询，并将数据放入电子邮件中并发送。
We have a number of customers that we have to send monthly invoices too. Right now, I'm managing a codebase that does SQL queries against our customer database and billing database and places that data into emails - and sends it.
我厌倦了保持这一点，每次我们想要包括一个新的促销或更改我们的客户服务电话号码。所以，我正在寻找一个替代品，将更多的移动到需要更改的人手中。
I grow weary of maintaining this every time we want to include a new promotion or change our customer service phone numbers. So, I'm looking for a replacement to move more of this into the hands of those requesting the changes.
在我理想的世界中，我需要：
In my ideal world, I need :
- 一个所见即所得（所有人，有人甚至会再说了吗？）电子邮件编辑器根据数据库查询的输出生成模板。
- 可以将数据库查询中的各种字段拖放到电子邮件模板中。
- 使用数据库查询显示示例电子邮件结果。
- Web应用程序，最好不要求IIS。
- 尽可能少地为终端用户提供代码，但允许基本功能（即数组/ for循环）
- 它自带的是电子邮件发送引擎，或者以可以轻松编写Python脚本来发送电子邮件的方式写入输出。
- 支持通用数据库连接器。 （我需要MSSQL和MySQL）
- F / OSS
- A WYSIWYG (man, does anyone even say that anymore?) email editor that generates templates based upon the output from a Database Query.
- The ability to drag and drop various fields from the database query into the email template.
- Display of sample email results with the database query.
- Web application, preferably not requiring IIS.
- Involve as little code as possible for the end-user, but allow basic functionality (i.e. arrays/for loops)
- Either comes with it's own email delivery engine, or writes output in a way that I can easily write a Python script to deliver the email.
- Support for generic Database Connectors. (I need MSSQL and MySQL)
- F/OSS
建议这样的项目，还是一些可用于滚动自己的工具？
So ... can anyone suggest a project like this, or some tools that'd be useful for rolling my own?
（我目前的替代想法是使用类似ERB或 Tenjin ，让他们编写代码，但没有编辑器的实时预览会吸引...）
(My current alternative idea is using something like ERB or Tenjin, having them write the code, but not having live-preview for the editor would suck...)
推荐答案
我觉得你要找一个也能发送邮件的报告工具。以html或者pdf格式发送一个通用的报告也不是很难做到。
我以前使用过 JasperReports ，我认为它应该符合您的需求。
另一个好的解决方案是 pentaho报告工具
I think your looking for a reporting tool which is also capable of sending email. Sending a generared report in html or pdf shouldn't be to hard to do as well. I've used JasperReports in the past for which I think it should fit your needs. Another good solution is the pentaho reporting tool
这篇关于寻找具有数据库后端的电子邮件/报告模板引擎 - 为最终用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
