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 Bryan, Thank You
Hi Bryan,
Thank You for suggesting the method to solve this issue. Your solution is good but i have a suggestion on that. Line 75 in controller.py was meant to convert values like amount, total etc that are of type float to float in excel file. If we change this line, the amount will be shown as string in excel file. I think the better way can be converting these type of fields in to float from js itself. In js, OpenERP has a build in function to do this job ie; instance.web.parse_value(text, { type:"float" }). If we use this method, the float values will be shown as float itself in excel file. I have made changes in the module and updated in my blog and in github. Please take a look at the module and inform me if you have any suggestions.
Valuable feedbacks like this are always welcome...
Hi, The new module is
Hi,
The new module is entirely different from the older module web_printscreen. Please make sure you have the latest OpenERP 7 server. If the problem persist, feel free to inform me..
Is there a similar module or
Is there a similar module or functionality that can be used with v 6.1? Looking for a module that can work in same manner and can print data of search view too.
Hi, Unfortunately this
Hi,
Unfortunately this module is not available in v6.1. For printing tree view in Excel there is a module named web_export_view which can be downloaded from from https://apps.openerp.com/apps/6.1/web_export_view/.
The version Openerp 7 is
The version Openerp 7 is Version 7.0-20130729-231030.
I've installed Print Screen Module with Print Screen menu on Slide bar.
After I installed the Advanced Printscreen for OpenERP 7 module, this menu is repaced with Export to pdf or export to excel
Hi, We have tested the
Hi,
We have tested the module with the version mentioned by you. We where unable to reproduce the error. I have made some minor changes to the module. Please try with this module. If the problem persist, please let me know...
This is really helpful . I
This is really helpful . I Was searching for a module like this.
Thanks
where download module ?
where download module ?
Hi, Module is attached
Hi,
Module is attached with the blog....
Great tool, realy. Please
Great tool, realy.
Please for some additional info:
1. Is it possible, to set up the header on each .pdf page? Maybe to add also the report header, regarding the menu selected.
2. Is there any solution to export/print the tree-view, like "Chart of accounts" from menu "Accounting-->Charts-->Chart of accounts", where the period filter is set already?
And one more question: how to expand the tree-views in one step, to see "parent" and all sub-level accounts?
Thanks.