Answers.Body: <p>In the end, this can't be done with a simple import. We must populate all of the following tables:</p>
  
  <ul>
  <li>civicrm_participant</li>
  <li>civicrm_line_item</li>
  <li>civicrm_contribution</li>
  <li>civicrm_participant_payment</li>
  <li>civicrm_financial_item</li>
  <li>civicrm_financial_trxn</li>
  <li>civicrm_entity_financial_trxn</li>
  </ul>
  
  <p>Given that complexity, I created a staging table and brought it all in via SQL scripts.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T22:41:22.783Z
Answers.LastActivityDate: 2015-05-15T22:41:22.783Z
Answers.UserDisplayName: Nicholai
Body: <p>I've tried importing participants in the standard way, then importing contributions for their event deposits (partial payments), then using API CSV import to connect them via a ParticipantPayment import. However, things don't seem to behave correctly afterward.</p>
  
  <p>Bringing the data directly in via SQL on civicrm_participants, civicrm_contributions, and civicrm_participant_payments doesn't seem to work either.</p>
  
  <p>What is the correct way to convert in the data so these participants will be connected with their deposits?</p>
  
Tags: <api><import>
Title: How to convert/import participants with partial payments
ThreadText: # How to convert/import participants with partial payments
  
  (Asked by: username_0 on 2015-05-09)
  
  I've tried importing participants in the standard way, then importing contributions for their event deposits (partial payments), then using API CSV import to connect them via a ParticipantPayment import. However, things don't seem to behave correctly afterward.
  
  Bringing the data directly in via SQL on civicrm\_participants, civicrm\_contributions, and civicrm\_participant\_payments doesn't seem to work either.
  
  What is the correct way to convert in the data so these participants will be connected with their deposits?
  
  **Tags:** api, import
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2015-05-15. Score: 3 | Accepted answer
  
  In the end, this can't be done with a simple import. We must populate all of the following tables:
  
  * civicrm\_participant
  * civicrm\_line\_item
  * civicrm\_contribution
  * civicrm\_participant\_payment
  * civicrm\_financial\_item
  * civicrm\_financial\_trxn
  * civicrm\_entity\_financial\_trxn
  
  Given that complexity, I created a staging table and brought it all in via SQL scripts.
  
  
  ---
  
  