Takuro Hishikawa

You must save your csv file in UTF-8 encoding. Your csv file is not a unicode file. It is Latin 1 Character Encoding. WordPress uses UTF-8 encoding to save data, so different character set makes some problem.

I tested import with below CSV data, but it works fine.

post_title,post_content
Problem importing content text,”City, Province – and then it proceeds with the content.”

Could you check your raw csv data?

Thanks a lot. In my project, I had been imported several thousands posts, but in that time, our WordPress were hosted on AWS and changed larger instance while importing. I think wp_get_object_terms function is too heavy, so I will try to reduce using it. Perhaps we need more lightweight API ??

Interesting, why such a lot of read queries..I’d like to do test case of importing many taxonomy. But, I think importing 1000 posts in single run is quite a heavy job for shared hosts. You should divide your csv file (eg. each file has 100 posts). I don’t have any plans to add ability to queue import job, because this plugin extends built-in importer of WordPress which has not queueing functions.

Exactly. I don’t like csv column mapping tools because these are NOT simple. If you want this, please try another csv importer. Thanks!

Thank you to report a issue! Exactly that was a bug, and it was already fixed, but I’m sorry, I haven’t updated my plugin due to some my trouble… I already pushed Version 0.5.6 to GitHub, so please download from GitHub if you are in a hurry.

https://github.com/hissy/rs-csv-importer

Just a example:

"post_type","post_status","post_content","post_title","_promo_slider_target","_promo_slider_url","tax_promotion-categories","post_thumbnail"
"ps_promotion","publish","content","title","_blank","https://example.com/","My Slider","/path/to/thumbnail_image.png

You will be able to get another field name from your database using database management tool like phpMyAdmin.

Hi Jenny,

please tell me more about your csv file. which columns included? like this?

"post_id","post_tags"
1,"apple"
2,"banana"

Thanks to report a issue, this was a bug. I have fixed the bug and update the plugin. Enjoy Importing!

You’re welcome! Thanks review ??

The Importer will create terms by names in csv file, but the terms exists in your blog, you can also use the slug or id of the terms in taxonomy.
I did not wrote this in docs because this is optional. But very useful. Hope this help you ??

More information: https://codex.www.ads-software.com/Function_Reference/wp_set_object_terms

Sorry, It does not support to add taxonomy hierarchy now. Please change parent of taxonomies before or after importing in dashboard.

Sorry, just updated the plugin for check the post type exist. Maybe you used the label of post type, but post type slug is needed.

If you want to update existing custom type post, please include post_type column in csv file. The importer checks both of csv post data and existing post data has same post type value. Because changing the type of existing post occurs unexpected error in some cases. Hope this will help you!

To import custom field value, you can simply use custom field key name. But, importing custom taxonomy is bit complicated.
“tax_$taxonomy” means, “tax_” is prefix, and $taxonomy is name of custom taxonomy (not label).

Here is a 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 key “released”: 2013
Custom taxonomy “Actors”: Tom Hanks, Barkhad Abdi, Barkhad Abdirahman

Another example files are included in sample directory. Hope this will help you.