Skip to Content

Rocker Reporting Application v3

by
Odoo

$ 11.72

v 15.0 Third Party 1
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 1606
Technical Name rocker_app_v3
LicenseOPL-1
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
LicenseOPL-1
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

Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

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 or have a question related to your purchase, please use the support page.
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')