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.
Apps professional templates reports
File in. (Template example)
File out [odt, pdf, doc, docx, ods, rtf]
File in. (Template example)
File out [odt, pdf, doc, docx, ods, rtf]
Other example file in.
File out.
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
Output formats:
- ODF Text Document [.odt]
- Portable Document Format [.pdf]
- Microsoft Word 97/2000/XP [.doc]
- Microsoft Office Open XML [.docx]
- ODF Spreadsheet [.ods]
- Microsoft Word Text Rich [.rtf]
If report config out file pdf return file merge pdf
Return file *.pdf
If report config out file not pdf return an file compress
Return file *.zip
Now with preview of the document PDF
Template report
Preview report
http://localhost:8069/report/odt_to_x/template_name/id
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: https://bit.ly/2SypPMB
References
- Manual videos: https://bit.ly/3fxxHXS
- Demo (User: demo pass: demo): https://bit.ly/3fWWrYf
- Repository demo template: https://bit.ly/3fx7mZZ
- Documentation py3o.template: https://bit.ly/3hXi3qi
- Documentation: https://bit.ly/2SypPMB
Note
- If the module is installed in a windows operating system, the output report will not convert into pdf
- This module has been tested in Community Version
- Run in odoo.sh
Insert barcode
Type convert barcode support:
In the template define the type of barcode
- Codabar
- Code11
- Code128
- EAN13
- EAN8
- Extended39
- Extended93
- FIM
- I2of5
- MSI
- POSTNET
- QR
- Standard39
- Standard93
- UPCA
- USPS_4State
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/ |
- Repository demo template
- Documentation py3otemplate
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
py3o.template: An easy solution to design reports using LibreOffice, for basic templating (odt->odt and ods->ods only)
pip3 install py3o.template
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 14.0 Community
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedThere are no ratings yet!
Selamat sore, izin saya pemula dalam melakukan customisasi report menggunakan addons ini. izin apakah ada tutorial dasar untuk melakukan custom report menggunakan addons ini ? tahapan awalnya seperti apa ? Terimakasih.
Re: Selamat sore, izin saya pemula dalam melakukan customisasi report menggunakan addons ini. izin apakah ada tutorial dasar untuk melakukan custom report menggunakan addons ini ? tahapan awalnya seperti apa ? Terimakasih.
Hi,
We have the manual for beginners and practical examples.
It supports the contract module -HR
hello
is it support RTL
Re:
Hello
It does not support
Erreur utilisateur
Mise à jour impossible du module "report_extend_bf", la dépendance externe Python library not installed: py3o.template n'est pas satisfaite
Est-ce que le point de vente peut imprimer la facture
Je vois est ce que la somme de total s'affiche à lettres
Odoo.sh
Hi this modules work also for odoo on odoo.sh ?
Many thanks
Marco
Re: Odoo.sh
Hello Marco
If you work with odoo.sh
Greetings
Problem with font family on py3o links in ODT
Hi,
we have bought the module with another account on Odoo. Great functionality so far!
We only have one problem. If we insert py3o links for functions in the report ODT template e.g. something like py3o://function="format_datetime(o.date_order, format='dd.MM.YYYY')" then the output (PDF) of the report will show the resulting text (so the formatted date) in Times New Roman font family and not the font we set in the ODT template.
For everything else the text is shown like we formatted in the ODT template.
Please help with this as the reports are not useful for us this way.
Re: Problem with font family on py3o links in ODT
Hi
What is the version of Odoo where the module is installed
Preferably write me to the following email david.2964.erls@gmail.com
Interested.
Dear Sir, it is not clear to me if the 14 community version is fully supported, I would like to know before proceeding with the purchase. thanks in advance.Re: Interested.
Hi
This module has been tested in Community Version 14.
Good module
Good module and easy to generate reports
Interested...
Dear sir,
Is this module working in windows server environnement?
Re: Interested...
Hello
Yes it is