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. Python circular importing?
  3. Where does the Media Library live in the database?
  4. How to import wordpress posts with images from one wordpress site to another?
  5. Failed to import Media
  6. What is the required format for importing posts into WordPress?
  7. What exactly does the import tool do?
  8. WordPress Theme Options Import/Export
  9. How to add featured thumbnail into import XML?
  10. One Click demo content installation feature in WordPress theme options panel
  11. Why do I lose all the slashes, i.e., ” \ “, in my blogs when I import XML files by the WordPress Importer plug-in?
  12. WordPress Import shows an error when uploading previously exported xml file
  13. Import and replace existing page/post content
  14. Disabling HTML Filtering When Importing Into WordPress Multisite
  15. How to re-Import the WordPress XML file after editing?
  16. Migrating WP site to another URL
  17. Import old SQL dump into new WordPress version
  18. Why shouldn’t @import be used to import a parent theme into a child theme?
  19. How to migrate a WordPress installation from one site to another, including all images?
  20. How to completely export and import WordPress?
  21. Import a very old WordPress Version into new WordPress
  22. WXR import problem — not including categories
  23. Moving a blog from Tumblr to WordPress
  24. Download/View Schema (or DTD) for XML Import
  25. Using the Importer on an IIS Server
  26. GUID not updated on import
  27. How to import a TypePad blog including all media?
  28. Easy way to import a post from Word?
  29. Convert WordPress.com embed links to normal embeds
  30. Importing large data from blogger
  31. Scrape data from a website and post it on the blog
  32. Faking the “onSave” event
  33. Better way to remove HTML syntax from all content
  34. Importing custom post types using WordPress Importer, how to check for meta field values
  35. Is there a way to import Blogger into bbPress?
  36. What can I expect when moving from a hosted (WordPress.com) blog to one hosted by Page.ly
  37. WXR slicing script
  38. can’t import xml file
  39. WP CLI not importing media files
  40. Importing XML to WordPress, permalink problem
  41. Error: Failed to import tag/post
  42. How to get and save WordPress content (html, css, images, videos) from a Java program?
  43. Update Attached Image Size after Import
  44. Exporting and Importing WordPress Media Libraries and Galleries
  45. WordPress does not import all pages and post
  46. Programmatically save one/any post
  47. How to add more names in Baby Name Page?
  48. Batch attach unattached images
  49. How to access my wordpress via IP in shared hosting
  50. Is there a way to import a folder of HTML files into the blog?
  51. Using WordPress Importer, how to import media only?
  52. A question on WXR
  53. Problems with WordPress Import
  54. What is basic structure of xml for importing a page in wordpress?
  55. How to import content from WordPress.com to a self hosted WordPress installation?
  56. keep two blogs under the same domain
  57. In What WordPress Version Was the Import/Export Tool Introduced?
  58. Shows 1400 post published but don’t see them
  59. how to import a custom website into WordPress
  60. Moving WordPress site to an existing WordPress site
  61. How to import Theme Unit Test on localhost
  62. WXR xml files are being imported as a TXT files and showing up under ‘Media’
  63. WordPress WXR import – importing a large file
  64. Import HTML/JS post to WordPress?
  65. Is it possible to import several xml from different sites to another?
  66. After imorting posts from another blog double line breaks have been replaced with single line breaks
  67. Import post from XML files into custom post type programatically [closed]
  68. how do i import a site given that i have [domain].sql and a folder of site files? [closed]
  69. WordPress: Updating via Import
  70. Export Users From Live Site to Import onto staging
  71. create importer with importer api [closed]
  72. Import subdomain WordPress into main domain WordPress
  73. Exporting featured image
  74. CSV to WordPress posts: do I have to populate each possible field?
  75. How to add biography of user while importing?
  76. How to import XML to WordPress as post and custom fields?
  77. Programatticaly Import Pages while Maintaining Hierarchy
  78. product export and import using xml
  79. How to export a WordPress blog with no export function?
  80. Importing a database from a custom built CMS to WordPress
  81. Is there a way to show different source feeds on individual pages?
  82. Export WordPress from one domain to another domain
  83. Exporting by table
  84. automated import from blogger
  85. Error in importing wordpress xml [closed]
  86. How to import media from folder as opposed from old site?
  87. CSV Import Tables
  88. How to correctly move jquery script to external file
  89. Import function loses tags
  90. WordPress Import (CLI) returns Error Establishing a database connection
  91. WordPress xml import too slow
  92. Import WordPress content to my website
  93. Existing posts hidden after WP import
  94. Importing a Google Group to bbPress
  95. Import large database in php my admin
  96. Request failed due to an error: (http_request_fail
  97. Error importing website: “There has been a critical error on your website.”
  98. After importing items are not displaying
  99. How to import posts correctly?
  100. import svg-files from wxr – (upload works, import not)
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)