Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-1928

Date format of contribution export is not compatible with date format for import

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 1.7
    • Fix Version/s: Unscheduled
    • Component/s: CiviContribute
    • Labels:
      None

      Description

      Dates in exported contribution records are formatted "YYYY-MM-DD HH:MM:SS", but this formatting is not compatible with import formats which expect only dates and not times.

      To recreate this:
      1. Export a contribution row with a valid Received Date
      2. Import the CSV file without changes, selected date format "YYYY-MM-DD" and matching the Received Date fields. An error occurs indicateding that the Received Date field is an incorrect format.

      To fix the exported dates should be formatted as "YYYY-MM-DD" (i.e. without HH:MM:SS). The work around right now is to use Excel to reformat the date fields.

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              chrism Chris Mott
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: