Forums

Export Data from table to CSV

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.
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.
GreyHead 12 Feb, 2014
Hi ratkin998,

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

Bob
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.
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
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.
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
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.