Description

When exporting form data with the List Box or Checkbox List fields to Excel using Web Forms for Marketers module, the generated document may contain the following XML tags around field values:

• <item></item>
• &lt;item&gt;&lt;/item&gt; 

Solution (WFFM 2.4)

1. Put the Sitecore.Support.380388.dll assembly file into the \bin folder.
2. Put the Z.Sitecore.Support.380388.config file into the \App_Config\Include folder.

After applying this patch, multiple values will be separated using the comma symbol. This is the same format as you see on the Data tab of the Form Reports application, but without the <item></item> tags in the generated Excel file.

Solution (WFFM 2.5)

1. Put the Sitecore.Support.380388.dll assembly file into the \bin folder.
2. Put the Z.Sitecore.Support.380388.config file into the \App_Config\Include folder.

After applying this patch, multiple values will be separated using the comma symbol, but without the &lt;item&gt;&lt;/item&gt; tags in the generated Excel file.

Solution (WFFM 8.0-8.1)

1. Put the Sitecore.Support.67717.dll assembly file into the \bin folder.
2. Put the Z.Sitecore.Support.67717.config file into the \App_Config\Include folder.

After applying this patch, multiple values will be separated using the comma symbol, but without the &lt;item&gt;&lt;/item&gt; tags in the generated Excel file.

You can change the value of the WFM.FormDataExcelSeparator setting in the Z.Sitecore.Support.67717.config file in order to use different separators for multiple field values.