Rocker Reporting Application
for Odoo 12.0 / Odoo 13.0 / Odoo 14.0
Collect data to single Excel from various data sources, Use Excel templates to present business graphs. Combine data with Excel Power Pivot. Get data from Odoo & external PostgreSQL, SQLServer, MySQL, MariaDB, ODBC or Oracle databases.
News/Notes:
- 15.2.2021
At the moment we have a problem starting Excel if Odoo runs as a service.
Everything works well if you start Odoo from command prompt. See install guide in docs folder.If someone knows the solution to: excel = win32.gencache.EnsureDispatch('Excel.Application') causing (-2147023584, 'A specified logon session does not exist. It may already have been terminated.', None, None) error, pls email.
Openpyxl version https://apps.odoo.com/apps/modules/14.0/rocker_app_v3/ does not have a problem but this one supports all Excel 2016 features including Power Pivot
Author contact: antti.rocker.karki@outlook.com
Requirements:
- Odoo 12 or Odoo 13 or Odoo 14 installed on Windows platform
- Excel installed on server
- Datasource drivers (PostgreSQL, SQLServer, Oracle, MySQL, MariaDB etc.) installed on server based on your needs
Examples:
-
Powerpoints: Powerpoint table slide
-
Powerpoints: Powerpoint Column Chart slide
-
Powerpoints: Powerpoint Pie Chart slide
-
Powerpoints: Powerpoint Collection
-
Rocker Excel example: Data from single datasource
-
Rocker Excel example: Collection reports, data from many datasources
Guides:
- Install guide
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedEmailing added
Now you can create Excel & Powerpoint reports. And run them scheduled and send them by Email. What do you think I should develop next? Maybe XML or CSV formatted reports for integration purposes? Or should I make some kind of UPSERT funtionality for managing data between 2 separate databases? Or add more datasources like XML / SOAP / REST? Antti PS some feedback would be appreciated
ubuntu, linux support
i want to try your addon but we cant install with ubuntu 18,04 LTS pywin32 doesnt support currenlty python 3+, have you got any offer ?
Re: ubuntu, linux support
Noup. Openpyxl (or other packages) do not support Excel 2016 (or Office 365) Power Pivot models. And I like to use Powerpivot models to combine data. But why don't you set up a separate windows server to get get your data...does not need to be the same odoo server
I need to use this add on on win 64 bit and excel 64 bit. Can you help me?
Error in Create Report
Error: Uncaught TypeError: Widget is not a constructor http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1598 Traceback: TypeError: Widget is not a constructor at Class._renderWidget (http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1598:635) at Class._renderTagWidget (http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1663:1147) at Class._renderNode (http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1648:246) at http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1645:178 at Function._.each._.forEach (http://localhost:8069/web/content/350-2f901dc/web.assets_common.js:12:558) at Class._renderInnerGroup (http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1642:63) at Class._renderTagGroup (http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1656:228) at Class._renderNode (http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1648:246) at Function._.map._.collect (http://localhost:8069/web/content/350-2f901dc/web.assets_common.js:13:270) at Class._renderTagSheet (http://localhost:8069/web/content/361-d2010df/web.assets_backend.js:1663:1039)
Re: Error in Create Report
Nothing from that look familiar to me, are you sure it comes from rocker_app
Request Customization
Hello, can you contact me for my some customization? live:29dda3336b07b4fb
Re: Request Customization
You can send email to me ( antti.rocker.karki@outlook.com ). Tell me what kind of customization you need.