WordPress.org

Support

Support » Plugins and Hacks » [Plugin: CSV Importer] error "empty title, body and excerpt"

[Plugin: CSV Importer] error "empty title, body and excerpt"

  • hey there, i exportet a csv-file from an old blog (sql). so i tried to import this csv-file now, but i’m always getting the following error:

    Skipped 23 posts (most likely due to empty title, body and excerpt).
    Imported 0 posts and 0 comments in 0.05 seconds.

    what could be the error. i made sure the columns are headed with “csv_post_title”, “csv_post_post” etc. thanks for your help in advance.

    http://wordpress.org/extend/plugins/csv-importer/

Viewing 11 replies - 1 through 11 (of 11 total)
  • 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

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘[Plugin: CSV Importer] error "empty title, body and excerpt"’ is closed to new replies.