import camt053.xml failed

[Knimmet]

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...

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

Did you install from the apps store? I'm afraid this easily allows the versions of the various modules to diverge. Seems that that is what happens here. Best thing is to install from bzr (sorry, GitHub ;-)

[Knimmet (temmink)]

I did install some of the modules from the launchpad (bzr).
(multibank/ing/mt940/ etc).

Do I have to install all of the modules from bzr?

You're mentioning Github. I cannot find the correct repository in Github.
Can you provide me the correct repository.

[Knimmet (temmink)]

the module and version I used:

"CAMT Format Bank Statements Import" version 7.0.0.1
with

Account Banking version 7.0.0.4

[Knimmet (temmink)]

is this the correct : https://github.com/OCA/bank-statement-reconcile

github url?

[Knimmet (temmink)]

I noticed there are 25 modules in that branch, on github.
Do I need to uninstall the "old banking add ons" from our server. and install all of the modules from that github repository?

[Knimmet (temmink)]

I had to restart the server and update all the banking modules including accounting (boekhouding).
After that, I could import the camt053 format successfully.

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

Thanks for reporting your solution. Yes, after a code update you need to restart OpenERP. I guess the app site does not tell you this.