banking-addons-team team mailing list archive

[Kevin van der Draai <info@xxxxxxxxxxxxx>]

Public bug reported:

I configured OpenERP with Account Banking + ING (NL) bank Statements
Import. I was able to import a few bank statements, but after the latest
update of Account Banking, I receive the following error after starting
the import:

DataError: invalid input syntax for type date: ""
LINE 1: ...e_uid,create_date,write_uid,write_date) values (2,'','','','...
                                                                                                                   ^
The first value (I assume create_date_uid), is sequentially rising after each attempt.
I use the 'komma gescheiden dd-mm-jjjj' format, but this also happened while using 'komma gescheiden jjjjmmdd' and 'Girotel kommagescheiden'. 

I tried to reinstall the add-on, this to no success. 
The CSV files contain the right data. (i.e. it has the same structure as the previous files, which I could successfully import).

When I remove the bank account from the standard settings (Finance >
Settings > Banking > Standard settings), the import add-on reports that
the csv file contains bank statements for account  ING *******, but that
there is no bank account defined in the standard settings.

Attached you will find the complete error message/error log.

** Affects: banking-addons
     Importance: Undecided
         Status: New

** Attachment added: "error report"
   https://bugs.launchpad.net/bugs/1310841/+attachment/4091820/+files/bug_import.txt

-- 
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/1310841

Title:
  Error on importing ING bank statements

Status in OpenERP Banking Addons:
  New

Bug description:
  I configured OpenERP with Account Banking + ING (NL) bank Statements
  Import. I was able to import a few bank statements, but after the
  latest update of Account Banking, I receive the following error after
  starting the import:

  DataError: invalid input syntax for type date: ""
  LINE 1: ...e_uid,create_date,write_uid,write_date) values (2,'','','','...
                                                                                                                     ^
  The first value (I assume create_date_uid), is sequentially rising after each attempt.
  I use the 'komma gescheiden dd-mm-jjjj' format, but this also happened while using 'komma gescheiden jjjjmmdd' and 'Girotel kommagescheiden'. 

  I tried to reinstall the add-on, this to no success. 
  The CSV files contain the right data. (i.e. it has the same structure as the previous files, which I could successfully import).

  When I remove the bank account from the standard settings (Finance >
  Settings > Banking > Standard settings), the import add-on reports
  that the csv file contains bank statements for account  ING *******,
  but that there is no bank account defined in the standard settings.

  Attached you will find the complete error message/error log.

To manage notifications about this bug go to:
https://bugs.launchpad.net/banking-addons/+bug/1310841/+subscriptions