banking-addons-team team mailing list archive

[Knimmet <temmink@xxxxxxxxxxx>]

Public bug reported:

when I try to import bank camt053.xml file with the with "generic camt format" the server gives an error, and nothing is imported.
The error I get is the following:

2014-07-04 13:31:42,954 30753 ERROR XXXXX  openerp.netsvc: column "value_date" of relation "banking_import_transaction" does not exist
LINE 1: insert into "banking_import_transaction" (id,"value_date","r...

Traceback (most recent call last):
  File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/openerp/addons/account_banking/wizard/bank_import.py", line 306, in import_statements_file
    cr, uid, values, context=context)
  File "/opt/openerp/server/openerp/addons/account_banking/banking_import_transaction.py", line 686, in create
    cr, uid, vals, context)
  File "/opt/openerp/server/openerp/osv/orm.py", line 4451, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "value_date" of relation "banking_import_transaction" does not exist
LINE 1: insert into "banking_import_transaction" (id,"value_date","r...

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

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

Title:
  import camt053.xml failed

Status in OpenERP Banking Addons:
  New

Bug description:
  when I try to import bank camt053.xml file with the with "generic camt format" the server gives an error, and nothing is imported.
  The error I get is the following:

  2014-07-04 13:31:42,954 30753 ERROR XXXXX  openerp.netsvc: column "value_date" of relation "banking_import_transaction" does not exist
  LINE 1: insert into "banking_import_transaction" (id,"value_date","r...

  Traceback (most recent call last):
    File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
      res = fn(db, uid, *params)
    File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/opt/openerp/server/openerp/addons/account_banking/wizard/bank_import.py", line 306, in import_statements_file
      cr, uid, values, context=context)
    File "/opt/openerp/server/openerp/addons/account_banking/banking_import_transaction.py", line 686, in create
      cr, uid, vals, context)
    File "/opt/openerp/server/openerp/osv/orm.py", line 4451, in create
      cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
    File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column "value_date" of relation "banking_import_transaction" does not exist
  LINE 1: insert into "banking_import_transaction" (id,"value_date","r...

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