Answers.Body: <p>Indeed there is not a standard importer for SEPA mandates. I have migrated SEPA mandates a few times and I use the <code>SepaMandate createfull</code> API. That will create the mandate and the recurring contribution.</p>
  
  <p>If you then want to import actual payments you should fill the column <code>contribution_recur_id</code> to ensure they are linked to the mandate.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-26T09:09:06.413Z
Answers.Text: Using the API sound like a good idea, thanks! For the second part you mean using the field `contribution_recur_id` of the `civicrm_contribution` table to point to the `id` of the right register of the `civicrm_contribution_recur` table? How do you propose to do the import of the payments?
Answers.UserDisplayName: Javier Elices
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-26T10:05:26.117Z
Answers.Text: Indeed, and using the Contribution create API.
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-26T07:32:17.610Z
Answers.LastActivityDate: 2018-10-26T07:32:17.610Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>In the <a href="https://wiki.civicrm.org/confluence/display/CRM/CiviSEPA+Setup+Instructions" rel="nofollow noreferrer">CiviSEPA Setup Instructions</a> there is a section regarding importing SEPA mandates, but instead of an answer there is a question... (similar to the one I am asking.)</p>
  
  <p>I have been checking the database tables and <em>Contribute</em> options and unless I have missed something, there is no way to import the contributions along with the mandates. That is, using the <em>Import contributions</em> option will populate the <code>civicrm_contribution</code> table, but not the <code>civicrm_contribution_recur</code> table which stores the details of the recurring transactions.</p>
  
  <p>There is also the question of populating the <code>civicrm_sdd_*</code> tables which are specific to the <strong>CiviSEPA</strong> extension.</p>
  
  <p>I don't intend to have all the history of the mandates I want to import, but at least a working mandate list that may be used to generate future mandates.</p>
  
  <p>I suppose that I could create a script to inject the data in the proper tables or through the API, but would like to know if someone has tried something easier or has something to start with.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I have found this question that also mentions <code>SepaMandate</code> and <code>createfull</code>: <a href="https://civicrm.stackexchange.com/questions/2193/need-to-create-a-sepamandate-for-street-walkers">Need to create a SepaMandate for street walkers?</a></p>
  
Tags: <import><civisepa>
Title: Is there a simple way to import recurring SEPA mandates that have been processed outside CiviCRM previously and should now be managed using CiviSEPA?
ThreadText: # Is there a simple way to import recurring SEPA mandates that have been processed outside CiviCRM previously and should now be managed using CiviSEPA?
  
  (Asked by: username_0 on 2018-10-25)
  
  In the [CiviSEPA Setup Instructions](https://wiki.civicrm.org/confluence/display/CRM/CiviSEPA+Setup+Instructions) there is a section regarding importing SEPA mandates, but instead of an answer there is a question... (similar to the one I am asking.)
  
  I have been checking the database tables and *Contribute* options and unless I have missed something, there is no way to import the contributions along with the mandates. That is, using the *Import contributions* option will populate the `civicrm_contribution` table, but not the `civicrm_contribution_recur` table which stores the details of the recurring transactions.
  
  There is also the question of populating the `civicrm_sdd_*` tables which are specific to the **CiviSEPA** extension.
  
  I don't intend to have all the history of the mandates I want to import, but at least a working mandate list that may be used to generate future mandates.
  
  I suppose that I could create a script to inject the data in the proper tables or through the API, but would like to know if someone has tried something easier or has something to start with.
  
  **UPDATE**
  
  I have found this question that also mentions `SepaMandate` and `createfull`: [Need to create a SepaMandate for street walkers?](https://civicrm.stackexchange.com/questions/2193/need-to-create-a-sepamandate-for-street-walkers)
  
  **Tags:** import, civisepa
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-10-26. Score: 3 | Accepted answer
  
  Indeed there is not a standard importer for SEPA mandates. I have migrated SEPA mandates a few times and I use the `SepaMandate createfull` API. That will create the mandate and the recurring contribution.
  
  If you then want to import actual payments you should fill the column `contribution_recur_id` to ensure they are linked to the mandate.
  
  > **Comments:**
  > **username_0**: Using the API sound like a good idea, thanks! For the second part you mean using the field `contribution_recur_id` of the `civicrm_contribution` table to point to the `id` of the right register of the `civicrm_contribution_recur` table? How do you propose to do the import of the payments?  
  > **username_1**: Indeed, and using the Contribution create API.  
  
  ---
  
  