Data Source for Contact Form 7 vs WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets

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

WP All Import – Simple & Powerful XML, CSV, Google Sheets, and Excel Importer Plugin “It’s a wonderful plugin that does so much, so well that it’s hard to list all of the features. But I’ll tell you this, I was able to import the content of a pair of websites running the ModX CMS into a WordPress install in less than 30 minutes. No joke!” Alex Vasquez – DigiSavvy Co-Founder & WordCamp Los Angeles Organizer WP All Import has a four-step import process and an intuitive drag-and-drop interface that makes complicated import tasks simple and fast. There are no special requirements that the elements in your file must be laid out in a certain way. WP All Import can import any XML, CSV, Excel spreadsheet, or Google Sheets file into WordPress. WP All Import can be used for everything from migrating content from a legacy CMS to WordPress to building a store with affiliate datafeed to displaying live stock quotes or sports scores to building a real estate portal. Check out our documentation and video tutorials to make the most of WP All Import. WP All Import integrates with our companion plugin, WP All Export. You can export posts, WooCommerce products, orders, users, or anything else with WP All Export. Then you can edit the WordPress data with Microsoft Excel, Numbers, or maybe something else, and re-import to the same site or migrate the data to another site with WP All Import. For technical support from the developers, please consider purchasing WP All Import Pro. WP All Import Pro Version WP All Import Pro is a paid upgrade that includes premium support and adds the following features: Import data to Custom Fields – used by many themes, especially those using Custom Post Types – to store data associated with the posts. Import images to the post media gallery – WP All Import can download images from URLs in an XML or CSV file and put them in the media gallery. Import files from a URL – Download and import CSV, XML, or Excel WordPress data files from external websites, even if they are password-protected with HTTP authentication. Cron Job/Recurring Imports from external URLs – WP All Import Pro can periodically check a file for updates, and add, edit, and delete the imported posts accordingly. Execution of Custom PHP Functions on data, i.e., use something like [my_function({xpath/to/a/field[1]})] in your template, to pass the value of {xpath/to/a/field[1]} to my_function and display whatever it returns. Guaranteed technical support via e-mail. Upgrade to the Pro edition of WP All Import. Need to import XML and CSV to WooCommerce? Check out our WooCommerce add-on. WordPress CSV Imports Read on to learn more about the CSV importer functionality of WP All Import. Importing CSVs with WP All Import is exactly the same as importing XML files because internally, WP All Import actually converts your CSV file to an XML file on the fly. You can use the same XPath filtering options and all the same features you have when importing XML files. CSV imports, including those exported from Excel and Google Sheets, don’t require your file to have a specific structure. Your CSV file can use any column names/headings. You can map the columns in your CSV file to the appropriate places in WordPress during the import process. When importing CSV files, your CSV should have UTF-8 encoding if you are having trouble importing special characters. In step 2 of a CSV import, you can specify an alternative delimiter if you aren’t using a comma. WP All Import can import CSVs that are pipe-delimited, # delimited, or delimited/separated by any other character. For CSV import tutorials and example files, visit our documentation. Please keep in mind CSV imports with WP All Import are just like XML imports – you have all the same functionality, and the process is exactly the same. Any of our tutorial videos that apply to XML files also apply to importing CSV files, so if you see a tutorial with us importing an XML file, know that you can follow the exact same steps for a CSV import. WordPress Excel Import / Google Sheets Import Don’t want to convert your Excel or Google Sheets data to CSV? WP All Import also works as a Google Sheets and Excel importer for WordPress. Simply upload your Excel file as you would for CSV and WP All Import will automatically detect the columns in your file. For Google Sheets, use the ‘Download a file’ option and paste your sheet’s public URL to import data to WordPress. Add-Ons A number of premium add-ons are available to add functionality to the importer and make XML, CSV, Google Sheets, and Excel import tasks to complex plugins simple. Advanced Custom Fields Add-On – ACF XML & CSV importer WooCommerce Add-On – XML & CSV importer for all WooCommerce product types User Import Add-On – XML & CSV importer for users, including user_meta Link Cloak Add-On – Auto-create redirects for links present during an XML or CSV import Learn more about our add-ons at http://www.wpallimport.com/add-ons A developer API (action hooks) is also available. Related Plugins Export any WordPress data to XML/CSV Import Products from any XML or CSV to WooCommerce Export Products to CSV/XML for WooCommerce Custom Product Tabs for WooCommerce WP All Import Add-on Export Orders to CSV/XML for WooCommerce Export WordPress Users to CSV/XML Premium Support You can submit the support form on our website or email us at [email protected]. While we try to assist users of our free version, please note that support is not guaranteed and will depend on our capacity. For premium support, purchase WP All Import Pro. Import To WooCommerce Need to import Excel, XML and CSV to WooCommerce? Check out our WooCommerce add-on. WooCommerce Excel, XML & CSV Import Pro Version