118.38

v 16.0 Third Party 177
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 1114
Technical Name report_extend_bf
LicenseAGPL-3
Websitehttp://www.build-fish.com/
Versions 17.0 15.0 11.0 13.0 10.0 16.0 14.0 9.0 12.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 1114
Technical Name report_extend_bf
LicenseAGPL-3
Websitehttp://www.build-fish.com/
Versions 17.0 15.0 11.0 13.0 10.0 16.0 14.0 9.0 12.0

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.

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/pdf/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/3G8gAGn
  • 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

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/

Contact us for support, consultation, customization

Contact by email

  • 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.

sudo apt-get install unoconv

Install py3o.template with python 3 support

py3o.template: An easy solution to design reports using LibreOffice, for basic templating (odt->odt and ods->ods only)

pip3 install py3o.template

Supported output format combinations (Template -> Output):

  • odt -> odt (default)
  • odt -> pdf
  • odt -> doc
  • odt -> docx
  • odt -> pds
  • rtf -> rtf

Install Google Fonts And Others Fonts - Example

Download desired fonts

https://fonts.google.com/?selection.family=Open+Sans

Install Google Fonts on Ubuntu

cd /usr/share/fonts

sudo mkdir googlefonts

cd googlefonts

wget -O Open_Sans.zip https://fonts.google.com/download?family=Open%20Sans

sudo unzip Open_Sans.zip

sudo chmod -R --reference=/usr/share/fonts/opentype /usr/share/fonts/googlefonts

Register fonts

sudo fc-cache -fv

Check if font installed

Example search OpenSans name file OpenSans-VariableFont_wdth,wght.ttf

sudo fc-match OpenSans

Restart Service Odoo

sudo systemctl restart odoo.service

Ref.

https://gist.github.com/lightonphiri/5811226a1fba0b3df3be73ff2d5b351c#file-bash-install_google_fonts_on_ubuntu-md

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 16.0 Community

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
There are no ratings yet!
Features in 16.0 version
by
Maquinaria para Obras Públicas y Construccción, S.A.
on 11/27/23, 9:40 AM

Does it support sections? 
And switch on/off the details of the lines? Hide/enable subtotal, hide/enable line amount, hide/show details?

Thanks

Re: Features in 16.0 version
by
David Jesús Peralta Buendia
on 11/27/23, 11:05 AM Author

Hi,

If it admits everything mentioned


Best regards


is it compatible with rtl Arabic?
by
Abdulaziz Alanazi
on 2/24/23, 6:40 AM Confirmed Purchase



Does libre office need to be installed on the odoo server? If yes then how to install it on servers without GUI. We use ubuntu server (no GUI).
by
Muhammad Ibrahim
on 2/22/23, 1:29 AM

Does libre office need to be installed on the odoo server? If yes then how to install it on servers without GUI. We use ubuntu server (no GUI).

Re: Does libre office need to be installed on the odoo server? If yes then how to install it on servers without GUI. We use ubuntu server (no GUI).
by
David Jesús Peralta Buendia
on 2/22/23, 10:02 AM Author

Hi,

No need to install libreoffice on the server

Libreoffice is installed on the client computer to design your templates


Run in Odoo SH
by
Xavier Rodriguez
on 2/20/23, 10:38 PM Confirmed Purchase

Hello, This module work in Odoo SH?

Re: Run in Odoo SH
by
David Jesús Peralta Buendia
on 2/22/23, 10:02 AM Author

Hi,

Yes work in Odoo sh