Alternative CSV Importer plugin. Simple and powerful, best for geeks.
Alternative CSV Importer plugin. Simple and powerful, best for geeks.
You can get example CSV files in /wp-content/plugins/really-simple-csv-importer/sample
directory.
ID
or post_id
: (int) post id.post_author
: (login or ID) The user name or user ID number of the author.post_date
: (string) The time of publish date.post_content
: (string) The full text of the post.post_title
: (string) The title of the post.post_excerpt
: (string) For all your post excerpt needs.post_status
: (‘draft’ or ‘publish’ or ‘pending’ or ‘future’ or ‘private’ or custom registered status) The status of the post. ‘draft’ is default.post_password
: (string) The password to protect the post. The password is limited to 20 characters.post_name
: (string) The slug of the post.post_parent
: (int) The post parent id. Used for page or hierarchical post type.menu_order
: (int)post_type
: (‘post’ or ‘page’ or any other post type name) (required) The post type slug, not labels.post_thumbnail
: (string) The uri or path of the post thumbnail.post_category
: (string, comma separated) slug of post categoriespost_tags
: (string, comma separated) name of post tagstax_{taxonomy}
: (string, comma separated) Any field prefixed with tax_
will be used as a custom taxonomy. Taxonomy must already exist. Entries are names or slugs of terms.{custom_field_key}
: (string) Any other column labels used as custom fieldcfs_{field_name}
: (string) If you would like to import data to custom fields set by Custom Field Suite, please add prefix cfs_
to column header name.scf_{field_name}
: (string) If you would like to import data to custom fields set by Smart Custom Fields, please add prefix scf_
to column header name.comment_status
: (‘closed’ or ‘open’) Default is the option ‘default_comment_status’, or ‘closed’.Note: Empty cells in the csv file means “keep it”, not “delete it”.
Note: To set the page template of a page, use custom field key of _wp_page_template
.
Note: If providing a post_status of ‘future’ you must specify the post_date in order for WordPress to know when to publish your post.
Note: If the post_type value is attachment
, you can use post_thumbnail
field to define media URL or path.
If advanced custom field key is exists, importer will trying to use update_field function instead of built-in add_post_meta function.
How to find advanced custom field key: Finding the field key
Add star and read future issues about rs-csv-importer on GitHub!
Cover banner designed by @luchino__
Really Simple CSV Importer Debugger add-on enables you to dry-run-testing and show more detailed post, meta, taxonomy data of each csv row.
Download from gist.
There are three filters available in the importer.
This filter is applied to post data.
Parameters:
$post
– (array)(required) post data$is_update
– (bool) update existing post data, or insert new post dataExample:
function really_simple_csv_importer_save_post_filter( $post, $is_update ) { // remove specific tag from import data if (isset($post['post_tags'])) { $_tags = array(); foreach ($post['post_tags'] as $tag) { if ($tag != 'Apple') { $_tags[] = $tag; } } $post['post_tags'] = $_tags; } return $post; } add_filter( 'really_simple_csv_importer_save_post', 'really_simple_csv_importer_save_post_filter', 10, 2 );
This filter is applied to post meta data.
Parameters:
$meta
– (array)(required) post meta data$post
– (array) post data$is_update
– (bool)Example:
function really_simple_csv_importer_save_meta_filter( $meta, $post, $is_update ) { // serialize metadata $meta_array = array(); if (isset($meta['meta_key_1'])) $meta_array[] = $meta['meta_key_1']; if (isset($meta['meta_key_2'])) $meta_array[] = $meta['meta_key_2']; $meta = array( 'meta_key' => $meta_array ); return $meta; } add_filter( 'really_simple_csv_importer_save_meta', 'really_simple_csv_importer_save_meta_filter', 10, 3 );
This filter is applied to post taxonomy data (categories and tags are not included, these are post data).
Parameters:
$tax
– (array)(required) post taxonomy data$post
– (array) post data$is_update
– (bool)Example:
function really_simple_csv_importer_save_tax_filter( $tax, $post, $is_update ) { // Fix misspelled taxonomy if (isset($tax['actors'])) { $_actors = array(); foreach ($tax['actors'] as $actor) { if ($actor == 'Johnny Dep') { $actor = 'Johnny Depp'; } $_actors[] = $actor; } $tax['actors'] = $_actors; } return $tax; } add_filter( 'really_simple_csv_importer_save_tax', 'really_simple_csv_importer_save_tax_filter', 10, 3 );
This filter is applied to thumbnail data.
Parameters:
$post_thumbnail
– (string)(required) the thumbnail file path or distant URL$post
– (array) post data$is_update
– (bool)Example:
function really_simple_csv_importer_save_thumbnail_filter( $post_thumbnail, $post, $is_update ) { // Import a local file from an FTP directory if (!empty($post_thumbnail) && file_exists($post_thumbnail)) { $upload_dir = wp_upload_dir(); $target_path = $upload_dir['path'] . DIRECTORY_SEPARATOR . basename($post_thumbnail); if (copy($post_thumbnail, $target_path)) { $post_thumbnail = $target_path; } } return $post_thumbnail; } add_filter( 'really_simple_csv_importer_save_thumbnail', 'really_simple_csv_importer_save_thumbnail_filter', 10, 3 );
This action provides availability to run some tasks after importing.
Example: Download image from remote url to custom field (Download from gist)
This filter provides availability to completely replace the RS_CSV_Importer#save_post
method.
Example: Update row based on a custom field ID/key match (Download from gist)
/wp-content/plugins/
directory./wp-content/plugins/
directory.No. Only columns which you want to update.
Yes. Please use ID field to specify the existing post.
Yes. Please use ID field to specify the new post ID.
Yes. You can use column names same as wp_post table, but if the column name does not match, it creates a custom field (post meta) data. Importing custom taxonomy is a bit more complicated, “tax_{taxonomy}” means, “tax_” is prefix, and {taxonomy} is name of custom taxonomy (not labels).
Here is an example.
csv file
“post_title”,”released”,”tax_actors”
“Captain Phillips”,”2013″,”Tom Hanks, Barkhad Abdi, Barkhad Abdirahman”
imported post data
Post Title: Captain Phillips
Custom field “released”: 2013
Custom taxonomy “Actors”: Tom Hanks, Barkhad Abdi, Barkhad Abdirahman
Because PHP cannot read multibyte text cells in some cases.
Locale setting is taken into account by this function. If LANG is e.g. en_US.UTF-8, files in one-byte encoding are read wrong by this function.
Yes. Please create additional plugin and use really_simple_csv_importer_save_meta
filter to make array data.