Support » Plugins » CSV Importer plugin wrong date – FINALLY SOLVED!

  • 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.

  • The topic ‘CSV Importer plugin wrong date – FINALLY SOLVED!’ is closed to new replies.