如何从 Sitecore 的营销人员 Web 表单数据库中提取数据？
我希望能够从营销人员 Web 表单数据库中提取表单提交内容，并将其输出到 Excel 文件中，以便按需向公众提供。
有人知道我该怎么做吗？
我知道他们有导出到 Excel 的选项，但它不是自动的，需要有人登录并有权访问表单。
我无法从 Sitecore 找到任何有关如何执行此操作的文档。这是支持的操作吗？我是否必须反思 dll 才能找到 api 调用？我是否必须深入研究 SQL 数据库并弄清楚如何手动执行此操作？难道就没有希望了吗？
I want to be able to extract the form submissions from the Web Forms for marketers database and output it in an excel file I can make available to the public on demand.
Anyone know how I can do this?
I know they have an export to Excel option, but it is not automatic and requires someone to login and have access to the form.
I haven't been able to find any documentation from Sitecore on how to do this. Is this a supported operation? Do I have to reflect over the dlls to find api calls? Do I have to delve in to the SQL database and figure out how to do it manually? Is there no hope?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
当使用 Reflector 反汇编 Sitecore.Forms dll 时，您可能会很幸运。尝试找出是否可以反汇编单击“导出”按钮时运行的代码。
实际上：
命令来自：
Sitecore.Form.Core.Commands.Export执行的代码位于：
Sitecore.Form.Core.Pipelines.Export.Excel祝你好运！
You might get lucky when using Reflector to disasamble the Sitecore.Forms dll. Try to find out if you can disassemble the code that get's run when clicking the Export button.
Actually:
The command comes from:
Sitecore.Form.Core.Commands.ExportThe executed code is in:
Sitecore.Form.Core.Pipelines.Export.ExcelGood luck!
这篇文章非常详细地说明了如果其他人偶然发现这篇文章如何执行此操作。 http://r-coding-sitecoreblog .blogspot.com/2011/11/extracting-data-from-sitecore-wffm.html
This writeup provides a very detailed account of how to do this if anyone else stumbles on this post. http://r-coding-sitecoreblog.blogspot.com/2011/11/extracting-data-from-sitecore-wffm.html
您好，您可以使用下面给出的我的博客 URL 以 CSV 格式导出数据我还编写了一些博客，以在前端以 XML 和 HTML 格式导出
http://sitecoretweaks.wordpress.com/2014/07/02/sitecore-export-to-csvexcel-of-web-form-for-marketers-form-wffm-reports/
您可以找到所有有关导出数据的博客
http://sitecoretweaks.wordpress.com/
Hello You can use below given my blog URL to export data in CSV I have also written some blogs to export in XML and HTML on front end
http://sitecoretweaks.wordpress.com/2014/07/02/sitecore-export-to-csvexcel-of-web-form-for-marketers-form-wffm-reports/
You can find all blogs about export data
http://sitecoretweaks.wordpress.com/