importing csv data but date field is wrong way around

Discussion in 'Troubleshooting' started by _matthew_, Jun 6, 2008.

  1. _matthew_

    _matthew_ New Member

    Joined:
    May 13, 2004
    Messages:
    9
    Thanks to Anton who worked very hard to get the installation set up I have a working site, but I am having huge problems with importing my existing membership data into it.

    I have 40,000 members so I can't retype (!) but the subscription start and end dates are in date format in excel which refuses to save as csv if you format columns as YYYY/MM/DD. Instead it saves it DD/MM/YYYY whether you like it or not.

    I feel like I have tried everything. My latest attempt was to copy and paste from excel into notepad (leaving tab spaces between fields) then find and replacing the tabs with commas and saving the file as csv.

    On a test of seven members 3 STILL end up in the control panel with a start date of 01/01/1970 which is what it seems to revert to in a crisis.

    Can anyone help please?

    Many thanks

    Matthew

Share This Page