MX CSV Import-Export Forum :: Create CSV from Form Submit?

Hello,

Wondering if there is a way to create a .csv file upon a form submit, in which the .csv columns would be the form fileds or the table columns that the form is inserting a record into.  The .csv file would then get attached to an email that is also sent upon form submit.  I do have the .csv import/export extension but couldn't see how to accomplish it.

What I need... is to send a file as an email attachment.  In this case, the recipients that are to receive these emails use a real estate lead management system that imports .csv files directly into the system.  The imported lead than works as if it was entered manually.

The form in this case is a brief mortgage application on the company website (PHP/MySQL).  Therefore, when someone submits a mortgage application online the company wants that lead to flow into their lead management software.

1) User fills a form and submits the form

2) the form inserts a record into a MySQL table (it does this)

3) an email is sent to recipients (it does this), however, I would like the email to have a .csv attachment. 

Perhaps there is a completely different way to do this, such as with XML.  I know MS Excel works closely with XML, although I have never used it.  In any event, any advice would be appreciated.

Thanks!

Hello,

Unfortunately, MX Send Email does not support sending of emails that contain attachments, so this use case is not supported by our products.

Regards,
Razvan RACASANU

Hello,

Although the current version of MX Send Email does not support the sending of emails with attachments, we are currently working on implementing this feature for MX Kollection 3 Pro that is due for release at the beginning of August.

Regards,
Razvan RACASANU

Thanks for the information.  I will lokk for that.

Is there a way using extension(s) and/or code to automatically  create the .csv file upon form submit without sending it as an email attachment, just save the .csv in a folder?  My form currently inserts a record into a MySQL table. 

Thanks

Hello,

You can do this, but it will require hand coding. You can attach a custom AFTER trigger to the insert transaction. In this trigger you can open a file using the fopen PHP function and write the data in the CSV format to it using fwrite.

Regards,
Razvan RACASANU

Thanks for the help.  I'll hit the search engones looking for info about the fopen and fwrite PHP functions.  I don't code too much and have relied on Interakt for almost everything.

I am trying to do somewhat similar thing. I am trying to creat a csv file from a mysql query browser on my local machine instead of the server. Is there a way, i can do it. The server is a linux machine and my machine is windows.

thanks