Skip to Content
  2. Mailing Lists
  3. Contributors

Archives

Contributors

  • Field Service PSC
    Hello,

    I would like to propose my 2 colleagues Steve Campbell (osi-scampbell) and Sandeep Mangukiya (smangukiya) to join the Field Service PSC.

    Thank you and stay safe!

    MAXIME CHAMBREUIL
    MANAGING DIRECTOR LATAM
    O: 1.855.877.2377 EXT. 710
    M: 602.427.5632
    E: MChambreuil@OpenSourcelntegrators.com
    P.O. BOX 940, HIGLEY, AZ 85236
    by Maxime Chambreuil - 09:41 - 31 Mar 2021

    10 replies 10 replies

  • Odoo load balancing

    Hi community,

    I'm looking for advice and experience regarding the topic of load balancing.

    There are two unrelated cases in which I would like to use it:

    1. Balancing over a pool of servers running Odoo

    We have a client with a horizontal setup with a pool of 4 servers running Odoo. Requests are now routed to the servers by means of round-robin, but that's not very smart - I'd rather pass the load to the server that I know has enough free workers, and perhaps memory/CPU/IO available to take on a new task. I've looked around and the only thing I've found so far is the UWSGI FastRouter: https://uwsgi-docs.readthedocs.io/en/latest/Fastrouter.html. Does someone have other suggestions?

    2. Smart balancing over worker pools on one server

    For a responsive Odoo you want to have many Odoo workers, but you don't want to run out of memory. This is a tradeoff. If you configure too few workers, your memory will sit idle, but if you configure many workers, you run the risk that occasional high memory requests (a heavy computation, a heavy report) come in and if by unlucky chance it's several at a time, your server can overload. Is there a load balancer or WSGI application server that can keep a track record of which requests generally take the most memory, and then throttle these requests to a limited "heavy pool" of Odoo workers that serve high-memory requests, whereas the "happy pool" will have many workers and process the trustworthy requests with much better responsiveness?

    Sorry if this is not the right place to ask - I will be happy about any pointers.

    -Tom

    by Tom Blauwendraat - 12:26 - 31 Mar 2021

    1 replies 1 replies

    • Re: Odoo load balancing
      HAProxy?

      Verstuurd vanaf mijn iPhone

      Op 31 mrt. 2021 om 12:27 heeft Tom Blauwendraat <tom@sunflowerweb.nl> het volgende geschreven:

      

      Hi community,

      I'm looking for advice and experience regarding the topic of load balancing.

      There are two unrelated cases in which I would like to use it:

      1. Balancing over a pool of servers running Odoo

      We have a client with a horizontal setup with a pool of 4 servers running Odoo. Requests are now routed to the servers by means of round-robin, but that's not very smart - I'd rather pass the load to the server that I know has enough free workers, and perhaps memory/CPU/IO available to take on a new task. I've looked around and the only thing I've found so far is the UWSGI FastRouter: https://uwsgi-docs.readthedocs.io/en/latest/Fastrouter.html. Does someone have other suggestions?

      2. Smart balancing over worker pools on one server

      For a responsive Odoo you want to have many Odoo workers, but you don't want to run out of memory. This is a tradeoff. If you configure too few workers, your memory will sit idle, but if you configure many workers, you run the risk that occasional high memory requests (a heavy computation, a heavy report) come in and if by unlucky chance it's several at a time, your server can overload. Is there a load balancer or WSGI application server that can keep a track record of which requests generally take the most memory, and then throttle these requests to a limited "heavy pool" of Odoo workers that serve high-memory requests, whereas the "happy pool" will have many workers and process the trustworthy requests with much better responsiveness?

      Sorry if this is not the right place to ask - I will be happy about any pointers.

      -Tom

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Willem Hulshof - 08:56 - 31 Mar 2021
  • Web_gannt for CE

    Hello,

    I'm looking for a module web_gantt replacement that was moved to Enterprise a couple of years ago. This module adds view-type gantt-view that is useful for project planning and others. I have found OCA-module project_timeline that is part of what I'm looking for.

    --
    Med vänlig hälsning / Best regards/ 顺祝商祺,
    Anders Wallenquist

    VERTEL AB | Anders Wallenquist | anders.wallenquist@vertel.se
    +46 (0)13 99 19 480 | +46 (0) 709 565 160 | vertel.se
    by Anders Wallenquist - 08:46 - 31 Mar 2021

    3 replies 3 replies

  • Propose myself as PSC for OCA/calendar
    I can't find which OCA team manages the https://github.com/OCA/calendar/ repo.

    I'm pushing some modules there, and modern branches are mostly empty, so I guess I should be PSC there.

    My github profile, just in case: https://github.com/Yajo

    Thanks everyone!
    by Jairo Llopis - 11:41 - 29 Mar 2021

    9 replies 9 replies

  • updating module no recreate removed `noupdate="True"` data
    Hi there,

    I'm wondering if there is any good reason for this default behavior from odoo that if I (as a user) remove a record created by a module using `noupdate="True"` this records is re-created by the ORM at the next update ?

    Is there some module that changes that behaviour to let the record unlink while there is ir_model_data record without its related record ?

    I'm on the way to suggest ir_model_norecreate module in server-bakend repo to change that behaviour.

    I would be happy to hear from you, I think it could be a nice feature for next odoo version and maybe with a new tag `norecreate=True`, any thoughts ?

    --
    Pierre Verkest
    06 81 12 25 20
    Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest
    by Pierre Verkest - 11:05 - 29 Mar 2021

    3 replies 3 replies

    • Re: updating module no recreate removed `noupdate="True"` data
      Oh thanks a lot I missed this one, you save my day :-)

      Le lun. 29 mars 2021 à 12:11, Iván Todorovich <ivan.todorovich@gmail.com> a écrit :
      Hello Pierre,

      This already exists in core, you can set the forcecreate="False" or forcecreate="0" to prevent odoo from re-creating a deleted record


      I hope it helps :)

      Best

      Iván Todorovich

      Odoo Techno-Functional Consultant



      On Mon, 29 Mar 2021 at 06:27, Pierre Verkest <pierreverkest84@gmail.com> wrote:
      hum... in fact this would required to overwrite BaseModel, Is there a nice way in v14.0 to change such class from a module ?

      I'm not very confident if I overwrite a BaseModel method because if such module is present in the python path it will take place event if the module is not install I suppose.
      And I'm not sure how to properly monkey patch BaseModel at run time :thinking:

      Le lun. 29 mars 2021 à 11:04, Pierre Verkest <pierreverkest84@gmail.com> a écrit :
      Hi there,

      I'm wondering if there is any good reason for this default behavior from odoo that if I (as a user) remove a record created by a module using `noupdate="True"` this records is re-created by the ORM at the next update ?

      Is there some module that changes that behaviour to let the record unlink while there is ir_model_data record without its related record ?

      I'm on the way to suggest ir_model_norecreate module in server-bakend repo to change that behaviour.

      I would be happy to hear from you, I think it could be a nice feature for next odoo version and maybe with a new tag `norecreate=True`, any thoughts ?

      --
      Pierre Verkest
      06 81 12 25 20
      Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest


      --
      Pierre

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      Pierre
      by Pierre Verkest - 01:11 - 29 Mar 2021
    • Re: updating module no recreate removed `noupdate="True"` data
      Hello Pierre,

      This already exists in core, you can set the forcecreate="False" or forcecreate="0" to prevent odoo from re-creating a deleted record


      I hope it helps :)

      Best

      Iván Todorovich

      Odoo Techno-Functional Consultant



      On Mon, 29 Mar 2021 at 06:27, Pierre Verkest <pierreverkest84@gmail.com> wrote:
      hum... in fact this would required to overwrite BaseModel, Is there a nice way in v14.0 to change such class from a module ?

      I'm not very confident if I overwrite a BaseModel method because if such module is present in the python path it will take place event if the module is not install I suppose.
      And I'm not sure how to properly monkey patch BaseModel at run time :thinking:

      Le lun. 29 mars 2021 à 11:04, Pierre Verkest <pierreverkest84@gmail.com> a écrit :
      Hi there,

      I'm wondering if there is any good reason for this default behavior from odoo that if I (as a user) remove a record created by a module using `noupdate="True"` this records is re-created by the ORM at the next update ?

      Is there some module that changes that behaviour to let the record unlink while there is ir_model_data record without its related record ?

      I'm on the way to suggest ir_model_norecreate module in server-bakend repo to change that behaviour.

      I would be happy to hear from you, I think it could be a nice feature for next odoo version and maybe with a new tag `norecreate=True`, any thoughts ?

      --
      Pierre Verkest
      06 81 12 25 20
      Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest


      --
      Pierre

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Iván Todorovich - 12:11 - 29 Mar 2021
    • Re: updating module no recreate removed `noupdate="True"` data
      hum... in fact this would required to overwrite BaseModel, Is there a nice way in v14.0 to change such class from a module ?

      I'm not very confident if I overwrite a BaseModel method because if such module is present in the python path it will take place event if the module is not install I suppose.
      And I'm not sure how to properly monkey patch BaseModel at run time :thinking:

      Le lun. 29 mars 2021 à 11:04, Pierre Verkest <pierreverkest84@gmail.com> a écrit :
      Hi there,

      I'm wondering if there is any good reason for this default behavior from odoo that if I (as a user) remove a record created by a module using `noupdate="True"` this records is re-created by the ORM at the next update ?

      Is there some module that changes that behaviour to let the record unlink while there is ir_model_data record without its related record ?

      I'm on the way to suggest ir_model_norecreate module in server-bakend repo to change that behaviour.

      I would be happy to hear from you, I think it could be a nice feature for next odoo version and maybe with a new tag `norecreate=True`, any thoughts ?

      --
      Pierre Verkest
      06 81 12 25 20
      Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest


      --
      Pierre
      by Pierre Verkest - 11:26 - 29 Mar 2021
  • New module for data synchronization between Odoo instances
    Hello,

    I'm working on a module to synchronize data between Odoo instances.
    It will support one master with many slave databases, and allow for bidirectional sync.
    My design builds on top of, and expands, the great auditlog module (https://github.com/OCA/server-tools/tree/14.0/auditlog)

    I'm considering my options on:

    a) the repo to contribute the module to, and
    b) the name for the module.

    Suggestions are welcome.

    Thank you

    --
    Daniel Reis
    Managing Director
    M: +351 919991307
    E: DReis@OpenSourceIntegrators.com
    Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


    by Daniel Reis - 01:15 - 19 Mar 2021

    13 replies 13 replies

  • Sale stock: widget qty_to_date
    Hello everyone,

    We recently went live with a customer on Odoo 14.0. On sales order lines, Odoo added this widget with the green/red graph icon and the quantity available/forecasted.

    The widget assumes that all the products in the warehouse are available for sales. It takes the view location "WH" to compute the quantities available/forecasted and provides that information to sales people.

    In previous versions, it was documented that the "Location Stock field on the warehouse shows the place of products available for delivery to a customer directly from this warehouse. Availability is given by all the products in that location and any child locations."

    This was the reason locations like Output, RMA, Repair or any use case where a company store items that are not for sales were NOT created under "Stock", so that they would not show up as available to salespeople.

    I reported an issue to Odoo support but their answer is to create a location outside of any warehouse using the Rental location as an example.

    This sounds terribly wrong to me and disconnected from the reality.

    Short term solution, we patched the stock and sale_stock modules to use the Stock location, but there are risks of breaking something.

    What do you think? What's your opinion?

    MAXIME CHAMBREUIL
    MANAGING DIRECTOR LATAM
    O: 1.855.877.2377 EXT. 710
    M: 602.427.5632
    E: MChambreuil@OpenSourcelntegrators.com
    P.O. BOX 940, HIGLEY, AZ 85236
    by Maxime Chambreuil - 04:31 - 17 Mar 2021

    5 replies 5 replies

  • Discover the OCA priorities for 2021 proposed by the board
    Hello contributors,

    Here is our latest blog post to present the 2021 OCA priorities proposed by the Board:

    Don't hesitate to come back to us/me if you'd like to give your feedback!

    Have a nice day,
    --
    Virginie for the Board
    by Virginie Dewulf. - 10:11 - 17 Mar 2021

    10 replies 10 replies

    • Re: Discover the OCA priorities for 2021 proposed by the board
      I don't know but I feel like any standard solution won't work for us.

      In a normal software project, you just have 1 branch (maybe 2: devel/stable). Then you add sphinx/mkdocs on a separate folder and docs live happily with your source code. Besides, those tools analyze your docstrings and autogenerate docs. Each repo contains 1 package, which has a single evolving version that follows a standard schema such as PEP 400, semver, calver, etc.

      OCA has a workflow that is very alien to general github workflow:
      1. Code is spread across different repos.
      2. Each repo has different modules which can be tightly or loosely related among themselves and among modules that might exist in other repos.
      3. Each module has its own version. Which, BTW, means nothing in reality and follows a different schema imposed by Odoo and some OCA members.
      4. Each repo has multiple maintained versions of each module, one (or zero) per branch.
      I think this is a deeply rooted problem across the whole OCA that hinders contributions and makes any move hard to achieve. I've tried to fix that in the past without success, so I don't care anymore. It's the OCA we have and I have to accept that.

      So, having all that said, I think that the only way this could work is stick as it is: one README per module/version pair.

      Odoo docs situation is today less crazy, so in case we have some functional stuff to document, if possible, the place to do it would be https://github.com/odoo/documentation

      IMHO user docs should be avoided and, instead, modules should be self-explained within the UI. That goes through having friendly empty pages, tours, help tooltips, self-explained dialogs, res.config.settings dialogs, etc. Just make the module obvious and save documentation.

      For other kind of cross-module, cross-repo, deployment, etc, kind of docs, possibly a single mkdocs repo could be deployed. As it wouldn't be coupled with any specific repo, odoo version or module, it wouldn't need any versioning or branching: just one main branch and build on each commit.
      by Jairo Llopis - 11:21 - 25 May 2021
    • Re: Discover the OCA priorities for 2021 proposed by the board
      Ok, I'm agree with you too.

      Now, I'm understanding that the documentation project take in account many things, besides Functional/Technical docs, like:

      - Transversal topics ( queue, connector, connector-odoo2odoo ...) depending the Business Objectives and the Technical requirements, so it depends on the specific implementation. So, maybe some sections with recipes for different Business Cases should be appreciate.

      - Versioning documentation is another gap, for example ReadTheDocs, like many others, manage versioning/branching/languages... and can be integrated with GitHub easily.

      I appreciate your answers,



      El lun, 24 may 2021 a las 11:42, Jairo Llopis (<jairo.llopis@tecnativa.com>) escribió:
      I agree with Tom.

      Also, having that /docs folder would make migrations even harder. Would make it very hard to find docs of several modules. Would force us to maintain one docs version per module version.


      El sáb, 22 may 2021 a las 18:42, Tom (<tom@sunflowerweb.nl>) escribió:
      I am with you except for 1 thing: I think documentation is central and not tied to specific repositories. Because if you want to make a doc about one topic such as "syncing data" it will involve many repositories: queue, connector, connector-odoo2odoo, server-tools, bank-statement, edi....

      The e-learning system is good but it is not so strong in wiki-like editing.

      The "Migration" docs and "OCA guidelines" have become powerful docs that are much referred to; i think a central place such as that would be better for the docs, and then organized per each topic. Either on Github Wiki or on Github pages.

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      Jairo Llopis

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      by Juan Del Castillo Gómez - 02:31 - 24 May 2021
    • Re: Discover the OCA priorities for 2021 proposed by the board
      I agree with Tom.

      Also, having that /docs folder would make migrations even harder. Would make it very hard to find docs of several modules. Would force us to maintain one docs version per module version.


      El sáb, 22 may 2021 a las 18:42, Tom (<tom@sunflowerweb.nl>) escribió:
      I am with you except for 1 thing: I think documentation is central and not tied to specific repositories. Because if you want to make a doc about one topic such as "syncing data" it will involve many repositories: queue, connector, connector-odoo2odoo, server-tools, bank-statement, edi....

      The e-learning system is good but it is not so strong in wiki-like editing.

      The "Migration" docs and "OCA guidelines" have become powerful docs that are much referred to; i think a central place such as that would be better for the docs, and then organized per each topic. Either on Github Wiki or on Github pages.

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      Jairo Llopis
      by Jairo Llopis - 11:41 - 24 May 2021
    • Re: Discover the OCA priorities for 2021 proposed by the board
      I am with you except for 1 thing: I think documentation is central and not tied to specific repositories. Because if you want to make a doc about one topic such as "syncing data" it will involve many repositories: queue, connector, connector-odoo2odoo, server-tools, bank-statement, edi....

      The e-learning system is good but it is not so strong in wiki-like editing.

      The "Migration" docs and "OCA guidelines" have become powerful docs that are much referred to; i think a central place such as that would be better for the docs, and then organized per each topic. Either on Github Wiki or on Github pages.
      by Tom Blauwendraat - 07:41 - 22 May 2021
    • Re: Discover the OCA priorities for 2021 proposed by the board
      Hi Contributors,

      I don't hesitate contribute with my strategical vision and I suggest it:

      - Create one /docs folder per repository instead in readme ( and point the readme to docs page )
      - One subfolder for technical documentation and another with functional with only the markdown files.
      - In /docs folder create a static web page with any generator and render and host it with GitHub pages.
      - Create one subdomain per repository pointing to webpage. In this way, making it web page is more searchable and accesible to people.
      - To Centralize all the How-To set up the e-learning module at OCA system.
      - In the e-learning module you can point content to each subdomain with each web page, in a embeded web page way.
      - In this way you can create a course path for functional or technical documentation based on this embeded web pages.

      This is my approach, with the e-learning system you can also do gamification, certification and promote the OCA mission.






      El vie, 19 mar 2021 a las 21:57, Virginie Dewulf (<virginie@coopiteasy.be>) escribió:
      Hi Tom and other contributors,

      Thanks a lot for your feedback! This post received a very nice welcome, it's really motivating!

      I keep note of your ideas about helping functional people get involved and participate to communicate the high value of OCA modules.
      If you're motivated for the first article (we can decide later on which platform/way of keeping this content) about the import/export module, that could be a first content to directly try and see how to diffuse it!

      We can keep in touch (outside from this mailing list).


      To the other contributors: if any other ideas/comments come to your minds, don't hesitate!

      Have a nice end of week and super cool week-end!
      Virginie
      0477/64.17.20

      -------- Message initial --------
      De: Tom Blauwendraat <tom@sunflowerweb.nl>
      Répondre à: Odoo Community Association (OCA) Contributors <contributors@odoo-community.org>
      Objet: Re: Discover the OCA priorities for 2021 proposed by the board
      Date: Wed, 17 Mar 2021 09:47:32 -0000

      PS. Instead of blogs, which are perhaps a bit flighty and lose their actuality value over time, it could also be some kind of permanent wiki or github-based website, which is updated and community-reviewed as time goes by, with the latest insights per functional topic and Odoo version.

      Anyway, ideas ideas... good luck in the new board for 2021!

      Op 3/17/21 om 10:38 AM schreef Tom Blauwendraat:

      Hi Virginie

      In the post you are mentioning people to react below the blog post, but I can't... so then here:

      As a part of communication - maybe a method can be to make a platform that facilitates functional people to write attractive documentation/blogs/howto's about solving Odoo problems with OCA modules. For one, this could supplement the thorough lack of documentation on Odoo CE; but also, if consultants and clients read these blogs with examples and understand better that OCA modules are better than alternatives, because they:

      - usually solve problems in the best way, as there is hard-won community consensus on their design
      - are designed to interoperate together as a holistic eco-system
      - are extendible (even better than most Odoo modules are)
      - are quality-controlled
      - are OpenUpgradable
      - etc.

      Then they would understand better why it can be commercially more interesting to choose OCA modules and avoid technical debt, then go for the latest and greatest Odoo version supported by some crude customizations and App Store modules, and become disappointed in Odoo in the long run. And then, they would also become motivated to financially support OCA.

      A case in point is for example the import/export modules in the "queue" repository - I'm seeing so many inferior hand-rolled syncing implementations lately, that I'm very motivated to write a furious blog to tell everyone to stop doing that and build on the OCA solution. But now, aside from starting my own blog on the subject, I wouldn't know where to place such an article.

      Tom

      Op 3/17/21 om 10:12 AM schreef Virginie Dewulf:
      Hello contributors,

      Here is our latest blog post to present the 2021 OCA priorities proposed by the Board:

      Don't hesitate to come back to us/me if you'd like to give your feedback!

      Have a nice day,
      --

      Virginie for the Board

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      by Juan Del Castillo Gómez - 04:41 - 22 May 2021

  • Re: Track sales packaging costs

    In general (accountant's view)
    1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
    2- The actual cost should be recorded when incurred (order > invoice)
    3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
    4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold

    Ciao

    Marco 
    by Marco Marchiori - 08:30 - 14 Mar 2021

    4 replies 4 replies

    • Re: Track sales packaging costs
      Hello,

      My requirements on this got more detailed,
      and I ended up created a module to allow including other costs in the margin calculation.

      I explain it in more detail in the module description, here:
      https://github.com/OCA/margin-analysis/pull/97/files#diff-d50d268e9b54e2cef699cc573b93425d9b1def68c6236a52c9c5c613f5f7b3bf

      """
      Track expected shipping costs, allowing more accurate margin calculations.

      Costs could include packaging, documentation or customs expenses.
      These may be consumables or services, not directly included in sales order lines
      nor accounted with the invoice.
      But we may still ant the Sales Order margin to consider these costs,
      especially if business margins are tight.

      Also allows for carrier shipping costs to be estimated separately,
      instead of being automatically added as a sales order line, to charge the customer.

      This is useful in the case the customer is charge with a shipping fee
      that can be very different from the actual shipping cost,
      or when no shipping fee is charged at all.

      In this case the expected shipping costs, computed by the UPDATE SHIPPING COSTS
      button, can be stored as Other Costs and considered for the sales order margin,
      instead being added as a sales order line and charged to the customer.
      """

      I hope this could be of interest for other people.

      Thanks
      Daniel



      On 15/03/2021 09:01, Antonio M. Vigliotti (gmail) wrote:
      This trouble looks like delivery cost of Intrastat.
      On intrastat statement, all delivery costs (required) and packaging costs (optional) have to be shared in COGS.

      Example:

      Sale Order












      Product Qty Unit Price Subtotal Delivery cost Intrastat value Pack.Cost
      Prod.A 10,0 € 10,50 € 105,00 € 6,56 € 111,56 € 3,28
      Prod.B 10,0 € 5,50 € 55,00 € 3,44 € 58,44 € 1,72
      Packaging 1,0 € 5,00 € 5,00


      Delivery 1,0 € 10,00 € 10,00


      TOTAL

      		€ 175,00


      Tot.Goods & Service 20
      		€ 160,00 € 10,00 € 170,00 € 5,00


      Antonio M. Vigliotti

      Mobile (+39) 342.8740910



      Il 15/03/21 01:56, Marco Marchiori ha scritto:
      Graeme

      as you said I was not so accurate to include the IAS compliance in the discussion.
      In any case we defined the nature of such costs: they are variable costs, they should be included in cogs but they could be allocated, with a sort of ABC, "depending on the sales order composition".
      If they are "extra-amounts" (as Daniel said) they should be allocated in addition to the cost (apparently) already included in the product, but of course I would not discuss IAS compliance here!
      So I suggested to track them separately (we agree on that).
      Then the entry I advised to make was an absorption one, that would work both in continental and anglo-saxon accounting.
      If I worked for a business like that (independently from IAS) I would ask myself if it's more important the cost of the product or the cost of the order...

      Ciao

      Marco

      Il giorno dom 14 mar 2021 alle ore 21:57 Graeme Gellatly <gdgellatly@gmail.com> ha scritto:
      Hi,

      Under IAS2 this advice is not correct. It is very clear that product costs relate to bringing the product to its present location and condition. It cannot include non incurred costs, or costs that form part of the sales process. Now if it forms part of a manufacturing process, then they can be included under costs of conversion, but only if they are part of that conversion. If there is no production process then no costs. If there is then actually the manufacturing process handles it all already because it occurs prior to the sales transaction.

      Here is the exact clause.
      The cost of inventories shall comprise all costs of purchase, costs of conversion and other costs incurred in bringing the inventories to their present location and condition.

      So in this case where the packaging costs are part of the sales process they do not form cost of inventories. Indeed any costs incurred in the selling process are explicitly excluded.

      However it should of course be included in Cost of Goods sold, but it is no different to any other cost / revenue required at time of sale (or purchase for that matter), such as rebates, discounts on either the vendor/customer side related to a particular customer. It is a very common use case, and its the same reason you need to accrue warranty liability accrual at time of sale rather than in inventories (or time of claim for that matter). The only tricky part being the management of the sales transaction because you need some way to record that (y), which is variable in this case, but effectively you end up with.

      CR Inventory - Product A x
      CR Packaging y
      DR COGS - Product A (x+y).

      Is how I'd do it, probably just adding the packaging to the picking (not the sale) and then overriding the anglosaxon entries to allocate costs.

      That is the simple case, Obviously there is a mix of products involved, all utilising the packaging, so a reasonable allocation decision needs to be made, probably a dollar weighted basis, but possibly volume. Under anglo saxon the way Odoo operates it will be a significant amount of work, as you then need to reconcile both sides of the accrual accounts, but really it is no different to the same issue you have with A/P accrual accounts and having to allow for expected rebates.

      On Mon, Mar 15, 2021 at 8:32 AM Marco Marchiori <info@marcomarchiori.com> wrote:

      In general (accountant's view)
      1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
      2- The actual cost should be recorded when incurred (order > invoice)
      3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
      4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold

      Ciao

      Marco 

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      M a r c o  M a r c h i o r i    
      consulente funzionale
      dottore commercialista, revisore  legale
      Via Stazione 12, 30035 MIRANO (VE);    telefono  e  fax  041 488195
      codice fiscale   MRCMRC67H11F241M;      partita IVA   03813290271

      --
      This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. Use of such information is exclusively reserved for the recipient of this e-mail.
      --

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe


      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe


      --
      Daniel Reis
      Managing Director
      M: +351 919991307
      E: DReis@OpenSourceIntegrators.com
      Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


      by Daniel Reis - 12:16 - 15 Jun 2021
    • Re: Track sales packaging costs
      This trouble looks like delivery cost of Intrastat.
      On intrastat statement, all delivery costs (required) and packaging costs (optional) have to be shared in COGS.

      Example:

      Sale Order












      Product Qty Unit Price Subtotal Delivery cost Intrastat value Pack.Cost
      Prod.A 10,0 € 10,50 € 105,00 € 6,56 € 111,56 € 3,28
      Prod.B 10,0 € 5,50 € 55,00 € 3,44 € 58,44 € 1,72
      Packaging 1,0 € 5,00 € 5,00


      Delivery 1,0 € 10,00 € 10,00


      TOTAL

      		€ 175,00


      Tot.Goods & Service 20
      		€ 160,00 € 10,00 € 170,00 € 5,00


      Antonio M. Vigliotti

      Mobile (+39) 342.8740910



      Il 15/03/21 01:56, Marco Marchiori ha scritto:
      Graeme

      as you said I was not so accurate to include the IAS compliance in the discussion.
      In any case we defined the nature of such costs: they are variable costs, they should be included in cogs but they could be allocated, with a sort of ABC, "depending on the sales order composition".
      If they are "extra-amounts" (as Daniel said) they should be allocated in addition to the cost (apparently) already included in the product, but of course I would not discuss IAS compliance here!
      So I suggested to track them separately (we agree on that).
      Then the entry I advised to make was an absorption one, that would work both in continental and anglo-saxon accounting.
      If I worked for a business like that (independently from IAS) I would ask myself if it's more important the cost of the product or the cost of the order...

      Ciao

      Marco

      Il giorno dom 14 mar 2021 alle ore 21:57 Graeme Gellatly <gdgellatly@gmail.com> ha scritto:
      Hi,

      Under IAS2 this advice is not correct. It is very clear that product costs relate to bringing the product to its present location and condition. It cannot include non incurred costs, or costs that form part of the sales process. Now if it forms part of a manufacturing process, then they can be included under costs of conversion, but only if they are part of that conversion. If there is no production process then no costs. If there is then actually the manufacturing process handles it all already because it occurs prior to the sales transaction.

      Here is the exact clause.
      The cost of inventories shall comprise all costs of purchase, costs of conversion and other costs incurred in bringing the inventories to their present location and condition.

      So in this case where the packaging costs are part of the sales process they do not form cost of inventories. Indeed any costs incurred in the selling process are explicitly excluded.

      However it should of course be included in Cost of Goods sold, but it is no different to any other cost / revenue required at time of sale (or purchase for that matter), such as rebates, discounts on either the vendor/customer side related to a particular customer. It is a very common use case, and its the same reason you need to accrue warranty liability accrual at time of sale rather than in inventories (or time of claim for that matter). The only tricky part being the management of the sales transaction because you need some way to record that (y), which is variable in this case, but effectively you end up with.

      CR Inventory - Product A x
      CR Packaging y
      DR COGS - Product A (x+y).

      Is how I'd do it, probably just adding the packaging to the picking (not the sale) and then overriding the anglosaxon entries to allocate costs.

      That is the simple case, Obviously there is a mix of products involved, all utilising the packaging, so a reasonable allocation decision needs to be made, probably a dollar weighted basis, but possibly volume. Under anglo saxon the way Odoo operates it will be a significant amount of work, as you then need to reconcile both sides of the accrual accounts, but really it is no different to the same issue you have with A/P accrual accounts and having to allow for expected rebates.

      On Mon, Mar 15, 2021 at 8:32 AM Marco Marchiori <info@marcomarchiori.com> wrote:

      In general (accountant's view)
      1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
      2- The actual cost should be recorded when incurred (order > invoice)
      3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
      4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold

      Ciao

      Marco 

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      M a r c o  M a r c h i o r i    
      consulente funzionale
      dottore commercialista, revisore  legale
      Via Stazione 12, 30035 MIRANO (VE);    telefono  e  fax  041 488195
      codice fiscale   MRCMRC67H11F241M;      partita IVA   03813290271

      --
      This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. Use of such information is exclusively reserved for the recipient of this e-mail.
      --

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe


      by Antonio M. Vigliotti - 10:00 - 15 Mar 2021

      3 attachments 3 attachments

      AntonioMariaVigliotti_html_2a3b0efbc5e4661a.png
      AntonioMariaVigliotti_html_51f470c428b0fa9b.png
      AntonioMariaVigliotti_html_60baa43d7331dc71.png
    • Re: Track sales packaging costs
      Graeme

      as you said I was not so accurate to include the IAS compliance in the discussion.
      In any case we defined the nature of such costs: they are variable costs, they should be included in cogs but they could be allocated, with a sort of ABC, "depending on the sales order composition".
      If they are "extra-amounts" (as Daniel said) they should be allocated in addition to the cost (apparently) already included in the product, but of course I would not discuss IAS compliance here!
      So I suggested to track them separately (we agree on that).
      Then the entry I advised to make was an absorption one, that would work both in continental and anglo-saxon accounting.
      If I worked for a business like that (independently from IAS) I would ask myself if it's more important the cost of the product or the cost of the order...

      Ciao

      Marco

      Il giorno dom 14 mar 2021 alle ore 21:57 Graeme Gellatly <gdgellatly@gmail.com> ha scritto:
      Hi,

      Under IAS2 this advice is not correct. It is very clear that product costs relate to bringing the product to its present location and condition. It cannot include non incurred costs, or costs that form part of the sales process. Now if it forms part of a manufacturing process, then they can be included under costs of conversion, but only if they are part of that conversion. If there is no production process then no costs. If there is then actually the manufacturing process handles it all already because it occurs prior to the sales transaction.

      Here is the exact clause.
      The cost of inventories shall comprise all costs of purchase, costs of conversion and other costs incurred in bringing the inventories to their present location and condition.

      So in this case where the packaging costs are part of the sales process they do not form cost of inventories. Indeed any costs incurred in the selling process are explicitly excluded.

      However it should of course be included in Cost of Goods sold, but it is no different to any other cost / revenue required at time of sale (or purchase for that matter), such as rebates, discounts on either the vendor/customer side related to a particular customer. It is a very common use case, and its the same reason you need to accrue warranty liability accrual at time of sale rather than in inventories (or time of claim for that matter). The only tricky part being the management of the sales transaction because you need some way to record that (y), which is variable in this case, but effectively you end up with.

      CR Inventory - Product A x
      CR Packaging y
      DR COGS - Product A (x+y).

      Is how I'd do it, probably just adding the packaging to the picking (not the sale) and then overriding the anglosaxon entries to allocate costs.

      That is the simple case, Obviously there is a mix of products involved, all utilising the packaging, so a reasonable allocation decision needs to be made, probably a dollar weighted basis, but possibly volume. Under anglo saxon the way Odoo operates it will be a significant amount of work, as you then need to reconcile both sides of the accrual accounts, but really it is no different to the same issue you have with A/P accrual accounts and having to allow for expected rebates.

      On Mon, Mar 15, 2021 at 8:32 AM Marco Marchiori <info@marcomarchiori.com> wrote:

      In general (accountant's view)
      1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
      2- The actual cost should be recorded when incurred (order > invoice)
      3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
      4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold

      Ciao

      Marco 

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      M a r c o  M a r c h i o r i    
      consulente funzionale
      dottore commercialista, revisore  legale
      Via Stazione 12, 30035 MIRANO (VE);    telefono  e  fax  041 488195
      codice fiscale   MRCMRC67H11F241M;      partita IVA   03813290271

      --
      This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. Use of such information is exclusively reserved for the recipient of this e-mail.
      --
      by Marco Marchiori - 01:56 - 15 Mar 2021
    • Re: Track sales packaging costs
      Hi,

      Under IAS2 this advice is not correct. It is very clear that product costs relate to bringing the product to its present location and condition. It cannot include non incurred costs, or costs that form part of the sales process. Now if it forms part of a manufacturing process, then they can be included under costs of conversion, but only if they are part of that conversion. If there is no production process then no costs. If there is then actually the manufacturing process handles it all already because it occurs prior to the sales transaction.

      Here is the exact clause.
      The cost of inventories shall comprise all costs of purchase, costs of conversion and other costs incurred in bringing the inventories to their present location and condition.

      So in this case where the packaging costs are part of the sales process they do not form cost of inventories. Indeed any costs incurred in the selling process are explicitly excluded.

      However it should of course be included in Cost of Goods sold, but it is no different to any other cost / revenue required at time of sale (or purchase for that matter), such as rebates, discounts on either the vendor/customer side related to a particular customer. It is a very common use case, and its the same reason you need to accrue warranty liability accrual at time of sale rather than in inventories (or time of claim for that matter). The only tricky part being the management of the sales transaction because you need some way to record that (y), which is variable in this case, but effectively you end up with.

      CR Inventory - Product A x
      CR Packaging y
      DR COGS - Product A (x+y).

      Is how I'd do it, probably just adding the packaging to the picking (not the sale) and then overriding the anglosaxon entries to allocate costs.

      That is the simple case, Obviously there is a mix of products involved, all utilising the packaging, so a reasonable allocation decision needs to be made, probably a dollar weighted basis, but possibly volume. Under anglo saxon the way Odoo operates it will be a significant amount of work, as you then need to reconcile both sides of the accrual accounts, but really it is no different to the same issue you have with A/P accrual accounts and having to allow for expected rebates.

      On Mon, Mar 15, 2021 at 8:32 AM Marco Marchiori <info@marcomarchiori.com> wrote:

      In general (accountant's view)
      1- A standard, or minimum or what-you-want package cost should be included in product cost, and "absorbed" when you FG is produced
      2- The actual cost should be recorded when incurred (order > invoice)
      3- The extra-package cost would be the "algebraic sum" of cost incurred and absorbed
      4- The total package cost would be the sum of extra and COGS-included package cost or (sould be the same) the total cost incurred referred to the product sold

      Ciao

      Marco 

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Graeme Gellatly - 09:55 - 14 Mar 2021
  • Track sales packaging costs
    Hello,

    Here is a functional issue I could use some brain sharing.

    A sales order needs packaging to be shipped to the customer.
    But product margins are tight and, depending on the value of the products sold, packaging costs can have a significant impact on the sales margin.
    Adding to the Product cost an extra amount for average packaging costs is not a solution, as the actual packaging costs depend on the sales order composition.

    This looks a bit like "landed costs" but for sales.
    It also looks a bit like "additional carrier shipping costs", but is an inventory expense rather than a vendor bill to be paid.
    There is no hard requirement to include the costs in the COGS, we are more interested in margin analysis.
     
    Thanks for sharing your ideas

    --
    Daniel Reis
    Managing Director
    M: +351 919991307
    E: DReis@OpenSourceIntegrators.com
    Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


    by Daniel Reis - 11:21 - 10 Mar 2021

    2 replies 2 replies

  • partner_revision module? 
    A client wants to keep a history of archived res.partner records lying 
around, to be able to link invoices to the exact partner record that was 
used for the invoice at the time (address details, etc).

Is there a module lying around somewhere that does this?
    by Tom Blauwendraat - 03:00 - 4 Mar 2021

    2 replies 2 replies

  • Integration of mailing.mailing (Email marketing) templates and webiste pages? 
    Hello,

let me start in this way. When receiving e-mail campaign mails from various 
sources, they usually contain a link saying "If you cannot read this email 
properly, click here to display on web" or something like that for cases when 
email client forbids loading external content or just cannot render the HTML 
content properly. The link leads to a webpage where there is basically the 
same content as in the email.

Now I would like to achieve something similar. I.e. to be able to send themed 
marketing emails and have them contain link to website page as a alternative 
way of displaying the content. That webpage should be a normal webpage - will 
be advertised through other means as well (Facebook, Instagram, ...)

Now I know I could design/create both email template and website page but that 
just doubles the work. So I am looking for something like one of these 
alternatives:

*) You design the email and have it render (create) the website page with the 
same content.
*) The same as above but just the other way around. Create webpage and from 
that have email generated.
*) Something else?

Can anyone advise anything in this regards? Or am I missing something as 
usual? ;-)

Best regards

	Radovan Skolnik
    by Radovan Skolnik - 09:20 - 4 Mar 2021

    5 replies 5 replies

    • Re: Integration of mailing.mailing (Email marketing) templates and webiste pages? 
      Simeno, thanx a lot again. Will dive into that.

	Radovan

On štvrtok 4. marca 2021 13:01:47 CET Simone Orsi wrote:

> On Thu, Mar 4, 2021 at 11:27 AM Radovan Skolnik < radovan@skolnik.info [1] >

> wrote: Thank you Simone!

> I was thinking about something exactly like this. How would you propose to

> handle a situation where I want to have a general copy of that email/page -

> for example shared via FB campaign? That is not linked to any specific

> recipient (or is linked to a pseudo one). Should I maybe extend extend the

> mail_browser_view controller to provide something like /campaing/view/

> <string:token> which would render the same content without tracking? Or to

> save removing the tracking elements and create a special version of

> mail.mail to be used in static linking from other websites? Hope I am clear

> :-) I see. Yeah maybe a fake recipient mail record is the easiest way. Then

> to strip out elements on rendering you could rely on query string params.

> Another approach would be to not use mail_browser_view for such case and do

> something custom based on

> https://github.com/OCA/social/blob/13.0/mail_layout_preview/controllers/lay

> out_preview.py [2]  This way you render what you want w/ whatever record you

> want. Best regards

> Radovan

> 

> On štvrtok 4. marca 2021 10:57:46 CET Simone Orsi wrote:

> > Hello,

> > this should address your issue

> > 

> >  https://github.com/OCA/social/tree/11.0/mail_browser_view [3] [1] And if

> >  you> 

> > want to test/dev your templates before sending them w/ real content you

> > can

> > use  https://github.com/OCA/social/tree/13.0/mail_layout_preview [4] [2]

> > HTH, On Thu, Mar 4, 2021 at 9:21 AM Radovan Skolnik < 

> > radovan@skolnik.info [5] [3] > wrote: Hello,

> > let me start in this way. When receiving e-mail campaign mails from

> > various

> > sources, they usually contain a link saying "If you cannot read this email

> > properly, click here to display on web" or something like that for cases

> > when email client forbids loading external content or just cannot render

> > the HTML content properly. The link leads to a webpage where there is

> > basically the same content as in the email.

> > Now I would like to achieve something similar. I.e. to be able to send

> > themed marketing emails and have them contain link to website page as a

> > alternative way of displaying the content. That webpage should be a normal

> > webpage - will be advertised through other means as well (Facebook,

> > Instagram, ...) Now I know I could design/create both email template and

> > website page but that just doubles the work. So I am looking for something

> > like one of these alternatives:

> > *) You design the email and have it render (create) the website page with

> > the same content.

> > *) The same as above but just the other way around. Create webpage and

> > from

> > that have email generated.

> > *) Something else?

> > Can anyone advise anything in this regards? Or am I missing something as

> > usual? ;-)

> > Best regards

> > Radovan Skolnik

> > 

> > 

> > _______________________________________________

> > Mailing-List:  https://odoo-community.org/groups/contributors-15 [6] [4]

> > Post to: mailto:  contributors@odoo-community.org [7] [5]

> > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [8] [6]

> > 

> > --

> > Simone Orsi

> > Full stack Python web developer,

> > Odoo specialist,

> > Odoo Community Board Member,

> > Freelance

> > in love with open source.

> > _______________________________________________

> > Mailing-List:  https://odoo-community.org/groups/contributors-15 [9] [7]

> > Post to: mailto: contributors@odoo-community.org [10]

> > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [11] [8]

> > 

> > 

> > 

> > [1]  https://github.com/OCA/social/tree/11.0/mail_browser_view [12]

> > [2]  https://github.com/OCA/social/tree/13.0/mail_layout_preview [13]

> > [3] mailto: radovan@skolnik.info [14]

> > [4]  https://odoo-community.org/groups/contributors-15 [15]

> > [5] mailto: contributors@odoo-community.org [16]

> > [6]  https://odoo-community.org/groups?unsubscribe [17]

> > [7]  https://odoo-community.org/groups/contributors-15 [18]

> > [8]  https://odoo-community.org/groups?unsubscribe [19]

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [20]

> Post to: mailto: contributors@odoo-community.org [21]

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [22]

> 

> --

> Simone Orsi

> Full stack Python web developer,

> Odoo specialist,

> Odoo Community Board Member,

> Freelance

> in love with open source.

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [23]

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [24]

> 

> 

> 

> [1] mailto:radovan@skolnik.info

> [2]

> https://github.com/OCA/social/blob/13.0/mail_layout_preview/controllers/lay

> out_preview.py [3] https://github.com/OCA/social/tree/11.0/mail_browser_view

> [4] https://github.com/OCA/social/tree/13.0/mail_layout_preview

> [5] mailto:radovan@skolnik.info

> [6] https://odoo-community.org/groups/contributors-15

> [7] mailto:contributors@odoo-community.org

> [8] https://odoo-community.org/groups?unsubscribe

> [9] https://odoo-community.org/groups/contributors-15

> [10] mailto:contributors@odoo-community.org

> [11] https://odoo-community.org/groups?unsubscribe

> [12] https://github.com/OCA/social/tree/11.0/mail_browser_view

> [13] https://github.com/OCA/social/tree/13.0/mail_layout_preview

> [14] mailto:radovan@skolnik.info

> [15] https://odoo-community.org/groups/contributors-15

> [16] mailto:contributors@odoo-community.org

> [17] https://odoo-community.org/groups?unsubscribe

> [18] https://odoo-community.org/groups/contributors-15

> [19] https://odoo-community.org/groups?unsubscribe

> [20] https://odoo-community.org/groups/contributors-15

> [21] mailto:contributors@odoo-community.org

> [22] https://odoo-community.org/groups?unsubscribe

> [23] https://odoo-community.org/groups/contributors-15

> [24] https://odoo-community.org/groups?unsubscribe
      by Radovan Skolnik - 01:10 - 4 Mar 2021
    • Re: Integration of mailing.mailing (Email marketing) templates and webiste pages?
      On Thu, Mar 4, 2021 at 11:27 AM Radovan Skolnik <radovan@skolnik.info> wrote:
      Thank you Simone!

I was thinking about something exactly like this. How would you propose to 
handle a situation where I want to have a general copy of that email/page - 
for example shared via FB campaign? That is not linked to any specific 
recipient (or is linked to a pseudo one). Should I maybe extend extend the 
mail_browser_view controller to provide something like /campaing/view/
<string:token> which would render the same content without tracking? Or to 
save removing the tracking elements and create a special version of mail.mail 
to be used in static linking from other websites? Hope I am clear :-)

      I see. Yeah maybe a fake recipient mail record is the easiest way.
      Then to strip out elements on rendering you could rely on query string params.
      Another approach would be to not use mail_browser_view for such case
      This way you render what you want w/ whatever record you want.
       
      Best regards

	Radovan

On štvrtok 4. marca 2021 10:57:46 CET Simone Orsi wrote:


> Hello,


> this should address your issue


> https://github.com/OCA/social/tree/11.0/mail_browser_view [1] And if you


> want to test/dev your templates before sending them w/ real content you can


> use https://github.com/OCA/social/tree/13.0/mail_layout_preview [2] HTH,


> On Thu, Mar 4, 2021 at 9:21 AM Radovan Skolnik < radovan@skolnik.info [3] >


> wrote: Hello,


> let me start in this way. When receiving e-mail campaign mails from various


> sources, they usually contain a link saying "If you cannot read this email


> properly, click here to display on web" or something like that for cases


> when email client forbids loading external content or just cannot render


> the HTML content properly. The link leads to a webpage where there is


> basically the same content as in the email.


> Now I would like to achieve something similar. I.e. to be able to send


> themed marketing emails and have them contain link to website page as a


> alternative way of displaying the content. That webpage should be a normal


> webpage - will be advertised through other means as well (Facebook,


> Instagram, ...) Now I know I could design/create both email template and


> website page but that just doubles the work. So I am looking for something


> like one of these alternatives:


> *) You design the email and have it render (create) the website page with


> the same content.


> *) The same as above but just the other way around. Create webpage and from


> that have email generated.


> *) Something else?


> Can anyone advise anything in this regards? Or am I missing something as


> usual? ;-)


> Best regards


> Radovan Skolnik


> 


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15 [4]


> Post to: mailto: contributors@odoo-community.org [5]


> Unsubscribe: https://odoo-community.org/groups?unsubscribe [6]


> 


> --


> Simone Orsi


> Full stack Python web developer,


> Odoo specialist,


> Odoo Community Board Member,


> Freelance


> in love with open source.


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15 [7]


> Post to: mailto:contributors@odoo-community.org


> Unsubscribe: https://odoo-community.org/groups?unsubscribe [8]


> 


> 


> 


> [1] https://github.com/OCA/social/tree/11.0/mail_browser_view


> [2] https://github.com/OCA/social/tree/13.0/mail_layout_preview


> [3] mailto:radovan@skolnik.info


> [4] https://odoo-community.org/groups/contributors-15


> [5] mailto:contributors@odoo-community.org


> [6] https://odoo-community.org/groups?unsubscribe


> [7] https://odoo-community.org/groups/contributors-15


> [8] https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      Simone Orsi

      Full stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source.
      by Simone Orsi - 01:00 - 4 Mar 2021
    • Re: Integration of mailing.mailing (Email marketing) templates and webiste pages? 
      Thank you Simone!

I was thinking about something exactly like this. How would you propose to 
handle a situation where I want to have a general copy of that email/page - 
for example shared via FB campaign? That is not linked to any specific 
recipient (or is linked to a pseudo one). Should I maybe extend extend the 
mail_browser_view controller to provide something like /campaing/view/
<string:token> which would render the same content without tracking? Or to 
save removing the tracking elements and create a special version of mail.mail 
to be used in static linking from other websites? Hope I am clear :-)

Best regards

	Radovan

On štvrtok 4. marca 2021 10:57:46 CET Simone Orsi wrote:

> Hello,

> this should address your issue

> https://github.com/OCA/social/tree/11.0/mail_browser_view [1] And if you

> want to test/dev your templates before sending them w/ real content you can

> use https://github.com/OCA/social/tree/13.0/mail_layout_preview [2] HTH,

> On Thu, Mar 4, 2021 at 9:21 AM Radovan Skolnik < radovan@skolnik.info [3] >

> wrote: Hello,

> let me start in this way. When receiving e-mail campaign mails from various

> sources, they usually contain a link saying "If you cannot read this email

> properly, click here to display on web" or something like that for cases

> when email client forbids loading external content or just cannot render

> the HTML content properly. The link leads to a webpage where there is

> basically the same content as in the email.

> Now I would like to achieve something similar. I.e. to be able to send

> themed marketing emails and have them contain link to website page as a

> alternative way of displaying the content. That webpage should be a normal

> webpage - will be advertised through other means as well (Facebook,

> Instagram, ...) Now I know I could design/create both email template and

> website page but that just doubles the work. So I am looking for something

> like one of these alternatives:

> *) You design the email and have it render (create) the website page with

> the same content.

> *) The same as above but just the other way around. Create webpage and from

> that have email generated.

> *) Something else?

> Can anyone advise anything in this regards? Or am I missing something as

> usual? ;-)

> Best regards

> Radovan Skolnik

> 

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [4]

> Post to: mailto: contributors@odoo-community.org [5]

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [6]

> 

> --

> Simone Orsi

> Full stack Python web developer,

> Odoo specialist,

> Odoo Community Board Member,

> Freelance

> in love with open source.

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [7]

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [8]

> 

> 

> 

> [1] https://github.com/OCA/social/tree/11.0/mail_browser_view

> [2] https://github.com/OCA/social/tree/13.0/mail_layout_preview

> [3] mailto:radovan@skolnik.info

> [4] https://odoo-community.org/groups/contributors-15

> [5] mailto:contributors@odoo-community.org

> [6] https://odoo-community.org/groups?unsubscribe

> [7] https://odoo-community.org/groups/contributors-15

> [8] https://odoo-community.org/groups?unsubscribe
      by Radovan Skolnik - 11:26 - 4 Mar 2021
    • Re: Integration of mailing.mailing (Email marketing) templates and webiste pages?
      Oh, forgot to mention: this won't prevent you to write 2 templates BUT if you use 


      and


      You can get to workable solution w/outing getting insane as you can reuse styles and templates.

      On Thu, Mar 4, 2021 at 10:52 AM Simone Orsi <simahawk@gmail.com> wrote:
      Hello,


      And if you want to test/dev your templates before sending them w/ real content you can use https://github.com/OCA/social/tree/13.0/mail_layout_preview

      HTH,


      On Thu, Mar 4, 2021 at 9:21 AM Radovan Skolnik <radovan@skolnik.info> wrote:
      Hello,

let me start in this way. When receiving e-mail campaign mails from various 
sources, they usually contain a link saying "If you cannot read this email 
properly, click here to display on web" or something like that for cases when 
email client forbids loading external content or just cannot render the HTML 
content properly. The link leads to a webpage where there is basically the 
same content as in the email.

Now I would like to achieve something similar. I.e. to be able to send themed 
marketing emails and have them contain link to website page as a alternative 
way of displaying the content. That webpage should be a normal webpage - will 
be advertised through other means as well (Facebook, Instagram, ...)

Now I know I could design/create both email template and website page but that 
just doubles the work. So I am looking for something like one of these 
alternatives:

*) You design the email and have it render (create) the website page with the 
same content.
*) The same as above but just the other way around. Create webpage and from 
that have email generated.
*) Something else?

Can anyone advise anything in this regards? Or am I missing something as 
usual? ;-)

Best regards

	Radovan Skolnik

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      Simone Orsi

      Full stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source.


      --
      Simone Orsi

      Full stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source.
      by Simone Orsi - 10:56 - 4 Mar 2021
    • Re: Integration of mailing.mailing (Email marketing) templates and webiste pages?
      Hello,


      And if you want to test/dev your templates before sending them w/ real content you can use https://github.com/OCA/social/tree/13.0/mail_layout_preview

      HTH,


      On Thu, Mar 4, 2021 at 9:21 AM Radovan Skolnik <radovan@skolnik.info> wrote:
      Hello,

let me start in this way. When receiving e-mail campaign mails from various 
sources, they usually contain a link saying "If you cannot read this email 
properly, click here to display on web" or something like that for cases when 
email client forbids loading external content or just cannot render the HTML 
content properly. The link leads to a webpage where there is basically the 
same content as in the email.

Now I would like to achieve something similar. I.e. to be able to send themed 
marketing emails and have them contain link to website page as a alternative 
way of displaying the content. That webpage should be a normal webpage - will 
be advertised through other means as well (Facebook, Instagram, ...)

Now I know I could design/create both email template and website page but that 
just doubles the work. So I am looking for something like one of these 
alternatives:

*) You design the email and have it render (create) the website page with the 
same content.
*) The same as above but just the other way around. Create webpage and from 
that have email generated.
*) Something else?

Can anyone advise anything in this regards? Or am I missing something as 
usual? ;-)

Best regards

	Radovan Skolnik

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      Simone Orsi

      Full stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source.
      by Simone Orsi - 10:56 - 4 Mar 2021
  • Partner Hierarchy module
    Hello,

    I'm quite sure there was an OCA module to enable multilevel Partner parent/child relations, but I'm not finding it right now.
    Use cases are Partner structures like: Holding company / Company / Branch Office / Contact.

    Am I missing something?

    Thanks!

    --
    Daniel Reis
    Managing Director
    M: +351 919991307
    E: DReis@OpenSourceIntegrators.com
    Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


    by Daniel Reis - 05:26 - 3 Mar 2021

    9 replies 9 replies

    • Re: Partner Hierarchy module
      Contact relation is a tricky thing, takes a lot of insight and thinking as it relates to almost every area of odoo. It's master data, after all. 
      We also looked into the various OCA contact extensions, and they are great, but somtimes they were not enough to fulfill the needs of various customers. Thus we additionally created a contact location extension, contact ++, togheter with contact hierachy.
      In particular this can be helpful if a person is located in a company, but also works in a home office and is associated with a branch office of this organisation that is the regular work location of this contact. Electronic communication (phone/mail, etc) means are likewise related.

      BTW: Besides of 80 other enhancement,  as for 14 we now have developed and included a "studio" product and various shipping connectors into the ITISeasy.business distro. Lauching soon. 

      Von: "Holger Brunn" <mail@hunki-enterprises.com>
      An: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
      Gesendet: Mittwoch, 3. März 2021 19:07:28
      Betreff: Re: Partner Hierarchy module

      > No hierarchy in the sense of parent_of though with 


> https://github.com/OCA/partner-contact/tree/13.0/partner_multi_relation [1]


> Only feedback, in environments with the granularity requested on the


> partners, we simultaneously have requests for qualifications of relations


> between partners without any parent relations as funders, investors,


> administrators ... and partner_multi_relation module is a good complement

when conceiving this originally, I did toy with a `transitive` checkbox, then 
you could use transitive relations just like parent_of. But as the customer 
lost interest in this feature, so did I. Maybe Daniel will add it?

OTOH this case sounds more like composite relations: When partner A has 
relation X with B, and B relation Y with C, then A and C have relation Z. This 
also sounds like a very useful feature to have, and I think will be much less 
computationally expensive to implement if you don't just store the transitive 
closure above.



-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe


      by Joerg Lorenz. - 11:21 - 4 Mar 2021
    • Re: Partner Hierarchy module

      p.s. partner in separate companies was meant to be a separate reply from our branch requirements 🙁 - Should have put a clearer divide....

      Richard deMeester

      Senior Development Analyst

      WilldooIT Pty Ltd

      E: richard.demeester@willdooit.com

      M: +61 403 76 76 76

      P: +61 3 9135 1900

      A: 10/435 Williamstown Road, Port Melbourne, Vic 3207

       

       

      Making growth through technology easy

       

       

      DISCLAIMER | This electronic message together with any attachments is confidential. If you are not the recipient, do not copy, disclose, or use the contents in any way. Please also advise us by e-mail that you have received this message in error and then please destroy this email and any of its attachments. WilldooIT Pty. Ltd. is not responsible for any changes made to this message and/or any attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd. use virus scanning software but exclude all liability for virus or anything similar in this email or attachment.

      From: Daniel Reis <dreis@opensourceintegrators.com>
      Sent: Thursday, 4 March 2021 3:27 AM
      To: Contributors <contributors@odoo-community.org>
      Subject: Partner Hierarchy module
       
      Hello,

      I'm quite sure there was an OCA module to enable multilevel Partner parent/child relations, but I'm not finding it right now.
      Use cases are Partner structures like: Holding company / Company / Branch Office / Contact.

      Am I missing something?

      Thanks!

      --
      Daniel Reis
      Managing Director
      M: +351 919991307
      E: DReis@OpenSourceIntegrators.com
      Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by "Richard deMeester" <richard.demeester@willdooit.com> - 10:30 - 4 Mar 2021

      2 attachments 2 attachments

      Outlook-cusq0kuq.png
      Outlook-misckdbq.jpg
    • Re: Partner Hierarchy module

      Morning,

      Slightly off topic, but not entirely, we are looking at migrating the contact in several companies to v14, and it is not on the to be migrated list, does anyone know why?

      Internally, we have created a "holding compamy" module, but would be interested in an OCA inspired solution.

      We have a link between "branch" and "holding company", and then they can obvioulsy have their standard contacts beneath.  The nice things we added are:

      Check boxes on "does the invoice accumulate with the branch or the holding company", "statements go to branch / holding company" (some franchises want them to behave differently) , meaning on a case by case basis the call can be made to send the invoice up the chain or to the holding company.  We also have mods in the purchasing side to allow holding companies to have purchase prices, and when a PO goes to a branch, it uses the holding company's pricelist to buy.

      This has real use when dealing with "stores" from one chain, or "franchises".  These are common structures where two "company" entities need to be associated with each other.

      Richard

      Richard deMeester

      Senior Development Analyst

      WilldooIT Pty Ltd

      E: richard.demeester@willdooit.com

      M: +61 403 76 76 76

      P: +61 3 9135 1900

      A: 10/435 Williamstown Road, Port Melbourne, Vic 3207

       

       

      Making growth through technology easy

       

       

      DISCLAIMER | This electronic message together with any attachments is confidential. If you are not the recipient, do not copy, disclose, or use the contents in any way. Please also advise us by e-mail that you have received this message in error and then please destroy this email and any of its attachments. WilldooIT Pty. Ltd. is not responsible for any changes made to this message and/or any attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd. use virus scanning software but exclude all liability for virus or anything similar in this email or attachment.

      From: Holger Brunn <mail@hunki-enterprises.com>
      Sent: Thursday, 4 March 2021 5:07 AM
      To: Contributors <contributors@odoo-community.org>
      Subject: Re: Partner Hierarchy module
       
      > No hierarchy in the sense of parent_of though with 

> https://github.com/OCA/partner-contact/tree/13.0/partner_multi_relation [1]

> Only feedback, in environments with the granularity requested on the

> partners, we simultaneously have requests for qualifications of relations

> between partners without any parent relations as funders, investors,

> administrators ... and partner_multi_relation module is a good complement

when conceiving this originally, I did toy with a `transitive` checkbox, then 
you could use transitive relations just like parent_of. But as the customer 
lost interest in this feature, so did I. Maybe Daniel will add it?

OTOH this case sounds more like composite relations: When partner A has 
relation X with B, and B relation Y with C, then A and C have relation Z. This 
also sounds like a very useful feature to have, and I think will be much less 
computationally expensive to implement if you don't just store the transitive 
closure above.


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by "Richard deMeester" <richard.demeester@willdooit.com> - 10:30 - 4 Mar 2021

      2 attachments 2 attachments

      Outlook-f3dd2oci.png
      Outlook-lnmyfreq.jpg
    • Re: Partner Hierarchy module 
      > No hierarchy in the sense of parent_of though with 

> https://github.com/OCA/partner-contact/tree/13.0/partner_multi_relation [1]

> Only feedback, in environments with the granularity requested on the

> partners, we simultaneously have requests for qualifications of relations

> between partners without any parent relations as funders, investors,

> administrators ... and partner_multi_relation module is a good complement

when conceiving this originally, I did toy with a `transitive` checkbox, then 
you could use transitive relations just like parent_of. But as the customer 
lost interest in this feature, so did I. Maybe Daniel will add it?

OTOH this case sounds more like composite relations: When partner A has 
relation X with B, and B relation Y with C, then A and C have relation Z. This 
also sounds like a very useful feature to have, and I think will be much less 
computationally expensive to implement if you don't just store the transitive 
closure above.


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com
      by Holger Brunn - 07:06 - 3 Mar 2021

      1 attachments 1 attachments

      signature.asc
    • Re: Partner Hierarchy module
      Completely agree with you Holger

      No hierarchy in the sense of parent_of though with https://github.com/OCA/partner-contact/tree/13.0/partner_multi_relation

      Only feedback, in environments with the granularity requested on the partners, we simultaneously have requests for qualifications of relations between partners without any parent relations as funders, investors, administrators ... and partner_multi_relation module is a good complement :) 
      Bruno Joliveau - Président
      NUMIGI SOLUTIONS INC.
      (514) 317-7944

      Longueuil, Québec, Canada

      linkedinyoutubecustom-icontwitter


      Le mer. 3 mars 2021 à 12:16, Holger Brunn <mail@hunki-enterprises.com> a écrit :
      > Use cases are Partner structures like: Holding company / Company /


> Branch Office / Contact.


> Am I missing something?

https://github.com/OCA/partner-contact/tree/13.0/partner_multi_relation?
No hierarchy in the sense of parent_of though


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Bruno Joliveau - 06:41 - 3 Mar 2021

  • Proposing moving Pledra product configurator to the OCA
    Hello all,

    Some of you may be familiar with the Pledra project, proposing an advanced product configurator.
    https://github.com/pledra/odoo-product-configurator

    I don't think there is a comparable project in the OCA, and I would like proposing to move Pledra under the OCA umbrella.
    I contacted the original author, Paul Catinean, and he  is supportive of this move.
    There are quite a few details to get right, and I'm ready to take the role and address them.

    At this point the main question is, from a high level PoV if this sounds like a good idea, and what concerns we should address when moving forward.

    Thank you, and thanks Paul for being onboard with this.

    --
    Daniel Reis
    Managing Director
    M: +351 919991307
    E: DReis@OpenSourceIntegrators.com
    Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


    by Daniel Reis - 05:01 - 3 Mar 2021

    23 replies 23 replies

    • Re: Proposing moving Pledra product configurator to the OCA
      +++++1

      Regards,
      Vishal Mehra

      cell: (972) 853-1805

      BizAlytics Consulting
      Analyzing Your Business for Success


      On Thu, Mar 4, 2021 at 7:32 AM Thorsten Vocks <thorsten.vocks@big-consulting.net> wrote:
      pledra configurator is really great. +1
      Thorsten Vocks

      openBIG.org
      Dipl. Kaufmann (FH)
      Porscheweg 4-6
      49661 Cloppenburg

      Phone: +49 4471 8409000
      Fax: +49 4471 84090009
      Mail: thorsten.vocks@openbig.org

                    


      Am Mi., 3. März 2021 um 17:02 Uhr schrieb Daniel Reis <dreis@opensourceintegrators.com>:
      Hello all,

      Some of you may be familiar with the Pledra project, proposing an advanced product configurator.
      https://github.com/pledra/odoo-product-configurator

      I don't think there is a comparable project in the OCA, and I would like proposing to move Pledra under the OCA umbrella.
      I contacted the original author, Paul Catinean, and he  is supportive of this move.
      There are quite a few details to get right, and I'm ready to take the role and address them.

      At this point the main question is, from a high level PoV if this sounds like a good idea, and what concerns we should address when moving forward.

      Thank you, and thanks Paul for being onboard with this.

      --
      Daniel Reis
      Managing Director
      M: +351 919991307
      E: DReis@OpenSourceIntegrators.com
      Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Vishal Mehra - 02:06 - 6 Mar 2021
    • Re: Proposing moving Pledra product configurator to the OCA
      pledra configurator is really great. +1
      Thorsten Vocks

      openBIG.org
      Dipl. Kaufmann (FH)
      Porscheweg 4-6
      49661 Cloppenburg

      Phone: +49 4471 8409000
      Fax: +49 4471 84090009
      Mail: thorsten.vocks@openbig.org

                    


      Am Mi., 3. März 2021 um 17:02 Uhr schrieb Daniel Reis <dreis@opensourceintegrators.com>:
      Hello all,

      Some of you may be familiar with the Pledra project, proposing an advanced product configurator.
      https://github.com/pledra/odoo-product-configurator

      I don't think there is a comparable project in the OCA, and I would like proposing to move Pledra under the OCA umbrella.
      I contacted the original author, Paul Catinean, and he  is supportive of this move.
      There are quite a few details to get right, and I'm ready to take the role and address them.

      At this point the main question is, from a high level PoV if this sounds like a good idea, and what concerns we should address when moving forward.

      Thank you, and thanks Paul for being onboard with this.

      --
      Daniel Reis
      Managing Director
      M: +351 919991307
      E: DReis@OpenSourceIntegrators.com
      Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Thorsten Vocks - 02:31 - 4 Mar 2021
    • Re: Proposing moving Pledra product configurator to the OCA
      +1

      Peter Langenberg
      Senior Odoo Consultant
      Product Owner Odoo
      Volg op twitter via : @mylbco




      Op do 4 mrt. 2021 om 13:56 schreef Paul Catinean <paulcatinean@gmail.com>:
      Hello everyone,

      I'm happy to see there is still great support on this project, both from customers and the community.

      While the initial intent to provide an ever evolving generic app did not go as planned I'm sure under the OCA umbrella it can grow faster and better.

      We have plans to refactor some bits of the architecture already but it's something we can discuss together after the move.

      Regards,
      Paul



      On Thu, Mar 4, 2021 at 11:32 AM Frederik Kramer <frederik.kramer@initos.com> wrote:
      Sounds great

@Daniel: I think we seldomly got more +1 within just two days. Would
you mind to get in touch with Paul to make the first handover quickly.
I think -from what we've discussed over the years- he would be more
than happy to see things evolve like this! And its definitely an added
value for the OCA ecosystem.

Best Frederik

Am Donnerstag, den 04.03.2021, 09:22 +0000 schrieb
luc.demeyer@noviat.com:



> We are running the configurator in production on Odoo 13.



> 



> A small couple of PR’s were sufficient for our use case.



> 



> I think we can use the current 13.0 code as the base for the OCA repo



> and do the refactoring in a second stage.



> 



>  



> 



> Luc



> 



>  



> 



> From: Richard deMeester <richard.demeester@willdooit.com> 



> Sent: Thursday, 4 March 2021 10:12



> To: Contributors <contributors@odoo-community.org>



> Subject: Re: Proposing moving Pledra product configurator to the OCA



> 



>  



> 



> Hi,



> 



>  



> 



> I had much involvement with this repo in v10, and ended up with a



> multitude of enhancements and patches outside of the configurator.



> 



>  



> 



> It is an awesome tool, and while at the low end, the Odoo tool can do



> a lot, at the top end, this is the deal.



> 



>  



> 



> Unfortunately, I feel that to bring it up to 13/14 needs a



> considerable rethink in some of the architecture, but in my spare



> time, I would be very keen to assist in this worthwhile project.



> 



>  



> 



> Richard



> 



>  



> 



> 



> Richard deMeester



> Senior Development Analyst



> WilldooIT Pty Ltd



> E: richard.demeester@willdooit.com



> M: +61 403 76 76 76



> P: +61 3 9135 1900



> A: 10/435 Williamstown Road, Port Melbourne, Vic 3207



>  



>  



> Making growth through technology easy



>  



> 



>  



> DISCLAIMER | This electronic message together with any attachments is



> confidential. If you are not the recipient, do not copy, disclose, or



> use the contents in any way. Please also advise us by e-mail that you



> have received this message in error and then please destroy this



> email and any of its attachments. WilldooIT Pty. Ltd. is not



> responsible for any changes made to this message and/or any



> attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd.



> use virus scanning software but exclude all liability for virus or



> anything similar in this email or attachment.



>  



> 



> From: Daniel Reis <dreis@opensourceintegrators.com>



> Sent: Thursday, 4 March 2021 3:02 AM



> To: Contributors <contributors@odoo-community.org>



> Subject: Proposing moving Pledra product configurator to the OCA



> 



>  



> 



> Hello all,



> 



> Some of you may be familiar with the Pledra project, proposing an



> advanced product configurator.



> https://github.com/pledra/odoo-product-configurator



> 



> I don't think there is a comparable project in the OCA, and I would



> like proposing to move Pledra under the OCA umbrella.



> I contacted the original author, Paul Catinean, and he  is supportive



> of this move.



> There are quite a few details to get right, and I'm ready to take the



> role and address them.



> 



> At this point the main question is, from a high level PoV if this



> sounds like a good idea, and what concerns we should address when



> moving forward.



> 



> Thank you, and thanks Paul for being onboard with this. 



> 



> 



> --



> 



> DANIEL REIS



> MANAGING DIRECTOR



> 



> M: +351 919991307



> E: DReis@OpenSourceIntegrators.com



> 



> AV DOUTOR DESIDÉRIO CAMBOURNAC 12 • 2710-553 SINTRA, PORTUGAL



> 



>  



> 



> 



> 



> 



> 



> 



> _______________________________________________



> Mailing-List: https://odoo-community.org/groups/contributors-15



> Post to: mailto:contributors@odoo-community.org



> Unsubscribe: https://odoo-community.org/groups?unsubscribe



> 



> _______________________________________________



> Mailing-List: https://odoo-community.org/groups/contributors-15



> Post to: mailto:contributors@odoo-community.org



> Unsubscribe: https://odoo-community.org/groups?unsubscribe



> 



> _______________________________________________



> Mailing-List: https://odoo-community.org/groups/contributors-15



> Post to: mailto:contributors@odoo-community.org



> Unsubscribe: https://odoo-community.org/groups?unsubscribe



-- 
Dr.-Ing. Frederik Kramer
Geschäftsführer
        
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
        
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
        
Email: frederik.kramer@initos.com
Web:   www.initos.com
        
Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Peter Langenberg - 02:21 - 4 Mar 2021
    • Re: Proposing moving Pledra product configurator to the OCA
      Hello everyone,

      I'm happy to see there is still great support on this project, both from customers and the community.

      While the initial intent to provide an ever evolving generic app did not go as planned I'm sure under the OCA umbrella it can grow faster and better.

      We have plans to refactor some bits of the architecture already but it's something we can discuss together after the move.

      Regards,
      Paul



      On Thu, Mar 4, 2021 at 11:32 AM Frederik Kramer <frederik.kramer@initos.com> wrote:
      Sounds great

@Daniel: I think we seldomly got more +1 within just two days. Would
you mind to get in touch with Paul to make the first handover quickly.
I think -from what we've discussed over the years- he would be more
than happy to see things evolve like this! And its definitely an added
value for the OCA ecosystem.

Best Frederik

Am Donnerstag, den 04.03.2021, 09:22 +0000 schrieb
luc.demeyer@noviat.com:


> We are running the configurator in production on Odoo 13.


> 


> A small couple of PR’s were sufficient for our use case.


> 


> I think we can use the current 13.0 code as the base for the OCA repo


> and do the refactoring in a second stage.


> 


>  


> 


> Luc


> 


>  


> 


> From: Richard deMeester <richard.demeester@willdooit.com> 


> Sent: Thursday, 4 March 2021 10:12


> To: Contributors <contributors@odoo-community.org>


> Subject: Re: Proposing moving Pledra product configurator to the OCA


> 


>  


> 


> Hi,


> 


>  


> 


> I had much involvement with this repo in v10, and ended up with a


> multitude of enhancements and patches outside of the configurator.


> 


>  


> 


> It is an awesome tool, and while at the low end, the Odoo tool can do


> a lot, at the top end, this is the deal.


> 


>  


> 


> Unfortunately, I feel that to bring it up to 13/14 needs a


> considerable rethink in some of the architecture, but in my spare


> time, I would be very keen to assist in this worthwhile project.


> 


>  


> 


> Richard


> 


>  


> 


> 


> Richard deMeester


> Senior Development Analyst


> WilldooIT Pty Ltd


> E: richard.demeester@willdooit.com


> M: +61 403 76 76 76


> P: +61 3 9135 1900


> A: 10/435 Williamstown Road, Port Melbourne, Vic 3207


>  


>  


> Making growth through technology easy


>  


> 


>  


> DISCLAIMER | This electronic message together with any attachments is


> confidential. If you are not the recipient, do not copy, disclose, or


> use the contents in any way. Please also advise us by e-mail that you


> have received this message in error and then please destroy this


> email and any of its attachments. WilldooIT Pty. Ltd. is not


> responsible for any changes made to this message and/or any


> attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd.


> use virus scanning software but exclude all liability for virus or


> anything similar in this email or attachment.


>  


> 


> From: Daniel Reis <dreis@opensourceintegrators.com>


> Sent: Thursday, 4 March 2021 3:02 AM


> To: Contributors <contributors@odoo-community.org>


> Subject: Proposing moving Pledra product configurator to the OCA


> 


>  


> 


> Hello all,


> 


> Some of you may be familiar with the Pledra project, proposing an


> advanced product configurator.


> https://github.com/pledra/odoo-product-configurator


> 


> I don't think there is a comparable project in the OCA, and I would


> like proposing to move Pledra under the OCA umbrella.


> I contacted the original author, Paul Catinean, and he  is supportive


> of this move.


> There are quite a few details to get right, and I'm ready to take the


> role and address them.


> 


> At this point the main question is, from a high level PoV if this


> sounds like a good idea, and what concerns we should address when


> moving forward.


> 


> Thank you, and thanks Paul for being onboard with this. 


> 


> 


> --


> 


> DANIEL REIS


> MANAGING DIRECTOR


> 


> M: +351 919991307


> E: DReis@OpenSourceIntegrators.com


> 


> AV DOUTOR DESIDÉRIO CAMBOURNAC 12 • 2710-553 SINTRA, PORTUGAL


> 


>  


> 


> 


> 


> 


> 


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15


> Post to: mailto:contributors@odoo-community.org


> Unsubscribe: https://odoo-community.org/groups?unsubscribe


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15


> Post to: mailto:contributors@odoo-community.org


> Unsubscribe: https://odoo-community.org/groups?unsubscribe


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15


> Post to: mailto:contributors@odoo-community.org


> Unsubscribe: https://odoo-community.org/groups?unsubscribe


-- 
Dr.-Ing. Frederik Kramer
Geschäftsführer
        
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
        
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
        
Email: frederik.kramer@initos.com
Web:   www.initos.com
        
Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Paul Catinean - 01:55 - 4 Mar 2021
    • Re: Proposing moving Pledra product configurator to the OCA 
      Sounds great

@Daniel: I think we seldomly got more +1 within just two days. Would
you mind to get in touch with Paul to make the first handover quickly.
I think -from what we've discussed over the years- he would be more
than happy to see things evolve like this! And its definitely an added
value for the OCA ecosystem.

Best Frederik

Am Donnerstag, den 04.03.2021, 09:22 +0000 schrieb
luc.demeyer@noviat.com:

> We are running the configurator in production on Odoo 13.

> 

> A small couple of PR’s were sufficient for our use case.

> 

> I think we can use the current 13.0 code as the base for the OCA repo

> and do the refactoring in a second stage.

> 

>  

> 

> Luc

> 

>  

> 

> From: Richard deMeester <richard.demeester@willdooit.com> 

> Sent: Thursday, 4 March 2021 10:12

> To: Contributors <contributors@odoo-community.org>

> Subject: Re: Proposing moving Pledra product configurator to the OCA

> 

>  

> 

> Hi,

> 

>  

> 

> I had much involvement with this repo in v10, and ended up with a

> multitude of enhancements and patches outside of the configurator.

> 

>  

> 

> It is an awesome tool, and while at the low end, the Odoo tool can do

> a lot, at the top end, this is the deal.

> 

>  

> 

> Unfortunately, I feel that to bring it up to 13/14 needs a

> considerable rethink in some of the architecture, but in my spare

> time, I would be very keen to assist in this worthwhile project.

> 

>  

> 

> Richard

> 

>  

> 

> 

> Richard deMeester

> Senior Development Analyst

> WilldooIT Pty Ltd

> E: richard.demeester@willdooit.com

> M: +61 403 76 76 76

> P: +61 3 9135 1900

> A: 10/435 Williamstown Road, Port Melbourne, Vic 3207

>  

>  

> Making growth through technology easy

>  

> 

>  

> DISCLAIMER | This electronic message together with any attachments is

> confidential. If you are not the recipient, do not copy, disclose, or

> use the contents in any way. Please also advise us by e-mail that you

> have received this message in error and then please destroy this

> email and any of its attachments. WilldooIT Pty. Ltd. is not

> responsible for any changes made to this message and/or any

> attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd.

> use virus scanning software but exclude all liability for virus or

> anything similar in this email or attachment.

>  

> 

> From: Daniel Reis <dreis@opensourceintegrators.com>

> Sent: Thursday, 4 March 2021 3:02 AM

> To: Contributors <contributors@odoo-community.org>

> Subject: Proposing moving Pledra product configurator to the OCA

> 

>  

> 

> Hello all,

> 

> Some of you may be familiar with the Pledra project, proposing an

> advanced product configurator.

> https://github.com/pledra/odoo-product-configurator

> 

> I don't think there is a comparable project in the OCA, and I would

> like proposing to move Pledra under the OCA umbrella.

> I contacted the original author, Paul Catinean, and he  is supportive

> of this move.

> There are quite a few details to get right, and I'm ready to take the

> role and address them.

> 

> At this point the main question is, from a high level PoV if this

> sounds like a good idea, and what concerns we should address when

> moving forward.

> 

> Thank you, and thanks Paul for being onboard with this. 

> 

> 

> --

> 

> DANIEL REIS

> MANAGING DIRECTOR

> 

> M: +351 919991307

> E: DReis@OpenSourceIntegrators.com

> 

> AV DOUTOR DESIDÉRIO CAMBOURNAC 12 • 2710-553 SINTRA, PORTUGAL

> 

>  

> 

> 

> 

> 

> 

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe

-- 
Dr.-Ing. Frederik Kramer
Geschäftsführer
        
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
        
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
        
Email: frederik.kramer@initos.com
Web:   www.initos.com
        
Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155
      by Frederik Kramer - 10:30 - 4 Mar 2021

  • Google Analytics config
    Hi

    I reinstalled Odoo when 14 came out, and recreated the website. Now I would like to configure Google Analytics, but where do I find the client ID of a website project that has already been created?

    Sorry if this is off topic, but it is and it isn't...



    Torvald Baade Bringsvor
    Bringsvor Consulting AS - Developer, consultant, allrounder

    Tel (+47) 4548 2848
    by Torvald Bringsvor - 12:35 - 3 Mar 2021
  • Image gallery for Odoo
    Hi

    I have one more requirement for this website I'm doing. It's kind of directed towards tourism and the people "owning" the site want to have a photo album on the page.... I feel photo albums on websites are very 1997 but I don't make (all) the shots.

    So... what would be a good way to display an album on an Odoo site, to show off this marvellous island that people should go see (when Corona is over). ?

    Btw the website is www.sandsoy.no

    -Torvald

    Torvald Baade Bringsvor
    Bringsvor Consulting AS - Developer, consultant, allrounder

    Tel (+47) 4548 2848
    by Torvald Bringsvor - 12:31 - 3 Mar 2021

    2 replies 2 replies

    • RE: Image gallery for Odoo

      Nice island! Actually looked at this spot when planning a fishing trip .. but the corona hit us ☹

       

      Nice work.

       

      regards

      Teo / Sweden

       

      From: Torvald Baade Bringsvor <torvald@bringsvor.com>
      Sent: den 3 mars 2021 00:33
      To: Contributors <contributors@odoo-community.org>
      Subject: Image gallery for Odoo

       

      EXTERNAL SENDER: Do not click any links or open any attachments unless you trust the sender and know the content is safe.
      EXPÉDITEUR EXTERNE:       Ne cliquez sur aucun lien et n’ouvrez aucune pièce jointe à moins qu’ils ne proviennent d’un expéditeur fiable, ou que vous ayez l'assurance que le contenu provient d'une source sûre.

       

      Hi

       

      I have one more requirement for this website I'm doing. It's kind of directed towards tourism and the people "owning" the site want to have a photo album on the page.... I feel photo albums on websites are very 1997 but I don't make (all) the shots.

       

      So... what would be a good way to display an album on an Odoo site, to show off this marvellous island that people should go see (when Corona is over). ?

       

      Btw the website is www.sandsoy.no

       

      -Torvald

       

      Torvald Baade Bringsvor

      Bringsvor Consulting AS - Developer, consultant, allrounder

      Tel (+47) 4548 2848

      by teo.pezo - 12:26 - 31 Mar 2021
    • Re: Image gallery for Odoo
      Hi..There is a "Image Gallery" component in the left pane of the website builder...you must add/upload the album images and call them from the "Image Gallery" component..will this work


      Sender notified by
      Mailtrack 03/30/21, 06:14:50 PM

      On Wed, Mar 3, 2021 at 5:02 AM Torvald Baade Bringsvor <torvald@bringsvor.com> wrote:
      Hi

      I have one more requirement for this website I'm doing. It's kind of directed towards tourism and the people "owning" the site want to have a photo album on the page.... I feel photo albums on websites are very 1997 but I don't make (all) the shots.

      So... what would be a good way to display an album on an Odoo site, to show off this marvellous island that people should go see (when Corona is over). ?

      Btw the website is www.sandsoy.no

      -Torvald

      Torvald Baade Bringsvor
      Bringsvor Consulting AS - Developer, consultant, allrounder

      Tel (+47) 4548 2848

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Sevate Software Services Pvt Ltd - 02:50 - 30 Mar 2021
  • Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
    Dear community,

    I'd like to be a PSC for the following teams: 
    - Logistics
    - Field Services
    - Storage

    Github profile : https://github.com/hparfr

    Thanks,

    --
    Raphaël Reverdy

    by Raphaël Reverdy - 04:41 - 1 Mar 2021

    11 replies 11 replies

  • OCA BOT can't merge PRs in OCA/l10n-italy branch 11.0
    Can anyone help us to understand why the BOT can't merge this PR


    or this one 


    ?

    Thank you.
    --

    Francesco Apruzzese

    Profilo professionale: http://it.linkedin.com/in/francescoapruzzese

    Il contenuto di questo messaggio elettronico è riservato e tutelato dal segreto professionale ed è rivolto esclusivamente al/ai destinatario/i identificato/i. Pertanto è proibito leggerlo, copiarlo, divulgarlo o utilizzarlo da parte di chiunque salvo il/i destinatario/i. Se non siete il destinatario, vi invitiamo a cancellare il messaggio ed eventuali allegati dandocene immediatamente comunicazione scritta a mezzo posta elettronica.
    This e-mail and any attachments are confidential and may contain information intended for the addressee(s) only. Reading, copying, disclosure or use by anybody else is unauthorised. If you are not the intended recipient, please delete this message and any attachments and advise the sender by return e-mail.

    Non stampare questa email se non strettamente necessario. Aiuta te ed aiuta l'ambiente.
    by Francesco Apruzzese - 02:21 - 1 Mar 2021

    17 replies 17 replies

  • Async import external employee data from db view to Odoo.
    Dear Community,

    We need to get data from external HR applications (they will provide an mssql database view), for users and employee data into Odoo.

    It seems to be quite a generic use case, to become an addon, so I want to check with community, would be nice to know how you normally cope with this.

    I checked OCA and plan to use the followings as starting point.
    Thank you!
    Kitti U.

    by Kitti Upariphutthiphong - 09:51 - 28 Feb 2021

    9 replies 9 replies

  • Postgresql Table partitioning in Odoo
    Dear contributors,

    We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?

    Looking forward to hearing your thoughts. 

    Regards,
    --
    Jordi Ballester Alomar
    CEO & Founder | ForgeFlow
    by Jordi Ballester Alomar - 08:16 - 26 Feb 2021

    5 replies 5 replies

    • Re: Postgresql Table partitioning in Odoo
      Graeme,

      I have considered for example to create materialized views for aggregated data in connection with the financial reports, MIS Builder, etc. The drawback is that it essentially requires you to introduce a lot of changes to the application logic in order to make use of those materialized views. At this stage partitioning seems to me like a better idea, because the change is (almost) limited to the database, and you can continue to use the application as it has been designed.

      I'm not concerned (yet) by the 32 bits limitation of id's.

      On Sat, Feb 27, 2021 at 3:12 AM Graeme Gellatly <gdgellatly@gmail.com> wrote:
      Hi,

      It's not really practical unfortunately. You can't just decide to use partitions. Well I suppose maybe you could rename the existing table, create a new one partitioned and then attach the renamed table as a partition if you were doing partition by date or id. I think a lot of the problem with aml in particular is the rows have gotten very wide as well.

      Materialized views, partial indexes, clustering tables, even just good GIN indexing are all quite a lot simpler and can offer far better performance depending on need. Indeed I remember 8 or 9 years ago there was a popular module for account move lines which implemented what could best be described as homegrown matviews to store aggregate AML data. However, all these solutions are still constrained by Odoo 32 bit id's. So if by getting large you mean approaching the billions, then that's a new set of problems.

      There is one set of solutions which I'm quite interested in for performance. That is using logical BDR to partition the write server of multi master databases. It seems this is doable without too much change but Odoo's id model doesn't meet the requirements, needing either GUID or BIGSERIAL. My idea is essentially to partition tables say geographically on some field, say company id, or create_uid and then run local Odoo instances in those geographies with their own pg cluster but achieving global consistency.

      On Sat, Feb 27, 2021 at 8:17 AM Jordi Ballester Alomar <jordi.ballester@forgeflow.com> wrote:
      Dear contributors,

      We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?

      Looking forward to hearing your thoughts. 

      Regards,
      --
      Jordi Ballester Alomar
      CEO & Founder | ForgeFlow

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      Jordi Ballester Alomar
      CEO & Founder | ForgeFlow
      by Jordi Ballester Alomar - 07:26 - 27 Feb 2021
    • Re: Postgresql Table partitioning in Odoo
      Nhomar,

      In this case the account_move_line table is larger than 10 millions records. The company is using inventory accounting, and does a lot of inventory transactions. That does not help, as it creates a big number of inventory related AML's. I'd like to get rid of inventory accounting, of course! :)

      We refactored the OCA financial reports completely, for example, and certainly this has added a lot of benefits.

      What makes sense for me with partitioning a table, especially in accounting, is that you don't often make use of previous years move lines, except when you are computing an initial balance.

      I tried to manually transform the account_move_line to a partitioned table with success. See https://github.com/odoo/odoo/pull/66964. I would need to test with a large database now to check if this really brings the expected benefits.

      As Daniel Reis suggestested, using partial indexes seems interesting. However the Postgres recommends not to use them when partitioning really makes more sense. https://www.postgresql.org/docs/current/indexes-partial.html

      "If your table is large enough that a single index really is a bad idea, you should look into using partitioning instead (see Section 5.11). With that mechanism, the system does understand that the tables and indexes are non-overlapping, so far better performance is possible."

      Partitioning in odoo must be limited to using always the "id" column in the partitions, as the primary key must be contained in all partitions.



      On Fri, Feb 26, 2021 at 8:57 PM Nhomar Hernández <nhomar@vauxoo.com> wrote:
      How many records is for you **Absurd**.?

      We try to fix odoo performance in the views or tools that are slow with records over between 1 and 10 millions.

      But not always touch postgres will help.. Did you make the measurement?

      El vie, 26 de feb. de 2021 a la(s) 13:17, Jordi Ballester Alomar (jordi.ballester@forgeflow.com) escribió:
      Dear contributors,

      We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?

      Looking forward to hearing your thoughts. 

      Regards,
      --
      Jordi Ballester Alomar
      CEO & Founder | ForgeFlow

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --

      Nhomar G Hernández

      Vauxoo | CEO

      ¡Construyamos algo genial!
      Cel: +52 (477) 393.3942 | Telegram: nhomar | Twitter: @nhomar

      México · Venezuela · Costa Rica · Perú

      phone nhomar@vauxoo.com phone vauxoo.com/contactus  

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --
      Jordi Ballester Alomar
      CEO & Founder | ForgeFlow
      by Jordi Ballester Alomar - 07:21 - 27 Feb 2021
    • Re: Postgresql Table partitioning in Odoo
      Hi,

      It's not really practical unfortunately. You can't just decide to use partitions. Well I suppose maybe you could rename the existing table, create a new one partitioned and then attach the renamed table as a partition if you were doing partition by date or id. I think a lot of the problem with aml in particular is the rows have gotten very wide as well.

      Materialized views, partial indexes, clustering tables, even just good GIN indexing are all quite a lot simpler and can offer far better performance depending on need. Indeed I remember 8 or 9 years ago there was a popular module for account move lines which implemented what could best be described as homegrown matviews to store aggregate AML data. However, all these solutions are still constrained by Odoo 32 bit id's. So if by getting large you mean approaching the billions, then that's a new set of problems.

      There is one set of solutions which I'm quite interested in for performance. That is using logical BDR to partition the write server of multi master databases. It seems this is doable without too much change but Odoo's id model doesn't meet the requirements, needing either GUID or BIGSERIAL. My idea is essentially to partition tables say geographically on some field, say company id, or create_uid and then run local Odoo instances in those geographies with their own pg cluster but achieving global consistency.

      On Sat, Feb 27, 2021 at 8:17 AM Jordi Ballester Alomar <jordi.ballester@forgeflow.com> wrote:
      Dear contributors,

      We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?

      Looking forward to hearing your thoughts. 

      Regards,
      --
      Jordi Ballester Alomar
      CEO & Founder | ForgeFlow

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Graeme Gellatly - 03:11 - 27 Feb 2021
    • Re: Postgresql Table partitioning in Odoo
      Hello Jordi,

      In some cases Partial Indexes can do the trick.

      For example, you could have a partial index only for active records. Since most of the time there is filter condition on the active field, the smaller partial index can be used instead of a full index.

      This can give you the same benefits as a partitioned table, with a simpler solution (no need to push data around).

      More info:


      --dr 

      No dia 26/02/2021, às 19:17, Jordi Ballester Alomar <jordi.ballester@forgeflow.com> escreveu:

      
      Dear contributors,

      We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?

      Looking forward to hearing your thoughts. 

      Regards,
      --
      Jordi Ballester Alomar
      CEO & Founder | ForgeFlow

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe

      by Daniel Reis - 09:36 - 26 Feb 2021
    • Re: Postgresql Table partitioning in Odoo
      How many records is for you **Absurd**.?

      We try to fix odoo performance in the views or tools that are slow with records over between 1 and 10 millions.

      But not always touch postgres will help.. Did you make the measurement?

      El vie, 26 de feb. de 2021 a la(s) 13:17, Jordi Ballester Alomar (jordi.ballester@forgeflow.com) escribió:
      Dear contributors,

      We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?

      Looking forward to hearing your thoughts. 

      Regards,
      --
      Jordi Ballester Alomar
      CEO & Founder | ForgeFlow

      _______________________________________________
      Mailing-List: https://odoo-community.org/groups/contributors-15
      Post to: mailto:contributors@odoo-community.org
      Unsubscribe: https://odoo-community.org/groups?unsubscribe



      --

      Nhomar G Hernández

      Vauxoo | CEO

      ¡Construyamos algo genial!
      Cel: +52 (477) 393.3942 | Telegram: nhomar | Twitter: @nhomar

      México · Venezuela · Costa Rica · Perú

      phone nhomar@vauxoo.com phone vauxoo.com/contactus  

      by Nhomar Hernández - 08:56 - 26 Feb 2021