Export Data from table to CSV

ra ratkin998 12 Feb, 2014
Hello,

I have my form working and writing to a table. What is the best way to export that data to a CSV? I've seen articles but only for V4 which when I try to follow some buttons are not available.
ra ratkin998 12 Feb, 2014
I have managed to save to the created table I just want to export from the table which is something that tutorial does not show.
Gr GreyHead 12 Feb, 2014
Hi ratkin998,

Have you tried the CSV Export action in CFv5 - it is similar to the one in v4?

Bob
ra ratkin998 12 Feb, 2014
Where would I find that?

Adding the CSV export to the On Submit event just downloads what the user has just put in the table.
Gr GreyHead 12 Feb, 2014
Hi ratkin998,

Sorry, I don't understand what you are trying to do? What do you want to export and when?

Bob
ra ratkin998 12 Feb, 2014
I have a form that multiple users will complete. The submit button writes info from the form to a table. Once everyone has completed the form I need all the data from the data into a CSV file.
Gr GreyHead 12 Feb, 2014
Hi ratkin998,

I think that CFv5 has an Export option in the View Data page, that may do what you need. Otherwise you can create a new form with a DB Loader and a CSV Export action - that will let you create a custom export.

Bob
ra ratkin998 12 Feb, 2014
Thanks Bob - that has given me something to work on.
This topic is locked and no more replies can be posted.