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 with the effort to match external id
Pages: [1]

Author Topic: Importing with the effort to match external id  (Read 3367 times)

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Importing with the effort to match external id
February 18, 2009, 12:15:18 am
This works fine if for example it is a file with all new people.
But if I take that same list of say 500 people and change a record  and then reimport with the update option Civi gets to the end as if all is well but there is no real import.

For example
Import
Update
Into New Group

Civi will then run the progress bar and on the final page it will tally the results and show a link to the new group.
But in this instance it gets to that last page

Says
Import has completed successfully. The information below summarizes the results.
And does not show the usual group link.
And really the data is not updates even updated.

I even brought the file down to 10 rows and nothing.

But if I remove the External Id field from an import mapping then it works.

Any thoughts to why civi can parse a 500 row file and update first last etc but die out on this?

Just a review
1. Import 500 NEW contacts including an external ID field and creating a new group WORKS
2. Import that same file again w/ a few changes to the names for testing and it does not work nor does it error out.
3. Import that same list but do not map the external id and it works.

Server logs not showing memory errors etc?

Thanks

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Importing with the effort to match external id
February 18, 2009, 01:44:26 am
We have made some significant changes / fixes to import in v2.2, so it would be great if you can test this on http://sandbox.civicrm.org

thanx,

Kurund
Found this reply helpful? Support CiviCRM

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: Importing with the effort to match external id
February 18, 2009, 05:03:24 am
Here is what I got there.
1. CiviCRM has detected mismatched contact IDs. These records have not been updated.
Then if you look in the csv it create you see
No contact ID found for this External Identifier:20022 <--one of the 500 lines.

So it can not create the user if they do not exist?
Maybe I should not use external ID but a custom field?

Attached is the file.

This process atleast worked in 2.1.4 in that if not a contact create contact.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Importing with the effort to match external id
February 18, 2009, 11:00:39 am
May be we should allow inserting of new record in update mode if external id is not found.
Can you file an issue for this.

Kurund
Found this reply helpful? Support CiviCRM

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Importing with the effort to match external id
February 19, 2009, 04:34:48 am
hi

Now in update/ fill mode if contact does not found for given contact matching criteria,  we are creating new contact.
for detail issue is here : CRM-4148

fix will be part of next release. ( v2.2.beta3 )

thanks,
kiran
You Are Designed To Choose... Defined By Choice.

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: Importing with the effort to match external id
February 19, 2009, 04:56:30 am
Thanks!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing with the effort to match external id

This forum was archived on 2017-11-26.