CSV Importer plugin wrong date - FINALLY SOLVED! (1 post)

  1. David_the Real
    Posted 4 years ago #

    What is really annoying users like me is that even topics that are clearly marked as "Not solved" are marked as "Topic closed"! One of MANY such topics: http://wordpress.org/support/topic/csv-importer-custom-fields?replies=10

    So, for posterity, I thought I should really make a NEW post to help all those wp users who are desperate to find a solution too, like I was! ...And who can use the search function here!

    Here is the solution for THIS issue: Denis' "CSV Importer plugin" - Date import always current date!

    --> When we write the date in the "csv_post_date" column, EXCEL (at least my version and apparently the version of all those who faced the same problem) CHANGES THE DATE to whatever format your computer has under "Start - Control Panel - Regional settings" in "Short Date"! Which in my case (UK) was: "dd/mm/yyyy".

    Once I changed this to the format the wordpress' mysql db (and Denis' php script, line 557) requires: yyyy-mm-dd hh:mm:ss, it worked like a charm! Now this brilliant CSV Importer plugin, one of a kind!, even imports the DATE correctly, finally! :-)
    Man, how much time this wasted...! Hopefully, not for you anymore now.

Topic Closed

This topic has been closed to new replies.

About this Topic