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.

DBMaker vs Import and export users and customers