CiviCRM Community Forums (archive)

Hi Carlos,
as you might be aware we are just doing this in co-operation with Amnesty Flanders?
Erik

Hi Carlos,

I still needed to send you an update. As we discussed earlier indeed Amnesty Flanders is embarking on the same road. We did now start up concretely, as Erik informed.

The work now is done by Xavier Dutoit and Erik Hommel, in close cooperation with Georges, Myriam and myself at Amnesty's side.

Some more in detail on what we are doing now:

1. Cleaning Up: Merging the SEPA CiviCRM extensions created by several CiviCRM community members for different projects into 1 extension. That new extension would be as generic as possible and would consider workflows in charities collecting SEPA direct debits, whether face2face, telemarketing or online - and the date to be kept needed.

2. History: Enabling CiviCRM logging for SEPA direct debit information That is a function not available yet in the previous work. If this does not work, enable storing history of the SEPA transactions and changes in another way.

Apart from this more generic work their will be some Belgian specific work (specific Belgian bankfile formats), and some Amensty Flanders specific work concerning migration of the actual mandates towards the new system.

Concerning timing
• Cleaning up to be finished by the middle of July
• History and Migration to be completed the middle of August
• Basic testing with the bank to be done during the second half of August.

Resulting we hope to have this new SDD-module to be operational in September-October.

What is not yet provides in this stage, but foreseen as next steps later is:
• importing data from external parties, we will continue the current manual process for the time being. (example: csv by F2F-agencies or TM-agencies containing new mandate information)
• providing a web donation page or function, we will continue the current partially manual process for the time being
• setting up validation rules other than invalid SEPA transactions, although we will check that the basic engine to do validation is in place.
-> foreseen: basic validation of transactions (ex: is this a coorect IBAN number?)
-> for later: more complex validation based on a series of business rules (ex: this donor has already an ongoing SDD-madante, are you sure to start a second?)

Concerning the funding for this project. Amnesty International Flanders has provided the funding for this next step. Of course the result will be available for the community. We are looking to the community to continue the funding for the further development of the SDD-module after this first step.
Of course we also welcome community member to step in now already, and share the initial funding. Investment in that way saved for Amnesty International then would go into funding for the next steps.

Parallel to this we (well Erik) are doing some work on import of bankfiles, building on what is already available with civibanking.


All participation and feedback welcome. And ofcourse I'm available for more details.

Greetings,
Ilja

Thanks for joining the conversation Ilja and Björn!

Would be great if you could investigate how it works in spain and if you can get a list of all the valid bic there.

I've been taking a look at it and, in fact, it looks like it's easy to obtain the official list of BIC/Swift codes for Spain banks:

• In Spain, the entity that regulates how banks operate is Banco de España (http://www.bde.es).
• In their website, there is a section where you can find a list of entities: http://www.bde.es/bde/es/secciones/servicios/Particulares_y_e/Registros_de_Ent/
• In this section, you can download an Excel file containing the list of bank entities. This list includes a BIC column: http://www.bde.es/f/webbde/IFI/servicio/regis/ficheros/es/REGBANESP_CONESTAB_A.XLS

We are now migrating our online member webforms to CiviCRM, so we'll have to make a decision soon. My preference is to create webforms where users will have, by default, an "Spanish way" to introduce their bank account number. If their bank account is Spanish, they will introduce their bank account as they have always done it (before SEPA). Otherwise, I'll ask for the IBAN account and I assume I wont actually validate the BIC code, as long as I don't have the complete list.

I've attached a screenshot that shows how a bank entity (Triodos) has implemented a form similar to the one I'm talking about (you can choose either the national account format, or the IBAN one). The screenshot is in Spanish but I guess its easy to understand the idea.