I imported content as CSV in following format.
wp_title|wp_post_date|wp_category|wp_content|field1|field2|field3
as per http://www.zackpreble.com/2008/03/28/importing-posts-from-csv-file-into-wordpress/
the posts are set as "future" within mySQL ??
there seems to be no easy way to alter the status to "published"
is there no bulk publish technique within dashboard ??
also since it has set the scheduled date for all 800 posts, can this scheduled date not be changed for all.
tia