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.

Will Jackson

<p>Audit Export is a comprehensive WordPress plugin designed to help site administrators and developers analyze and report on the entity structure and overall usage of their WordPress site. The plugin provides detailed audits of various WordPress components and allows you to export this data in multiple formats.</p>
<h4>Key Features</h4>
<ul>
<li><strong>Comprehensive Site Auditing</strong>: Analyze plugins, themes, content types, taxonomies, menus, widgets, users & roles, and generate overall site reports</li>
<li><strong>Multiple Export Options</strong>: Export audit reports as CSV files or store them in the database</li>
<li><strong>Remote Posting</strong>: Send audit data to remote endpoints with authentication support</li>
<li><strong>WP-CLI Integration</strong>: Full command-line interface for all plugin operations</li>
<li><strong>Automated Processing</strong>: Schedule audits to run automatically via WordPress cron</li>
<li><strong>Extensible Architecture</strong>: Hook-based system for adding custom audits and modifying behavior</li>
</ul>
<h4>Available Audits</h4>
<ul>
<li><strong>Plugins Audit</strong>: Lists all installed plugins with status, version, and metadata</li>
<li><strong>Themes Audit</strong>: Reports on installed themes and their configurations</li>
<li><strong>Content Types Audit</strong>: Analyzes custom post types and their usage</li>
<li><strong>Taxonomies Audit</strong>: Reviews all taxonomies including custom ones</li>
<li><strong>Menus Audit</strong>: Examines navigation menu structures</li>
<li><strong>Widgets Audit</strong>: Audits widget areas and active widgets</li>
<li><strong>Users & Roles Audit</strong>: Reports on user accounts and role assignments</li>
<li><strong>Site Report</strong>: Comprehensive overview of the WordPress installation</li>
</ul>
<h4>Export Capabilities</h4>
<ul>
<li>Save reports to the WordPress database</li>
<li>Export as CSV files to the filesystem</li>
<li>Send data to remote endpoints via HTTP POST</li>
<li>Support for JSON and CSV formats</li>
</ul>
<h4>Use Cases</h4>
<ul>
<li><strong>Site Documentation</strong>: Generate comprehensive documentation of your WordPress site structure</li>
<li><strong>Migration Planning</strong>: Analyze site components before migrations</li>
<li><strong>Development Workflows</strong>: Track changes in site structure over time</li>
<li><strong>Client Reporting</strong>: Provide detailed site analysis reports to clients</li>
<li><strong>Multi-site Management</strong>: Centralize reporting from multiple WordPress installations</li>
</ul>
<h3>WP-CLI Integration</h3>
<p>The plugin provides comprehensive WP-CLI commands for all operations:</p>
<h4>List Available Audits</h4>
<pre><code>wp audit-export list
</code></pre>
<p>Shows all available audit reports with their ID, group, description, type, and last processed date.</p>
<h4>Run Audits</h4>
<pre><code>wp audit-export run [<audit_id>] [--all] [--format=<format>]
</code></pre>
<p>Examples:<br />
* <code>wp audit-export run</code> – Interactive audit selection<br />
* <code>wp audit-export run --all</code> – Process all audits<br />
* <code>wp audit-export run site_report</code> – Run specific audit<br />
* <code>wp audit-export run content_types --format=csv</code> – Run audit with specific output format</p>
<h4>Export Audits</h4>
<pre><code>wp audit-export export <audit_id> [--file=<file>] [--format=<format>]
</code></pre>
<p>Examples:<br />
* <code>wp audit-export export site_report</code> – Export to stdout<br />
* <code>wp audit-export export content_types --file=content_types.csv</code> – Export to file<br />
* <code>wp audit-export export plugins --format=json --file=plugins.json</code> – Export as JSON</p>
<h4>Manage Cron</h4>
<pre><code>wp audit-export cron <action>
</code></pre>
<p>Actions:<br />
* <code>status</code> – Show cron status and next run time<br />
* <code>enable</code> – Enable cron processing<br />
* <code>disable</code> – Disable cron processing<br />
* <code>run</code> – Manually trigger cron execution<br />
* <code>schedule</code> – Schedule cron events</p>
<h4>Test Remote Connection</h4>
<pre><code>wp audit-export test-connection
</code></pre>
<p>Tests the configured remote endpoint connection.</p>
<h4>Force Remote Post</h4>
<pre><code>wp audit-export force-post <audit_id>
</code></pre>
<p>Manually post a specific audit to the remote endpoint.</p>
<h4>Plugin Information</h4>
<pre><code>wp audit-export info
</code></pre>
<p>Displays plugin version, statistics, and configuration status.</p>
<h3>Configuration</h3>
<h4>File Export Settings</h4>
<ul>
<li><strong>Save to Filesystem</strong>: Enable/disable saving exports to files</li>
<li><strong>Filesystem Type</strong>: Choose between uploads directory or content directory</li>
<li><strong>Export Path</strong>: Subdirectory path for saving export files</li>
</ul>
<h4>Cron Settings</h4>
<ul>
<li><strong>Enable Cron</strong>: Turn on automated audit processing</li>
<li><strong>Run on Every Cron</strong>: Process audits on each WordPress cron execution</li>
<li><strong>Cron Frequency</strong>: Set interval in minutes (if not running on every cron)</li>
<li><strong>Queue Timeout</strong>: Maximum processing time per audit in seconds</li>
</ul>
<h4>Remote Post Settings</h4>
<p>Basic Settings:<br />
* <strong>Enable Remote Post</strong>: Turn on posting to remote endpoints<br />
* <strong>Remote URL</strong>: Endpoint URL for receiving audit data<br />
* <strong>Site Name</strong>: Identifier for this WordPress site</p>
<p>Authentication:<br />
* <strong>Authentication Type</strong>: None, Basic, or Bearer Token<br />
* <strong>Username/Password</strong>: For Basic Authentication<br />
* <strong>Bearer Token</strong>: For token-based authentication</p>
<p>Advanced:<br />
* <strong>Timeout</strong>: Request timeout in seconds (30-900)<br />
* <strong>Verify SSL</strong>: SSL certificate verification<br />
* <strong>Debug Mode</strong>: Enable detailed logging</p>
<h3>Hooks and Filters</h3>
<h4>Actions</h4>
<ul>
<li><code>audit_export_complete</code> – Fired after an audit completes processing</li>
<li><code>audit_export_before_process</code> – Fired before processing an audit</li>
<li><code>audit_export_after_process</code> – Fired after processing an audit</li>
</ul>
<h4>Filters</h4>
<ul>
<li><code>audit_export_post_url</code> – Modify the remote post URL</li>
<li><code>audit_export_post_data</code> – Modify data before remote posting</li>
<li><code>audit_export_post_site_info</code> – Customize site information in remote posts</li>
<li><code>audit_export_post_request_args</code> – Modify HTTP request arguments</li>
<li><code>audit_export_{audit_id}_headers</code> – Customize CSV headers for specific audits</li>
<li><code>audit_export_{audit_id}_data</code> – Modify audit data before saving</li>
</ul>
<h3>Developer Documentation</h3>
<h4>Creating Custom Audits</h4>
<p>To create a custom audit:</p>
<ol>
<li>Extend the <code>Audit_Export_Audit</code> abstract class</li>
<li>Implement required methods: <code>prepare_data()</code> and <code>process_data()</code></li>
<li>Set audit properties: <code>$label</code>, <code>$description</code>, <code>$group</code>, <code>$data_type</code></li>
<li>Register with the audit manager using the <code>audit_export_register_audits</code> action</li>
</ol>
<p>Example:</p>
<pre><code>class My_Custom_Audit extends Audit_Export_Audit {
    protected $label = 'My Custom Audit';
    protected $description = 'Audits custom functionality';
    protected $group = 'custom';

    public function prepare_data() {
        // Return array of items to process
    }

    public function process_data( $item ) {
        // Process individual item and return data row
    }
}
</code></pre>
<h4>Database Structure</h4>
<p>The plugin creates a table <code>{prefix}_audit_export_reports</code> with columns:<br />
* <code>id</code> – Primary key<br />
* <code>audit_name</code> – Audit identifier<br />
* <code>audit_data</code> – JSON-encoded audit results<br />
* <code>created_at</code> – Timestamp<br />
* <code>created_by</code> – User ID</p>
<h3>Support</h3>
<p>For bug reports and feature requests, please use the <a href="https://wordpress.org/support/plugin/audit-export/" rel="ugc">plugin support forum</a>.</p>
<h3>Privacy Policy</h3>
<p>This plugin stores audit data in your WordPress database and optionally saves CSV files to your server. When remote posting is enabled, audit data is sent to configured external endpoints. No data is sent to third parties without explicit configuration.</p>


Audit Export

Audits and exports WordPress site structure: plugins, themes, content types, users, menus, widgets, and taxonomies with remote posting.

Advanced CSV Importer vs Audit Export