Entries Database for Contact Form 7 – iKetch - Version 2.3.1

A WordPress plugin to save, view, search, filter, manage, print, and export Contact Form 7 submissions directly from your WordPress dashboard. It stores entries independently and does not require Flamingo.

What's New in Version 2.3.1

• Rebranded the public-facing plugin name to Entries Database for Contact Form 7 – iKetch.
• Improved WordPress.org metadata and readme content.
• Updated Arabic, German, Spanish, French, and Russian translations.

What's New in Version 2.3.0

• Refined desktop, mobile, RTL, and LTR admin layouts.
• Mobile entries now follow WordPress responsive list-table behavior and open their details by default.
• Print individual entries with a clean print layout.
• Export an individual entry directly from its detail page.
• Clearer Add to favorites and Remove from favorites actions.
• Updated Arabic, German, Spanish, French, and Russian translations.

What's New in Version 2.2.0

• New submissions are tracked as unread and become read automatically when opened.
• Unread entries are highlighted and include clear status labels.
• Filter entries by read status and update one or many entries at once.
• See the unread count directly in the WordPress admin menu and dashboard statistics.
• The unread menu counter updates immediately when an entry is opened.
• Historical entries remain read when upgrading, so the counter starts accurately.
• Star and unstar entries instantly without reloading the page.
• Filter Starred entries, combine star and read-status filters, and apply bulk star actions.

🎉 What's New in Version 2.0.0

✨ New Features

• 🔍 Search Functionality: Search through all form submissions quickly
• 📊 Statistics Dashboard: View total entries and active forms at a glance
• 📤 Export to CSV: Export filtered or all entries to CSV format
• ⚙️ Settings Page: Full control over plugin behavior
  • Customize entries per page
  • Select which forms to track
  • Auto-cleanup old entries
  • Enable/disable file saving
• ️ GDPR Compliance: Delete all entries for a specific email address
• 📅 Scheduled Cleanup: Automatically delete old entries based on age

🔒 Security Improvements

• Permission Checks: All admin actions now require proper capabilities
• File Type Validation: Only allow safe file types (jpg, png, pdf, doc, etc.)
• Directory Protection: Added .htaccess and index.php to uploads folder
• Input Sanitization: Enhanced sanitization across all user inputs
• Nonce Verification: Added nonce checks for all form submissions
• Fixed Data Leak: Removed print_r() debug output from table columns

🎨 UI/UX Improvements

• Form Filter: Filter entries by specific Contact Form 7 forms
• Better Bulk Actions: Improved bulk delete and export functionality
• Success Messages: Clear feedback after actions
• Responsive Design: Better layout on different screen sizes

📋 Features

Core Features

• ✅ Capture all CF7 form submissions automatically
• ✅ View entries in a sortable, paginated table
• ✅ View detailed entry information including uploaded files
• ✅ Delete individual or bulk entries
• ✅ Files are saved separately and linked to entries

Advanced Features

• ✅ Search through entry data
• ✅ Filter by specific forms
• ✅ Export entries to CSV (with UTF-8 BOM for Excel compatibility)
• ✅ Track only specific forms or all forms
• ✅ Auto-cleanup old entries
• ✅ GDPR data deletion by email address
• ✅ Control file saving to save storage space

🔧 Installation

1. Upload the plugin files to /wp-content/plugins/iketch-entries-viewer-for-contact-form-7/
2. Activate the plugin through the 'Plugins' menu in WordPress
3. Go to Entries Viewer in the admin menu
4. Configure settings as needed

⚙️ Settings

Navigate to Entries Viewer > Settings to configure:

General Settings

• Entries per page: Number of entries to display (5-100)
• Tracked Forms: Choose which forms to capture (or track all)
• Auto-cleanup: Automatically delete entries older than X days
• Save uploaded files: Enable/disable file saving

Data Management

• GDPR Deletion: Delete all entries for a specific email
• Automatic Cleanup: Delete entries older than the configured age on the daily schedule

🔐 Security

This plugin follows WordPress security best practices:

• Nonce verification for all actions
• Capability checks for admin pages
• Input sanitization and output escaping
• File type validation for uploads
• Protected upload directory

📝 Requirements

• WordPress 5.3+
• PHP 7.0+
• Contact Form 7 plugin

🛠️ Developer Info

Capabilities

The plugin registers separate capabilities for viewing entries and files, exporting CSV, deleting entries, managing settings, and processing GDPR deletion requests. Administrators receive all plugin capabilities automatically; other roles can be configured from the Permissions screen. The legacy manage_cf7_entries capability remains supported for compatibility.

Filter

// Filter the roles that receive the default view-only capability.
add_filter( 'iketch_entries_viewer_default_view_roles', function( $roles ) {
    return $roles;
});

Database Structure

Table: {$wpdb->prefix}cf7_entries_viewer

• id (bigint) - Primary key
• form_id (bigint) - CF7 form ID
• form_title (varchar) - Form title
• user_data (longtext) - JSON encoded form data
• files_data (longtext) - JSON encoded file URLs
• is_read (tinyint) - Read/unread status
• is_starred (tinyint) - Starred status
• created_at (datetime) - Submission timestamp

📧 Support

For support and questions, visit: https://iketch.com/

📜 License

This plugin is free to use.

🙏 Credits

Developed with ❤️ by iketch