Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Aplikacije
    Finance
    • Knjigovodstvo
    • Obračun
    • Stroški
    • Spreadsheet (BI)
    • Dokumenti
    • Podpisovanje
    Prodaja
    • CRM
    • Prodaja
    • POS Shop
    • POS Restaurant
    • Naročnine
    • Najem
    Spletne strani
    • Website Builder
    • Spletna trgovina
    • Blog
    • Forum
    • Pogovor v živo
    • eUčenje
    Dobavna veriga
    • Zaloga
    • Proizvodnja
    • PLM
    • Nabava
    • Vzdrževanje
    • Kakovost
    Kadri
    • Kadri
    • Kadrovanje
    • Odsotnost
    • Ocenjevanja
    • Priporočila
    • Vozni park
    Marketing
    • Družbeno Trženje
    • Email Marketing
    • SMS Marketing
    • Dogodki
    • Avtomatizacija trženja
    • Ankete
    Storitve
    • Projekt
    • Časovnice
    • Storitve na terenu
    • Služba za pomoč
    • Načrtovanje
    • Termini
    Produktivnost
    • Razprave
    • Odobritve
    • IoT
    • Voip
    • Znanje
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industrije
    Trgovina na drobno
    • Book Store
    • Trgovina z oblačili
    • Trgovina s pohištvom
    • Grocery Store
    • Trgovina s strojno opremo računalnikov
    • Trgovina z igračami
    Food & Hospitality
    • Bar and Pub
    • Restavracija
    • Hitra hrana
    • Guest House
    • Beverage Distributor
    • Hotel
    Nepremičnine
    • Real Estate Agency
    • Arhitekturno podjetje
    • Gradbeništvo
    • Estate Management
    • Vrtnarjenje
    • Združenje lastnikov nepremičnin
    Svetovanje
    • Računovodsko podjetje
    • Odoo Partner
    • Marketinška agencija
    • Law firm
    • Pridobivanje talentov
    • Audit & Certification
    Proizvodnja
    • Tekstil
    • Metal
    • Pohištvo
    • Hrana
    • Brewery
    • Poslovna darila
    Health & Fitness
    • Športni klub
    • Trgovina z očali
    • Fitnes center
    • Wellness Practitioners
    • Lekarna
    • Frizerski salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Sistemi sončne energije
    • Izdelovalec čevljev
    • Čistilne storitve
    • HVAC Services
    Ostali
    • Neprofitna organizacija
    • Agencija za okolje
    • Najem oglasnih panojev
    • Fotografija
    • Najem koles
    • Prodajalec programske opreme
    Browse all Industries
  • Skupnost
    Learn
    • Tutorials
    • Dokumentacija
    • Certifikati
    • Šolanje
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Prenesi
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Dogodki
    • Prevodi
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Sklici kupca
    • Podpora
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Določanje cen
  • Pomoč

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Knjigovodstvo
  • Zaloga
  • PoS
  • Projekt
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
Pomoč

Updating multi line pdf form fields using quote builder in Odoo17.

Naroči se

Get notified when there's activity on this post

This question has been flagged
Odoo17pdfquotebuilderPyPDF2
1 Odgovori
1992 Prikazi
Avatar
Matthias de Vries

I created a pdf template with form fields which are filled by Odoo when printing the quotation in the sales app.

In the base that works fine. However I created some multiline fields by overwriting the "_get_form_fields_mapping" function in the "ir_actions_report" model from Odoo.

Unfortunately line breaks are removed in the pdf field. Is there any way to avoid that and just keep the line breaks?

My code (deleted all unnecessary code):

def _get_form_fields_mapping(self, order, doc_line_id_mapping=None):

        """ Dictionary mapping specific pdf fields name to Odoo fields data for a sale order.
        Override this method to add new fields to the mapping.

        :param recordset order: sale.order record
        :rtype: dict
        :return: mapping of fields name to Odoo fields data

        Note: order.ensure_one()
        """
        order.ensure_one()
        env = self.with_context(use_babel=True).env
        tz = order.partner_id.tz or self.env.user.tz or 'UTC'
        lang_code = order.partner_id.lang or self.env.user.lang

        form_fields_mapping = {
            'test': "This is a test \n to see if \n line breaks are working.",
         }

        # Adding fields from each line, prefixed by the line_id to avoid conflicts
        lines_with_doc_ids = set(doc_line_id_mapping.values())
        for line in order.order_line.filtered(lambda sol: sol.id in lines_with_doc_ids):
            form_fields_mapping.update(self._get_sol_form_fields_mapping(line))

        return form_fields_mapping




In the field I created in the pdf the multiple lines flag is activated (set in Libre office and turned to pdf). De name of the field is "test" like the key in the "form_fields_mapping" dictionary.

Still the result in the pdf is: 

"This is a test to see if line breaks are working." So without the line breaks.


I traced back the problem till the Odoo pdf model in "src/odoo/odoo/tools/pdf.py" and the methode "fill_form_fields_pdf(writer, form_fields)" where, just before the line "writer.updatePageFormFieldValues(page, form_fields)", the field "text" still has the line breaks in it. "updatePageFormFieldValues" is a class in the PyPDF2 library. The version of PyPDF2 installed on Odoo.sh is


Actually I got stuck at this point. The problem should, as far as I can understand, be in the code of the PyPDF library, in the pdf field settings or the settings of PyPDF2 set in the Odoo code some where. At the moment I have no idea what to do next. I hope someone can help.


0
Avatar
Opusti
Avatar
Matthias de Vries
Avtor Best Answer

I solved it by adding pypdf to requirments.txt in our Github project and wrote my own script to update the fields in the pdf templates.

May I suggest that Odoo will also update to pypdf (replacement of PyPDF2)? 
That would be beneficial really for customers who try to use the quot builder with pdf forms and would like to add for example addresses, or descriptions that need more then one line.


I also have an other suggestion:

It would also be nice if language support will be extended to quote builder, for example by the option to add a header page, a footer page and product pages per language. The customers language determines what pdf templates will be used. For the product that is an easy fix, as only a language field on the product.documents form and in _render_qweb_pdf_prepare_streams of IrActionsReport in the model ir_actions_report add the language as a filter in docs_to_include (d.lang == order.partner_id.lang). An equal approach could be created for the footer and the header. 




Please keep me posted if you will update the code.

Thank you.

0
Avatar
Opusti
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
Displaying Many2one field on mobile devices identical to desktop view in Odoo 17
Odoo17
Avatar
Avatar
1
jul. 25
1733
Update the discount in POS order
Odoo17
Avatar
0
nov. 24
1989
New employee Button in POS
Odoo17
Avatar
0
okt. 24
2623
ADD new group under other
Odoo17
Avatar
Avatar
1
okt. 24
3181
Odoo 17 kanban second Progress bar
Odoo17
Avatar
0
okt. 24
2071
Community
  • Tutorials
  • Dokumentacija
  • Forum
Open Source
  • Prenesi
  • Github
  • Runbot
  • Prevodi
Services
  • Odoo.sh Hosting
  • Podpora
  • Nadgradnja
  • Custom Developments
  • Izobraževanje
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Sredstva blagovne znamke
  • Kontakt
  • Zaposlitve
  • Dogodki
  • Podcast
  • Blog
  • Stranke
  • Pravno • Zasebnost
  • Varnost
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now