如何获得WFFM字段的值作为标记并将其输出到Sitecore DMS报告中? [英] How do I get the value of a WFFM field as a tag and output it in a Sitecore DMS report?
问题描述
如果我创建启用了Analytics(分析)的行销人员网络表单"表单，则可以选择将每个字段作为标签添加到访问者".我看不到如何配置应将其添加到哪个标签，甚至看不到默认情况下调用的标签(我假设已创建具有字段名称的标签).
If I create a Web Forms For Marketers form with Analytics enabled I can choose to add each field as a tag to a Visitor. I can't see how to configure which tag they should be added to, or even what the tag is called by default (I'm assuming a tag with the field name is created).
我还想知道如何在访问报告中检索标签数据(即，如果您在表单报告"对话框中双击表单提交会得到的标签数据).我可以看到如何访问大量的内置标签，但是我无法从表单中具体找到如何填充这些标签，也看不到报表设计器中代表我具有的字段名称的任何字段.
I'd also like to know how to retrieve the tag data in a visit report (i.e. the one you'd get if you double clicked on a form submission in the Form Reports dialogue). I can see how to access plenty of inbuilt tags, but I can't find out how to fill these specifically from the form, and I cant see any fields in the report designer representing the field names I have.
推荐答案
问题1:如何设置标签名称
如果在表单字段上设置标签"复选框，则将表单字段的项目名称(=字段名称)用作标签名称. 如果您具有数据库访问权限，则可以检查分析数据库上的"VisitorTags"表，以查看写入了哪些标记以及如何调用它们.
If you set the "Tag" checkbox on the form field, the Item Name (=field name) of the form field is used as tag name. If you have database access, you can check the "VisitorTags" table on the analytics database to see which tags are written and how they are called.
问题2:在访问报告中检索标记数据
在VisitDetail报告中，如果设置，则会显示以下内置标记:
In the VisitDetail report, the following inbuilt tags will be displayed if set:
- 电子邮件
- 名字
- 第二名
- 公司
- 组织
- 全名
- 州省
相应地命名您的表单字段，这些值将在开箱即用的报表中使用.
Name your form fields accordingly and the values will be used in the report out of the box.
如果要在报告中使用自定义标签，请查看/sitecore/shell/Applications/Reports/中的.mrt文件.您将不得不扩展报告以使用自己的标签.
If you want to use custom tags in reports, have a look at the .mrt files in /sitecore/shell/Applications/Reports/. You will have to extend the report to use your own tags.
示例:向访问详细信息"报告中添加自定义标签.
Example: Adding a custom tag to the VisitDetail report.
-
扩展SQL查询以获取/sitecore/system/Settings/Analytics/Reports SQL查询/Visits访问者标签项目中的标签.添加行
Extend the SQL Query to fetch tags in the /sitecore/system/Settings/Analytics/Reports SQL Queries/Visits Visitor Tags item. Add the line
，最大值(当[TagName] ='SomeCustomTag'THEN [TagValue] ELSE NULL END时的情况)[SomeCustomTag]
扩展VisitDetail.mrt，将值 SomeCustomTag 的列添加到 VisitorTags 部分，就像预定义标签一样.
Extend the VisitDetail.mrt, add a column with value SomeCustomTag to the VisitorTags section just like the predefined tags.
通过使用 {Visit.VisitorTagsRelation.SomeCustomTag}
我使用文本编辑器来编辑.mrt文件，但是您也可以在Reports Designer中进行编辑.
I use a text editor to edit the .mrt files, but you can probably also do it in Reports Designer.
这篇关于如何获得WFFM字段的值作为标记并将其输出到Sitecore DMS报告中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
