Module support python 3.x
Is Easy an elegant and scalable solution to design reports using LibreOffice.
Export data all objects odoo to LibreOffice output files odt, pdf, doc, docx, ods, rtf.
Ideal for creating contracts and other documents.
Report templates can be created directly in of following format:
*.odt Using the word processor LibreOffice
Example templates in module report_extend_bf_examples.
Note: LibreOffice (Version: 4.4.6.3 or better). tested with LibreOffice write version: 4.4.6.3 or 6.0 (Optional for create templates).
Example Create report:
Settings/Technical/Reporting/Reporting
If there are several records return an file compress.
Return file *.zip
Print format fields
To print the fields with their respective format put the prefix bf_ followed by the name of the field.
Show documentation technical
Global Values & Icons
Value | Name in report | Description | Out (Example) |
---|---|---|---|
user | py3o.user.* | Record res.users | Defined by the user |
company_id | py3o.company_id.* | Record res.company | Defined by the user |
lang | py3o.lang | Lang user login | es |
time | py3o.time | Function time | |
company_vat_label | py3o.company_vat_label | Company vat label | TIN (Default TIN) |
company_vat_label_full | py3o.company_vat_label_full | Concatenate Vat label + vat | TIN: 32412423423 |
company_display_address | py3o.company_display_address |
Field company.partner_id.display_address with format LibreOffice |
YourCompany 1725 Slough Ave. Scranton PA 18540 United States |
company_name | py3o.company_name | Company name | YourCompany |
company_footer_line | py3o.company_footer_line | Initials line dates & separate per tab. | P. +1 555 123 8069 E. info@example.com W. http://www.example.com TIN: 32412423423 |
company_footer_line_break | py3o.company_footer_line_break | Initials dates & line break |
P. +1 555 123 8069 E. info@example.com W. http://www.example.com TIN: 32412423423 |
company_footer_line_icon | py3o.company_footer_line_icon | Line dates icons & separate per tab | 📞 +1 555 123 8069 ✉ info@example.com 🌐 http://www.example.com TIN: 32412423423 |
company_footer_line_break_icon | py3o.company_footer_line_break_icon | Icons dates & line break |
📞 +1 555 123 8069 ✉ info@example.com 🌐 http://www.example.com TIN: 32412423423 |
company_header | py3o.company_header | Company Tagline with format LibreOffice line break | Header Company |
company_footer | py3o.company_footer | Report Footer with format LibreOffice line break | Footer Company |
iphone | py3o.iphone | Icon phone | 📞 |
imobile | py3o.imobile | Icon mobile | 📱 |
iemail | py3o.iemail | Icon email | ✉ |
iwebsite | py3o.iwebsite | Icon website | 🌐 |
imoney | py3o.imoney | Icon money | 💰 |
idolar | py3o.idolar | Icon dolar | 💵 |
ilabel | py3o.ilabel | Icon label | 🏷 |
inote | py3o.inote | Icon note | 🗈 |
iimg | py3o.iimg | Icon image | 🖵 |
ilist | py3o.ilist | Icon list | ☰ |
iqty | py3o.iqty | Icon qty | ☷ |
ipushpin | py3o.ipushpin | Icon pushpin | 📌 |
ioffice | py3o.ioffice | Icon office | 🏢 |
Extra fields in res.partner
Field name | Type field | Description | Out example |
Out example prefix bf_ (Out format report) |
---|---|---|---|---|
display_address | Text | Call function _display_address() | China Export ChinaShanghai52 Chop Suey street 200000 |
China Export ChinaShanghai52 Chop Suey street 200000 |
display_address_without_company | Text | Without company | ChinaShanghai52 Chop Suey street 200000 | ChinaShanghai52 Chop Suey street 200000 |
display_address_without_company_line | Text | Without company inline separate per | | ChinaShanghai52 Chop Suey street 200000 | ChinaShanghai52 Chop Suey street 200000 |
vat_label | Char | Vat label (Default TIN label) | TIN | TIN |
vat_label_full | Char | Concatenate vat label + vat number | TIN: 32412423423 | = |
data_line | Text | Line data initials | P. +86 21 6484 5671 E. chinaexport@exm.com W. http://www.chinaexport.com/ | = |
data_line_break | Text | Line break data initials | P. +86 21 6484 5671 E. chinaexport@exm.com W. http://www.chinaexport.com/ |
P. +86 21 6484 5671 E. chinaexport@exm.com W. http://www.chinaexport.com/ |
data_line_icon | Text | Line data icons | 📞 +86 21 6484 5671 ✉ chinaexport@exm.com 🌐 http://www.chinaexport.com/ | = |
data_line_break_icon | Text | Line break data icons | 📞 +86 21 6484 5671 ✉ chinaexport@exm.com 🌐 http://www.chinaexport.com/ |
📞 +86 21 6484 5671 ✉ chinaexport@exm.com 🌐 http://www.chinaexport.com/ |
data_line_abbr | Text | Line data abbreviation | Tel: +86 21 6484 5671 Mail: chinaexport@exm.com Web: http://www.chinaexport.com/ | = |
data_line_break_abbr | Text | Line break data abbreviation | Tel: +86 21 6484 5671 Mail: chinaexport@exm.com Web: http://www.chinaexport.com/ |
Tel: +86 21 6484 5671 Mail: chinaexport@exm.com Web: http://www.chinaexport.com/ |
Extra fields in res.company
Field name | Type field | Description | Out example |
Out example prefix bf_ (Out format report) |
---|---|---|---|---|
display_address | Text | Call function _display_address() | China Export ChinaShanghai52 Chop Suey street 200000 |
China Export ChinaShanghai52 Chop Suey street 200000 |
display_address_without_company | Text | Without company | ChinaShanghai52 Chop Suey street 200000 | ChinaShanghai52 Chop Suey street 200000 |
display_address_without_company_line | Text | Without company inline separate per | | ChinaShanghai52 Chop Suey street 200000 | ChinaShanghai52 Chop Suey street 200000 |
vat_label | Char | Vat label (Default TIN label) | TIN | TIN |
vat_label_full | Char | Concatenate vat label + vat number | TIN: 32412423423 | = |
footer_line | Text | Line data initials | P. +86 21 6484 5671 E. chinaexport@exm.com W. http://www.chinaexport.com/ | = |
footer_line_break | Text | Line break data initials | P. +86 21 6484 5671 E. chinaexport@exm.com W. http://www.chinaexport.com/ |
P. +86 21 6484 5671 E. chinaexport@exm.com W. http://www.chinaexport.com/ |
footer_line_icon | Text | Line data icons | 📞 +86 21 6484 5671 ✉ chinaexport@exm.com 🌐 http://www.chinaexport.com/ | = |
footer_line_break_icon | Text | Line break data icons | 📞 +86 21 6484 5671 ✉ chinaexport@exm.com 🌐 http://www.chinaexport.com/ |
📞 +86 21 6484 5671 ✉ chinaexport@exm.com 🌐 http://www.chinaexport.com/ |
footer_line_abbr | Text | Line data abbreviation | Tel: +86 21 6484 5671 Mail: chinaexport@exm.com Web: http://www.chinaexport.com/ | = |
footer_line_break_abbr | Text | Line break data abbreviation | Tel: +86 21 6484 5671 Mail: chinaexport@exm.com Web: http://www.chinaexport.com/ |
Tel: +86 21 6484 5671 Mail: chinaexport@exm.com Web: http://www.chinaexport.com/ |
Install module in S.O. based Linux
- Red Hat
- Debian
- Fedora
- Mandriva
- Ubuntu
- OpenSUSE
- Others linux distro.
Pre-Installation Requirements
- Unoconv: Convert files to any format that supports LibreOffice. Website: Unoconv example install ubuntu O.S.
# apt-get install unoconv subversion
Install py3o.template with python 3 support
- py3o.template: An easy solution to design reports using OpenOffice, for basic templating (odt->odt and ods->ods only)
Ref: py3o.template install
Preferably install in this order:
py3o.template is python3 ready. But, yes there is a but... alas!, you'll need to install a trunk version of Genshi.
pip3 install py3o.template==0.9.12
Uninstall genshi
pip3 uninstall genshi
And we reinstall genshi
svn checkout https://svn.edgewall.org/repos/genshi/trunk genshi_trunk
cd genshi_trunk
python3 setup.py build
python3 setup.py install
Or see example script Vagrant install
Supported output format combinations (Template -> Output):
- odt -> odt (default)
- odt -> pdf
- odt -> doc
- odt -> docx
- odt -> pds
- rtf -> rtf
Note
If the program unoconv default output will show in ODT format regardless of the output field you selected in the report is not installed.
- Fully Supports Odoo Version 11.0 Community
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedI did not get timely support and no replay to the questions.
Can print several records to a single pdf file instead of compress?
Can print several records return a single pdf file instead of compress? PS: It work now after updated Odoo to the latest.
Works very well
Issue in file output
I'm running Odoo in mac osx And the file output is always odt no matter what I change the format output file!
Support very slow
The support is very slow. I bought it for a few months & I couldn't use it yet.
When module will be compatible with Python 3.x?