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.

Malcolm Peralty

<p>Governance Guardrails is a file-based WordPress governance plugin for site owners, agencies, and managed WordPress teams that want important operational rules to live in code instead of scattered database settings.</p>
<p>You define a policy in a PHP configuration file. Governance Guardrails reads that file on each request and applies the configured rules. This makes the policy easy to review, version-control, and deploy consistently across environments or multiple sites.</p>
<p>Governance Guardrails can help you manage:</p>
<ul>
<li>Feature toggles such as XML-RPC, comments, feeds, the Customizer, widgets, application passwords, user registration, WP-Cron, and related admin features.</li>
<li>Admin UI cleanup, including admin bar nodes, dashboard widgets, menu pages, and admin footer text.</li>
<li>Runtime capability denials by role without changing stored role definitions in the database.</li>
<li>Upload governance, including allowed MIME types and per-file size limits.</li>
<li>Content behavior such as revisions, autosave intervals, oEmbed, and emoji loading.</li>
<li>Login behavior such as password reset restrictions, generic login errors, and post-logout redirects.</li>
<li>HTTP security headers and other hardening options such as pingback removal, author archive handling, file editing restrictions, and staging noindex headers.</li>
<li>Head cleanup for RSD, WLW manifest, shortlinks, feed links, and REST API discovery links.</li>
<li>Locked options so selected <code>wp_options</code> values are pinned from code.</li>
<li>Custom governance callbacks for site-specific rules.</li>
</ul>
<p>This plugin does not claim to secure a site by itself. It is intended as a governance and consistency tool that helps keep selected WordPress settings and behaviors aligned with your site’s operational policy.</p>
<h4>Must-use plugin support</h4>
<p>Governance Guardrails was originally built for must-use plugin deployment. It can still be installed that way by copying <code>governance-guardrails.php</code> and the <code>governance-guardrails/</code> directory into <code>wp-content/mu-plugins/</code>.</p>
<p>For WordPress.org installation, it can also be installed and activated as a normal plugin. In that case, the included sample config is used from the plugin directory unless you define a custom config path.</p>
<p>To use a custom config file, add this to <code>wp-config.php</code>:</p>
<pre><code>define( 'GOVGUARD_CONFIG', '/absolute/path/to/governance-guardrails-config.php' );
</code></pre>
<p>The shipped sample config lives at <code>governance-guardrails/governance-guardrails-config.php</code>.</p>
<p>Config loading is fail-open. If the config file is missing, unreadable, has a syntax error, or does not return an array, Governance Guardrails does not enforce governance rules and logs a warning instead of crashing the site.</p>
<h4>WP-CLI</h4>
<p>When WP-CLI is available, Governance Guardrails registers the <code>wp governance</code> command set.</p>
<p>Examples:</p>
<ul>
<li><code>wp governance status</code></li>
<li><code>wp governance check</code></li>
<li><code>wp governance audit</code></li>
<li><code>wp governance audit --severity=high</code></li>
<li><code>wp governance diff</code></li>
<li><code>wp governance get features --format=json</code></li>
<li><code>wp governance mimes</code></li>
</ul>


Governance Guardrails

Governance Guardrails provides file-based rules for managing admin behavior, capabilities, uploads, and operational hardening from code.

Advanced CSV Importer vs Governance Guardrails