Form data export data with text field and import in excel

Hi

I have a weell running form which stores the input in a database. The form contains a text field. This text field can contain the sign comma (',').

I now export the data with save table or save records. Secondly I want to import the data in excel. But now there is the problem with the text field containing the ','.

Problem: The field separator is also the ',' which makes excel confused.

Is it possible to change the field separator for export to another sign like ';' or something else?

Hi pklinke,

I have a CSV Export [GH] action for CFv5 which allows you to change the Delimiter and Enclosure characters. It also allows you to select rows and columns to export. I will send you a PM with a link to download it and test to see if it does what you need.

Bob

Hi Bob,

thanks a lot!

But I think it's a missunderstanding. I want to export the records manually from backend. As I understand, the action is for export from the from ?

Regards
Peter

Hi Peter,

Yes, that is correct, you would need to build a form to export the records that you need. That's probably simpler than doing a manual export. Alternatively there is a MySQL extension for Excel that will probably solve the problem for you.

Bob

Hi Bob,

thank you once again.

Is there an example, documentation or something else how to do this with a cf form?

Peter

Hi Peter,

To add a CSV Export form I would typically create a form with Admin only Access, add just a submit button in the Designer view (you could also add inputs to select records if you want more control) and that have the CSV Export in the form Submit event. There are various ways to do the export - you can use my action - or custom code the whole export if you prefer.

Bob

Hi,
​
How about IMPORT a CSV file to a table ??
​
regards,
​
Kate_ee

Hi Kate_ee,
​
You could build a form to to that but there are other methods e.g. PHPMyAdmin that might be simpler.
​
Bob