I have exactly the same problem, and I’m afraid I don’t fully understand what “proper escaping” means.
All my values are between quotations and separated by semicolon. Such as:
“csv_post_title”;”csv_post_post” #line break#
“post title”;”post text”
What could be missing?
Sorry, I’ll answer myself: semicolon doesn’t work as a separator, it needs to be a comma.
I’ve triend everithing.
With coma and semicolon separator
With and without quotations…
Always the same result:
Skipped 10 posts (most likely due to empty title, body and excerpt).
Imported 0 posts and 0 comments in 0.03 seconds.
i have tried everything as well. changed the options from comma, semicolon, tabs, etc. i have inserted “csv_post_*” into the beginning of every section. nothing is working. please help. i’m also using OpenOffice.
I’ve given up on the CSV Import.
I’ve activated de API and created a PHP script to read my website database and upload de images and write the post throw the API.
Please be advised: if you want to upload images I suggest to upgrade WordPress to the latest version, so that you have the image ID on the upload response. The API have a bug (easy to correct) on the image/post association.
thank you for the comment. i appreciate it. i have been at it for a couple hours and am currently looking for another way. i am horribly a novice at this. it’s not my usual job duty. everything you said went well over my 🙂 is there an easier way to explain it or have it done?
for what it is worth – I’m having the same issue – also using open office
oh, so frustrating
Skipped 9 posts (most likely due to empty title, body and excerpt).
Imported 0 posts and 0 comments in 0.01 seconds.
plz anyone have this solution…
plz help……me…
I had this problem also, but i did the next thing;
I actually deleted all the “” in the openOfficeCalc and it works fine.
(setting for csv when open OpenOfficeCalc are separator-comma, text separator – ” , format-UTF-8).
Please tell me if it works for you. Thanks
Same error for me.
I try with the sample file and it’s the same.
This working was great before, but now is broken! ;-(
Hope someone can fix this