Can the form save to a database or export to CSV file?

Question:
Can the form save to a database or export to CSV file?

Answer:
Yes, Michael Simpson has made a WordPress plugin that adds the ability for “Fast Secure Contact Form” emails to be automatically saved to the WordPress database. This feature is supported in his “Contact Form DB plugin”.

“Contact Form DB” used to be just for Contact Form 7, but Michael has added support for this plugin to capture data from both Contact Form 7 and Fast Secure Contact Form. It can even work if both contact forms are installed.

Features:
Save the contact form data to a Database table, export to CSV file, or export to Excel CSV. It can even save the optional attachment fields. It supports the WordPress version of “Fast Secure Contact Form”. This plugin also puts a menu link on the contact form settings page menu where you can view the data in the database and access the export functions.

Requirements:

Installation:

  • Be sure that “Fast Secure Contact Form” 2.9.7 or higher is installed and activated (this is just an extension to it)
  • Install “Contact Form DB” from the “Plugins” – “Add” menu in WordPress, or Import a locally downloaded zip file via the ‘Plugins’ menu in WordPress.
  • Activate the plugin through the ‘Plugins’ menu in WordPress
  • Next time an email es received, it will be saved in the database. Emails prior to installing the database plugin will not be found, this is normal.

Usage:
Installing Contact Form DB automatically creates its own table in WordPress. It also creates links to “Contact Form DB Extension | Database | Database Options | Build Short Code | Reference on the top of the contact form edit settings page. All new Emails from Fast Secure Contact Form will be automatically saved to the WordPress database. Click the link to “Database” on the top of the form edit page to see the data in the database. The data can be viewed on the page, and can be exported to CSV or Excel files. The “Database Options” page has settings to set users roles for accessing the data and settings to prevent specific forms or fields from being saved. For more information: Read the FAQ

contact-database1

contact-database-screenshot-1

Can certain fields be ignored or renamed, and can certain forms be excluded?
Yes, this feature was added in version FSCF 2.9.8.1

Use the Data Export settings to manage what fields are allowed to be exported or ignored for each form. This feature only alters new submissions, not old ones.

The available settings are:

Data export fields to ignore:
Optional list of field names for fields you do not want included in the data export. Start each entry on a new line. Click “help” to see a list of available field tags. Note: If you add any extra fields, they will show up in this list of available tags.

Data export fields to rename:
Optional list of field names for fields you want renamed in the data export. Start each entry on a new line. Type the old field name separated by the equals character, then type the new name, like this: oldname=newname

Examples:
from_name=name
from_email=email

Click “help” to see a list of available field tags. Note: If you add any extra fields, they will show up in this list of available tags. This feature is most useful when using extra fields, it allows you to tag them with a more specific name.

Data export key value pairs to add:
Optional list of key value pairs that need to be added. Sometimes the outgoing connection will require fields that were not posted on your form. Start each entry on a new line. Type the key separated by the equals character, then type the value, like this: key=value

Examples:
account=3629675
newsletter=join
action=signup

data-export-settings

Can the email sending be turned off when exporting?
Yes, this feature was added in version FSCF 2.9.8.1
Use the Data Export setting: “Disable email sending (use only when required while you have enabled data export).
When this setting is checked, no email will be sent to you!! The posted data will ONLY be sent to the data export. Note: the confirmation email feature will still send email if it is enabled.

Note about form labels and selection of database data
In FSCF, the “Form X label:” on the form edit page is optional(X is the form number). If you do not have a “Form X label” set, then the database will use “Form X” as the form selection option. If you are using the DB feature for submissions and later edit the form and add a “Form X label:”, then all new form submissions must be selected using the new form x label. ‘Form X’ selection option will still contain the old submissions, this is normal.

database-view

My forms are not saving to the database
Make sure you installed and activated the Contact Form DB plugin.
Be sure to check the form selection options on the database view page, be sure you have selected the correct form to view. Emails prior to installing the database plugin will not be found, this is normal

How do I change the extra field column names from ex_field(number) to something more descriptive?
Use the using the Data export fields to rename feature. You find this on the form edit page. This is a list of field names for fields you want renamed in the data export. Start each entry on a new line. Type the old field name separated by the equals character, then type the new name, like this: oldname=newname

Examples:
ex_field1=sex
ex_field2=age
ex_field3=marital status
ex_field4=employment
ex_field5=education

Note that the Data export fields to rename feature only alters new submissions column names, not old ones. You may want to delete all the old submissions, or change the label of your form # on the FSCF form edit page so that the new submissions are displayed under a new option select on the database viewer, that way the old column names would not mix with the new ones.

Support for Contact Form DB plugin:
I (Mike Challis) am not the maker of Contact Form DB plugin and am not associated with the development of it. All questions and support for Contact Form DB plugin should be directed to:

Send us a Donation:

Donate to Mike Challis

Comments are closed.