2

I am working on Sitecore 9.0.2 with Sitecore 9 Forms. When I am trying to export the form data, it shows me that "The list is being exported" but I get nothing.

Below is the screenshot for reference:-

enter image description here

This message I see when I select Complete List in the export wizard.

enter image description here

I get a different message when I select a specific Date Range like below:-

enter image description here

enter image description here

When I looked into the console I found 401 Status for export data request.

enter image description here

Is there any configuration to export form data which I am missing?

Any help is much appreciated.

Improve this question
3
  • Are you sure you have data (for that form) in the database? Query your database to be sure - I've seen this message when there was no data.
    – Gatogordo
    Jun 26, 2019 at 12:26
  • @Gatogordo I checked the data in myproject_ExperienceForms and there is no data in [FormEntry] and [FieldData] table. But simultaneously I checked the myproject_Reporting database and found data in Fact_FormFieldMetrics and Fact_FormMetrics tables. Both these table consist form id similar to the forms in sitecore. What does that mean?
    – SumitK
    Jun 26, 2019 at 16:02
  • @Gatogordo As per you answer, I have added the "Save data" submit action and placed it before the redirection to Thankyou page and now I am getting data saved in database. Also I am able to download the data for a single form one at a time.
    – SumitK
    Jun 27, 2019 at 4:57

1 Answer 1

Reset to default
2

I've seen this behavior when there is no data for the form in the database. As mentioned in the comments, that seems to be your case.

Check if your form has the "Save data" submit action. This will save the data in the database.

Also make sure that this submit action is not preceded with a redirect action as that would abort the execution of subsequent steps (all actions after a redirect are not performed).

If needed, check in the web database that the save data action is present - it might be not published.

https://doc.sitecore.com/users/91/sitecore-experience-platform/en/working-with-submit-actions.html

Improve this answer
4
  • Is there any other interface where we can see the form data for all the forms at one place?
    – SumitK
    Jun 27, 2019 at 5:10
  • Don't think so.. not ootb.
    – Gatogordo
    Jun 27, 2019 at 8:27
  • I am having " save data" option still unable to export data. Any idea ?
    – samridhi sachdeva
    Sep 13, 2019 at 2:39
  • Are you sure you have data? If so, call Sitecore Support.
    – Gatogordo
    Sep 13, 2019 at 7:53

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.