Update BIC Database

[jvermeercc]

Good afternoon,

Could you please update your BIC database? The BIC 'BUNQDE82XXX' is currently not present, and therefor IBAN's belonging to this BIC are marked as 'invalid' when validating it via your service.

[UkeHa]

i opened a pull request in the data repo, but it seems like this project has gone stale

[jeinwag]

I created a fork of the original project and built a docker image with updated databases for Germany and Austria:

docker pull ghcr.io/marcapo/goiban-service:release

[jvermeercc]

Thanks!
Would it be possible to add French BIC's there as well? Or should I write a separate request for that?

[jeinwag]

@jvermeercc please open an issue at https://github.com/marcapo/goiban-service and I'll see what I can do.

[jvermeercc]

The tab for seeing/creating issues is not available in that project @jeinwag , could you please enable it? Thanks!

[jeinwag]

@jvermeercc Ah sorry, done!

[juherr]

As said at marcapo#1, the European Central Bank is providing this list: https://www.ecb.europa.eu/stats/financial_corporations/list_of_financial_institutions/html/monthly_list-MID.en.html

[oliverpool]

I took a look at https://www.ecb.europa.eu/stats/financial_corporations/list_of_financial_institutions/html/monthly_list-MID.en.html but apparently it only gives the list of BIC. It does not seem to list the corresponding Bank Code (which is present in the IBAN), so it can't be used to deduce the BIC code from an IBAN.

PS: for anyone interested, I am creating an easily importable go package to check an IBAN/BIC locally https://code.pfad.fr/swift/ (it uses code generation instead of a local database)

[oliverpool]

It does not seem to list the corresponding Bank Code

I was wrong. I stumbled upon https://github.com/sigalor/iban-to-bic/blob/main/src/fr-es.js by @sigalor which assumes that the RIAD Code (provided by the european file) for France and Spain is the concatenation of the country letters and the bank code.

I implemented this trick into my library https://code.pfad.fr/swift/bic/ , which now supports the following countries for BIC computation:

• AT (Austria)
• BE (Belgium)
• CH (Switzerland)
• DE (Germany)
• ES (Spain)
• FR (France)
• LI (Liechtenstein)
• LU (Luxembourg)
• MC (Monaco)
• NL (Netherlands)