Really Simple CSV Importer

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. Add-on development example

Here is an example, assuming you have a field called cf47rs_images, format the csv cell data as, http://localhost/websitename/photos/photo12345-1.jpg|http://localhost/websitename/photos/photo12345-2.jpg|http://localhost/websitename/photos/photo12345-3.jpg or some other urls of files you want to import, and then use the really_simple_csv_importer_save_meta filter to hook into the import process, add_filter( 'really_simple_csv_importer_save_meta', 'rsc_import_images',10,3); function rsc_import_images( $meta, $post, $is_update ) { //convert to an array $images = explode("|",$meta['cf47rs_images']); $meta['cf47rs_images']=array();//reset the meta field //directory to import images to $artDir = 'wp-content/uploads/imported_cf47rs_images/'; //if the directory doesn't exist, create it if(!file_exists(ABSPATH.$artDir)) { mkdir(ABSPATH.$artDir); } require_once(ABSPATH . 'wp-load.php'); require_once(ABSPATH . 'wp-admin/includes/image.php'); global $wpdb; //loop through each photos that need to be imported foreach($images as $file_url){ //let's get the image file name $new_filename = array_pop(explode("/", $file_url)); //move the file to our custom import folder if (@fclose(@fopen($file_url, "r"))) { //make sure the file actually exists $siteurl = get_option('siteurl'); $skip_attachment_insert=false; //check if this image has already been imported, if(file_exists(ABSPATH.$artDir.$new_filename) ){ //file already imported //either change the name of the file UNCOMMENT the following line //$new_filename = date("Y-m-d H:i:s").$new_filename; //.... or overwrite it, COMMENT OUT the next 3 lines of code if you choose to uncomment the renaming of file name. //in which case we want to find the attachment ID and store it in our meta field $attach_id = attachment_url_to_postid($siteurl.'/'.$artDir.$new_filename); $meta['cf47rs_images'][$attach_id] = $siteurl.'/'.$artDir.$new_filename; //no need to insert a new attachment, we reuse the same $skip_attachment_insert=true; } //(over)write the new file copy($file_url, ABSPATH.$artDir.$new_filename); if($skip_attachment_insert) continue; $file_info = getimagesize(ABSPATH.$artDir.$new_filename); //create an array of attachment data to insert into wp_posts table $artdata = array( 'post_author' => 1, 'post_date' => current_time('mysql'), 'post_date_gmt' => current_time('mysql'), 'post_title' => $new_filename, 'post_status' => 'inherit', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_name' => sanitize_title_with_dashes(str_replace("_", "-", $new_filename)), 'post_modified' => current_time('mysql'), 'post_modified_gmt' => current_time('mysql'), 'post_type' => 'attachment', 'guid' => $siteurl.'/'.$artDir.$new_filename, 'post_mime_type' => $file_info['mime'] ); $uploads = wp_upload_dir(); $save_path = $uploads['basedir'].'/imported_cf47rs_images/'.$new_filename; //insert the database record $attach_id = wp_insert_attachment( $artdata, $save_path ); $meta['cf47rs_images'][$attach_id] = $siteurl.'/'.$artDir.$new_filename; //generate metadata and thumbnails, comment this out if you don't want thumbnails if ($attach_data = wp_generate_attachment_metadata( $attach_id, $save_path)) { wp_update_attachment_metadata($attach_id, $attach_data); } } } return $meta; }