Rocker Reporting V3

for Odoo / Linux, Unix & Windows platforms

Odoo 12.0 & Odoo 13.0 & Odoo 14

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 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