寻找带有数据库后端的电子邮件/报告模板引擎 - 适合最终用户
我们有很多客户，我们也必须发送每月发票。现在，我正在管理一个代码库，该代码库对我们的客户数据库和计费数据库进行 SQL 查询，并将这些数据放入电子邮件中并发送。
每次我们想要加入新的促销活动或更改客户服务电话号码时，我都厌倦了维护这一点。因此，我正在寻找替代者，以便将更多的内容转移到那些要求更改的人手中。
在我的理想世界中，我需要：
- 一个所见即所得（伙计，还有人这么说吗？）电子邮件编辑器，它根据数据库查询的输出生成模板。
- 能够将数据库查询中的各种字段拖放到电子邮件模板中。
- 通过数据库查询显示示例电子邮件结果。
- Web 应用程序，最好不需要 IIS。
- 为最终用户提供尽可能少的代码，但允许基本功能（即数组/for 循环）
- 要么附带自己的电子邮件传送引擎，要么以我可以轻松编写 Python 脚本来传送电子邮件的方式编写输出。
- 支持通用数据库连接器。 （我需要 MSSQL 和 MySQL）
- F/OSS
所以...任何人都可以建议这样的项目，或者一些对我自己的项目有用的工具吗？
（我目前的替代想法是使用 ERB 或 Tenjin 之类的东西，让他们编写代码，但没有编辑器的实时预览会很糟糕......）
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 :
- 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?
(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...)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我认为您正在寻找一个也能够发送电子邮件的报告工具。以 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
您可以轻松地自己编写一些内容。给他们一个基本的编辑控件，并允许他们在邮件正文中使用伪变量，例如 {customername} {anothercustomerattribute}。
提交时直接发送或另存为模板。
当模板被发送出去时，脚本会自动将诸如 {customername} 之类的内容解析为数据库中的真实客户名称。
您自己的非常非常简单的自定义脚本语言:)
其他所有内容（例如循环等）都将在服务器端维护。如果您希望特定的客户群体收到信件，请允许最终用户从选择框或其他内容中进行选择，并使用预定义的规则在服务器端完成其余操作。
You could easily write something on your own.. give them a basic edit control and allow them to use psuedo variables like {customername} {anothercustomerattribute} within the mail body.
On submit either send directly or save as template.
When the template is sent away the script automatically parses stuff like {customername} into the real customers name from the database.
Your own very very simple custom scriptlanguage :)
Everything else like loops and so on would be maintained on serverside. And if you want particular groups of customers to receive the letter, allow the enduser to select from selectboxes or whatever and do the rest on the serverside with pre-defined rules.