4

For a WFFM, I have used the Save Action as Create Item. On Submit, it creates a new item as desired.

I read that the WFFM data will be saved into these SQL tables - FormFieldValues, Fact_FormSummary, Fact_FormEvents and Fact_FormStatisticsByContact but it did not.

Those tables are empty. Is there any other option I should select in the "Save Actions", to have the data save into the tables.

In the Sitecore.WFFM.Dependencies.config, I changed the dataprovider from <formsDataProvider ref="/sitecore/wffm/analytics/analyticsFormsDataProvider"/> to <formsDataProvider ref="/sitecore/wffm/analytics/sqlFormsDataProvider"/>.

It creates the item but no data in the tables.

Using sc8.2u3.

  • Did you add the wffm connectionstring? And is "Save Form Data to storage" checked on the form? – Gatogordo Nov 20 '17 at 14:30
  • Are you seeing any errors in the logs when you submit a form? – Ahmed Okour Nov 20 '17 at 14:41
  • @Gatogordo. The "Save Form Data..." was checked by default. Is there another connection string for WFFM ?? – Qwerty Nov 20 '17 at 15:02
  • @AhmedOkour. No. The item gets created without any errors. – Qwerty Nov 20 '17 at 15:03
  • 1
    @Qwerty You need to attach the WFFM database and add a connection string for it, Here are the steps : doc.sitecore.net/web_forms_for_marketers/82/… – Ahmed Okour Nov 20 '17 at 15:05
1

I was able to solve this following @AhmedOkour's suggestion.

  1. Attach the Sitecore_Wffm database which will be located inside /website/data folder.

  2. Open /App_Config/Include/Sitecore.WFFM.Dependencies.config and change the reference attribute for formsDataProvider. It should be sqlFormsDataProvider.

    formsDataProvider ref="/sitecore/wffm/analytics/sqlFormsDataProvider"/>

  3. Open /App_Config/Include/Sitecore.Forms.config and check the WFFM connection string setting

    setting name="WFM.ConnectionString" value="wfm" />

  4. Add a new connection string in /App_config/ConnectionStrings.config

add name="wfm" connectionString="Data Source=(local);Initial Catalog=mysite_Sitecore_wffm;Integrated Security=False;User ID=sa;Password=123" />

The connection string name should be the same as mentioned in Sitecore.Forms.config

  1. Submit the form and you can check the data in these tables in the mysite_sitecore_wffm database - FieldData, FormData

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.