Advanced Printscreen for Odoo 7 and Odoo 8(Analytic Report Printing)
Printscreen has been and is an attractive feature of OpenERP. But unfortunately this feature was available for OpenERP 6.1 GTK Client. OpenERP 7 provide an functionality to print the current view in PDF.
You may have already noticed that i have already published a blog named "Printscreen in OpenERP 7 which was a migrated module from web_export_view with few my own functionality added to it. But now we have developed a new module called web_printscreen_zb with some new features that might be helpful to users of OpenERP 7.
The main features of this module are:
- Ability to export view in both PDF as well as in Excel.
- Ability to export analytic views in to PDF and Excel including group totals.
- Hierarchical view of the groups.
The module can be installed as a normal OpenERP module. The only python dependency that is need for the module is python-xlwt which is needed to export to xls file. This can be installed using the comment "sudo apt-get install python-xlwt" for Ubuntu. After installing the module, you can see two anchor buttons called "Export to PDF" and "Export to Excel" on the right side of the OpenERP web client as shown in the screenshot below:
These buttons will only appear if the active view is a tree view. This button wont be visible in any of the other view types. When the button "Export to PDF" is clicked, the report will be exported to PDF or if "Export to Excel", the report will be printed in "Excel". The heading and the totals will be printed in Bold. A sample screenshot of the excel and PDF report is shown below:
The module also allows to print analytic reports in to CSV of excel. The screenshot below shows an analytic view:
You can also see the "Export to Excel" and "Export to PDF" in the top right side of the view. If you click the button "Export to Excel", it will be exported to excel else if "Export to PDF", it will be exported to "PDF". A sample report is shown below:
A video showing the functionality of the module is shown below:
The module is attached with the blog. Module is also shared at https://github.com/zbeanz/openerp-7-web-addons. Module can also be downloaded from launchpad bzr branch lp:~r-launchpadzbeanz/zbeanz/addons.
Module is also available in Odoo 8. Module is attached with the blog.
Attachment | Size |
---|---|
web_printscreen_zb_24_mar_v7.zip | 18.16 KB |
web_printscreen_zb_24_mar_v8.zip | 18.69 KB |
unfortunately without
unfortunately without success, I still have the same problem even if I empty the cash and I reload the browser, any ideas
Journal items can't be
Journal items can't be exported, however it is shown as a tree view.
If I go to Accounting/Journal Entries/Journal items menu and I set the filters, I can't see the PDF and Excel export buttons.
It would be good if it would work.
Thanks again for this module.
Best regards,
TArpi
I've been using the old
I've been using the old module. Today I had a problem with the decimal separator. I looked on your web page, and I saw the improved version. I installed, and now everything is OK.
Thank you for this useful module. You should add to the official "openerp.com/apps"!
Thanks again!
TArpi
This is a wonderful custom
This is a wonderful custom module. My question is how do you install this module in your openerp that runs online (Not the demo openerp from official site but yours you install to run in a web server) and not local (it worked for local openerp installation on window).
ASAP
Hi, This module can be
Hi,
This module can be installed and used as any other normal OpenERP module. The server should have python-xlwt python package installed.
When i export to excel with
When i export to excel with 2000 record, server raise error
raise ValueError("More than 4094 XFs (styles)")
ValueError: More than 4094 XFs (styles)
How can i solve this? I made
How can i solve this?
I made some alterations to the module, but i get the error:
raise ValueError("More than 4094 XFs (styles)")
Where is this bug? Thanx
Hi, I have solved the
Hi,
I have solved the issue. Please check now...
Thanks for reporting this issue...
I receive the same
I receive the same error.
BTW, this is a great tool.
Now it's ok, it's very good,
Now it's ok, it's very good, thank you very much