Toshiyuki Kawashima

<p>This plugin make simple database from csv.<br />
Import from csv files to custom post type.</p>
<h3>features</h3>
<ul>
<li>you can make database from csv file</li>
<li>import over 10000 records from csv file</li>
<li>delete all data records</li>
<li>support custom fields and taxonomies</li>
<li>sort and search data in backend</li>
<li>support shortcode for search form and result list in frontend</li>
<li>import from csv, insert only. update record not supported.</li>
</ul>
<h3>Usage</h3>
<h4>Create Database</h4>
<ol>
<li>Select DataBase Maker in admin menu. Add new post.</li>
<li>Title is database name, it is displayed admin menu.</li>
<li>Content is frontend search form. If content is empty, default form inserted.</li>
</ol>
<h4>Edit csv settings</h4>
<ol>
<li>post_type is database type</li>
<li>format is column names order in csv files. comma separated. see <strong>column names</strong></li>
<li>status is default post status.</li>
<li>character encoding is csv file’s encodeing</li>
<li>“skip lines” : skip n lines</li>
<li>“public access” is data status. if it is checked, public access from frontend.</li>
<li>save post. </li>
</ol>
<h4>Import data from csv file</h4>
<ol>
<li>Select your database name  in admin menu.</li>
<li>Select csv file and push “read csv”, start importing.</li>
<li>Display progress bar, please wait for a while.</li>
</ol>
<h4>Data operation in admin menu</h4>
<ul>
<li>keyword search target all columns</li>
<li>taxonomy filter supported</li>
<li>title, date and  custom fields support sorting.</li>
<li>Delete all data supported</li>
</ul>
<h4>Create search form for frontend</h4>
<ol>
<li>Select DataBase Maker, edit database</li>
<li>edit contents, see <strong>Short codes</strong></li>
<li>save contents then view posts</li>
</ol>
<h3>Column names</h3>
<ul>
<li>post_title: title of the post</li>
<li>post_author: (login or ID) The user name or user ID number</li>
<li>post_date:</li>
<li>post_excerpt:</li>
<li>post_status:</li>
<li>post_password:</li>
<li>post_name:</li>
<li>post_parent:</li>
<li>menu_order:</li>
<li>tax_{taxonomy}: (string, comma separated) Any field prefixed with tax_ will be used as a custom taxonomy.</li>
<li>{custom_field_key}: Any other column labels used as custom field.</li>
</ul>
<h3>Short codes</h3>
<h4>dbm_search</h4>
<p>Create form tag for search. This code is enclosing.</p>
<p>option</p>
<ul>
<li>post_type : <strong>required</strong> Search database post_type.</li>
<li>posts_per_page : default: 5</li>
<li>pager : This option set not empty string, pager support. default: ”</li>
</ul>
<h4>dbm_tax_checkbox</h4>
<p>Create checkboxes for taxonomy</p>
<p>option</p>
<ul>
<li>name : <strong>requried</strong> taxonomy name.(No “tax_” prefix)</li>
</ul>
<h4>dbm_tax_select</h4>
<p>Create select tag for taxonomy.</p>
<p>option</p>
<ul>
<li>name : <strong>requried</strong> taxonomy name.(No “tax_” prefix)</li>
<li>multiple : This option set not empty string, multiple select box. default: ”</li>
<li>size : Select tag size.</li>
</ul>
<h4>dbm_textbox</h4>
<p>Create text input box</p>
<p>option</p>
<ul>
<li>name : Set search target column name. ‘s’ is target all columns. default : ‘s’</li>
<li>required : true or false.  default : ‘false’</li>
</ul>
<h4>dbm_result_table</h4>
<p>Display search result table. This code need outside of dbm_search.</p>
<p>option</p>
<ul>
<li>label : th tag names, comma separated.</li>
<li>data : column names, comma separated.</li>
</ul>
<h4>dbm_result_pager</h4>
<p>Output pager</p>
<p>option</p>
<ul>
<li>label : pager button label. default : ‘first, prev, next, last’</li>
</ul>
<h3>Arbitrary section</h3>


DBMaker

Simple database plugin. import csv file, delete all records, search and sort in backend, simple search form for frontend.

codepeople

<p>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.</p>
<p>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.</p>
<p>A form can include several “recordset” fields, and it is possible to link multiple “recordset field link” controls to the same recordset.</p>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/bcf1i6jvlYE?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<p>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.</p>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/a-8AtsNJZ1A?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<p>How to create the simplest contact form from our practical examples.</p>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/DisVNGHiMe0?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<p>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.</p>
<h4>Features:</h4>
<ul>
<li>Set the information of external data sources available for the Contact Form 7 fields.</li>
<li>Easy to use, includes two new controls in the controls bar to define the <a href="https://cf7-datasource.dwbooster.com/documentation#recordset-control" rel="nofollow ugc">recordsets</a> and the <a href="https://cf7-datasource.dwbooster.com/documentation#link-control" rel="nofollow ugc">link fields</a>.</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#url-parameters" rel="nofollow ugc">“URL Parameters”</a> data source to populate the form’s fields with the values of the URL parameters.</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#user-information" rel="nofollow ugc">“Users Information”</a> data source to populate the form’s fields with the users’ information.</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#post-data" rel="nofollow ugc">“Posts Information”</a> data source to populate the form’s fields with the posts’ data, pages, and custom post types (like the WooCommerce products).</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#taxonomy" rel="nofollow ugc">“Taxonomy”</a> data source to populate the form’s fields with taxonomy terms, like categories, posts tags, or any other custom taxonomy.</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#database" rel="nofollow ugc">“Database”</a> data source to populate the form’s fields with the information of a database. Allow defining even complex queries.</li>
<li>SQL Generator module. It generates the database queries in a more conversational style.</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#javascript-function" rel="nofollow ugc">“Javascript Function”</a> data source to populate the form’s fields with the information returned from a Javascript function.</li>
<li>Allows using the fields’ values for filtering the recordset records.</li>
<li><a href="https://cf7-datasource.dwbooster.com/complementary-controls-addon" rel="nofollow ugc">Complementary Controls add-on</a>. 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.</li>
</ul>
<h4>Features in Premium version:</h4>
<ul>
<li>All features of the free version of the plugin.</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#acf" rel="nofollow ugc">“Advanced Custom Fields (ACF) – Secured Custom Fields”</a> 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.</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#csv" rel="nofollow ugc">“CSV”</a> data source to populate the form’s fields with the data store into a CSV file.</li>
<li>Includes the <a href="https://cf7-datasource.dwbooster.com/documentation#json" rel="nofollow ugc">“JSON”</a> 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.</li>
<li><a href="https://cf7-datasource.dwbooster.com/pdf-generator-addon" rel="nofollow ugc">PDF Generator add-on</a>. 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).</li>
<li><a href="https://cf7-datasource.dwbooster.com/post-generator-addon" rel="nofollow ugc">Post Generator add-on</a>. It generates new posts (posts, pages, or any custom post) with the information collected by the form.</li>
<li><a href="https://cf7-datasource.dwbooster.com/user-registration-addon" rel="nofollow ugc">User Registration add-on</a> to convert contact forms into user registration forms.</li>
<li><a href="https://cf7-datasource.dwbooster.com/csv-generator-addon" rel="nofollow ugc">CSV Generator add-on</a> to populate a CSV file with the information collected by the form.</li>
<li><a href="https://cf7-datasource.dwbooster.com/json-generator-addon" rel="nofollow ugc">JSON Generator add-on</a> to populate a JSON file with the information collected by the form.</li>
<li><a href="https://cf7-datasource.dwbooster.com/server-side-addon" rel="nofollow ugc">Server Side add-on</a> to implement server side functions to call from the Recordset controls and get the list of records.</li>
</ul>
<h4>Data Source Fields</h4>
<p>Data Source for Contact Form 7 includes two new controls in the controls bar of Contact Form 7, <a href="https://cf7-datasource.dwbooster.com/documentation#recordset-control" rel="nofollow ugc"><strong>recordset</strong></a> and <a href="https://cf7-datasource.dwbooster.com/documentation#link-control" rel="nofollow ugc"><strong>recordset field link</strong></a>.</p>
<p>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.</p>
<p>To insert a recordset field in the form, press the <strong>“recordset”</strong> button in the controls bar. This action opens a dialog to define the recordset.</p>
<p>The insertion dialog includes common attributes for all data sources and specific attributes for the data source selected.</p>
<p>The <strong>“recordset field link”</strong> control links a recordset field to other fields in the form to populate them with the recordset data.</p>
<p>To insert a link field in the form, press the <strong>“recordset field link”</strong> button in the controls bar. This action opens a dialog to define the relationship between a recordset and a form’s field.</p>
<p>The link dialog includes the attributes to define the relationship between the recordset field and the form’s fields.</p>
<h4>Cases of Use</h4>
<p>Get the information of the registered user and populate the form fields for his name and email:</p>
<pre><code><label> Your name [text* your-name] </label>

<label> Your email [email* your-email] </label>

<label> Subject [text* your-subject] </label>

<label> Your message (optional) [textarea your-message] </label>

[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"]
</code></pre>
<p>Filling a plain text in the form with the first name and last name of the logged user:</p>
<pre><code><label> Hello <span id="first-name"></span> <span id="last-name"></span></label>

<label> Enter your address [textarea address] </label>

[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"]
</code></pre>
<p>Populates the list of WooCommerce products and get the price of the selected one:</p>
<pre><code><label>Products List [select menu-719]</label>

<label>Product Price [number number-534]</label>

[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"]
</code></pre>
<p>Using templates to create complex data structures. Displaying the title and excerpt of every published post:</p>
<pre><code><div id="posts-list"></div>
<template id="summary">
<p style="font-style:bold">{attribute.post_title}</p>
<p>{attribute.post_excerpt}</p>
</template>

[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}"]
</code></pre>
<p>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}</p>
<p>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}</p>
<pre><code>[cf7-link-field recordset="cf7-posts" field="posts-list" value="{template.summary}"]
</code></pre>
<h4>Using Javascript to Access the Recordset Data</h4>
<p>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.</p>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/YIpXLR-A014?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<h4>Add ons (Extensions)</h4>
<p><a href="https://cf7-datasource.dwbooster.com/complementary-controls-addon" rel="nofollow ugc">Complementary Controls add-on</a></p>
<p><a href="https://cf7-datasource.dwbooster.com/pdf-generator-addon" rel="nofollow ugc">PDF Generator add-on</a></p>
<p><a href="https://cf7-datasource.dwbooster.com/post-generator-addon" rel="nofollow ugc">Post Generator add-on</a></p>
<p><a href="https://cf7-datasource.dwbooster.com/user-registration-addon" rel="nofollow ugc">User Registration add-on</a></p>
<p><a href="https://cf7-datasource.dwbooster.com/csv-generator-addon" rel="nofollow ugc">CSV Generator add-on</a></p>
<p><a href="https://cf7-datasource.dwbooster.com/json-generator-addon" rel="nofollow ugc">JSON Generator add-on</a></p>
<p><a href="https://cf7-datasource.dwbooster.com/server-side-addon" rel="nofollow ugc">Server Side add-on</a></p>


Data Source for Contact Form 7

Allows you to use server side data with the CF7 form, like the users information, posts data, taxonomies, and many other data sources.

Versatile plugin

The Data Source for Contact Form 7 plugin populates fields with data from external sources like databases, CSVs, URL parameters, ACF, and others.

DBMaker vs Data Source for Contact Form 7