Answers.Body: <p>Contact records must exist before you import membership data. If you want to import membership data for contacts that do not yet exist in CiviCRM, you will first need to import the Contact data. Make sure the contact data has an External ID so you can include this External ID with your membership data to associate these records with the related contacts. If you are importing membership data for contacts that already exist, then you will need the Internal Contact ID or the fields from your Unsupervised Duplicate Matching Rule to associate the related membership data with the correct contact.</p>
  
  <p>Your import membership data file MUST contain both Membership Type and Start Date. The membership types listed must exactly match the membership types set up by your CiviCRM Administrator. The start date should use the date format specified for your CiviCRM installation. If your import file does not contain these fields then you will not be able to import it.</p>
  
  <p>You must import membership data for different contact types separately. Importing files with more than one contact type will not work. (You must import new memberships and renewals separately also.)</p>
  
  <p><a href="https://docs.civicrm.org/user/en/4.7/membership/manual-entry-of-memberships/" rel="nofollow noreferrer">https://docs.civicrm.org/user/en/4.7/membership/manual-entry-of-memberships/</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-16T08:15:42.180Z
Answers.LastActivityDate: 2017-06-16T08:15:42.180Z
Answers.UserDisplayName: Parthibaraj Rajasekar
Body: <p>I am going to freshly import data from excel into civiCRM. I have some contact related information like addresses, educational info, etc and also membership data like membership date, enrolled by whom, member center etc. </p>
  
  <p>what are all my possibilities and their pros/cons?</p>
  
  <ol>
  <li><p>Upload contact info in a separate excel and then should I upload membership info in a separate excel with the unique ID mentioned in membership excel? </p></li>
  <li><p>upload both contact and membership together (if possible)? </p></li>
  <li><p>Any other methods?</p></li>
  </ol>
  
Tags: <civimember><contacts><import><duplicate-contacts>
Title: noob query : Importing contacts and membership
ThreadText: # noob query : Importing contacts and membership
  
  (Asked by: username_0 on 2017-06-16)
  
  I am going to freshly import data from excel into civiCRM. I have some contact related information like addresses, educational info, etc and also membership data like membership date, enrolled by whom, member center etc.
  
  what are all my possibilities and their pros/cons?
  
  1. Upload contact info in a separate excel and then should I upload membership info in a separate excel with the unique ID mentioned in membership excel?
  2. upload both contact and membership together (if possible)?
  3. Any other methods?
  
  **Tags:** civimember, contacts, import, duplicate-contacts
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2017-06-16. Score: 3 | Accepted answer
  
  Contact records must exist before you import membership data. If you want to import membership data for contacts that do not yet exist in CiviCRM, you will first need to import the Contact data. Make sure the contact data has an External ID so you can include this External ID with your membership data to associate these records with the related contacts. If you are importing membership data for contacts that already exist, then you will need the Internal Contact ID or the fields from your Unsupervised Duplicate Matching Rule to associate the related membership data with the correct contact.
  
  Your import membership data file MUST contain both Membership Type and Start Date. The membership types listed must exactly match the membership types set up by your CiviCRM Administrator. The start date should use the date format specified for your CiviCRM installation. If your import file does not contain these fields then you will not be able to import it.
  
  You must import membership data for different contact types separately. Importing files with more than one contact type will not work. (You must import new memberships and renewals separately also.)
  
  <https://docs.civicrm.org/user/en/4.7/membership/manual-entry-of-memberships/>
  
  
  ---
  
  