Toro_Unit (Hiroshi Urabe)

hamworks

<p>Simple CSV Exporter. Exported CSV can be imported with <a href="https://ja.wordpress.org/plugins/really-simple-csv-importer/" rel="nofollow ugc">Really Simple CSV Importer</a>.</p>
<p>When you select a post type, the posts will be exported.</p>
<p>Github Repo: <a href="https://github.com/hamworks/simple-csv-exporter" rel="nofollow ugc">https://github.com/hamworks/simple-csv-exporter</a></p>
<h4>Customize the data to be exported</h4>
<p>Customize for column.</p>
<pre>use HAMWORKS\WP\Simple_CSV_Exporter\Data_Builder;
add_action( 'simple_csv_exporter_created_data_builder', 
    function ( Data_Builder $data ) {
        // Remove column.
        $data->append_drop_column( 'page_template' );
        // Add custom field column.
        $data->append_meta_key( 'my_meta_key' );
    }
);</pre>
<p>Customize posts for export.</p>
<pre>add_action( 'simple_csv_exporter_data_builder_for_wp_posts_pre_get_posts', 
    function ( WP_Query $query ) {
        $query->set( 'order', 'ASC' );
    }
);</pre>
<p>Data filter for metadata.</p>
<pre>add_filter( 'simple_csv_exporter_data_builder_for_wp_posts_get_post_meta_fields',
    function ( array $fields ) {
        foreach (
            array(
                'your_flag',
            ) as $key
        ) {
            if ( isset( $fields[ $key ] ) ) {
                $fields[ $key ] = ! empty( $fields[ $key ] ) ? 'TRUE' : 'FALSE';
            }
        }
        return $fields;
    }
);</pre>
<p>Data filter for post.</p>
<pre>add_filter(
    'simple_csv_exporter_data_builder_for_wp_posts_row_data',
    function ( $row_data, $post ) {
        $row_data['permalink'] = get_permalink( $post );
        unset( $row_data['comment_status'] );
        return $row_data;
    },
    10,
    2
);</pre>


Simple CSV Exporter

Simplicity is the key to a powerful tool.  This is the sister plugin of Really Simple CSV Importer, and both do a remarkable job of manipulating post data in and out of the DB. 

The one thing missing is the ability  to export other types of data, users, taxonomies, attachment meta-data...it would be a real complete swiss-army knife with the ability to also export these other data types.  This way you can batch fix missing pieces of meta-data in your DB by simply sorting through it in a google sheet

Does exactly what it says in the title!

Masahiro NAKASHIMA

<p>You can export posts in CSV format for each post type.<br />
It is compatible with posts’ custom fields and custom taxonomies.<br />
It is also possible to set the number or date range of posts to download.</p>
<h3>How to customize export post data</h3>
<p>This plugin has below filters.</p>
<ul>
<li>wp_csv_exporter_post_name</li>
<li>wp_csv_exporter_post_title</li>
<li>wp_csv_exporter_post_content</li>
<li>wp_csv_exporter_post_excerpt</li>
<li>wp_csv_exporter_post_status</li>
<li>wp_csv_exporter_post_author</li>
<li>wp_csv_exporter_post_date</li>
<li>wp_csv_exporter_post_modified</li>
<li>wp_csv_exporter_thumbnail_url</li>
<li>wp_csv_exporter_post_tags</li>
<li>wp_csv_exporter_post_category</li>
<li>wp_csv_exporter_tax_{taxonomy}</li>
<li>wp_csv_exporter_{custom_field_key}</li>
</ul>
<h4>wp_csv_exporter_post_name</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_name</code> – (required) post slug</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<p>Example:</p>
<pre><code>add_filter( 'wp_csv_exporter_post_name', 'wp_csv_exporter_post_name_filter', 10, 3 );
function wp_csv_exporter_post_name_filter( $post_name, $post_id  ) {
    return $post_name;
}
</code></pre>
<h4>wp_csv_exporter_post_title</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_title</code> – (required) post title</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<p>Example:</p>
<pre><code>add_filter( 'wp_csv_exporter_post_title', 'wp_csv_exporter_post_title_filter', 10, 3 );
function wp_csv_exporter_post_title_filter( $post_title, $post_id  ) {
    $post_title = $post_id . ':' . $post_title;
    return $post_title;
}
</code></pre>
<h4>wp_csv_exporter_post_content</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_content</code> – (required) post content</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<h4>wp_csv_exporter_post_excerpt</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_excerpt</code> – (required) post excerpt</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<h4>wp_csv_exporter_post_status</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_status</code> – (required) post status</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<h4>wp_csv_exporter_post_author</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_author</code> – (required) post author</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<h4>wp_csv_exporter_post_date</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_date</code> – (required) post date</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<h4>wp_csv_exporter_post_modified</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_modified</code> – (required) post modified date</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<h4>wp_csv_exporter_post_thumbnail_url</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_thumbnail_url</code> – (required) post thumbnail_url</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<h4>wp_csv_exporter_post_tags</h4>
<p>Parameters:</p>
<ul>
<li><code>$post_tags</code> – (array)(required) post tags</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<p>Example:</p>
<pre><code>add_filter( 'wp_csv_exporter_post_tags', 'wp_csv_exporter_post_tags_filter', 10, 3 );
function wp_csv_exporter_post_tags_filter( $post_tags, $post_id  ) {
    $_post_tags = array();
    foreach ( $post_tags as $key => $tag ) {
        $_post_tags[] = 'Tag:'.$tag;
    }
    return $_post_tags;
}
</code></pre>
<h4>wp_csv_exporter_category</h4>
<p>Parameters:</p>
<ul>
<li><code>$category</code> – (array)(required) post category</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<p>Example:</p>
<pre><code>add_filter( 'wp_csv_exporter_category', 'wp_csv_exporter_category_filter', 10, 3 );
function wp_csv_exporter_post_category_filter( $category, $post_id  ) {
    $_category = array();
    foreach ( $category as $key => $value ) {
        $_category[] = 'Category:'.$value;
    }
    return $_category;
}
</code></pre>
<h4>wp_csv_exporter_tax_{taxonomy}</h4>
<p>Parameters:</p>
<ul>
<li><code>$term_values</code> – (array)(required) post taxonomy</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<p>Example: taxonomy = “dogs”</p>
<pre><code>add_filter( 'wp_csv_exporter_tax_dogs', 'wp_csv_exporter_tax_dogs_filter', 10, 3 );
function wp_csv_exporter_tax_dogs_filter( $term_values, $post_id ) {
    $_term_values = array();
    foreach ( $term_values as $key => $term_value ) {
        $_term_values[] = 'Dog:'.$term_value;
    }
    return $_term_values;
}
</code></pre>
<h4>wp_csv_exporter_{custom_field_key}</h4>
<p>Parameters:</p>
<ul>
<li><code>$field</code> – (required) post custom field</li>
<li><code>$post_id</code> – (int) post id</li>
</ul>
<p>Example: custom field key = “price”</p>
<pre><code>add_filter( 'wp_csv_exporter_price', 'wp_csv_exporter_price_filter', 10, 3 );
function wp_csv_exporter_price_filter( $field, $post_id ) {
    return 'Price:'.$field;
}
</code></pre>


WP CSV Exporter

You can export posts in CSV format for each post type. It is compatible with posts' custom fields and custom taxonomies.

Simple CSV Exporter vs WP CSV Exporter