michaelstaatz/static_info_tables_bic_de

Static info tables - German Bank Identifier Codes

2.0.0 2025-07-20 04:02 UTC

Requires

• typo3/cms-backend: *
• typo3/cms-core: ^11.4 || ^12.4 || ^13.4

GPL-2.0-or-later

• Michael Staatz

README

This SQL table contains 4810 entries. The data is generated by me from the Bundesbank Files in July 2025 and are valid from 09.06.25 to 07.09.2025

Find new CSV - File: Bundesbank CSV Download

At actual state you have to download the file, open it in your preferred spreadsheet application and save it as "utf-8". They stated that their file is "ASCII" and mb_detect_encoding($csvContent) is returning the same but mb_convert_encoding($csvContent, 'UTF-8', 'ASCII') is not working with german umlauts. Either the hole file nor the single row entry.

There is a ImportBlz Command and you can use it from command line like: ddev typo3 static-info-tables-bic-de:import:blz --file=blz-aktuell-csv-data.csv --skipFirstLine or use it with a scheduler task. Location of the file where it is searched is fileadmin

Each imported table row contains and rows with no swiftcode where not imported:

• The german BIC (BLZ)
• The name of the associated bank
• The Swiftcode / BIC

This table and the data in it is believed to be in the public domain. If you'd like to submit changes or updates, feel free to drop me a line at [e-mail].

Michael Staatz