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

CLI import doesn't allow external identifier to be used to specify a contact

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.7.23
    • Fix Version/s: None
    • Component/s: Import
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      User and Admin Doc
    • Funding Source:
      Contributed Code
    • Verified?:
      No
    • How it works currently:
      Hide
      The CLI import utility requires that the field contact_id be used when creating non-contact entities, such as contributions. It would be useful to be able to use the external identifier to specify a contact instead of Contact ID. This would improve the ability to integrate with external systems, which may not have the Contact ID available.
      Show
      The CLI import utility requires that the field contact_id be used when creating non-contact entities, such as contributions. It would be useful to be able to use the external identifier to specify a contact instead of Contact ID. This would improve the ability to integrate with external systems, which may not have the Contact ID available.
    • How it should work:
      If the CSV file being imported has the external_identifier column instead of contact_id, the importer should look up a contact based on the External ID and operate on that contact.

      Description

      The CLI import utility requires that the field contact_id be used when creating non-contact entities, such as contributions. It would be useful to be able to use the external identifier to specify a contact instead of Contact ID. This would improve the ability to integrate with external systems, which may not have the Contact ID available.

      Other Improvements:

      • Detailed progress messages during import
      • Any records that fail import can be directed to another csv file. Line number and error message are appended as columns in each line.

        Attachments

          Activity

            People

            • Assignee:
              axon-obriend Dan O'Brien
              Reporter:
              axon-obriend Dan O'Brien
              Authorized Participants:
              Frank J. Gómez
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: