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.

Soflyy

WP All Import

<h4>WP All Import – Simple & Powerful XML, CSV, Google Sheets, and Excel Importer Plugin</h4>
<p><em>“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!”</em><br />
<strong>Alex Vasquez</strong> – DigiSavvy Co-Founder & WordCamp Los Angeles Organizer</p>
<p>WP All Import has a four-step import process and an intuitive drag-and-drop interface that makes complicated import tasks simple and fast.</p>
<p>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.</p>
<p>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.</p>
<p>Check out our <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs" rel="nofollow ugc">documentation and video tutorials</a> to make the most of WP All Import.</p>
<p>WP All Import integrates with our companion plugin, <a href="https://wordpress.org/plugins/wp-all-export/" rel="ugc">WP All Export</a>. 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.</p>
<p>For technical support from the developers, please consider purchasing WP All Import Pro.</p>
<h4>WP All Import Pro Version</h4>
<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/pD6WQANJcJY?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><em>WP All Import Pro</em> is a paid upgrade that includes premium support and adds the following features:</p>
<ul>
<li>
<p>Import data to Custom Fields – used by many themes, especially those using Custom Post Types – to store data associated with the posts.</p>
</li>
<li>
<p>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.</p>
</li>
<li>
<p>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.</p>
</li>
<li>
<p>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.</p>
</li>
<li>
<p>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.</p>
</li>
<li>
<p>Guaranteed technical support via e-mail.</p>
</li>
</ul>
<p><a href="http://www.wpallimport.com/wordpress-xml-csv-import/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=upgrade-to-pro" rel="nofollow ugc">Upgrade to the Pro edition of WP All Import.</a></p>
<p>Need to <a href="http://www.wpallimport.com/woocommerce-product-import/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=upgrade-to-pro" rel="nofollow ugc">import XML and CSV to WooCommerce?</a> Check out our WooCommerce add-on.</p>
<h4>WordPress CSV Imports</h4>
<p>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.</p>
<p>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.</p>
<p>When importing CSV files, your CSV should have UTF-8 encoding if you are having trouble importing special characters.</p>
<p>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.</p>
<p>For CSV import tutorials and example files, visit our <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs" rel="nofollow ugc">documentation</a>. 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.</p>
<h4>WordPress Excel Import / Google Sheets Import</h4>
<p>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.</p>
<p>For Google Sheets, use the ‘Download a file’ option and paste your sheet’s public URL to import data to WordPress.</p>
<h4>Add-Ons</h4>
<p>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.</p>
<ul>
<li>Advanced Custom Fields Add-On – <a href="http://www.advancedcustomfields.com/" rel="nofollow ugc">ACF</a> XML & CSV importer</li>
<li>WooCommerce Add-On – XML & CSV importer for all <a href="https://wordpress.org/plugins/woocommerce" rel="ugc">WooCommerce</a> product types</li>
<li>User Import Add-On – XML & CSV importer for users, including user_meta</li>
<li>Link Cloak Add-On – Auto-create redirects for links present during an XML or CSV import</li>
</ul>
<p>Learn more about our add-ons at <a href="http://www.wpallimport.com/add-ons/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=add-ons" rel="nofollow ugc">http://www.wpallimport.com/add-ons</a></p>
<p>A <a href="http://www.wpallimport.com/documentation/developers/action-reference/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs" rel="nofollow ugc">developer API</a> (action hooks) is also available.</p>
<h4>Related Plugins</h4>
<p><a href="https://wordpress.org/plugins/wp-all-export/" rel="ugc">Export any WordPress data to XML/CSV</a><br />
<a href="https://wordpress.org/plugins/woocommerce-xml-csv-product-import/" rel="ugc">Import Products from any XML or CSV to WooCommerce</a><br />
<a href="https://wordpress.org/plugins/product-export-for-woocommerce/" rel="ugc">Export Products to CSV/XML for WooCommerce</a><br />
<a href="https://wordpress.org/plugins/custom-product-tabs-wp-all-import-add-on/" rel="ugc">Custom Product Tabs for WooCommerce WP All Import Add-on</a><br />
<a href="https://wordpress.org/plugins/order-export-for-woocommerce/" rel="ugc">Export Orders to CSV/XML for WooCommerce</a><br />
<a href="https://wordpress.org/plugins/export-wp-users-xml-csv/" rel="ugc">Export WordPress Users to CSV/XML</a></p>
<h3>Premium Support</h3>
<p>You can submit the <a href="https://www.wpallimport.com/support/" rel="nofollow ugc">support form on our website</a> or email us at <a href="mailto:support@wpallimport.com" rel="nofollow ugc">support@wpallimport.com</a>. 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 <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=5839966&edd_options%5Bprice_id%5D=1&discount=welcome-upgrade-99&utm_source=import-plugin-free&utm_medium=readme&utm_campaign=premium-support" rel="nofollow ugc">WP All Import Pro</a>.</p>
<h3>Import To WooCommerce</h3>
<p>Need to <a href="https://wordpress.org/plugins/woocommerce-xml-csv-product-import/" rel="ugc">import Excel, XML and CSV to WooCommerce?</a> Check out our WooCommerce add-on.</p>
<p><a href="http://www.wpallimport.com/woocommerce-product-import/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=import-wooco-products" rel="nofollow ugc">WooCommerce Excel, XML & CSV Import Pro Version</a></p>


WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets

The plugin is very powerful, almost everything is possible if you are a developer.

The support team is also a great resource if you get stuck.

Powerfull plugin


Been using it for years, and without a doubt, it is unparalleled in its category.


The BEST!!


I am really happy with this plugin, with a little knowledge of PHP and little help from support, you can achieve whatever you want to. Thank you


Awesome plugin


Importing data is always challenging but this plugin makes life WAY easier, especially when it comes to dealing with commerce data imports.  The ability to use my own PHP functions to format or adjust data at runtime is a life saver. 



I'll be honest: Even when using this plugin, it sometimes takes me several tries to get things just right but 95% of the time, the problem is my data, not the plugin.  I have had to reach out to support a few times and they are responsive.  


THE Import Plugin

Easily import any file of any size into any plugin, post type, custom field, or taxonomy. Supports WooCommerce, ACF, images, galleries, users, real es …

DBMaker vs WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets