Forums

CSV download help

vdub01 18 May, 2014
Okay, full disclosure, I am having a very blonde day due to unnecessary pressure on a project I am doing. I have trolled through the forums and FAQs but am not seeming to get anywhere.

I have set up a form which once filled out sends an email to the administrator with the form details.

What I am wanting is to be able to create a frontend link to download a csv of all of the details from the forms filled out. I want the project administrator to be able to go to a page and download every person that has filled out the form.

For the life of me I cannot seem to work this out (tbh i can't even seem to figure out how to view them in the back end either)

Could someone please help?
GreyHead 18 May, 2014
Hi vdub01,

It looks as though ChronoForms v5 doesn't yet have a View Data option. I expect it will come in a future release. Meanwhile you can use the AceSQL extension to view or edit any database table - for trusted admins only!!!

To enable a download I would create a new mini-form using the Authenticator action to limit access and with just an 'Export' submit button. Then use the CSV Export action to create the file and add a link in a Thank You message.

You can make it more sophisticated by adding the ability to download only new records (requires a 'status' column in the DB to keep track); and/or to house-keep old saved export files.

Bob
This topic is locked and no more replies can be posted.