CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
I want to do a contributions import using a spreadsheet exported from Go Cardless.
When matching this info to contacts in Civi, 'External Identifier' is a mandatory field. I want to override what exists there as not everyone currently has an External Identifier, using data from Go Cardless.
How do I do that?
Thanks!
If you don't have 'External Identifier' for everyone yet - do a Contact import first!
Contact import: Include the data fields used for contact "matching" based on your configured Duplicate Matching rules. For the default duplicate matching rules, you would include 3 columns in each row with the contributors' First Name, Last Name and Email Address.
Your main Goal here is to find the Contacts in your Database and add an 'External Identifier' for them (and these come from your Go CardLess)
Contribution import: Very straightforward now that everyone has an 'External Identifier' - you can even now dump the name fields; all you need is 'External Identifier' and the contribution data columns.
