Unable to import Dutch ING bank transaction files

[Kees van den Broek]

I setup company information in OpenERP (trunk) with the IBAN bank account: NL32 INGB 000x xxxx xx
Using the handy Iban lookup (legacy) module, it was recognised instantly.
Also the Domestic Account Number was automatically displayed: 000xxxxxxx

Then, I went to ing.nl, downloaded a transaction as dd-mm-yyyy CSV format.
Tried importing in OpenERP using: Accounting -> Bank and Cash -> Import Bank Statements File -> Select
The bank account 'xxxxxxx' couldn't be linked to any of my bank accounts.

I needed to run a small search/replace first, before it got recognised:
sed -i 's/"xxxxxxx"/"NL32 INGB 000x xxxx xx"/g' transaction.csv

Not sure why ING doesn't provide any newer IBAN style bank accounts, but for the time being, a smarter module would be very welcome.
It might be able to match the domestic account number when any 0's prefix values it encounters in the CSV are stripped?

[Stefan Rijnhart (Opener) (stefan-opener)]

Thanks for the report. Can you check if the account settings are properly recognized if you strip the leading zeroes from the domestic number on the company's bank account?

[Stefan Rijnhart (Opener) (stefan-opener)]

You could also try account_banking_nl_ing_mt940 if mt940 format statements are available to download for your bank account. I'd be curious to hear if this module work for you.

[Stefan Rijnhart (Opener) (stefan-opener)]

Setting to incomplete to indicate I am waiting for a response from the submitter.

[Kees van den Broek (kvdb-kvdb)]

I tried removing the leading zeroes from my bank account (field: Domestic Account Number).
Whenever the field lost focus, the zeroes were automatically re-added.
Worked around that by disabling the module 'Banking Addons - Iban lookup (legacy)'. Thought you should know that.

When I tried the import again (on a unmodified .csv), this is the error I see:

Statements found for unknown account 000xxxxxxxx

To get back on your third reply:
I added ticket #1317021 documenting my struggle with account_banking_nl_ing_mt940.

[Launchpad Janitor (janitor)]

[Expired for Banking Addons because there has been no activity for 60 days.]