How to Import and Export Your Contact Form 7 Data with CFDB7
Content
Migrating your Contact Form 7 submission data to a new site or simply creating a backup is a common need for website administrators. Many users of the 'Contact Form 7 Database Addon – CFDB7' plugin find that the standard WordPress export tools do not handle this data. This guide will walk you through the most common methods for exporting and importing your valuable form entries.
Why Standard WordPress Export Doesn't Work
The 'Contact Form 7 Database Addon – CFDB7' plugin stores submissions in a custom database table within your WordPress database. The core WordPress export function is designed for posts, pages, and comments, not custom tables. Therefore, you need a different approach to move this data.
Method 1: Using a Dedicated Import/Export Add-on (Recommended)
Based on numerous community threads, the developers and community often suggest using a separate plugin to handle imports and exports. This is typically the easiest method for most users.
- For Exporting Data: An add-on often mentioned in support forums is the "Public Export to CSV" extension. This tool allows you to export your form submissions directly from the WordPress admin area into a CSV file.
- For Importing Data: To bring data into a CFDB7 installation, the "CFDB7 Import" add-on is frequently recommended. This plugin is designed to take a CSV file and insert the records into the database, making it ideal for migrations or restoring backups.
Note: BugWP.com is an independent resource and is not affiliated with these add-ons. You can search for "CFDB7 Import CSV" and "CFDB7 Export CSV" to find these tools.
Method 2: Manual Database Manipulation (Advanced)
For users comfortable with phpMyAdmin or other database management tools, a manual export/import is possible.
- In your source website's database, locate the
wp_db7_formstable (thewp_prefix may be different if you changed it). - Export this single table as an SQL file.
- On your new website, ensure the CFDB7 plugin is installed and activated. This will create the necessary empty table.
- Import the SQL file you exported into the new website's database.
Warning: This method requires technical skill. Incorrectly modifying your database can break your site. Always create a full backup before proceeding.
Frequently Asked Questions
Q: Can I import data from another form plugin or a custom post type?
A: Based on community questions, this is not a default feature of the core CFDB7 plugin. Importing data from other sources typically requires custom development work to format the data correctly for the CFDB7 table.
Q: I have a full site backup but no CSV export. Can I recover my data?
A: Yes. If you have a database backup (e.g., from phpMyAdmin or a backup plugin), you can restore the entire database or extract just the wp_db7_forms table and import it manually using Method 2.
Q: The plugin doesn't save the IP address. How can I add it?
A: The core plugin does not store this data by default. Community suggestions often involve using an additional plugin, like "Contact Form 7 Dynamic Text Extension," to capture the IP address and pass it through the form as a hidden field, which CFDB7 will then save.
Conclusion
While the 'Contact Form 7 Database Addon – CFDB7' itself does not have built-in import/export functions, the solutions above provide clear paths for managing your data. For most users, seeking out the dedicated import and export add-ons is the most straightforward solution. For advanced users, a manual database transfer is a powerful alternative.
Related Support Threads Support
-
import data in pluginhttps://wordpress.org/support/topic/import-data-in-plugin/
-
Import data from Custom Post Typehttps://wordpress.org/support/topic/import-data-from-custom-post-type/
-
Show datahttps://wordpress.org/support/topic/show-data/
-
Where is the data stored?https://wordpress.org/support/topic/where-is-the-data-stored-10/
-
IP addresshttps://wordpress.org/support/topic/ip-address-18/
-
Is there any way to unstore the timestamp, datefield and ip address to the dbhttps://wordpress.org/support/topic/is-there-any-way-to-unstore-the-timestamp-datefield-and-ip-address-to-the-db/
-
Import Form Datahttps://wordpress.org/support/topic/import-form-data/
-
Pipes – How does it save them?https://wordpress.org/support/topic/pipes-how-does-it-save-them/
-
Use an external Databasehttps://wordpress.org/support/topic/use-an-external-database/
-
import functionhttps://wordpress.org/support/topic/import-function-4/
-
automatic save csv on webspacehttps://wordpress.org/support/topic/automatic-save-csv-on-webspace/
-
Manually add users to databasehttps://wordpress.org/support/topic/manually-add-users-to-database/
-
Table creation when adding new sitehttps://wordpress.org/support/topic/table-creation-when-adding-new-site/
-
Import to new WordPress installationhttps://wordpress.org/support/topic/import-to-new-wordpress-installation/
-
Import entries from file manager filehttps://wordpress.org/support/topic/import-entries-from-file-manager-file/
-
IMPORThttps://wordpress.org/support/topic/import-81/
-
custom tablehttps://wordpress.org/support/topic/custom-table-5/
-
import from Submissions pluginhttps://wordpress.org/support/topic/import-from-submissions-plugin/
-
Looking for a solution to save user specific entrys from logged in usershttps://wordpress.org/support/topic/looking-for-a-solution-to-save-user-specific-entrys-from-logged-in-users/
-
Where my Data?https://wordpress.org/support/topic/where-my-data/
-
Export to TablePresshttps://wordpress.org/support/topic/export-to-tablepress/
-
Store to different SQL databases??https://wordpress.org/support/topic/store-to-different-sql-databases/
-
API Endpoints or so?https://wordpress.org/support/topic/api-endpoints-or-so/
-
Custom Columnshttps://wordpress.org/support/topic/custom-columns-3/
-
Importing and exporting datahttps://wordpress.org/support/topic/importing-and-exporting-data-2/
-
save data to another databasehttps://wordpress.org/support/topic/save-data-to-another-database/
-
Import cbd7 data in a new wordpress installationhttps://wordpress.org/support/topic/import-cbd7-data-in-a-new-wordpress-installation/
-
Directing data to a particular tablehttps://wordpress.org/support/topic/directing-data-to-a-particular-table/
-
Uninstall and delete all data from databasehttps://wordpress.org/support/topic/uninstall-and-delete-all-data-from-database/