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 would require lots of
customization in order to make this data appear in reports. But you still can obtain the data, and in order to get interactions with form submit,
you can use the following query against your Mongo instance:
db.getCollection('Interactions').find({'Pages.PageEvents.Name':'Submit Success Event', 'Pages.PageEvents.CustomValues':{$exists:true}})
The actual form values would be saved under "Pages.PageEvents.CustomValues._v" array: you would be able to find field names, IDs and values there.
Querying CRMs:
There is another way or you can call it as a workaround to retrieve the data if your application is connected to any CRM system like Salesforce etc.,
Here are the steps.
1. Using Salesforce for example, you can login to the account using your credentials
2. Navigate to Leads or Contacts based on the data of your target
3. Filter the data based on the dates or you can select all
4. Choose the right-most icon to Export to excel
5. Now you filter the data based on different parameters.
Hope this was useful tip to get the Form data back. Let me know your comments.
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 would require lots of
customization in order to make this data appear in reports. But you still can obtain the data, and in order to get interactions with form submit,
you can use the following query against your Mongo instance:
db.getCollection('Interactions').find({'Pages.PageEvents.Name':'Submit Success Event', 'Pages.PageEvents.CustomValues':{$exists:true}})
The actual form values would be saved under "Pages.PageEvents.CustomValues._v" array: you would be able to find field names, IDs and values there.
Querying CRMs:
There is another way or you can call it as a workaround to retrieve the data if your application is connected to any CRM system like Salesforce etc.,
Here are the steps.
1. Using Salesforce for example, you can login to the account using your credentials
2. Navigate to Leads or Contacts based on the data of your target
3. Filter the data based on the dates or you can select all
4. Choose the right-most icon to Export to excel
5. Now you filter the data based on different parameters.
Hope this was useful tip to get the Form data back. Let me know your comments.
Thank you!
ReplyDelete