Simple CSV/XLS Exporter

Tanya Jawab

How do I choose my post type, taxonomies and custom fields?

Head over to the plugin’s settings page, choose the post type. Then click “Save Changes” at the end of the page.

At this point, a list of the custom taxonomies and fields associated with that post type will appear.

Choose all of the fields you wish to export (use CTRL+click to select multiple ones) and click “Save Changes” again.

Then click on the “Export” buttons to get your CSV or XLS file.

I don’t see any custom fields on the Settings page. How come?

You mush first choose your post type and click “Save Changes” before you can see a list of the associated custom fields.

Be sure to click “Save Changes” again in order to save your choices.

Can I export to CSV from frontend?

Yes, just place this URL where you want the download link/button to be: <a class="btn" href="?export=csv">Export to CSV</a>

This will export as per plugin Settings.

Can I export to XLS from frontend?

Yes, just place this URL where you want the download link/button to be: <a class="btn" href="?export=xls">Export to XLS</a>

This will export as per plugin Settings.

Can I change the post type, from the frontend URL?

Yes, use the URL var ?post_type=yourcustomposttypeslug

Keep in mind however, that it will still look for the taxonomies and custom fields as per plugin Settings.

Eg. https://yoursite.com/?export=xls&post_type=portfolio

Can I only export parents or children?

Yes, use the URL var ?only=x, where x is either children or parents.

Default is both.

Eg. https://yoursite.com/?export=xls&post_type=portfolio&only=parents

Does it support cyrillic characters? (eg. Russian)

Yes, but only for the CSV format (for now).

Can I export only posts with a certain post status?

Yes, as of v. 1.3.8.

You can set it up from the Settings page as default, or add to your url ?post_status=nameofstatus

Eg. https://yoursite.com/?export=xls&post_type=portfolio&post_status=draft

Can I export only posts from a specific user, or the current one?

Yes, as of v. 1.4.

To export the file with content from the currently logged-in user, add this to your url ?user

To export the file of a specific user ID, use this in your url ?user=x, where X is the user ID you need.

Default is all users.

Eg. https://yoursite.com/?export=xls&post_type=portfolio&user

Can I export specific posts?

Yes, as of v. 1.5.

You need the parameter ?specific_posts in the export url.

Eg. https://yoursite.com/?export=xls&specific_posts=1,2,3

Can I export only posts from a specific date onward?

Yes, as of v. 1.5.5.

To export the file with content created from a specific date, either use the global options or add this to your url ?date_min

The date format, when using the url parameter, must be mm-dd-yyyy.

Eg. https://yoursite.com/?export=csv&date_min=07-11-2020 (July 11 2020)

Can I populate certain data in my export, in a custom way, through a filter?

Yes, as of v. 1.5.7

Eg.

function ccsve_generate_query_callback($query_arr) {

    if (isset($_REQUEST['order_id']) && $_REQUEST['order_id']) {
        $query_arr['meta_key'] = '_order_id';
        $query_arr['meta_value'] = $_REQUEST['order_id'];
    }

    return $query_arr;
}
add_filter('ccsve_generate_query', 'ccsve_generate_query_callback');

Where order_id is an assigned data to export, from plugin’s options, _order_id is the name of the custom column you need and its value will be order_id.

Please remember to create your query according to WP Query guidelines.
Eg. If you want to add a custom date export, you will need to follow the same query construct shown here.

For your own reference, you can find the original export query, and the filter hook, in this plugin file.

Can I populate certain data in my export, in a custom way, through a shortcode in the url parameter?

Yes.

Eg.

This is a solution provided by Jayanta Sarkar, to generate custom post IDs through a function and then use the result as a shortcode, inside the export url, as a parameter value.

This url cannot be used directly however (copy and paste it in the browser url bar, it must be printed somewhere on a page of your website – backend or frontend).

add_shortcode('search_post_ids', 'search_posts_function');

function  search_posts_function(){
    $search_term = $_GET['s'];
    $args = array(
        's' => $search_term,
        'posts_per_page' => -1,
        'post_type' => 'your_custom_post_type'
    );
    $query = new WP_Query( $args );
    if ( $query->have_posts() ) {
        while ( $query->have_posts() ) {
            $query->the_post();
            $ID_string .= get_the_ID().",";
        }
    }
    return $ID_string; 
}

Adjust the above function to your needs.

Then use the shortcode in a url, like this:
https://yoursite.com/?export=xls&specific_posts=[shortcode]