Hi Team,

I tested the statement import again after replacing the previously downloaded App with the new download one and upgrading the App and its dependency Apps. It still does not work.

Could you please advise on the columns you are using for this App to work?

If I could make a suggestion, it would be for the App to give the user better error messages of what the App is expecting as an input and to advise on the spreadsheet columns or column names the App is trying to read. 

Therefore, it would be nice to have a guideline of what columns and column names you are using to get this App to work.

Here is my spreadsheet with dummy data which should be importing, but does not.

Thanks. Hope it helps.

What could be the reason for this error?

My date column in my statement.xlsx is set to a date category with dd/mm/yyyy format.

Here is the Odoo error:

Traceback (most recent call last):

  File "/opt/odoo/odoo/odoo/http.py", line 1788, in _serve_db

    return service_model.retrying(self._serve_ir_http, self.env)

  File "/opt/odoo/odoo/odoo/service/model.py", line 152, in retrying

    result = func()

  File "/opt/odoo/odoo/odoo/http.py", line 1816, in _serve_ir_http

    response = self.dispatcher.dispatch(rule.endpoint, args)

  File "/opt/odoo/odoo/odoo/http.py", line 2020, in dispatch

    result = self.request.registry['ir.http']._dispatch(endpoint)

  File "/opt/odoo/odoo/odoo/addons/base/models/ir_http.py", line 221, in _dispatch

    result = endpoint(**request.params)

  File "/opt/odoo/odoo/odoo/http.py", line 757, in route_wrapper

    result = endpoint(self, *args, **params_ok)

  File "/opt/odoo/odoo/addons/web/controllers/dataset.py", line 29, in call_button

    action = self._call_kw(model, method, args, kwargs)

  File "/opt/odoo/odoo/addons/web/controllers/dataset.py", line 21, in _call_kw

    return call_kw(Model, method, args, kwargs)

  File "/opt/odoo/odoo/odoo/api.py", line 484, in call_kw

    result = _call_kw_multi(method, model, args, kwargs)

  File "/opt/odoo/odoo/odoo/api.py", line 469, in _call_kw_multi

    result = method(recs, *args, **kwargs)

  File "/opt/odoo/odoo/addons/import_bank_statement_odoo/wizard/import_bank_statement.py", line 178, in action_statement_import

    line[2].date()

AttributeError: 'str' object has no attribute 'date'

The above server error caused the following client error:

RPC_ERROR: Odoo Server Error

    RPC_ERROR

        at makeErrorFromResponse (http://XX.X.X.XX:8069/web/assets/da62c2b/web.assets_web.min.js:XXXX:XXX)

        at XMLHttpRequest.<anonymous> (http://XX.X.X.XX:8069/web/assets/da62c2b/web.assets_web.min.js:XXXX:XX)

Validation Error

Account name is not set

Where are the formats for the CSV import described?

The following message appears when I try to use the app:

“Table name 'account_common_journal_report_account_report_horizontal_group_rel' is too long.”

Could you please assist with resolving this issue?

When I am trying to install this app in the Odoo 17 community version.it throws an error as follows. Let me know the solution to resolve this issue.

Traceback (most recent call last):

  File "/odoo/odoo-server/odoo/http.py", line 1764, in _serve_db

    return service_model.retrying(self._serve_ir_http, self.env)

  File "/odoo/odoo-server/odoo/service/model.py", line 133, in retrying

    result = func()

  File "/odoo/odoo-server/odoo/http.py", line 1791, in _serve_ir_http

    response = self.dispatcher.dispatch(rule.endpoint, args)

  File "/odoo/odoo-server/odoo/http.py", line 1995, in dispatch

    result = self.request.registry['ir.http']._dispatch(endpoint)

  File "/odoo/odoo-server/odoo/addons/base/models/ir_http.py", line 222, in _dispatch

    result = endpoint(**request.params)

  File "/odoo/odoo-server/odoo/http.py", line 741, in route_wrapper

    result = endpoint(self, *args, **params_ok)

  File "/odoo/odoo-server/addons/web/controllers/dataset.py", line 28, in call_button

    action = self._call_kw(model, method, args, kwargs)

  File "/odoo/odoo-server/addons/web/controllers/dataset.py", line 20, in _call_kw

    return call_kw(request.env[model], method, args, kwargs)

  File "/odoo/odoo-server/odoo/api.py", line 468, in call_kw

    result = _call_kw_multi(method, model, args, kwargs)

  File "/odoo/odoo-server/odoo/api.py", line 453, in _call_kw_multi

    result = method(recs, *args, **kwargs)

  File "", line 2, in button_immediate_install

  File "/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 75, in check_and_log

    return method(self, *args, **kwargs)

  File "/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 466, in button_immediate_install

    return self._button_immediate_function(self.env.registry[self._name].button_install)

  File "/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 590, in _button_immediate_function

    registry = modules.registry.Registry.new(self._cr.dbname, update_module=True)

  File "", line 2, in new

  File "/odoo/odoo-server/odoo/tools/func.py", line 87, in locked

    return func(inst, *args, **kwargs)

  File "/odoo/odoo-server/odoo/modules/registry.py", line 113, in new

    odoo.modules.load_modules(registry, force_demo, status, update_module)

  File "/odoo/odoo-server/odoo/modules/loading.py", line 480, in load_modules

    processed_modules += load_marked_modules(env, graph,

  File "/odoo/odoo-server/odoo/modules/loading.py", line 364, in load_marked_modules

    loaded, processed = load_module_graph(

  File "/odoo/odoo-server/odoo/modules/loading.py", line 227, in load_module_graph

    load_data(env, idref, mode, kind='data', package=package)

  File "/odoo/odoo-server/odoo/modules/loading.py", line 71, in load_data

    tools.convert_file(env, package.name, filename, idref, mode, noupdate, kind)

  File "/odoo/odoo-server/odoo/tools/convert.py", line 627, in convert_file

    convert_xml_import(env, module, fp, idref, mode, noupdate)

  File "/odoo/odoo-server/odoo/tools/convert.py", line 693, in convert_xml_import

    obj.parse(doc.getroot())

  File "/odoo/odoo-server/odoo/tools/convert.py", line 613, in parse

    self._tag_root(de)

  File "/odoo/odoo-server/odoo/tools/convert.py", line 567, in _tag_root

    raise ParseError(msg) from None  # Restart with "--log-handler odoo.tools.convert:DEBUG" for complete traceback

odoo.tools.convert.ParseError: while parsing /odoo/custom/addons/import_bank_statement_odoo-17.0.1.0.0/base_accounting_kit/views/res_config_view.xml:4

Error while parsing or validating view:

Element '' cannot be located in parent view

View error context:

{'file': '/odoo/custom/addons/import_bank_statement_odoo-17.0.1.0.0/base_accounting_kit/views/res_config_view.xml',

'line': 2,

'name': 'res.config.view.inherited.base.accounting.kit',

'view': ir.ui.view(1515,),

'view.model': 'res.config.settings',

'view.parent': ir.ui.view(735,),

'xmlid': 'es_config_settings_view_form_base_accounting_kit'}

The above server error caused the following client error:

RPC_ERROR://AAA.AAA.AAA.AA:8072/web/assets/99ad606/web.assets_web.min.js:2874:163)

    at XMLHttpRequest. (http://AAA.AAA.AAA.AA:8072/web/assets/99ad606/web.assets_web.min.js:2878:13)