ONLY 1st post is added to wp_posts

  • Resolved mohammad-mursaleen

    (@mohammad-mursaleen)


    11 years, 2 months ago

    I was trying to add a list of posts using CSV importer, but only first post is added to the database.

    Below is the fragment of CSV file that I’m trying to import

    csv_post_post,csv_post_title,csv_post_author,csv_post_type
https://www.youtube.com/watch?v=GxMYKYX4PPo,Shahid Afridi Boom Boom 51 Runs,1,post
https://www.youtube.com/watch?v=9rrDbl3GOeU,Shahid Afridi 7 wickets vs West Indies 2013,1,post
https://www.youtube.com/watch?v=vtgig0LK1aM,Shahid afridi 158 meter SIX vs South Africa 3rd ODI ,1,post
https://www.youtube.com/watch?v=--uWrm6MC5U,Afridi 100 of 45 balls VS India ,1,post
https://www.youtube.com/watch?v=GN96B6pPrhU,Shahid Afridi 5 Wickets And 1 Run Out Vs Canada,1,post

    Did any of you have faced such issue or have any solution for this.

    Would appreciate any help in this regard.

    https://www.ads-software.com/plugins/csv-importer/

Viewing 3 replies - 1 through 3 (of 3 total)

  • Same here. Anyone?

    This is a great plugin, and it’s one of the very few that offers custom taxonomy and CPTs for free.

    My first thought would be that a “special” character (such as non-English character, an accented character) might be breaking the import.

    I don’t see that in Mohammad’s example above, though.

    Still, I would suggest trying to encode the file in UTF-8 by opening it with a text editor that can save to that encoding (Notepad on Windows), and see if that helps.

    jsafire

    (@jsafire)

    Well, after 2 days, I finally got this to work.
    If you’re on a Mac, Excel saves files as Western (Mac OS Roman) and Classic Mac (CR).
    I opened the .csv file in BBEdit and saved it as UTF-8 with Unix linefeeds (Unix LF). That did it. It works every time now. Don’t forget to make a column for custom_post_type and put the slug of your CPT all the way down that column.

    This plugin really does work quite simply. Of course, tweaking everything from a Cold Fusion site to WP took another whole day.

    Have fun!
    Jeff

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘ONLY 1st post is added to wp_posts’ is closed to new replies.