Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [external-id]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer

Copy the contents of Custom Field to external_identfier field for all contacts

Loving civicrm, just getting to grips with it. I've imported a load of contacts but I've made a rookie error and instead of importing my unique ID number for each contact into the 'external_identifier'...
Steve Middleton's user avatar
3 votes
2 answers

Dangerous to force a binary collation on civicrm_contact.external_identifier?

We're trying to get External Identifier working for an external system that uses case-sensitive IDs (such that external contact "abc123" John Smith is distinct from external contact "...
TwoMice's user avatar
  • 1,824
0 votes
1 answer

How can I update all my external-IDs?

My client's outside database has changed. I have spent a few hours (fun!) matching the old and new external IDs and the internal CiviCRM contact ID as well. Not every record in the CiviCRM database ...
TimETown's user avatar
  • 373
2 votes
1 answer

possible bug: when using External ID as matching method, imported contributions can get matched to contacts in the trash--would expect error instead

I have a client whose accounting team has run into the following issue (admittedly an edge case but causes a lot of confusion and troubleshooting time for the team so we want to fix). Following the ...
Lisa J's user avatar
  • 474
1 vote
1 answer

how can I create an hook when external id change

I would to ask you , on how can create an event (programatically) when I change the external ID in contact form, how can I t make some kind of process like validation in another module or service I ...
Aneury Perez's user avatar
0 votes
1 answer

Importing Notes with external identifier

I'm trying to import notes into CiviCRM with only an external identifier. Inside the current database, the contacts are already assigned these external identifiers correctly within CiviCRM. I was ...
Kurt Leadley's user avatar
0 votes
1 answer

How to sort in descending order the results of CiviCRM API

I need to find the external identifier with highest value and hence need to sort in descending order .So I need to use sorting feature but unaware of what value should be added in screenshot shown.I ...
harshal's user avatar
  • 841
4 votes
2 answers

how to get an autoincrementing membership id with existing membership numbers

I've imported our membership list with existing membership numbers into CiviCRM. The old membership numbers are currently under external ID. I'd like an autoincrementing membership number. The best ...
dgk112's user avatar
  • 367
1 vote
2 answers

Allow Duplicate External IDs for later merge?

I have a large number of contacts across different contact sub-types, imported via CiviMigrate. The particulars: I am pulling multiple contact types from the same, flat master table. This means ...
Derek's user avatar
  • 355
1 vote
1 answer

questions on External ID

Is External ID Unique? will it automatically check for a duplicate External ID when the attempt is made to enter into database? Can External ID be auto incremented whenever an individual gets added?
Parthibaraj Rajasekar's user avatar
1 vote
1 answer

How can I avoid my import crashing with a Fatal Error due to an existing external ID?

I've had a few separate imports crash with a fatal error in the last month: Sorry but we are not able to provide this at the moment. DB Error: already exists Fatal error: Uncaught ...
Laryn's user avatar
  • 8,268
1 vote
1 answer

Can Quick Search be set up so External ID does not have to be exact match to work?

Tested on dmaster. Give Contact external ID eg fz123456 then set QuickSearch for External ID and enter fz123 - no result fz1234 - no result fz12345 - no result fz123456 - yay Ah, see this applies ...
petednz - fuzion's user avatar
  • 28.3k
0 votes
1 answer

How can I make External ID a searchable field?

Or create a directory that displays all recorded external IDs?
Ashe Higgs's user avatar
4 votes
2 answers

How do I get the External ID to appear in my contacts through Webform?

On the CiviCRM Webform Integration, I setup the External ID to appear as a textfield. Once the form is submitted, the External ID is captured in Webform, but not in the CiviCRM contacts. Is this a bug ...
Kristine's user avatar
  • 1,173