Skip to Content

Rocker Reporting Application v3

by
Odoo
v 15.0 Third Party 1 599
Download for v 15.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 1606
Technical Name rocker_app_v3
LicenseAGPL-3
Versions 12.0 13.0 14.0 15.0 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 1606
Technical Name rocker_app_v3
LicenseAGPL-3
Versions 12.0 13.0 14.0 15.0 16.0 17.0 18.0

Rocker Reporting V3

for Odoo / Linux, Unix & Windows platforms

Odoo 12.0 & Odoo 13.0 & Odoo 14 & Odoo 15

Collect data to Excel or Powerpoint from various data sources, Present business data with Powerpoint graphs. Or use Excel templates to present business graphs. Get data from Odoo & external PostgreSQL, SQLServer, MySQL, MariaDB, ODBC or Oracle databases. Send reports by email.

Requirements:

  1. Odoo 12 or Odoo 13 or Odoo 14 or Odoo 15 installed
  2. Support Linux, Unix & Windows servers
  3. Does not need Excel or PowerPoint installed on server
  4. Openpyxl, Python-PPTX & Pandas python packages installed on server
  5. Datasource drivers (PostgreSQL, SQLServer, Oracle, MySQL, MariaDB etc.) installed on server based on your needs

News/Notes:

  • 3.2.2021
    Fixed access rules
  • 3.2.2021
    Fixed some deprecated tags
  • 2.2.2021
    Can't have 2 modules with same technical name in Odoo Apps. Renamed
    rocker_app --> rocker_app_v3
    Easier to install
  • 22.1.2021
    Rocker can be installed on Linux Odoo. Excel are created with the help of Openpyxl, Powerpoints with Python-pptx packages.
    Does not support Excel 2016 PowerPivot but Excel 2016 or Office365 can be used for opening/viewwing reports.
    Charts can not base on Excel Tables but Rocker creates dynamic ranges for creating charts on Sheets.

  • 22.1.2021
    Odoo for Windows & Win32Api version of Rocker can be found from separate repository. This version uses openpyxl & python-pptx python packages

  • 25.3.2020
    Send reports by Email. When scheduled report is ready then it can be sent by email. Also fixed some scheduler issues.

  • 19.3.2020
    With V2 you can create Powerpoints. Download newest version, install python-pptx on the server and that's it! Watch the demo: Powerpoint demo on Youtube

  • 24.2.2020
    Did you create nice report that takes data from Odoo or other well known Application?
    Why don't you share it with others. Upload your Excel template, SQL & screendump to Rocker_Templates repository

    Author contact: antti.rocker.karki@outlook.com

Guides:

Guides in zip/rocker_app_v3_static/description -folder
  1. Excel Charts/Pivots User Guide
  2. Email User Guide
  3. Powerpoint User Guide
  4. Install Guide

Examples:

  1. Powerpoints: Powerpoint table slide


  2. Powerpoints: Powerpoint Column Chart slide


  3. Powerpoints: Powerpoint Pie Chart slide


  4. Powerpoints: Powerpoint Collection


  5. Rocker Excel example: Data from single datasource


  6. Rocker Excel example: Collection reports, data from many datasources

Demos:

  1. View Powerpoint demo


  2. View Basic demo


  3. Get data from SQLServer demo


  4. Collection Reports demo, get data from many data sources


  5. Access rights demo


  6. Hyperlinks demo


  7. Scheduler demo

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
Issue installing Rocker Reporting Application v3
by
caesar13
on 6/26/22, 1:07 PM

Hi, I have this issue when I want to install the module. Any help?

Traceback (most recent call last):
  File "C:\Odoo 15\server\odoo\addons\base\models\ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "C:\Odoo 15\server\odoo\http.py", line 687, in dispatch
    result = self._call_function(**self.params)
  File "C:\Odoo 15\server\odoo\http.py", line 359, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "C:\Odoo 15\server\odoo\service\model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "C:\Odoo 15\server\odoo\http.py", line 348, in checked_call
    result = self.endpoint(*a, **kw)
  File "C:\Odoo 15\server\odoo\http.py", line 916, in __call__
    return self.method(*args, **kw)
  File "C:\Odoo 15\server\odoo\http.py", line 535, in response_wrap
    response = f(*args, **kw)
  File "C:\Odoo 15\server\odoo\addons\web\controllers\main.py", line 1351, in call_button
    action = self._call_kw(model, method, args, kwargs)
  File "C:\Odoo 15\server\odoo\addons\web\controllers\main.py", line 1339, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "C:\Odoo 15\server\odoo\api.py", line 464, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "C:\Odoo 15\server\odoo\api.py", line 451, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "<decorator-gen-74>", line 2, in button_immediate_install
  File "C:\Odoo 15\server\odoo\addons\base\models\ir_module.py", line 74, in check_and_log
    return method(self, *args, **kwargs)
  File "C:\Odoo 15\server\odoo\addons\base\models\ir_module.py", line 483, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "C:\Odoo 15\server\odoo\addons\base\models\ir_module.py", line 600, in _button_immediate_function
    registry = modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "C:\Odoo 15\server\odoo\modules\registry.py", line 87, in new
    odoo.modules.load_modules(registry, force_demo, status, update_module)
  File "C:\Odoo 15\server\odoo\modules\loading.py", line 476, in load_modules
    loaded_modules, update_module, models_to_check)
  File "C:\Odoo 15\server\odoo\modules\loading.py", line 365, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "C:\Odoo 15\server\odoo\modules\loading.py", line 179, in load_module_graph
    load_openerp_module(package.name)
  File "C:\Odoo 15\server\odoo\modules\module.py", line 396, in load_openerp_module
    __import__('odoo.addons.' + module_name)
  File "C:\Odoo 15\server\odoo\addons\rocker_app_v3\__init__.py", line 3, in <module>
    from . import models
  File "C:\Odoo 15\server\odoo\addons\rocker_app_v3\models\__init__.py", line 4, in <module>
    from . import rocker_report
  File "C:\Odoo 15\server\odoo\addons\rocker_app_v3\models\rocker_report.py", line 34, in <module>
    import openpyxl as op
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\Odoo 15\server\odoo\http.py", line 643, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "C:\Odoo 15\server\odoo\http.py", line 301, in _handle_exception
    raise exception.with_traceback(None) from new_cause
ModuleNotFoundError: No module named 'openpyxl'
Re: Issue installing Rocker Reporting Application v3
by
Antti Kärki
on 6/30/22, 3:57 AM Author

Install openpyxl package. Read install guide

by
Mohamed Omary
on 3/4/22, 11:56 AM

Can you send me template sample excel 2016

Re:
by
Antti Kärki
on 3/4/22, 1:05 PM Author

Run your report first without a template. Rocker will create new empty excel and adds datasheet to it with your data. Save that one to disk, modify it as you like but do not add tables to data sheet, instead use copy/paste link. Then upload that one to Odoo to be a template. Next run will populate the datasheet with new data.

Antti 

Email: antti.rocker.karki@outlook.com


by
Mohamed Omary
on 3/4/22, 11:55 AM

Hi sir

Excel 2016

Re:
by
Antti Kärki
on 3/7/22, 4:43 AM Author

Upgrade openpyxl package

Error When run Report
by
Mohamed Omary
on 3/3/22, 6:07 AM 
File "/odoo/custom/omari/rocker_app_v3/models/rocker_report.py", line 208, in export_report
    self.export_xls(self)
  File "/odoo/custom/omari/rocker_app_v3/models/rocker_report.py", line 413, in export_xls
    self._populate_sql(con, workbook, worksheet, self.select_clause, self.column_headings)
  File "/odoo/custom/omari/rocker_app_v3/models/rocker_report.py", line 550, in _populate_sql
    for tbl in worksheet.tables:
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/odoo/odoo-server/odoo/http.py", line 644, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/odoo/odoo-server/odoo/http.py", line 302, in _handle_exception
    raise exception.with_traceback(None) from new_cause
AttributeError: 'Worksheet' object has no attribute 'tables'
Re: Error When run Report
by
Antti Kärki
on 3/3/22, 7:15 AM Author

Which Excel version you are using? Does your excel template contain tables on data sheet?

Run odoo in debug mode. Then you might get:

_logger.debug('Warning: Sheet ' + worksheet.title + ' has a table ' + tbl + '. If it is overlapping with data area, Excel might be corrupted')