banking-addons-team team mailing list archive
-
banking-addons-team team
-
Mailing list archive
-
Message #02077
[Bug 1310290] Re: Unable to import Dutch ING bank transaction files
[Expired for Banking Addons because there has been no activity for 60
days.]
** Changed in: banking-addons
Status: Incomplete => Expired
--
You received this bug notification because you are a member of Banking
Addons Core Editors, which is subscribed to Banking Addons.
https://bugs.launchpad.net/bugs/1310290
Title:
Unable to import Dutch ING bank transaction files
Status in OpenERP Banking Addons:
Expired
Bug description:
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?
To manage notifications about this bug go to:
https://bugs.launchpad.net/banking-addons/+bug/1310290/+subscriptions
References