I'm importing a csv file via the database, all the posts are unpublished when I look in the CMS, is there a way to make them automatically published on import?
Doing a bulk publish via the CMS doesn't work as I need the dates I've put in the CSV file to be the publish date, not the date publish was clicked.
In the post_status column, all the posts are set to publish.
I'm trying to import hundreds of posts of news and the dates need to be in the past.
Here's my csv file:
ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count 6000 1 13/09/2010 00:00 13/09/2010 00:00 "Content here" New Report Available - Taking Medical Sensing Technologies to Market publish open open new-report-available-taking-medical-sensing-technologies-to-market 13/09/2010 00:00 13/09/2010 00:00 0 http://www.mediwales.com/v3/?post_type=news&p=6000 0 news 0