Advanced Contact form 7 DB

Description

Plug and Play, No Confrontation is required after install and activated, you can see it in wp-admin.

Each and every submission of Contact Form 7 is stored in the database and manage easily using the default WordPress interface. There is a nice drop-down to select the form and view all form data for that particular form. you can filter by searching keywords or select a date range.

Attached files are stored in the /wp-content/uploads/advanced-cf7-upload directory and also download from wp-admin.

Features

  • Multisite compatible to store individual site wise contact form data.
  • Save Contact Form 7 form submitted data to the database.
  • Easy to update/edit enquiry data.
  • Display all created contact form 7 form list.
  • Keyword search for all the entries of selected form.
  • Date range filter to filter specific date related entries easily.
  • Export all, or only searched, filtered results with selected fields.
  • Export data in CSV, EXCEL and PDF file.
  • Display attachment download link.
  • Given advance pagination on the listing screen so all the records are not loaded at once, to save resources.
  • Given go to page functionality within pagination so view specific page related entries.
  • Enable or disable columns display.
  • Drag and drop to reorder columns once the entries are stored.
  • Multiple select of records and selected records will be deleted or export in the sheet.
  • Facility to update each record.
  • Easy to update each field label name.
  • Easy to setup import functionality.
  • Facility to import form related entries from CSV file.
  • Provided filters for excluding particular contact form entry to CF7 DB.
  • Provided filter to add,modify,remove CF7 fields and data before submitting to CF7 DB.
  • You can display the contact form DB data to user by using shortcodes.
  • Generate shortcode using different parameters to display specific data only.
  • For more details checkout the plugin “Shortcode” screen.

Commercial Features

1. Advanced CF7 DB – GDPR compliant
Advanced CF7 DB – GDPR compliant plugin assists website and web-shop owners to comply with European privacy regulations known as GDPR. Advanced CF7 DB – GDPR compliant is an add-on of Advanced Cf7 DB, based on GDPR rules to Export or Erase user’s personal data stored with advanced cf7 DB. For more details you can check the below download link.

You can download the plugin from here

Advanced CF7 DB – GDPR compliant Plugin Features

  • Compatible with the latest WordPress version 4.9.6 and later for GDPR compliances. Meets with the new regulations for the data to be handled.
  • Individual CF7 form wise settings to show the personal data on user’s request.
  • Erase only the CF7 form personal data, that are required.
  • Site owners can export a ZIP file containing a user’s personal data, including data collected by Advanced CF7 DB plugin.
  • Site owners can erase a user’s personal data, including data collected by Advanced CF7 DB plugin.

2. Schedule Report
We have also introduced new feature “Schedule Report”. This add-on is specially for businesses that require daily, weekly or monthly reports for the data that are stored at Advanced Contact form 7 DB. Schedule Report For Advanced CF7 DB plugin will do the same and send the email as per schedule set(Daily, Monthly, Weekly or Yearly) with report attachment.

You can download the plugin from here

Schedule Report Plugin Features

  • Automatically generating the CSV report, Send an email with report attachment based on the scheduled time.
  • Option to create more than one scheduling event to get different enquiry form data report.
  • Option to select report datasheet columns from enquiry form field.
  • Provision to filter the data while creating the scheduled event for the particular report.
  • You can manage the email content by defining TO, FROM and email body content for each scheduling event.
  • The added schedule event will be added to WordPress cron schedule and accordingly will be fire at the scheduled time.

3. Advanced CF7 DB – User Access Manager
Need to provide access to other users? Your, search ends now, this plugin provides access to individual users OR based on user Role and accordingly user can view or edit the contact form DB data. For more details you can check the below download link.

You can download the plugin from here

Advanced CF7 DB – User Access Manager Plugin Features

  • Provide access of contact form 7 DB to View & Update data to individual users OR based on user Role.
  • Provide access of Single/Multiple forms to single user.

Plugin Customization

= Restrict IP address storage =
* Some of Countries have introduced a Law to don’t store the user’s IP addresses into the database, So we had given provision to Restrict IP address storage.

How to Restrict IP address storage?

  1. Goto -> wp-content/themes/{active theme folder}/functions.php
  2. Open the functions.php file and place the code do_shortcode( ‘[cf7-db-display-ip]’ ); at the end of the file.

Need Support? mehul@vsourz.com

How to use?

  1. Install Plugin via WordPress Admin – Go to Admin > Plugins > Add New.
  2. View form entries Go To Admin >> Advanced CF7 DB >> Select form name.
  3. Import CSV file Go To Admin >> Import CSV >> Import CSV tab >> Select form name.

Screenshots

  • Display form related records.
  • Display Setting popup screen.
  • Edit information popup screen.
  • Setup import file fields.
  • Import CSV file.

Installation

Install via WordPress Admin

  1. Ready the zip file of the plugin
  2. Go to Admin > Plugins > Add New
  3. On the upper portion click the Upload link
  4. Using the file upload field, upload the plugin zip file here and activate the plugin

Install via FTP

  1. First, unzip the plugin file
  2. Using FTP go to your server’s wp-content/plugins directory
  3. Upload the unzipped plugin here
  4. Once finished login into your WP Admin and go to Admin > Plugins
  5. Look for Advanced CF7 DB and activate it

FAQ

Can I use this plugin when contact form 7 not install or activate?

No, without contact form this plugin is not worked.

How can I import CSV sheet?

First, you need to add CSV sheet related column name on Import CSV screen in the field setting tab and save values then import sheet on import CSV tab screen.

Can I change the field name?

No, You can change only field label name from Display settings screen.

Any Difficulty to exported data in CSV?

While exporting the data as CSV, the sheet needs to be opened with delimiter as “,” comma separated else the sheet data will not be displayed properly.

What to do if advanced CF7 DB not work?

If the plugin does not work on the website, contact our Support Team via following email address: mehul@vsourz.com.
If you think, that you found a bug in our plugin or have any question contact us at mehul@vsourz.com. Our support team will solve within 24 hours.

Can I restrict the plugin from storing IP address of the user to contact form DB?

Yes, you can strict the plugin for storing IP address of the user.

Can I display contact form DB data to user ?

Yes, you can display contact form DB data to user. You can use short code for this purpose. For detail please visit “Shortcode” screen of plugin.

How to restrict the plugin from storing IP address of the user to contact form DB?

Restriction is simple, just code do_shortcode( ‘[cf7-db-display-ip]’ ); to be placed in theme folder functions.php. By placing the code the IP address of the user will not been stored. Step by step process is explained below :
– Goto -> wp-content/themes/{active theme folder}/functions.php
– Open the functions.php file and place the code do_shortcode( ‘[cf7-db-display-ip]’ ); at the end of the file.
For Multisite it should be do_shortcode( ‘[cf7-db-display-ip site_id=”(your-site-id)”]’ );
– You need to add different shortcode for each site with specific siteId. If you need to restrict for all the sites then just place the shortcode without the parameter.

How to restrict the plugin from storing form entry to contact form DB?

Restriction is simple, just following below steps :
– Goto -> wp-content/themes/{active theme folder}/functions.php
– Open the functions.php file and place below code at the end of the file.
add_filter(‘vsz_cf7_unwanted_form_data_submission’,’vsz_restrict_form_data_submission’);
function vsz_restrict_form_data_submission($contact_form_ids){
$contact_form_ids[] = {your-contact-form-id};
return $contact_form_ids;
}
For multiple forms
add_filter(‘vsz_cf7_unwanted_form_data_submission’,’vsz_restrict_form_data_submission’);
function vsz_restrict_form_data_submission($contact_form_ids){
$contact_form_ids[] = [‘{your-contact-form-id}’,'{your-contact-form-id}’];
return $contact_form_ids;
}

Reviews

Can’t really tell

Seems to go into an infinite loop. The icon spins without the “activated” notification, and reloading the page also hangs. Removing the plugin solves the problem.

[Wed May 02 10:38:53.914939 2018] [core:error] [pid 20249] [client 17.58.103.217:51859] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use ‘LimitInternalRecursion’ to increase the limit if necessary. Use ‘LogLevel debug’ to get a backtrace.

[edited to add]

Turns out the feature I was looking for was included in a recent update of Contact Form 7, which is why I haven’t taken the time to go through the debugging and support steps. I’m changing the rating to a more neutral three stars. Sorry for the bad press.

Great plugin

It’s a great plugin. I like everything except that it still save sender IP in a database. With all these EU upcoming privacy policy requirements etc. It must be an optional option. In this case, it’s doesn’t matter do I hide the field or not, it’s still saved in a database.

But everything else is great! I like this plugin.

You should really need to consider to add an option to NOT save sender IP in a database.

UPDATE: The plugin team now allows to NOT to save sender IP in the DB. Now this is a perfect plugin. Thank you!

Read all 14 reviews

Contributors & Developers

“Advanced Contact form 7 DB” is open source software. The following people have contributed to this plugin.

Contributors

“Advanced Contact form 7 DB” has been translated into 3 locales. Thank you to the translators for their contributions.

Translate “Advanced Contact form 7 DB” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.5.0

  • Developer Support: Provide screen for the developer to manage Display Enquiry, Ban IP and Actions & Filters.
  • Add-ons: Provision to select other add-ons of Advanced CF7 DB.

1.4.4

  • Fixed issue related to export records in PDF.
  • Provided filter for excluding particular contact form entry to the database
  • Provided filter to add, modify, remove CF7 fields and data before submitting to the database.

1.4.3

  • Fixed issue related to export records in PDF.
  • Multisite support for IP restrict.

1.4.2

  • Fixed issue related to hide ip address
  • Delete attachment when record deleted
  • Search with special characters issue fixed
  • Accents and other languages special characters support added for export file with Excel and CSV
  • Added the New library for the PDF

1.4.1

  • Hidden field : Provision to update hidden field value.
  • Export data in EXCEL : Resolved Special characters related issue.

1.4.0

  • Export data in EXCEL & PDF file.
  • IP address storage restriction.
  • Mobile UI compatible
  • Schedule Report: We have also introduced new feature Schedule Report., now You can download our Commercial plugin from here

1.3.0

  • Fixed issue related to the Contact Form tel field while editing the form data entry.
  • Provision to change the number of records to be displayed in listing page from display setting option.
  • Fixed issue related to redirection to the first page when a record is been updated from edit data popup.
  • Compatible up to PHP 7.1

1.2.0

  • Fix error related to PHP strings.

1.1.2

  • Fix error related to PHP 7.1.

1.1.1

  • Made changes to resolve the issue of user feasibility when editing the form fields.
  • Minor tweak related to export functionality and attachment download functionality.

1.1.0

  • Update Import Functionality.
  • Fix CF7 Version related issue.

1.0.0

  • Initial