Takayuki Miyauchi

DigitalCube Inc.

<p>The Advanced CSV Importer will import the following content from a CSV file.</p>
<p>Advanced CSV Importer is fully unit-tested. The plugin is stable and ready to be used in large projects like enterprise applications.</p>
<ul>
<li>Posts, pages and other custom post types</li>
<li>Custom fields and post meta</li>
<li>Categories, tags</li>
</ul>
<p>https://github.com/miya0001/advanced-csv-importer</p>
<p>This plugin requires PHP 5.3 or later.</p>
<h4>Default CSV field names</h4>
<ul>
<li>ID</li>
<li>post_content</li>
<li>post_name</li>
<li>post_title</li>
<li>post_status</li>
<li>post_type</li>
<li>post_author</li>
<li>ping_status</li>
<li>post_parent</li>
<li>menu_order</li>
<li>to_ping</li>
<li>pinged</li>
<li>post_password</li>
<li>guid</li>
<li>post_content_filtered</li>
<li>post_excerpt</li>
<li>post_date</li>
<li>post_date_gmt</li>
<li>comment_status</li>
<li>post_category</li>
<li>tags_input</li>
<li>page_template</li>
</ul>
<p>You can change field name via <code>acsv_post_object_keys</code> hook like following.</p>
<pre><code>add_filter( 'acsv_post_object_keys', function( $post_object_keys ){
    $post_object_keys['title'] = 'post_title';
    $post_object_keys['content'] = 'post_content';
    return $post_object_keys;
} );
</code></pre>
<p>Other columns will be saved to the custom field.</p>
<p>There is a sample of the CSV.</p>
<p><style>.gist table { margin-bottom: 0; }</style>
<div style="tab-size: 8" id="gist17649185" class="gist">
<div class="gist-file" translate="no" data-color-mode="light" data-light-theme="light">
<div class="gist-data">
<div class="js-gist-file-update-container js-task-list-container">
<div id="file-test-csv" class="file my-2">
<div itemprop="text"
      class="Box-body p-0 blob-wrapper data type-csv  "
      style="overflow: auto" tabindex="0" role="region"
      aria-label="test.csv content, created by miya0001 on 06:51PM on December 27, 2014."
    ></p>
<div class="blob-interaction-bar">
  <svg aria-hidden="true" data-component="Octicon" height="16" viewBox="0 0 16 16" version="1.1" width="16" data-view-component="true" class="octicon octicon-search">
    <path d="M10.68 11.74a6 6 0 0 1-7.922-8.982 6 6 0 0 1 8.982 7.922l3.04 3.04a.749.749 0 0 1-.326 1.275.749.749 0 0 1-.734-.215ZM11.5 7a4.499 4.499 0 1 0-8.997 0A4.499 4.499 0 0 0 11.5 7Z"></path>
</svg><br />
  <input type="text" name="filter" class="form-control js-csv-filter-field blob-filter" autocapitalize="off"
         placeholder="Search this file…" aria-label="Search this file…">
</div>
<div class="markdown-body js-check-hidden-unicode" data-line-alert="before" data-hpc>
    <template class="js-file-alert-template"></p>
<div data-view-component="true" class="flash flash-warn flash-full d-flex flex-items-center">
  <svg aria-hidden="true" data-component="Octicon" height="16" viewBox="0 0 16 16" version="1.1" width="16" data-view-component="true" class="octicon octicon-alert">
    <path d="M6.457 1.047c.659-1.234 2.427-1.234 3.086 0l6.082 11.378A1.75 1.75 0 0 1 14.082 15H1.918a1.75 1.75 0 0 1-1.543-2.575Zm1.763.707a.25.25 0 0 0-.44 0L1.698 13.132a.25.25 0 0 0 .22.368h12.164a.25.25 0 0 0 .22-.368Zm.53 3.996v2.5a.75.75 0 0 1-1.5 0v-2.5a.75.75 0 0 1 1.5 0ZM9 11a1 1 0 1 1-2 0 1 1 0 0 1 2 0Z"></path>
</svg><br />
    <span><br />
      This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.<br />
      <a class="Link--inTextBlock" href="https://github.co/hiddenchars" target="_blank" rel="nofollow ugc">Learn more about bidirectional Unicode characters</a><br />
    </span></p>
<div data-view-component="true" class="flash-action">        <a href="{{ revealButtonHref }}" data-view-component="true" class="btn-sm btn" rel="nofollow ugc">    Show hidden characters<br />
</a>
</div>
</div>
<p></template><br />
<template class="js-line-alert-template"><br />
  <span aria-label="This line has hidden Unicode characters" data-view-component="true" class="line-alert tooltipped tooltipped-e"><br />
    <svg aria-hidden="true" data-component="Octicon" height="16" viewBox="0 0 16 16" version="1.1" width="16" data-view-component="true" class="octicon octicon-alert">
    <path d="M6.457 1.047c.659-1.234 2.427-1.234 3.086 0l6.082 11.378A1.75 1.75 0 0 1 14.082 15H1.918a1.75 1.75 0 0 1-1.543-2.575Zm1.763.707a.25.25 0 0 0-.44 0L1.698 13.132a.25.25 0 0 0 .22.368h12.164a.25.25 0 0 0 .22-.368Zm.53 3.996v2.5a.75.75 0 0 1-1.5 0v-2.5a.75.75 0 0 1 1.5 0ZM9 11a1 1 0 1 1-2 0 1 1 0 0 1 2 0Z"></path>
</svg><br />
</span></template></p>
<table class="js-csv-data csv-data js-file-line-container">
<thead>
<tr id="file-test-csv-LC1" class="js-file-line">
<td id="file-test-csv-L1" class="blob-num js-line-number" data-line-number="1"></td>
<th>ID</th>
<th>post_name</th>
<th>post_author</th>
<th>post_date</th>
<th>post_type</th>
<th>post_status</th>
<th>post_title</th>
<th>post_content</th>
<th>post_category</th>
<th>tags_input</th>
<th>custom_field</th>
</tr>
</thead>
<tbody>
<tr id="file-test-csv-LC2" class="js-file-line">
<td id="file-test-csv-L2" class="blob-num js-line-number" data-line-number="2"></td>
<td></td>
<td>Import-test</td>
<td>admin</td>
<td>2013/9/13 0:00</td>
<td>post</td>
<td>publish</td>
<td>CSV Import Test</td>
<td>This is a post for csv import.<br />
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<br />
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</td>
<td>fruits</td>
<td>apple,banana</td>
<td>this is custom field value.</td>
</tr>
<tr id="file-test-csv-LC3" class="js-file-line">
<td id="file-test-csv-L3" class="blob-num js-line-number" data-line-number="3"></td>
<td></td>
<td></td>
<td>editor</td>
<td></td>
<td>post</td>
<td>publish</td>
<td>define author test</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr id="file-test-csv-LC4" class="js-file-line">
<td id="file-test-csv-L4" class="blob-num js-line-number" data-line-number="4"></td>
<td></td>
<td></td>
<td>2</td>
<td></td>
<td>post</td>
<td></td>
<td>define author id test</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr id="file-test-csv-LC5" class="js-file-line">
<td id="file-test-csv-L5" class="blob-num js-line-number" data-line-number="5"></td>
<td>1</td>
<td>Hello-world-updated</td>
<td></td>
<td></td>
<td>post</td>
<td></td>
<td>Hello world! Updated!</td>
<td>Welcome to WordPress. This is your first post. Updated by RS CSV Importer!</td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table></div>
</p></div>
</p></div>
</div></div>
<div class="gist-meta">
        <a href="https://gist.github.com/miya0001/06f1a8e2bf1789c7ddee/raw/3c95de96302f556e58049e550f9a14b047048dbe/test.csv" style="float:right" class="Link--inTextBlock" rel="nofollow ugc">view raw</a><br />
        <a href="https://gist.github.com/miya0001/06f1a8e2bf1789c7ddee#file-test-csv" class="Link--inTextBlock" rel="nofollow ugc"><br />
          test.csv<br />
        </a><br />
        hosted with ❤ by <a class="Link--inTextBlock" href="https://github.com" rel="nofollow ugc">GitHub</a>
      </div>
</p></div>
</div>
<h4>Action Hooks</h4>
<ul>
<li>acsv_after_insert_post</li>
</ul>
<h4>Filter Hooks</h4>
<ul>
<li>acsv_post_object_keys</li>
<li>acsv_post_defaults</li>
<li>acsv_import_upload_size_limit</li>
<li>acsv_pre_get_post_objects</li>
<li>acsv_after_get_post_objects</li>
<li>acsv_csv_format</li>
<li>acsv_csv_to_hash_array</li>
<li>acsv_get_user_by_field</li>
</ul>
<h4>WP-CLI</h4>
<p>Importing:</p>
<pre><code>$ wp csv import tests/_data/wp/sample.csv
+------+-----------------------+------+---------+------------+---------------------+
| ID   | Title                 | Type | Status  | Author     | Date                |
+------+-----------------------+------+---------+------------+---------------------+
| 1720 | CSV Import Test       | post | publish | admin      | 2013-09-13 00:00:00 |
| 1721 | define author test    | post | publish | admin      | 2014-12-27 18:44:46 |
| 1722 | define author id test | post | publish | themedemos | 2014-12-27 18:44:46 |
| 1    | Hello world! Updated! | post | publish | admin      | 2014-12-27 18:44:46 |
+------+-----------------------+------+---------+------------+---------------------+
</code></pre>
<p>History:</p>
<pre><code>$ wp csv log
+----------+-----------------------------+---------------------+---------+---------+
| ID       | Title                       | Date                | Success | Failure |
+----------+-----------------------------+---------------------+---------+---------+
| e0a66344 | Imported from WP-CLI.       | 2014-12-27 18:44:46 |       4 |       0 |
| 43c47af6 | Imported from admin screen. | 2014-12-27 16:53:17 |       4 |       0 |
| df0f140b | Imported from WP-CLI.       | 2014-12-27 16:21:42 |       4 |       0 |
+----------+-----------------------------+---------------------+---------+---------+
</code></pre>
<p>Details of the history:</p>
<pre><code>$ wp csv log e0a66344
+------+-----------------------+------+---------+------------+---------------------+
| ID   | Title                 | Type | Status  | Author     | Date                |
+------+-----------------------+------+---------+------------+---------------------+
| 1720 | CSV Import Test       | post | publish | admin      | 2013-09-13 00:00:00 |
| 1721 | define author test    | post | publish | admin      | 2014-12-27 18:44:46 |
| 1722 | define author id test | post | publish | themedemos | 2014-12-27 18:44:46 |
| 1    | Hello world! Updated! | post | publish | admin      | 2014-12-27 18:44:46 |
+------+-----------------------+------+---------+------------+---------------------+
</code></pre>


Advanced CSV Importer

Import posts, pages, custom fields, categories, tags and more from a CSV file.

keith_wp

<p>Developing any WP plugin or theme often means needing to test it against as much of a “real site” as your development environment will allow, and if you’re adding that test data by hand, it gets pretty tedious pretty quickly.</p>
<p>This plugin will let you use either <a href="https://wp-cli.org/" rel="nofollow ugc">WP-CLI</a> commands, or the admin page in Tools-><strong>Content Generator</strong> to add test users, populate the Media Library with example images, an additional test custom post type and custom taxonomies, generate as many test “<em>Lorem Ipsum</em>” posts as you want, and then add comments to those posts.</p>
<p>Each of those “<em>Lorem Ipsum</em>” posts will be randomly tagged and categorised, and can also be assigned one of the test images as its Featured Image, as well as a variety of HTML content in addition to the usual paragraphs.</p>
<p>This plugin is primarily for people who need to test plugins and themes on a regular basis, but it would let anyone get a feel of how their site will look when it’s full of real content.</p>
<h3>Workflow</h3>
<p>All the parts of this plugin are optional, and each can be repeated as much as you want, depending on which parts of your site you want to test.</p>
<p>However, no individual step will “backfill” preceeding ones automatically, so if you have an empty site and you want (eg.) your test <em>Posts</em> to appear to have been written by different people, then you need to add the test <em>Users</em> first.</p>
<p>ie.</p>
<ul>
<li>Enable <strong>Custom</strong> (Post Types & Categories & Tags) before adding terms from your <strong>Taxonomies</strong>,</li>
<li>Add <strong>Users</strong> before downloading <strong>Images</strong> before generating <strong>Posts</strong> before adding <strong>Comments</strong>.</li>
</ul>
<h3>WP CLI Integration</h3>
<p>Using the plugin defaults, you can populate a test site with just the following commands:</p>
<ol>
<li><code>wp plugin install test-content-generator --activate</code><br />
Download and activate the plugin.</li>
<li><code>wp test users --amount=20</code><br />
Add 20 random Editor/Author/Contributor/Subscribers users who have registered within the last 60 days.</li>
<li><code>wp test taxonomies --amount=50</code><br />
Add 50 taxonomy terms split between Categories and Post Tags.</li>
<li><code>wp test images --amount=10</code><br />
Add 10 images of size 800×400 uploaded by any Editor/Author.</li>
<li><code>wp test posts --amount=40</code><br />
Add 40 Posts written within the last 60 days by any Editor/Author/Contributor, with a Featured Image and both categorised and tagged.</li>
<li><code>wp test comments --amount=100</code><br />
Add 100 comments to your Posts written within the last 60 days by any of the registered users.</li>
</ol>
<p>See <code>wp help test</code> for more details.</p>


Test Content Generator


Good to see a plugin that actually generates test content with ease.


It works


Thanks for this - I really like how straight-forward it is. I've used most of the UI features and it works very well, with a nice, native interface and no distractions!



I haven't used the WP CLI features as I don't normally use WP CLI.


Great plugin :-)

Quickly generate a test site full of random users, posts, comments, tags and images.

Advanced CSV Importer vs Test Content Generator