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) »
  • Resetting External Identifier
Pages: [1]

Author Topic: Resetting External Identifier  (Read 920 times)

BE55Roberts

  • Guest
Resetting External Identifier
June 04, 2010, 05:36:46 am
After reviewing postings about import, I wonder if it wouldn't make sense to reset the external identifier field at the point where you have concluded import activities. You could thus make it a standardized string. Would this have a negative effect on how Civi operates? Or would it only be a problem if you had to go back and reimport some old data.

I guess I'm trying to set the stage for future imports, so that they will work better. The External Identifier appears to be key to successfully importing data.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Resetting External Identifier
June 04, 2010, 06:46:34 am

in general its a bad idea for any system to reset data imported or entered by a user.

in some use cases external identifiers are used to decide on updating a contact vs creating a new contact, so resetting it is definitely a bad idea in those cases

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

BE55Roberts

  • Guest
Re: Resetting External Identifier
June 08, 2010, 01:33:01 pm
Thanks for the quick response. Which use cases are affected? I want to be sure that we are using them. For example, if they are part of case management, then they would not apply to us, since we don't use CiviCase. However, if they are part of CiviMail, then I can see the wisdom in leaving them alone. Maybe all I really need to do is make sure every contact has one. (Currently, about 50% of the contacts actually lack external identifiers. That's one reason I was considering a reset.) That won't be as clean as a new enumeration, but it will honor the "sticky data" aspect of previous assignments. I do expect that in many cases, the external identifier is simply the previous version of the contact_id field. In one sense, CiviCRM is keeping a historical record!

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

This forum was archived on 2017-11-26.