Hi,
im an newby with CF.
I created an Form an can save the data after submit in an table.
Now i want to export the submitted data in an csv-file and send this file to an email adress.
The csv-file shoud be have an filname withe the uniq_id of the submitted table record.
Maybe, its possible to save this file also to an Joomla Path? or another webserver?
Thank you for any help.
Michael
Hi Michael,
You want to save a single record as a CSV file?
The simplest way is probably to use a Custom Code action and build the file there exactly as you want it.
There is a CSV export action but that it intended to export a whole table rather than a single record.
Bob
Hello Bob
I have the same problem.
I would like to place a button exports in the frontend of the site to export all the data loaded in the table jos_iscrizioni
Or if more simple that every time a user fills out the form on my site automatically email me arrivals the excel file with all the data in the table
Thank You
Hi pepepa,
You can build a little ChronoForm that will export the table data when you click the submit button. Or, you could add each new record to a Google Spreadsheet - that might be more practical.
Bob
Hi there,
My name is Jerome and i would like to have the following info.
I know how to export the database in excel but would like to certain fields of the excel sheet to appear in same file but in a different worksheet. Is that possible?
Hi Jerome,
Not as far as I know, there is nothing in the action that identifies which worksheet to export to :-( I think you would need to export, open the file and copy and paste into the final location.
Bob