Answers.Body: <p>Kudos to LarsSG: having &quot;Email (Unsupervised)&quot; in &quot;dedupe rules&quot; works indeed.  Contact ID is required in case if all Dedupe Rules fail. In this case, first thing would be to Export existing contacts: not all PRIMARY fields, only Contact ID and Email. Then do some concatenating Excel magic (&quot;vlookup&quot; works too, thanks to peterdnz comment below) and Import results back.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-03T15:13:04.377Z
Answers.Text: You can definitely import contacts or memberships with email alone if your unsupervised dedupe rule only needs email.
Answers.UserDisplayName: Lars SG
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-03T17:11:10.793Z
Answers.Text: @LarsSG Afraid your suggestion hasn't been working for me since 2017 ( including the last attempt made past week). Each time I start an import I hope an email or  an external id would suffice but it is always about contact id for existing contacts.
Answers.UserDisplayName: yurg
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-03T17:36:31.643Z
Answers.Text: Sounds like you might have a specific issue, as this definitely does work in general. Have you tried what you're trying to do on https://dmaster.demo.civicrm.org/?
Answers.UserDisplayName: Lars SG
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-03T18:43:16.277Z
Answers.Text: vlookup is how i would add Contact ID to your membership import s'sheet but if you have a small / easy dataset then just ordering by email may suffice to copy in your contact ID
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-04T09:22:15.553Z
Answers.Text: @LarsSG Thank you, will definitely try your approach the next import.
Answers.UserDisplayName: yurg
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-09T12:14:41.840Z
Answers.Text: @LarsSG Hallelujah! It works w/o Contact ID, have just tried. Such a relief.
Answers.UserDisplayName: yurg
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-10-03T11:46:37.973Z
Answers.LastActivityDate: 2023-10-09T12:19:32.793Z
Answers.LastEditDate: 2023-10-09T12:19:32.793Z
Answers.UserDisplayName: yurg
Body: <p>I am trying to do a Membership Import from a spreadsheet (Members.csv) with the following columnns:
  Membership Type | MEMBERSHIP # | DATE OF PURCHASE | AMOUNT PAID | FIRST NAME | LAST NAME |   Mailing ADDRESS | POSTAL CODE | Summer Residence | Primary phone # | Secondary phone # | EMAIL | Topics of Interest | Notes | RECEIPT NUMBER</p>
  <p>I created a 2nd spreadsheet to establish the contact data for each member (ContactList.csv) with the following columns:
  FIRST NAME | LAST NAME | Primary phone # | Secondary phone # | EMAIL
  with the same Email address as in the Members.csv file.  I added all these contacts using the Contacts &gt; Import Contacts dialog and the ContactList.csv file.</p>
  <p>I then tried the Memberships &gt; Import Memberships dialog, using the Members.csv file.  On selecting &quot;Import Now&quot; I see the following:
  <a href="https://i.sstatic.net/Zsbrf.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Zsbrf.png" alt="enter image description here" /></a>
  On viewing the Import_Errors.csv file, I see all 47 rows of the table have the &quot;Reason&quot; as<br />
  &quot;No matching Contact found for (email address)&quot;
  Why?  The same email address exists in the Contacts table.  How can I Import members if there is no way to establish a connection with the Contacts table?  I am missing something, but am unsure what.  We are running CiviCRM 5.64.3.</p>
  <p>Any help will be much appreciated.</p>
  <p>Brad Nickerson</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-03T02:23:40.697Z
Comments.Text: What is your unsupervised dedupe matching rule (under Contacts > Find & Merge Duplicate Contacts)? Is it just email? Is it possible that you have more than one contact with the same email?
Comments.UserDisplayName: Lars SG
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-03T18:41:44.207Z
Comments.Text: Your question says you are importing "MEMBERSHIP #" - how can you have this when you are importing them? If i understand right Memb ID won't exist. Is this possible confusion that your 'memb ID' should be your 'contact id'?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-11-07T05:47:00.993Z
Comments.Text: Hi Petednz.  The "MEMBERSHIP #" is already defined for members as part of our Excel based membership management system since 2019.  It is unclear what "Contact ID" means.  Assuming I first import the Contacts from the ContactsList.csv file, how do I then Export existing contacts so that it shows a Contact ID field?  I only have the FIRST NAME | LAST NAME | Primary phone # | Secondary phone # | EMAIL fields.  Is Contact ID an internal field defined by CiviCRM on import?  There is no "Export" option on the Contact main menu drop down list.
Comments.UserDisplayName: aqua
Tags: <civimember><error><import>
Title: I am trying to do a Membership Import from a spreadsheet (.csv file). All imports fail with the message "No matching Contact found for (email add.)"
ThreadText: # I am trying to do a Membership Import from a spreadsheet (.csv file). All imports fail with the message "No matching Contact found for (email add.)"
  
  (Asked by: username_0 on 2023-10-03)
  
  I am trying to do a Membership Import from a spreadsheet (Members.csv) with the following columnns:
  Membership Type | MEMBERSHIP # | DATE OF PURCHASE | AMOUNT PAID | FIRST NAME | LAST NAME | Mailing ADDRESS | POSTAL CODE | Summer Residence | Primary phone # | Secondary phone # | EMAIL | Topics of Interest | Notes | RECEIPT NUMBER
  
  I created a 2nd spreadsheet to establish the contact data for each member (ContactList.csv) with the following columns:
  FIRST NAME | LAST NAME | Primary phone # | Secondary phone # | EMAIL
  with the same Email address as in the Members.csv file. I added all these contacts using the Contacts > Import Contacts dialog and the ContactList.csv file.
  
  I then tried the Memberships > Import Memberships dialog, using the Members.csv file. On selecting "Import Now" I see the following:
  [![enter image description here](https://i.sstatic.net/Zsbrf.png)](https://i.sstatic.net/Zsbrf.png)
  On viewing the Import\_Errors.csv file, I see all 47 rows of the table have the "Reason" as  
  "No matching Contact found for (email address)"
  Why? The same email address exists in the Contacts table. How can I Import members if there is no way to establish a connection with the Contacts table? I am missing something, but am unsure what. We are running CiviCRM 5.64.3.
  
  Any help will be much appreciated.
  
  Brad Nickerson
  
  **Tags:** civimember, error, import
  
  > **Comments:**
  > **username_1**: What is your unsupervised dedupe matching rule (under Contacts > Find & Merge Duplicate Contacts)? Is it just email? Is it possible that you have more than one contact with the same email?  
  > **username_2**: Your question says you are importing "MEMBERSHIP #" - how can you have this when you are importing them? If i understand right Memb ID won't exist. Is this possible confusion that your 'memb ID' should be your 'contact id'?  
  > **username_0**: Hi Petednz.  The "MEMBERSHIP #" is already defined for members as part of our Excel based membership management system since 2019.  It is unclear what "Contact ID" means.  Assuming I first import the Contacts from the ContactsList.csv file, how do I then Export existing contacts so that it shows a Contact ID field?  I only have the FIRST NAME | LAST NAME | Primary phone # | Secondary phone # | EMAIL fields.  Is Contact ID an internal field defined by CiviCRM on import?  There is no "Export" option on the Contact main menu drop down list.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2023-10-03. Score: 1
  
  Kudos to LarsSG: having "Email (Unsupervised)" in "dedupe rules" works indeed. Contact ID is required in case if all Dedupe Rules fail. In this case, first thing would be to Export existing contacts: not all PRIMARY fields, only Contact ID and Email. Then do some concatenating Excel magic ("vlookup" works too, thanks to peterdnz comment below) and Import results back.
  
  > **Comments:**
  > **username_1**: You can definitely import contacts or memberships with email alone if your unsupervised dedupe rule only needs email.  
  > **username_3**: @LarsSG Afraid your suggestion hasn't been working for me since 2017 ( including the last attempt made past week). Each time I start an import I hope an email or  an external id would suffice but it is always about contact id for existing contacts.  
  > **username_1**: Sounds like you might have a specific issue, as this definitely does work in general. Have you tried what you're trying to do on https://dmaster.demo.civicrm.org/?  
  > **username_2**: vlookup is how i would add Contact ID to your membership import s'sheet but if you have a small / easy dataset then just ordering by email may suffice to copy in your contact ID  
  > **username_3**: @LarsSG Thank you, will definitely try your approach the next import.  
  > **username_3**: @LarsSG Hallelujah! It works w/o Contact ID, have just tried. Such a relief.  
  
  ---
  
  