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

CiviCRM importing field matching has trouble matching civicrm exports.

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.5
    • Fix Version/s: 1.6
    • Component/s: None
    • Labels:
      None

      Description

      Update the "headerPattern" regular expressions in XML files so that the column header values from our exports will automatically map to the import drop-downs for the following "primary export" columns which currently do NOT map or map to the wrong drop-down value:

      Internal Contact ID
      Contact Sub Type
      Is Deceased - this missing from Import mapping drop-down, it s/b importable
      Deceased Date
      Individual Prefix
      Location Type - maps erroneously to "Location Name"
      Postal Code Suffix - maps erroneously to "Individual Suffix"
      Phone Type - maps erroneously to "Phone"
      IM Provider - maps erroneously to "State"
      Home URL
      Source of Contact Data
      Preferred Mail Format
      Do Not Phone - maps erroneously to "Phone"
      Do Not Email - maps erroneously to "Email"
      No Bulk Mail (Opted-out)

      — original post from robin monks ----
      A .csv exported from a CRM site when imported, many of the fields won't match, requiring alot of custom configuration.
      The field matching should become smarter, and exports should be made compatible with crm imports.

      Robin

        Attachments

          Activity

            People

            • Assignee:
              rupam Rupam Jaiswal
              Reporter:
              mozillaman Robin Monks
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2 hours, 15 minutes
                2h 15m
                Remaining:
                Remaining Estimate - 2 hours, 15 minutes
                2h 15m
                Logged:
                Time Spent - Not Specified
                Not Specified