← Back to team overview

banking-addons-team team mailing list archive

[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