account_payroll_sheet_import
in account-financial-tools · source on GitHub
Import payroll from sheet files and generate journal entries
Category: Accounting · APSL-Nagarro · AGPL-3
| Series | Status | Details | Code |
|---|---|---|---|
| 16.0 | —Not tested | no branch | |
| 17.0 | ✗Install error | UNRECOGNISED: ValueError: numpy.dtype size changed, may indicate binary incompatibility. Expected 96 from C header, got 88 from PyObject · run 2026-08-27 | on GitHub |
| 18.0 | ✓Installs | · run 2026-08-22 · 18.0.1.0.0 | on GitHub |
| 19.0 | ✓Installs | · run 2026-08-19 · 19.0.1.0.0 | on GitHub |
| 20.0 | —Not tested | no branch |
Odoo 20.0 dev — development line
A different statement from the table above. There: the module as published, on a released platform. Here: the module’s code with its manifest version mechanically raised, on a platform that has not been released and changes daily.
| Status | Details |
|---|---|
| ✗fails | The same code installs on 19.0; on the development line it does not. The difference belongs to the platform. (model_gone) · failed in a file of this module: account_payroll_sheet_import/security/payroll_import_security.xml · version 19.0.1.0.0 → 19.5.1.0.0, code unchanged · run 2026-09-10 · odoo 19.5 · modidx/odoo:master-deps-20260910 |
Log excerpt, 20.0 dev
2026-09-10 15:43:16,049 1 INFO job_820b77530166 odoo.modules.loading: Loading module account_payroll_sheet_import (50/55)
2026-09-10 15:43:16,837 1 INFO job_820b77530166 odoo.registry: module account_payroll_sheet_import: creating or updating database tables
2026-09-10 15:43:17,222 1 INFO job_820b77530166 odoo.modules.loading: loading account_payroll_sheet_import/security/payroll_import_security.xml
2026-09-10 15:43:17,513 1 WARNING job_820b77530166 odoo.modules.loading: Transient module states were reset
2026-09-10 15:43:17,515 1 ERROR job_820b77530166 odoo.registry: Failed to load registry
2026-09-10 15:43:17,515 1 CRITICAL job_820b77530166 odoo.service.server: Failed to initialize database `job_820b77530166`.
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 628, in _tag_root
f(rec)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 362, in _tag_record
model = env[rec_model]
~~~^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/orm/environments.py", line 107, in __getitem__
return self.registry[model_name](self, (), ())
~~~~~~~~~~~~~^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/orm/registry.py", line 385, in __getitem__
return self.models[model_name]
~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 'ir.rule'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 1559, in preload_registries
registry = Registry.new(dbname, update_module=update_module, install_modules=config['init'], upgrade_modules=config['update'], reinit_modules=config['reinit'])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 67, in locked
return func(inst, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/orm/registry.py", line 222, in new
contextvars.Context().run(
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 446, in load_modules
load_module_graph(
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 211, in load_module_graph
load_data(env, idref, 'init', kind='data', package=package)
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 56, in load_data
convert_file(env, package.name, filename, idref, mode, noupdate=kind == 'demo')
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 716, in convert_file
convert_xml_import(env, module, fp, idref, mode, noupdate)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 815, in convert_xml_import
obj.parse(doc.getroot())
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 686, in parse
self._tag_root(de)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 641, in _tag_root
raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /mnt/pool/account_payroll_sheet_import/security/payroll_import_security.xml:3, somewhere inside
<record id="payroll_import_mapping_multi" model="ir.rule">
<field name="name">payroll import mapping multi-company</field>
<field ref="model_payroll_import_mapping" name="model_id"/>
<field eval="True" name="global"/>
<field name="domain_force">['|', ('company_id', '=', False), ('company_id', 'in', company_ids)]</field>
</record>
2026-09-10 15:43:17,522 1 INFO job_820b77530166 odoo.service.server.ThreadedServer: Initiating shutdown
2026-09-10 15:43:17,522 1 INFO job_820b77530166 odoo.service.server.ThreadedServer: Hit CTRL-C again or send a second signal to force the shutdown.
2026-09-10 15:43:17,522 1 INFO job_820b77530166 odoo.addons.bus.websocket: Disconnecting 0 websockets
2026-09-10 15:43:17,624 1 INFO job_820b77530166 odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 1 connectionsProvenance: __manifest__.py sha256 2b48d6cd2086c753… · tree of 27 files without the manifest, sha256 3f4fbbda35d74631…
This does not say the module is compatible with Odoo 20.0, and does not say it installs on Odoo 20.0 — on a stock platform it will not, until its maintainer raises the version. Why we raise the version
Odoo 20.0 — the branch itself
The same frozen code, run again against the real 20.0 branch. The run above used Odoo’s development line before the branch was cut; this one used the branch, pinned to one commit.
| Status | Details |
|---|---|
| ✗fails | The same code installs on 19.0; on the development line it does not. The difference belongs to the platform. (model_gone) · failed in a file of this module: account_payroll_sheet_import/security/payroll_import_security.xml · version 19.0.1.0.0 → 20.0.1.0.0, code unchanged · run 2026-09-18 · odoo 20.0 · modidx/odoo:20.0-deps-20260918 |
Log excerpt, 20.0 dev
2026-09-18 23:31:59,458 1 INFO job_25c558e04e9d odoo.modules.loading: Loading module account_payroll_sheet_import (50/55)
2026-09-18 23:32:00,490 1 INFO job_25c558e04e9d odoo.registry: module account_payroll_sheet_import: creating or updating database tables
2026-09-18 23:32:00,906 1 INFO job_25c558e04e9d odoo.modules.loading: loading account_payroll_sheet_import/security/payroll_import_security.xml
2026-09-18 23:32:01,198 1 WARNING job_25c558e04e9d odoo.modules.loading: Transient module states were reset
2026-09-18 23:32:01,199 1 ERROR job_25c558e04e9d odoo.registry: Failed to load registry
2026-09-18 23:32:01,200 1 CRITICAL job_25c558e04e9d odoo.service.server: Failed to initialize database `job_25c558e04e9d`.
Traceback (most recent call last):
File "/opt/odoo/odoo/tools/convert.py", line 630, in _tag_root
f(rec)
File "/opt/odoo/odoo/tools/convert.py", line 362, in _tag_record
model = env[rec_model]
~~~^^^^^^^^^^^
File "/opt/odoo/odoo/orm/environments.py", line 107, in __getitem__
return self.registry[model_name](self, (), ())
~~~~~~~~~~~~~^^^^^^^^^^^^
File "/opt/odoo/odoo/orm/registry.py", line 385, in __getitem__
return self.models[model_name]
~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 'ir.rule'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/odoo/odoo/service/server.py", line 1520, in preload_registries
registry = Registry.new(dbname, update_module=update_module, install_modules=config['init'], upgrade_modules=config['update'], reinit_modules=config['reinit'])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/odoo/tools/func.py", line 67, in locked
return func(inst, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/odoo/orm/registry.py", line 222, in new
contextvars.Context().run(
File "/opt/odoo/odoo/modules/loading.py", line 449, in load_modules
load_module_graph(
File "/opt/odoo/odoo/modules/loading.py", line 211, in load_module_graph
load_data(env, idref, 'init', kind='data', package=package)
File "/opt/odoo/odoo/modules/loading.py", line 56, in load_data
convert_file(env, package.name, filename, idref, mode, noupdate=kind == 'demo')
File "/opt/odoo/odoo/tools/convert.py", line 718, in convert_file
convert_xml_import(env, module, fp, idref, mode, noupdate)
File "/opt/odoo/odoo/tools/convert.py", line 817, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/odoo/odoo/tools/convert.py", line 688, in parse
self._tag_root(de)
File "/opt/odoo/odoo/tools/convert.py", line 643, in _tag_root
raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /mnt/pool/account_payroll_sheet_import/security/payroll_import_security.xml:3, somewhere inside
<record id="payroll_import_mapping_multi" model="ir.rule">
<field name="name">payroll import mapping multi-company</field>
<field ref="model_payroll_import_mapping" name="model_id"/>
<field eval="True" name="global"/>
<field name="domain_force">['|', ('company_id', '=', False), ('company_id', 'in', company_ids)]</field>
</record>
2026-09-18 23:32:01,215 1 INFO job_25c558e04e9d odoo.service.server.ThreadedServer: Initiating shutdown
2026-09-18 23:32:01,216 1 INFO job_25c558e04e9d odoo.service.server.ThreadedServer: Hit CTRL-C again or send a second signal to force the shutdown.
2026-09-18 23:32:01,217 1 INFO job_25c558e04e9d odoo.addons.bus.websocket: Disconnecting 0 websockets
2026-09-18 23:32:01,319 1 INFO job_25c558e04e9d odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 1 connectionsProvenance: __manifest__.py sha256 2b48d6cd2086c753… · tree of 27 files without the manifest, sha256 3f4fbbda35d74631…
This does not say the module is compatible with Odoo 20.0, and does not say it installs on Odoo 20.0 — on a stock platform it will not, until its maintainer raises the version. Why we raise the version
The module’s code on 19.0
| Lines of code | python 511 · xml 186 |
| Tests | yes: 1 file(s), 225 lines |
| Migration scripts | no |
| Models | 4 new · 0 extensions |
Lines are physical, blanks and comments included, as wc -l. Tests are test_*.py files under tests/. Models are lines holding _name = and _inherit =. These are facts about the code, not a judgement: more lines is neither better nor worse. Measured 2026-08-28 on tree e81c87ccaa12.
The apps.odoo.com catalogue has a listing under the same technical name on 17.0, 18.0: apps.odoo.com/apps/modules/18.0/account_payroll_sheet_import. A matching name does not prove matching code — how we counted this.
Depends on
| Module | Status | Checked |
|---|---|---|
| account | core | ships with Odoo |
| hr | core | ships with Odoo |
External dependencies
Checked against modidx/odoo:19.0-deps-20260922.
| Kind | Package | In our image |
|---|---|---|
| python | pandas | in image |
| python | openpyxl>=3.1.0 | in image |
History
| Last change | 2026-08-17 |
| Code commits, 12 months | 5 |
| Most active | BernatObrador, bobrador |
| Files | 28 |
Translation and bot commits are excluded from the commit count.
Install log 17.0
Time Off Management
-----------------
2026-08-27 07:56:44,984 1 CRITICAL job_4e43f8044fbc odoo.modules.module: Couldn't load module account_payroll_sheet_import
2026-08-27 07:56:44,995 1 WARNING job_4e43f8044fbc odoo.modules.loading: Transient module states were reset
2026-08-27 07:56:44,996 1 ERROR job_4e43f8044fbc odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 99, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 485, in load_modules
processed_modules += load_marked_modules(env, graph,
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 366, in load_marked_modules
loaded, processed = load_module_graph(
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 187, in load_module_graph
load_openerp_module(package.name)
File "/usr/lib/python3/dist-packages/odoo/modules/module.py", line 424, in load_openerp_module
__import__(qualname)
File "/mnt/pool/account_payroll_sheet_import/__init__.py", line 2, in <module>
from . import wizard
File "/mnt/pool/account_payroll_sheet_import/wizard/__init__.py", line 1, in <module>
from . import payroll_import_wizard
File "/mnt/pool/account_payroll_sheet_import/wizard/payroll_import_wizard.py", line 8, in <module>
import pandas as pd
File "/usr/local/lib/python3.10/dist-packages/pandas/__init__.py", line 22, in <module>
from pandas.compat import is_numpy_dev as _is_numpy_dev # pyright: ignore # noqa:F401
File "/usr/local/lib/python3.10/dist-packages/pandas/compat/__init__.py", line 18, in <module>
from pandas.compat.numpy import (
File "/usr/local/lib/python3.10/dist-packages/pandas/compat/numpy/__init__.py", line 4, in <module>
from pandas.util.version import Version
File "/usr/local/lib/python3.10/dist-packages/pandas/util/__init__.py", line 2, in <module>
from pandas.util._decorators import ( # noqa:F401
File "/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py", line 14, in <module>
from pandas._libs.properties import cache_readonly
File "/usr/local/lib/python3.10/dist-packages/pandas/_libs/__init__.py", line 13, in <module>
from pandas._libs.interval import Interval
File "pandas/_libs/interval.pyx", line 1, in init pandas._libs.interval
ValueError: numpy.dtype size changed, may indicate binary incompatibility. Expected 96 from C header, got 88 from PyObject
2026-08-27 07:56:45,010 1 CRITICAL job_4e43f8044fbc odoo.service.server: Failed to initialize database `job_4e43f8044fbc`.
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 1422, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "<decorator-gen-16>", line 2, in new
File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 99, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 485, in load_modules
processed_modules += load_marked_modules(env, graph,
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 366, in load_marked_modules
loaded, processed = load_module_graph(
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 187, in load_module_graph
load_openerp_module(package.name)
File "/usr/lib/python3/dist-packages/odoo/modules/module.py", line 424, in load_openerp_module
__import__(qualname)
File "/mnt/pool/account_payroll_sheet_import/__init__.py", line 2, in <module>
from . import wizard
File "/mnt/pool/account_payroll_sheet_import/wizard/__init__.py", line 1, in <module>
from . import payroll_import_wizard
File "/mnt/pool/account_payroll_sheet_import/wizard/payroll_import_wizard.py", line 8, in <module>
import pandas as pd
File "/usr/local/lib/python3.10/dist-packages/pandas/__init__.py", line 22, in <module>
from pandas.compat import is_numpy_dev as _is_numpy_dev # pyright: ignore # noqa:F401
File "/usr/local/lib/python3.10/dist-packages/pandas/compat/__init__.py", line 18, in <module>
from pandas.compat.numpy import (
File "/usr/local/lib/python3.10/dist-packages/pandas/compat/numpy/__init__.py", line 4, in <module>
from pandas.util.version import Version
File "/usr/local/lib/python3.10/dist-packages/pandas/util/__init__.py", line 2, in <module>
from pandas.util._decorators import ( # noqa:F401
File "/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py", line 14, in <module>
from pandas._libs.properties import cache_readonly
File "/usr/local/lib/python3.10/dist-packages/pandas/_libs/__init__.py", line 13, in <module>
from pandas._libs.interval import Interval
File "pandas/_libs/interval.pyx", line 1, in init pandas._libs.interval
ValueError: numpy.dtype size changed, may indicate binary incompatibility. Expected 96 from C header, got 88 from PyObjectResult looks wrong? Tell us — we will show the log or run it again. Report a wrong result