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 CiviMember (Moderator: Deepak Srivastava) »
  • Update membership with external ID
Pages: [1]

Author Topic: Update membership with external ID  (Read 659 times)

Ed van Leeuwen

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Drupal 7.x
  • MySQL version: MariaDB 10
Update membership with external ID
December 08, 2013, 04:59:56 am
When updating memberships via the import wizard, it is not possible to use the external ID. What is the reason that this is not possible?

Evidently, the import should contain a unique key. But most of the time, the external ID is.

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: Update membership with external ID
December 08, 2013, 07:17:52 am

to keep things simple and focussed on membership stuff only, i suspect

U'll need to use the contact import to update external id

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

Ed van Leeuwen

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Drupal 7.x
  • MySQL version: MariaDB 10
Re: Update membership with external ID
December 08, 2013, 07:26:54 am
Thanks, lobo.

In my case, I would like to import contacts and memberships from a single Excel file. I could do that in two steps, first importing the contacts and then the 'membership stuff'. This is only possible now when inserting; for updating, I first have to export the imported contacts for the internal ID.

This is a far more complex thing and not easy to maintain when importing this for 75 organizations each month. If the external ID could be used to map the memberships, this would simplify things - at least from an end-user view.

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: Update membership with external ID
December 08, 2013, 08:39:40 am

might want to adopt an approach like the one suggested in this blog post:

https://civicrm.org/blogs/capo/new-tool-civicrm-data-integration

Your other option would be to contribute patches to improve civicrm's import. But this might be a more involved, more expensive project

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Update membership with external ID

This forum was archived on 2017-11-26.