Export CSV

I've created a form for downloading a database table as a CSV file. It consists of a submit button with a 'read DB' action, followed by a page with a 'CSV export' option.
Everything works, but the form freezes after the download. I'll attach some screenshots.
Do you have any experience with 'CSV export'?

Bruno,

If you email me at webmaster@friendsofsilverbrook.org, I'll send you screenshots of how I set up the download for CSV on this page: Photos To Reshoot (friendsofsilverbrook.org).

After getting stuck with the Download option, I took a different approach. I save the CSV file to disk upon entering the form.  Then I have a button that references the CSV file.  For 1,000 rows it's fast enough.

Thanks,

--Bob.

Hi Bob, sorry for the delayed response. Your solution is good, but it doesn't fit my needs. I tried creating a PHP script for downloading the CSV. It works, but I still have the issue of the page freezing (a refresh fixes it though). Here’s the script; it has the advantage of exporting all table fields without having to define them beforehand.

As you’ll see, I also tried redirecting to a page after the download, but it still freezes. :)

Ciao @BrunoPigi ,

per caso sei riuscito a risolvere in qualche modo?

Io ho lo stesso tuo problema, ma la pagina rimane freezata anche se inserisco redirect in javascript o php.

Grazie,lorenzo.

The easiest way to do this is to do a redirect with a "delay", the redirect should be to the page with the download, in some cases this page should be a different form

Hi Max,

thanks for your reply, but i don't know if i undestand your suggestion.

Now i have a page with a submit button that refrs at the submit page where i locate the php script.

I tried to put a redirect with 5 seconds before the php script but when the page breaks down, the redirect doesn't work.

Can you please explain step by step your suggestion?

Thanks a lot,

Lorenzo.

the delayed redirect may not work if the page "breaks down", why does the page break down ?