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.

Hussam Hussien

<p>This is plugin will make normal wordpress users able to import excel sheets to database table.</p>
<h3>Donations</h3>


WP Excel 2 DB

Don’t worry the plugin is safe.It doesn’t access your WordPress tables in your database.

Secure, Smart and Interactive

Import excel sheet to wordpress database table form wordpress dashboard.

DBMaker vs WP Excel 2 DB