CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing Unique IDs
Pages: [1]

Author Topic: Importing Unique IDs  (Read 924 times)

bixgomez

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
Importing Unique IDs
April 09, 2010, 10:24:32 am
I am working with a nonprofit organization that already has a decades-old membership database, currently stored in *gasp* Microsoft Access.

As such, all members already have unique ID values.

In importing contacts into CiviCRM, is there any way to import, or preserve, the existing ID values?

This would help greatly when I import the same contacts as members, because then I can match their ID values up.

I can't match them up using email addresses, because many, many of these members (nearly half) do not have email addresses on file!

Any thoughts?  Thanks for any help or guidance you can offer!

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Importing Unique IDs
April 09, 2010, 05:22:05 pm
We would use the External ID field for this. This can then be used for importing on Membership and Contributions too.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

bixgomez

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
Re: Importing Unique IDs
April 13, 2010, 12:58:06 am
Thanks!  External Identifier is the thing!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing Unique IDs

This forum was archived on 2017-11-26.