banking-addons-team team mailing list archive

[Denis Roussel <roussel2nis@xxxxxxxxx>]

Public bug reported:

When you want to import an OFX file from a Belgian bank (e.g. FORTIS),
you have an 'Invalid Transaction Amount' exception from Ofx parser.

The transaction amounts are represented with a comma as decimal point.


Client Traceback (most recent call last):
  File "/media/data/openerp/server/openerp/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/media/data/openerp/server/openerp/addons/web/controllers/main.py", line 1129, in call_button
    action = self._call_kw(req, model, method, args, {})
  File "/media/data/openerp/server/openerp/addons/web/controllers/main.py", line 1117, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/media/data/openerp/server/openerp/addons/web/session.py", line 42, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/media/data/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/media/data/openerp/server/openerp/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/media/data/openerp/server/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/media/data/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/media/data/openerp/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/media/data/openerp/server/openerp/osv/osv.py", line 190, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/media/data/openerp/server/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/media/data/openerp/server/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/media/data/openerp/server/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/media/data/openerp/addons/account_statement_base_import/wizard/import_statement.py", line 108, in import_statement
    context=context
  File "/media/data/openerp/addons/account_statement_base_import/statement.py", line 150, in statement_import
    result_row_list = parser.parse(file_stream)
  File "/media/data/openerp/addons/account_statement_base_import/parser/parser.py", line 148, in parse
    self._parse(*args, **kwargs)
  File "/media/data/openerp/addons/account_statement_ofx_import/parser/ofx_parser.py", line 69, in _parse
    ofx = ofxparse.OfxParser.parse(file(ofx_file.name))
  File "/usr/local/lib/python2.7/dist-packages/ofxparse-0.14-py2.7.egg/ofxparse/ofxparse.py", line 345, in parse
    ofx_obj.accounts += cls_.parseStmtrs(stmtrs_ofx, AccountType.Bank)
  File "/usr/local/lib/python2.7/dist-packages/ofxparse-0.14-py2.7.egg/ofxparse/ofxparse.py", line 646, in parseStmtrs
    account.statement = cls_.parseStatement(stmtrs_ofx)
  File "/usr/local/lib/python2.7/dist-packages/ofxparse-0.14-py2.7.egg/ofxparse/ofxparse.py", line 736, in parseStatement
    cls_.parseTransaction(transaction_ofx))
  File "/usr/local/lib/python2.7/dist-packages/ofxparse-0.14-py2.7.egg/ofxparse/ofxparse.py", line 792, in parseTransaction
    six.u("Invalid Transaction Amount: '%s'") % amt_tag.contents[0])
OfxParserException: Invalid Transaction Amount: '-72,00'

** 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/1271478

Title:
  OfxParserException : Invalid Transaction Amount

Status in OpenERP Banking Addons:
  New

Bug description:
  When you want to import an OFX file from a Belgian bank (e.g. FORTIS),
  you have an 'Invalid Transaction Amount' exception from Ofx parser.

  The transaction amounts are represented with a comma as decimal point.


  
  Client Traceback (most recent call last):
    File "/media/data/openerp/server/openerp/addons/web/http.py", line 204, in dispatch
      response["result"] = method(self, **self.params)
    File "/media/data/openerp/server/openerp/addons/web/controllers/main.py", line 1129, in call_button
      action = self._call_kw(req, model, method, args, {})
    File "/media/data/openerp/server/openerp/addons/web/controllers/main.py", line 1117, in _call_kw
      return getattr(req.session.model(model), method)(*args, **kwargs)
    File "/media/data/openerp/server/openerp/addons/web/session.py", line 42, in proxy
      result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
    File "/media/data/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method
      result = self.session.send(self.service_name, method, *args)
    File "/media/data/openerp/server/openerp/addons/web/session.py", line 103, in send
      raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

  
  Server Traceback (most recent call last):
    File "/media/data/openerp/server/openerp/addons/web/session.py", line 89, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/media/data/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/media/data/openerp/server/openerp/service/web_services.py", line 626, in dispatch
      res = fn(db, uid, *params)
    File "/media/data/openerp/server/openerp/osv/osv.py", line 190, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/media/data/openerp/server/openerp/osv/osv.py", line 132, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/media/data/openerp/server/openerp/osv/osv.py", line 199, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/media/data/openerp/server/openerp/osv/osv.py", line 187, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/media/data/openerp/addons/account_statement_base_import/wizard/import_statement.py", line 108, in import_statement
      context=context
    File "/media/data/openerp/addons/account_statement_base_import/statement.py", line 150, in statement_import
      result_row_list = parser.parse(file_stream)
    File "/media/data/openerp/addons/account_statement_base_import/parser/parser.py", line 148, in parse
      self._parse(*args, **kwargs)
    File "/media/data/openerp/addons/account_statement_ofx_import/parser/ofx_parser.py", line 69, in _parse
      ofx = ofxparse.OfxParser.parse(file(ofx_file.name))
    File "/usr/local/lib/python2.7/dist-packages/ofxparse-0.14-py2.7.egg/ofxparse/ofxparse.py", line 345, in parse
      ofx_obj.accounts += cls_.parseStmtrs(stmtrs_ofx, AccountType.Bank)
    File "/usr/local/lib/python2.7/dist-packages/ofxparse-0.14-py2.7.egg/ofxparse/ofxparse.py", line 646, in parseStmtrs
      account.statement = cls_.parseStatement(stmtrs_ofx)
    File "/usr/local/lib/python2.7/dist-packages/ofxparse-0.14-py2.7.egg/ofxparse/ofxparse.py", line 736, in parseStatement
      cls_.parseTransaction(transaction_ofx))
    File "/usr/local/lib/python2.7/dist-packages/ofxparse-0.14-py2.7.egg/ofxparse/ofxparse.py", line 792, in parseTransaction
      six.u("Invalid Transaction Amount: '%s'") % amt_tag.contents[0])
  OfxParserException: Invalid Transaction Amount: '-72,00'

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