Skip to main content

Posts

Showing posts from September, 2019

How to retrieve WFFM form data when Save Form Data to Storage is unchecked

Recently, we had situation where for one of our WFFM form (Contact Us form) Save Form Data To Storage was unchecked by mistake and published unknowingly by one of our content admin. This we noticed after few days. Between this period, data stopped storing into reporting database and reports were not showing data for the latest submissions in WFFM form reports. Regarding the same, just wanted to document our options and approaches which we thought and recovered the data for this period. In Sitecore 8.1, it is possible to configure WFFM data storage in different ways (using SQL or Mongo providers). It is also possible to collect WFFM data with analytics disabled. Querying Mongo DB : Since the "Save Form Data To Storage" field has been unchecked, the data was not saved to reporting DB. However, it can still be found in analytics MongoDB, in the "interactions" section. Unfortunately, writing these values to reporting table is a very nontrivial task and it w