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.

giuliopanda

<p>If you’re a website developer and you need to extend the functionality of WordPress by creating new data structures, this plugin is for you.</p>
<p>Admin Form allows you to create data collections by connecting directly to your WordPress database. With this plugin, you can easily create new data structures or manage and filter existing tables in the database. For instance, you can streamline the process of developing new plugins by automating the entire data entry administration section.</p>
<p>Using shortcodes, you can quickly display HTML tables on your site with search results, column sorting, and page breakdowns. Alternatively, you can design your own HTML and use special shortcodes to input data. Admin Form also includes a complete template engine.</p>
<p>Our comprehensive documentation provides clear and concise instructions on how to use the plugin to its fullest extent. Additionally, the plugin offers flexible customization options, so you can tailor it to your specific needs. Whether you need to manage existing data or create entirely new structures, our plugin can help you accomplish your goals quickly and efficiently.</p>
<h3>Key Features</h3>
<p>With Admin Form, you can:</p>
<ul>
<li>Create data tables for backend use, including forms with more than 20 data types and an advanced Excel-style search system</li>
<li>Choose the fields to display and how to display them</li>
<li>Delete selected data or choose to delete all filtered data (PRO version only)</li>
<li>Download selected data or all filtered data (PRO version only)</li>
<li>Choose the roles of who can edit the table</li>
<li>Use LOOKUP field to show data from other tables (PRO version only)</li>
<li>Create and edit complex data structures from MySQL queries (PRO version only)</li>
<li>Publish data in tables with customizable colors, pagination, and search/sort fields</li>
<li>Show details of single records in popups</li>
<li>Customize data display using a powerful template engine with attributes, operators, and shortcodes</li>
<li>Work with PHP hooks and filters, and use a class with functions to manage data from the code</li>
<li>Create custom post types, generating new lists of data and detail pages</li>
<li>Add custom fields to post, user, and comment tables, as well as other tables that have a linked “meta” table</li>
<li>Enjoy advanced management in table creation with the PRO version<br />
I- mport and export data in MySQL or CSV format with the PRO version</li>
<li>Download the free PRO version at https://github.com/giuliopanda/admin-form-pro/releases/ to access even more features, such as calculated fields and the ability to create query forms.</li>
<li>Choose the color, the type of pagination, whether to show the search or the ability to sort the fields.</li>
<li>Show the detail of single records in popup.</li>
<li>Customize the view through a custom template engine.</li>
</ul>
<p>We hope you find Admin Form to be a useful tool for your WordPress development needs!</p>
<h3>TEMPLATE ENGINE</h3>
<p>You have at your disposal a powerful template engine similar to wordpress shortcodes.<br />
You can customize the data display through attributes. For example to make text uppercase:</p>
<pre><code>[%item.Title uppercase]
</code></pre>
<p>You can control data flows through the most used operators (if, for, break, while, math…)<br />
For example, to check if a user is logged in you can write:</p>
<pre><code>[^IF [^user]==""] you are not logged in
[^else]  You are logged in [^endif]
</code></pre>
<p>Or pull the data directly into a post via the [adfo_tmpl] shortcode</p>
<pre><code>[adfo_tmpl]
<ul>
    [^FOR EACH=[^POST TYPE=post]]
        <li>[%item.title_link]</li>
    [^ENDFOR]
</ul>
[/adfo_tmpl]
</code></pre>
<h3>PHP</h3>
<p>Obviously you have a set of hooks and filters available for working in php, but you also have a class available with a set of functions to manage data from the code. You will find all the documentation inside the plugin.</p>
<h3>POST TYPE SUPPORT</h3>
<p>Custom post types can be created. These are handled with the plugin’s display and insertion system, thus focusing on data entry rather than content formatting. Using post_types, it is possible to generate not only new lists of data, but also the detail of individual content opened on new pages.</p>
<h3>METADATA SUPPORT</h3>
<p>For post, user, comment tables and all tables that have a linked “meta” table, Admin Form allows you to add custom fields to the table you are editing.</p>
<h3>MULTI ROW FOR POST, USER, MEDIA AND LOOKUP SUPPORT</h3>
<p>You can create fields that can save multiple data such as user lists, media or posts.</p>
<h3>PRO VERSION</h3>
<p>There is also a PRO version that you can download for free!</p>
<p>The pro version adds:<br />
– <a href="https://github.com/giuliopanda/admin-form-pro/wiki/Calculated-fields" rel="nofollow ugc">The calculated fields</a>.<br />
– <a href="https://github.com/giuliopanda/admin-form-pro/wiki/LOOKUP" rel="nofollow ugc">The lookups fields</a>.<br />
– A system for managing tables through mysql queries<br />
– The ability to create query forms (LAB).<br />
– Advanced management in the creation of tables<br />
– <a href="https://github.com/giuliopanda/admin-form-pro/wiki/Import-Export" rel="nofollow ugc">Import and export of data in mysql / csv</a>.</p>
<p>With the pro version you can directly manage the WordPress database by creating queries like on phpmyadmin or adminer.<br />
Some differences are:<br />
– Greater integration with WordPress allows you to avoid accidental changes to WordPress core tables.<br />
– The replace system supports serialized fields<br />
– You can edit the query with the help of a series of dedicated tools<br />
– For each column you have a menu of options inspired by the Excel system<br />
– The ability to edit multiple tables at the same time. in fact, it is possible to edit the fields extracted from the query independently of the tables to which it refers.<br />
For example:</p>
<pre><code>SELECT post.post_title, m01.meta_value AS test, m02.meta_value AS test2 FROM wp_posts` post LEFT JOIN wp_postmeta m01 ON post.ID = m01.post_id AND m01.meta_key = 'test' LEFT JOIN wp_postmeta m02 ON post.ID = m02.post_id AND m02.meta_key = 'test2'
</code></pre>
<p>`</p>
<p>Allows you to edit both the test field and the test2 field</p>
<p>the link to the project:  <a href="https://github.com/giuliopanda/admin-form-pro/releases/" rel="nofollow ugc">https://github.com/giuliopanda/admin-form-pro/releases/</a></p>


ADFO – Custom data in admin dashboard


This plugin is just amazing. 



It helped me dealing with custom admin forms for the backend and saved me a lot of time.



There are tones of tools it offers, and all for free!


Such a great plugin!

Allow your customers to manage new data sets for your site.

DBMaker vs ADFO – Custom data in admin dashboard