Data Source for Contact Form 7 vs Import and export users and customers

Data Source for Contact Form 7 plugin allows populating the “Contact Form 7” fields (text, email, URL, drop-down menu, …) with data stored in external data sources, like a database, CSV file, URL parameters, users information, post data, taxonomies, Advanced Custom Fields (ACF) – Secured Custom Fields, and JSON objects. Data Source for Contact Form 7 includes two new controls in the controls bar of Contact Form 7, recordset and recordset field link. The “recordset” control reads the information from the external data source (a database, a CSV file, or any other data source supported), and the “recordset field link” control for linking the recordsets and form fields to populate them with the recordset data. A form can include several “recordset” fields, and it is possible to link multiple “recordset field link” controls to the same recordset. The new SQL-Generator module. It generates the database queries in a more conversational style. Just describe the information needed, and get the DB query without any prior database knowledge. How to create the simplest contact form from our practical examples. The plugin includes other complementary controls in the controls bar in addition to the “recordset” and “recordset field link”. The “Print Form” button for printing the form area, “Data Table” control for inserting an advanced table with the recordset records, “copy to clipboard” functionality for copying the values of the fields into the clipboard, and the “Search box in dropdown menu” functionality to make easy the selection in long dropdown menus. Features: Set the information of external data sources available for the Contact Form 7 fields. Easy to use, includes two new controls in the controls bar to define the recordsets and the link fields. Includes the “URL Parameters” data source to populate the form’s fields with the values of the URL parameters. Includes the “Users Information” data source to populate the form’s fields with the users’ information. Includes the “Posts Information” data source to populate the form’s fields with the posts’ data, pages, and custom post types (like the WooCommerce products). Includes the “Taxonomy” data source to populate the form’s fields with taxonomy terms, like categories, posts tags, or any other custom taxonomy. Includes the “Database” data source to populate the form’s fields with the information of a database. Allow defining even complex queries. SQL Generator module. It generates the database queries in a more conversational style. Includes the “Javascript Function” data source to populate the form’s fields with the information returned from a Javascript function. Allows using the fields’ values for filtering the recordset records. Complementary Controls add-on. Includes additional controls and functionalities, such as the “Print Form” button, the addition of the search box to the drop-down menu, copy to clipboard functionality, and Data Table to display the data source records. Features in Premium version: All features of the free version of the plugin. Includes the “Advanced Custom Fields (ACF) – Secured Custom Fields” data source to fill the form filds with data stored in the Advanced Custom Fields or Secured Custom Fields in post, users, comments, taxonomies, widgets, and options. Includes the “CSV” data source to populate the form’s fields with the data store into a CSV file. Includes the “JSON” data source to populate the form’s fields with the data store into a JSON file. There are hundreds of services whose outputs are JSON objects. PDF Generator add-on. It generates PDF files with the information collected by the form and attaches them to the notification emails (Supports the “Conditional Fields for Contact Form 7” plugin tags in the PDF file content if the “Conditional Fields for Contact Form 7” plugin is installed on the website). Post Generator add-on. It generates new posts (posts, pages, or any custom post) with the information collected by the form. User Registration add-on to convert contact forms into user registration forms. CSV Generator add-on to populate a CSV file with the information collected by the form. JSON Generator add-on to populate a JSON file with the information collected by the form. Server Side add-on to implement server side functions to call from the Recordset controls and get the list of records. Data Source Fields Data Source for Contact Form 7 includes two new controls in the controls bar of Contact Form 7, recordset and recordset field link. The recordset control reads the information from the external data source and makes it available on the form. A recordset field can read one or many records from the data source. To insert a recordset field in the form, press the “recordset” button in the controls bar. This action opens a dialog to define the recordset. The insertion dialog includes common attributes for all data sources and specific attributes for the data source selected. The “recordset field link” control links a recordset field to other fields in the form to populate them with the recordset data. To insert a link field in the form, press the “recordset field link” button in the controls bar. This action opens a dialog to define the relationship between a recordset and a form’s field. The link dialog includes the attributes to define the relationship between the recordset field and the form’s fields. Cases of Use Get the information of the registered user and populate the form fields for his name and email: Your name [text* your-name] Your email [email* your-email] Subject [text* your-subject] Your message (optional) [textarea your-message] [cf7-recordset id="cf7-recordset-434" type="user" attributes="first_name, user_email" logged="1"] [cf7-link-field recordset="cf7-recordset-434" field="your-name" value="first_name"] [cf7-link-field recordset="cf7-recordset-434" field="your-email" value="user_email"] [submit "Submit"] Filling a plain text in the form with the first name and last name of the logged user: Hello Enter your address [textarea address] [cf7-recordset id="cf7-recordset-434" type="user" attributes="first_name, last_name" logged="1"] [cf7-link-field recordset="cf7-recordset-434" field="first-name" value="first_name"] [cf7-link-field recordset="cf7-recordset-434" field="last-name" value="last_name"] [submit "Submit"] Populates the list of WooCommerce products and get the price of the selected one: Products List [select menu-719] Product Price [number number-534] [cf7-recordset id="cf7-recordset-619" type="database" engine="mysql" query="SELECT ID,post_title,meta_value as price FROM {wpdb.posts} posts, {wpdb.postmeta} meta WHERE posts.post_type='product' AND posts.ID=meta.post_id AND meta.meta_key='_regular_price'"] [cf7-link-field recordset="cf7-recordset-619" field="menu-719" value="ID" text="post_title"] [cf7-link-field recordset="cf7-recordset-619" field="number-534" value="price" condition="record['ID']=={field.menu-719}"] [submit "Submit"] Using templates to create complex data structures. Displaying the title and excerpt of every published post: {attribute.post_title} {attribute.post_excerpt} [cf7-recordset id="cf7-posts" type="post" attributes="post_title,post_excerpt" condition="post_status='publish' AND post_type='post'"] [cf7-link-field recordset="cf7-posts" field="posts-list" value="{template.summary}"] The form includes a template tag to design a complex data structure. To access the records attributes from the template, use {attribute.attribute-name} format. Ex. {attribute.post_title} You can use the templates for the fields’ values or texts. The format for referring to templates is {template.template-id}. You should replace “template-id” with the id of the template tag. Ex. {template.summary} [cf7-link-field recordset="cf7-posts" field="posts-list" value="{template.summary}"] Using Javascript to Access the Recordset Data The recordset fields trigger the “cf7-recordset” event after receiving the information from the data source, allowing you to access this information with Javascript. In this example, the recordset field reads motivational phrases from a third-party service and displays the first of them into a DIV tag on the form. Add ons (Extensions) Complementary Controls add-on PDF Generator add-on Post Generator add-on User Registration add-on CSV Generator add-on JSON Generator add-on Server Side add-on

Try it out on your free dummy site: Click here => https://demo.tastewp.com/import-users-from-csv-with-meta Import, export and migrate WordPress users and WooCommerce customers from a CSV file. Bulk-create or update thousands of users in seconds, schedule automatic recurring imports from a local file or URL, and carry over roles, passwords and any custom meta field. Works with WooCommerce, BuddyPress, Advanced Custom Fields, Paid Membership Pro, WooCommerce Memberships, WooCommerce Subscriptions and many more. Import CSV file with users directly to your WordPress or customers into WooCommerce Import thousands of users or customers in only some seconds Export users or customers to a CSV file, filtering by role or registered date You can also import meta-data like data from WooCommerce customers You can assign roles while importing. Send a mail to every new user, this mails can be saved as templates and are fully customizable, before sending you can test it You can also update users if the user is already in your WordPress Create a cron task to import users periodically Edit the metadata (you will be able to edit the metadata imported using metakeys directly in the profile of each user) Extend the plugin using the hooks we provide Compatible with WPML read the documentation to see how you can translate the front-end import and export users page and send translated email notifications to users Moreover this plugin is compatible with many other plugins to be able to import and include them data, subscriptions, memberships, etc. Take a look: WooCommerce: to import the customer data WooCommerce Memberships: to import memberships WooCommerce Subscriptions: to create subscriptions associated with users while they are being imported BuddyPress: to import custom BuddyPress avatars, fields, groups and roles Advanced Custom Fields: to import data to the fields you define there Paid Membership Pro: to import memberships, included compatibility with PMPro version 3 Indeed Ultimate Membership Pro: to import memberships Paid Member Subscriptions: to import memberships Allow Multiple Accounts: plugin will allow the same rules importing than this plugin Groups: to assign users to groups while importing New User Approve: you can import users and approbe/wait for approve them Users Group: to assign users to groups while importing WP LMS Course: to enroll users in the courses while importing WP Members: to import memberships WP Users Group: to assign users to groups while importing WooCommerce Membership by RightPress: to create memberships while users are being imported WP Private Content Plus: To import and export the groups to which users are assigned If you have some problem or doubt: Read our documentation Ask anything in support forum, we try to give the best support Common use cases Migrate users from one WordPress site to another Bulk create or update WooCommerce customers from a spreadsheet Sync users automatically from an external CRM or ERP via CSV Onboard members to a membership site (Paid Membership Pro, WooCommerce Memberships) Periodically import subscribers or students from an external list Import users from the frontend using a shortcode Usage Once the plugin is installed you can use it. Go to Tools menu and there, there will be a section called Insert users from CSV. Just choose your CSV file and go! CSV generation You can generate CSV file with all users inside it, using a standar spreadsheet software like: Microsoft Excel, LibreOffice Calc, OpenOffice Calc or Gnumeric. You have to create the file filled with information (or take it from another database) and you will only have to choose CSV file when you “Save as…” the file. As example, a CSV file is included with the plugin. Some considerations Plugin will automatically detect: Charset and set it to UTF-8 to prevent problems with non-ASCII characters. It also will auto detect line-ending to prevent problems with different OS. Finally, it will detect the delimiter being used in CSV file Other plugins by Codection RedSys Gateway for WooCommerce Pro (premium) Ceca Gateway for WooCommerce Pro (premium) RedSys Gateway for Contact Form 7 (premium) Ceca Gateway for Contact Form 7 (premium) RedSys & Bizum Gateway for Gravity Forms (premium) RedSys & Bizum Gateway for WPForms (premium) RedSys & Bizum for GiveWP (premium) RedSys Link Generator (premium) RedSys & Bizum Gateway for EDD Pro (premium) RedSys Gateway for WP Booking Calendar Pro (premium) Clean Login (free) Products Restricted Users for WooCommerce (free) First payment date for WooCommerce Subscriptions (free) Payment Schedule for WooCommerce Subscriptions (premium)