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 |
Hi, Great addon !! I've
Hi,
Great addon !!
I've installed it in Odoo v8 and works at 50 %. print perfectly with excel but not work me with the export to pdf. I've read that it's neccesary a downgrade in version wkhtmtopdf from 0.9.4 to 0.8.3.. Is it neccesary ?
Is it possible that was another problem ?
Thank you very much for your work !! a great module !
Best Regards, Saúl.
The problem is not in
The problem is not in werkzeug.
It is not neccesary a downgrade, but to solve this you must modify, around line 183, the file controllers.py, changing from: cookies={'fileToken': int(token)})
to: cookies={'fileToken': token})
this work fo me (odoo 8.0).
As far as i know, this module
As far as i know, this module only available for openerp-v7 and odoo v8. how can i use this module for odoo saas 6. it is possible to make it function perfectly. i tried to install this module before, but it cannot work on odoo saas6. kindly help me. thank you.
Hi mp, Thank you for
Hi mp,
Thank you for your valuable information. I have made change in controllers.py based on your suggestion and updated module is attached with the blog.
now its ok but i have problem
now its ok but i have problem with arabic language in pdf export ?
(pdf print of odoo work in arabic without problem)
Thank you very much !!! I'll
Thank you very much !!!
I'll try it in this way.
Best Regards, Saúl.
Hi Prajul, I have test
Hi Prajul,
I have test web_printscreen_zb for version 8,
it can be installed, but there's some problem
For example:
1. Cannot print pdf when we click pdf button on it.
2. We can export it to excel by click the button excel, but when we want to make an exportation from the more>Export and choose the excel type we cannot export it again from there.
We have check this issue, and this is come when we installed your module, when we uninstalled it we can export in excel type.
Thank You.
Hi, This module is great!
Hi,
This module is great! When will this be available for v8?
Thanks!
Hi, I have attaced the
Hi,
I have attaced the migrated module with the blog...
Hello, This is very useful
Hello,
This is very useful module. What is the status of the migration to V8?