Solspace's Freeform Module. How to export CSV?
Development and Programming
Hello. I’m using Solspace’s Freeform module on this monster student enrollment application at http://gsis.amystoddard.com/admissions/application/. I figured the modules’s EXPORT button would output a tab-delimited .csv file. No dice. Between the natural line breaks that are happening in textarea submissions, etc., the EXPORT feature is useless. I’ve been combing the Solspace forums looking for a solution to no avail. The form delivers a beautiful text email to the recipients of my choice, complete w/ attachments. Now the client wants the form data submitted in a CSV file. I’m wondering if you have any suggestions or have run across a form processor for EE that’s just as powerful as Solspace’s Freeform module.
I’ve seen the recommendation to use the CSVee plugin. How do the two work in tandem exactly?
Thanks for any suggestions you might have.
I think I’m figuring out the answer to my own question. Example how to query the freeform table:
{exp:csvee filename="call_registration.csv" fixed_width="200" group_id="1|6" query="SELECT first_name, last_name, call_email, phone1, questions, mailinglist, template FROM exp_freeform_entries WHERE template='callregistration'"}I’ll give this a whirl and repost how it goes.
This CSVee plugin works great, but how can I also include links to the attachments that are submitted as part of my Freeform form? It looks like all the attachments are stored in a separate table: exp_freeform_attachments. What’s more, the path to where the attachment lives is the full server path. How could I query both tables (“exp_freeform_entries” and “exp_freeform_attachments”) and still export a single CSV? Is that even possible?
You should be able to do that by joining the 2 tables in your select statement.
Jim