Answers.Body: <p>We are upgrading from CiviCRM 4.6 to 4.7.17.  The Eternal ID is now available for matching to contact records for importing multi-record custom data sets.  I just completed a test and the import worked fine and matched using the External ID.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-12T13:19:16.317Z
Answers.LastActivityDate: 2017-03-12T13:19:16.317Z
Answers.UserDisplayName: Ron Gridley
Body: <p>I'm importing education history for each Individual Contact, which can have from 0 to 5+ sets of multi-records.  Each set of multi-records comprises [institution], [degree level], [degree name], and [grad year].</p>
  
  <p>The level, name, and year are custom fields that show up in the multi-import wizard.  The institutions are already imported as Organization Contacts with their own external IDs, and I have a relationship set up between individuals and educational orgs (much in the same way as employees would be related to employers).</p>
  
  <p>However I don't see a way in the multi-record import wizard to relate a set of education multi records with the corresponding institution's External ID. Is there a way to do this in the wizard?</p>
  
  <p>If not, is there a way to do it directly in MySQL?  (Though I hesitate to muck with the guts, since last time I changed some seemingly innocuous data, the site got corrupted.)</p>
  
  <p>With hundreds of records to import and limited manpower, a manual process is likely not feasible.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-03-09T12:10:09.007Z
Comments.Text: I have the same issue.  Did you every get a solution for importing mulit-record custom data sets matching to External ID instead of internal ID?
Comments.UserDisplayName: Ron Gridley
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-01-24T00:11:56.400Z
Comments.Text: I actually moved away from CiviCRM shortly after my original post, but Ron's answer below would seem to help your situation
Comments.UserDisplayName: flopsquad
Tags: <import><multi-record>
Title: How can I assign an External Identifier to each set in a multi-record import?
ThreadText: # How can I assign an External Identifier to each set in a multi-record import?
  
  (Asked by: username_0 on 2016-07-13)
  
  I'm importing education history for each Individual Contact, which can have from 0 to 5+ sets of multi-records. Each set of multi-records comprises [institution], [degree level], [degree name], and [grad year].
  
  The level, name, and year are custom fields that show up in the multi-import wizard. The institutions are already imported as Organization Contacts with their own external IDs, and I have a relationship set up between individuals and educational orgs (much in the same way as employees would be related to employers).
  
  However I don't see a way in the multi-record import wizard to relate a set of education multi records with the corresponding institution's External ID. Is there a way to do this in the wizard?
  
  If not, is there a way to do it directly in MySQL? (Though I hesitate to muck with the guts, since last time I changed some seemingly innocuous data, the site got corrupted.)
  
  With hundreds of records to import and limited manpower, a manual process is likely not feasible.
  
  **Tags:** import, multi-record
  
  > **Comments:**
  > **username_1**: I have the same issue.  Did you every get a solution for importing mulit-record custom data sets matching to External ID instead of internal ID?  
  > **username_0**: I actually moved away from CiviCRM shortly after my original post, but Ron's answer below would seem to help your situation  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-03-12. Score: 2 | Accepted answer
  
  We are upgrading from CiviCRM 4.6 to 4.7.17. The Eternal ID is now available for matching to contact records for importing multi-record custom data sets. I just completed a test and the import worked fine and matched using the External ID.
  
  
  ---
  
  