Importing posts via MySql (a csv file) need to be automatically published

Suggestions for what you can try:
Try to remove the empty columns, especially post_excerpt.
Try another import plugin.
Try another delimiter.

Related Posts:

  1. Java Package Does Not Exist Error
  2. How to import wordpress posts with images from one wordpress site to another?
  3. Failed to import Media
  4. What is the required format for importing posts into WordPress?
  5. What exactly does the import tool do?
  6. WordPress Theme Options Import/Export
  7. How to add featured thumbnail into import XML?
  8. One Click demo content installation feature in WordPress theme options panel
  9. Why do I lose all the slashes, i.e., ” \ “, in my blogs when I import XML files by the WordPress Importer plug-in?
  10. WordPress Import shows an error when uploading previously exported xml file
  11. Import and replace existing page/post content
  12. Disabling HTML Filtering When Importing Into WordPress Multisite
  13. How to re-Import the WordPress XML file after editing?
  14. Import old SQL dump into new WordPress version
  15. Why shouldn’t @import be used to import a parent theme into a child theme?
  16. How to migrate a WordPress installation from one site to another, including all images?
  17. Import a very old WordPress Version into new WordPress
  18. Moving a blog from Tumblr to WordPress
  19. Using the Importer on an IIS Server
  20. GUID not updated on import
  21. How to import a TypePad blog including all media?
  22. Easy way to import a post from Word?
  23. Convert WordPress.com embed links to normal embeds
  24. Importing large data from blogger
  25. Faking the “onSave” event
  26. Better way to remove HTML syntax from all content
  27. Importing custom post types using WordPress Importer, how to check for meta field values
  28. What can I expect when moving from a hosted (WordPress.com) blog to one hosted by Page.ly
  29. WXR slicing script
  30. WP CLI not importing media files
  31. How to get and save WordPress content (html, css, images, videos) from a Java program?
  32. Exporting and Importing WordPress Media Libraries and Galleries
  33. Programmatically save one/any post
  34. How to add more names in Baby Name Page?
  35. Batch attach unattached images
  36. How to access my wordpress via IP in shared hosting
  37. Using WordPress Importer, how to import media only?
  38. A question on WXR
  39. Problems with WordPress Import
  40. What is basic structure of xml for importing a page in wordpress?
  41. keep two blogs under the same domain
  42. In What WordPress Version Was the Import/Export Tool Introduced?
  43. Shows 1400 post published but don’t see them
  44. Moving WordPress site to an existing WordPress site
  45. How to import Theme Unit Test on localhost
  46. WordPress WXR import – importing a large file
  47. Import HTML/JS post to WordPress?
  48. how do i import a site given that i have [domain].sql and a folder of site files? [closed]
  49. WordPress: Updating via Import
  50. Export Users From Live Site to Import onto staging
  51. create importer with importer api [closed]
  52. Import subdomain WordPress into main domain WordPress
  53. Exporting featured image
  54. CSV to WordPress posts: do I have to populate each possible field?
  55. How to add biography of user while importing?
  56. How to import XML to WordPress as post and custom fields?
  57. Programatticaly Import Pages while Maintaining Hierarchy
  58. product export and import using xml
  59. How to export a WordPress blog with no export function?
  60. Exporting by table
  61. Error in importing wordpress xml [closed]
  62. CSV Import Tables
  63. Import function loses tags
  64. WordPress Import (CLI) returns Error Establishing a database connection
  65. Import WordPress content to my website
  66. Importing a Google Group to bbPress
  67. Import large database in php my admin
  68. Request failed due to an error: (http_request_fail
  69. Error importing website: “There has been a critical error on your website.”
  70. import svg-files from wxr – (upload works, import not)
  71. WordPress All-Import to ATUM Stock Management
  72. Mixed Content: The page at ” was loaded over HTTPS, but requested an insecure font ”
  73. How can I import a BlogML file into my WordPress site?
  74. WordPress importer – How to handle id clashes for featured images
  75. How to import several big Import XMLs?
  76. How to make bulk changes to wordpress posts
  77. Merge two wordpress sites
  78. Import demo data into wordpress template
  79. XML file import for attachments or featured images
  80. XML importing fails
  81. When migrating all backslashes were stripped and special signs are converted in html entities
  82. How to do one-off import or data migration?
  83. Import xml feed
  84. Max execution time error with stream_body() in wp-includes/class-http.php
  85. Importing demo content from plugin
  86. Standard wordpress importer seems to be missing blog images
  87. Moving 2 wordpress sites to one
  88. How to import data from Mingle Forum plugin to bbPress?
  89. Export plugin omits many images
  90. Create CSV for import from File directories?
  91. Export and import all Plugin options
  92. Import data from file larger than 15 MB
  93. How to import individual blog posts into WordPress?
  94. Failed Media Import (importing from LIVE to local)
  95. Import post from Tumblr to WordPress [duplicate]
  96. Syndicate posts to another blog?
  97. WXR? Export from Drupal 7 – import into WordPress
  98. WordPress Export/Import for custom options.php values?
  99. How to create import option for xml
  100. How to add featured thumbnail into import XML using URL image?