Answers.Body: <p>You cannot do this in one import. You have to update one table per import.</p>
  
  <p>You will likely need the API csv Import extension.</p>
  
  <p>First step will be to create your csv files. 
  1. If they do not have it already, give each member a unique id number. 
  2. If your contact info and contribution are all on the same report, divide those into two csv files. You will need to assign the unique contact id # to each contribution. </p>
  
  <p>After you have your csv files ready, you can import the contact files and then the contribution files. I recommend that your first import only have 2-3 contacts and then another with 2-3 related contributions. This way you can test it without making a mess of all 300 contacts.</p>
  
  <p>You may need the API csv Import extension to import the Contributions. It depends on your setup and which fields you are importing.</p>
  
  <p><a href="https://wiki.civicrm.org/confluence/display/CRM/Import+Contacts+from+Other+Sources" rel="nofollow noreferrer">https://wiki.civicrm.org/confluence/display/CRM/Import+Contacts+from+Other+Sources</a></p>
  
  <p><a href="https://wiki.civicrm.org/confluence/display/CRMDOC/Import+Contributions" rel="nofollow noreferrer">https://wiki.civicrm.org/confluence/display/CRMDOC/Import+Contributions</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-17T15:21:12.327Z
Answers.Text: The issue is that this will not link the membership and contribution payments - though if you have the API csv import extension, you can generate MembershipPayment entities, which will solve you problem.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-18T18:31:25.220Z
Answers.Text: Jon G, it WILL link the contacts and the contributions IF you import the contacts with an ID and import the contributions with the same contact ID.  It is easy if you have the contact ID in both imports. The other way to do it is to import the contacts without a Contact ID. Then you can add the Civi generated Contact ID with the contributions. But this is a much more difficult method.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-18T18:32:34.513Z
Answers.Text: Parthibaraj Rajasekar, https://civicrm.org/extensions/api-csv-import-gui/11 Is needed because (at least historically) the core Civi import process does not give you access to match to all tables/fields. The extension gives you access to more tables/fields.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-18T18:46:35.153Z
Answers.Text: As an example, I believe you need the API csv Import extension to have the Contact ID with the Contribution import. I could be wrong but I think this is the case. You definitely need the extension if your Civi setup includes Price Sets for contributions. The core import process does not include the Line Item table matching.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-17T15:13:08.197Z
Answers.LastActivityDate: 2017-07-17T15:13:08.197Z
Answers.UserDisplayName: Iowa Boy
Body: <p>What is the simplest way to import Membership information and corresponding contribution information together from .CSV files? </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-16T11:49:02.380Z
Comments.Text: check https://civicrm.stackexchange.com/questions/1/whats-the-best-way-to-import-memberships-and-their-associated-contributions?rq=1
Comments.UserDisplayName: jitendra - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-16T14:41:12.610Z
Comments.Text: I saw that. Quite a newbie. Some explanation is needed how to implement the answer. Was looking for further simplified solutions
Comments.UserDisplayName: Parthibaraj Rajasekar
Tags: <civicontribute><civimember><import><contributions><recurring-contributions>
Title: simple way to import membership and contributions together
ThreadText: # simple way to import membership and contributions together
  
  (Asked by: username_0 on 2017-07-16)
  
  What is the simplest way to import Membership information and corresponding contribution information together from .CSV files?
  
  **Tags:** civicontribute, civimember, import, contributions, recurring-contributions
  
  > **Comments:**
  > **username_1**: check https://civicrm.stackexchange.com/questions/1/whats-the-best-way-to-import-memberships-and-their-associated-contributions?rq=1  
  > **username_0**: I saw that. Quite a newbie. Some explanation is needed how to implement the answer. Was looking for further simplified solutions  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2017-07-17. Score: 1 | Accepted answer
  
  You cannot do this in one import. You have to update one table per import.
  
  You will likely need the API csv Import extension.
  
  First step will be to create your csv files.
  1. If they do not have it already, give each member a unique id number.
  2. If your contact info and contribution are all on the same report, divide those into two csv files. You will need to assign the unique contact id # to each contribution.
  
  After you have your csv files ready, you can import the contact files and then the contribution files. I recommend that your first import only have 2-3 contacts and then another with 2-3 related contributions. This way you can test it without making a mess of all 300 contacts.
  
  You may need the API csv Import extension to import the Contributions. It depends on your setup and which fields you are importing.
  
  <https://wiki.civicrm.org/confluence/display/CRM/Import+Contacts+from+Other+Sources>
  
  <https://wiki.civicrm.org/confluence/display/CRMDOC/Import+Contributions>
  
  > **Comments:**
  > **username_3**: The issue is that this will not link the membership and contribution payments - though if you have the API csv import extension, you can generate MembershipPayment entities, which will solve you problem.  
  > **username_2**: Jon G, it WILL link the contacts and the contributions IF you import the contacts with an ID and import the contributions with the same contact ID.  It is easy if you have the contact ID in both imports. The other way to do it is to import the contacts without a Contact ID. Then you can add the Civi generated Contact ID with the contributions. But this is a much more difficult method.  
  > **username_2**: username_0, https://civicrm.org/extensions/api-csv-import-gui/11 Is needed because (at least historically) the core Civi import process does not give you access to match to all tables/fields. The extension gives you access to more tables/fields.  
  > **username_2**: As an example, I believe you need the API csv Import extension to have the Contact ID with the Contribution import. I could be wrong but I think this is the case. You definitely need the extension if your Civi setup includes Price Sets for contributions. The core import process does not include the Line Item table matching.  
  
  ---
  
  