Skip to Content
  2. Mailing Lists
  3. Contributors

Archives

  • Translations done by a webservice
    Hi all,

    Do you know any Odoo open source module that is able to translate user generated content (product descriptions for example) in an integrated way?

    Thanks in advance.
    by Pedro M. Baeza - 11:11 - 22 Jun 2022

    2 replies 2 replies

    • Re: Translations done by a webservice 
      On 22/06/2022 11:12, Pedro M. Baeza (Tecnativa) wrote:

> Hi all,

> 

> Do you know any Odoo open source module that is able to translate user 

> generated content (product descriptions for example) in an integrated way?

> 

Hi,

I don't know a ready to use odoo addon for this but what about 
argos-translate ?

You can use it directly in your code as a python module,

Use it offline, set up your own server, use a public server using api, ...

Depending if you want use it offline from addon code(pure python, 
privacy, silent machine translation), or from the frontend (js using api 
(private or public), end user live double check)

For example it seems very fast and easy to just add an automated action 
to update translations with this tool.

https://github.com/argosopentech/argos-translate

You can try it online here :

https://libretranslate.com

https://github.com/LibreTranslate/LibreTranslate


-- 
Simon Maillard
simon@ogesta.fr

Parce que sinon ça rend la discussion incompréhensible.
 > Pourquoi ça ?
 >> Je préfère répondre en dessous.
 >>> Que faites-vous à la place ?
 >>>> Non.
 >>>>> Vous n'aimez pas répondre au-dessus ?
      by simon - 02:56 - 22 Jun 2022
    • Re: Translations done by a webservice
      Hi Pedro and community,

      We looked for different possibilities with already existing Odoo modules. Finally, our last tests were oriented towards services like https://weglot.com

      Have a nice day !
      Bruno Joliveau - Président
      NUMIGI SOLUTIONS INC.
      (514) 317-7944

      Longueuil, Québec, Canada

      linkedinyoutubecustom-icontwitter


      Le mer. 22 juin 2022 à 05:12, Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> a écrit :
      Hi all,

      Do you know any Odoo open source module that is able to translate user generated content (product descriptions for example) in an integrated way?

      Thanks in advance.

      _______________________________________________
      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 - 02:25 - 22 Jun 2022
  • Split of contract/agreement
    Hi all,

    Before merging the first agreement module to v15, and after some discussions I've had about overloaded repositories, I want to create a new one for those related.

    The PR for agreement is here, where I've already suggested it: https://github.com/OCA/contract/pull/795

    Thanks for your feedback on this

    --

    Denis Roussel
    Software Engineer
    T    : +32 2 888 31 49
    M : +32 472 22 00 57


    Val Benoit, Quai Banning 6 | B-4000 Liège | Belgium
    Atrium Building, Drève Richelle 167 | B-1410 Waterloo | Belgium
    Zone industrielle 22 | L-8287 Kehlen | Luxembourg
    by Denis Roussel. - 08:41 - 20 Jun 2022

    5 replies 5 replies

  • Module loading priority and inheritance
    Hi,

    I just installed the auth_totp module to add MFA support to our odoo 12.0 instance and its behaviour is totally broken after a server restart when the auth_ldap module is also installed.

    Because _check_credentials logic is just made to accept at least one Valid authentication and not globally refuse any authentication, the current implementation of the auth_totp will always fail if a module validate _check_credentials after that the MfaLoginNeeded exception is raised.

    To me it's more a framework issue and the manifest should allow a new priority value to sort modules without inter-dependencies (because actually, it seems to use an alphabetic sorting based on module name).
    But without this, how do you handle such situations ?

    --
    Yann PAPOUIN, Ingénieur R&D | DEC

    by Yann Papouin - 03:31 - 15 Jun 2022

    5 replies 5 replies

    • Re: Module loading priority and inheritance
      Richard, I understand your concern about the priority number, but having it in our toolbox could still be extremely useful.

      As a first step, I made a PR that implements both:

      Contrary to my original proposal, I don't alter the SQL query, the sorting is done in python like the dependency loading by using the manifest attributes (not stored in the DB)


      by Yann Papouin - 03:21 - 17 Jun 2022
    • Re: Module loading priority and inheritance

      Yann,

      Yes, we too have occasionally encountered such issues.  Bridging modules are sometimes required to ensure correct execution, but then, that is still for modules all within our control.

      We often find the issue worst when using a third-party app, where there is a complete method overwrite (and maybe justifiably so).


      Under your proposal, though, one would need to know about the modules causing the issue - which generally, I guess, is feasable.

      I do wonder, though, if implementing a "soft_depends" as opposed to a loading priority, is better.

      If randomly, in a manifest, there is a loading priority, then you sort of need to know and set all the other loading priorities, even in the third party modules, which may have their own issues.

      A soft depends, at least, it is clear that "this module has a conflict with that module which is now resolved by this dependency", as a priority number just gets lost (like sequences on views when you have many modules extending views)

      I would love to see something in this area...

      Richard


       

       

      Kind Regards 

       

       

      A close up of a sign Description automatically generated 

       

      Richard deMeester 

      Senior Development Analyst 

      richard.demeester@willdooit.com 

       

       

       

       

      T: (03) 9135 1900 | M: 0403 76 76 76 | A: Bld 10/435 Williamstown Road, Port Melbourne, 3207 

       

      A picture containing monitor, screen, holding, person Description automatically generated 

       

       
      MAKING GROWTH THROUGH TECHNOLOGY EASY 

       
      Notice: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you may not disclose or use the information in this email in any way. If you have received this email in error please notify the sender. Although reasonable precautions have been taken to ensure no viruses are present in this email, no responsibility is accepted by WilldooIT Pty Ltd or its related entities for any loss or damage arising from the use of this email or attachments. Any views expressed in this email or file attachments are those of the individual sender only, unless expressly stated to be those of WilldooIT Pty Ltd  ABN 85 006 073 052 or any of its related entities. 

       

       


      From: Yann Papouin <ypa@decgroupe.com>
      Sent: Friday, 17 June 2022 7:02 PM
      To: Contributors <contributors@odoo-community.org>
      Subject: Re: Module loading priority and inheritance
       
      After investigation, the sequence field is only used for the kanban view to display applications in a specific order.

      Module list is fetched from database in odoo/odoo/modules/loading.py::load_marked_modules with this query

      cr.execute("SELECT name from ir_module_module WHERE state IN %s" ,(tuple(states),))

      So, the module loading order actually depends on 4 params:
      1. PostgreSQL database collation
      2. Module name
      3. Datetime of the creation of the ir_module_module row (since no ORDER BY is defined in the query)
      4. The dependencies
      That's a terrible loading implementation as the parameter 3 is based on an internal postgreSQL data, it also depends on the list order of your addons_path and also depends on when odoo/addons/base/models/ir_module.py::update_list is called.

      Example for this last assertion:
      • On the development database:
        • You add the module account_extra, that depends on account and override method update_something, in your main addons path
        • update_list()
        • Two weeks later, you add the module account_best , that also depends on account and also override the method update_something, in your main addons path
        • update_list()
        • Module account_extra will be loaded before account_best
      • Three weeks later, on the production database:
        • You add modules account_extra and account_best in your main addons path
        • update_list()
        • Module account_best will be loaded before account_extra
      And there I'm not talking about other cases like:
      • Multiple addons_path
      • Manual module deletion from odoo module list followed by a module list update
      • Manual module installation from UI whereas the server is already started with loaded modules

      So, I agree that most cases would be solved by the depends attribute but a fix could still be:
      • Add a loading_priority manifest key:
        • default value is 0 if not set, could be positive (load before) or negative (load after)
        • add an ORDER BY loading_priority, name in all SQL query of the loading.py
      • Add a soft_depends manifest key:
        • a list of modules that we depends on, only if they exists and are installed

      _______________________________________________
      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> - 02:46 - 17 Jun 2022

      5 attachments 5 attachments

      Outlook-5xqrm2jz.png
      Outlook-A picture .png
      Outlook-xsjdn3kg.png
      Outlook-xwsfd0mz.png
      Outlook-A close up.png
    • Re: Module loading priority and inheritance
      Thanks for the investigation. Your proposals seems good, but not sure if Odoo will add such mechanisms in the framework. You can try.

      Regards.
      by Pedro M. Baeza - 12:26 - 17 Jun 2022
    • Re: Module loading priority and inheritance
      After investigation, the sequence field is only used for the kanban view to display applications in a specific order.

      Module list is fetched from database in odoo/odoo/modules/loading.py::load_marked_modules with this query

      cr.execute("SELECT name from ir_module_module WHERE state IN %s" ,(tuple(states),))

      So, the module loading order actually depends on 4 params:
      1. PostgreSQL database collation
      2. Module name
      3. Datetime of the creation of the ir_module_module row (since no ORDER BY is defined in the query)
      4. The dependencies
      That's a terrible loading implementation as the parameter 3 is based on an internal postgreSQL data, it also depends on the list order of your addons_path and also depends on when odoo/addons/base/models/ir_module.py::update_list is called.

      Example for this last assertion:
      • On the development database:
        • You add the module account_extra, that depends on account and override method update_something, in your main addons path
        • update_list()
        • Two weeks later, you add the module account_best , that also depends on account and also override the method update_something, in your main addons path
        • update_list()
        • Module account_extra will be loaded before account_best
      • Three weeks later, on the production database:
        • You add modules account_extra and account_best in your main addons path
        • update_list()
        • Module account_best will be loaded before account_extra
      And there I'm not talking about other cases like:
      • Multiple addons_path
      • Manual module deletion from odoo module list followed by a module list update
      • Manual module installation from UI whereas the server is already started with loaded modules

      So, I agree that most cases would be solved by the depends attribute but a fix could still be:
      • Add a loading_priority manifest key:
        • default value is 0 if not set, could be positive (load before) or negative (load after)
        • add an ORDER BY loading_priority, name in all SQL query of the loading.py
      • Add a soft_depends manifest key:
        • a list of modules that we depends on, only if they exists and are installed

      by Yann Papouin - 11:00 - 17 Jun 2022
    • Re: Module loading priority and inheritance
      AFAIK, there's a `sequence` manifest key for such loading order.

      Regards.
      by Pedro M. Baeza - 05:26 - 15 Jun 2022
  • Generic rest_api modules
    Hi all

    With Acsone, Camptocamp and Forgeflow, we are working on several generic rest_api modules on top of odoo/oca modules that can be used in whatever application you need (e-commerce, event, portal, ....)

    We were thinking first to put this modules in every related oca repo, but it's will make hard for us to maintain it (module will be everywhere)

    So we would like to have a centralized repository to put all this "api" modules so it will be easier
    - to have a quick overview for developper of the list of existing generic endpoint
    - to maintain, by having the api maintainer working on only one repo

    So are you ok with having a "rest-api" repo ?

    In the long term if this repo starts to be too big, we may split it by domain (sale-rest-api, manufacturing-rest-api...)

    Thanks
    by Sébastien Beau - 12:41 - 15 Jun 2022

    13 replies 13 replies

  • New repos proposal
    Hi all,

    I'd like to propose 2 new repos:

    1. web-api : collect modules to expose or deal with web api (eg: custom management for routes and endpoints, generic tools to handle calls to ext api, etc).

    2. pwa-builder : collect modules that allow to create and manage standalone PWA apps. As many of you know I split the core of the shopfloor wms app some time ago and this core now allows you to create - potentially - any kind of PWA app w/ its backend (based on rest services) and frontend tools (VueJS based). This core is now in OCA/wms but that's not really the right place. The name is not adequate too (shopfloor_base) so I think I'm going to rename it to pwa_core or pwa_builder or something similar.

    I'd say each of them should have its own PSC but maybe having one is fine too.

    Looking fwd to your feedback.

    Bests,

    --
    Simone Orsi

    Full stack Python web developer, Odoo specialist, Odoo Community Board Member, in love with open source.
    by Simone Orsi. - 09:21 - 14 Jun 2022

    14 replies 14 replies

    • Re: New repos proposal 
      Hi Simone,

Alright, you've convinced me and it seems others as well! Let's just go 
with "web-api" and "pwa-builder" then and do our best on the README's to 
make clear how they differ from "connector" and "rest-framework". It's 
good enough and frankly I am super interested in the code so I hope 
you'll be able to push it soon!

-Tom
      by Tom Blauwendraat - 05:50 - 21 Jun 2022
    • Re: New repos proposal
      +1



      Le mar. 21 juin 2022 à 11:37, Simone Orsi <simahawk@gmail.com> a écrit :
      Hi,

      On Thu, Jun 16, 2022 at 11:37 AM Tom Blauwendraat <tom@sunflowerweb.nl> wrote:

      To make these scope statements more concrete:

      1. web-api : collect modules to expose or deal with web api (eg: custom management for routes and endpoints, generic tools to handle calls to ext api, etc).
      This description as a scope statement IMO should be better, it should be crystal clear why this is not part of "OCA/rest-framework". As it stands now, this text does not teach or convince me why it should be separate. Could we come up with a better text?

      It's not about REST, it's about any kind of WEB related API that you might want to expose or call.
      Examples:
      * inbound - an endpoint to accept a file upload or to create a record
      * outbound - configuration of an external web service to call + reusable tools or api to make this happen

      In any case, the text I wrote in my first email was not intended to be the readme of the repo, was just to have an idea ;)
      2. pwa-builder : collect modules that allow to create and manage standalone PWA apps. As many of you know I split the core of the shopfloor wms app some time ago and this core now allows you to create - potentially - any kind of PWA app w/ its backend (based on rest services) and frontend tools (VueJS based). This core is now in OCA/wms but that's not really the right place. The name is not adequate too (shopfloor_base) so I think I'm going to rename it to pwa_core or pwa_builder or something similar.

      For this the reason to separate is much more clear. OCA/wms is definitely the wrong place, as you want to be able to use this framework for "any app".

      Three questions though:

      1. Why "builder" ? Does this actually build apps for you, or is it just a framework. A builder sounds to me as a tool that allows you to generate an app from building blocks. If a framework, "pwa", "pwa-core", "pwa-engine" or "pwa-framework" sounds more appropriate to me.


      To be honest I don't care that much about this name, I'm open for suggestions ;) "builder" sounded in line with "mis-builder" and generic enough to not require another repo for additional modules. I mean, if we call it pwa-core (which I like more) then I won't put any other module there which is not for the "core" and then we'll need a new one like pwa-contribs (or any similar name). I don't dislike this option. 
      Hence, if everybody prefers `-framework` or another option, I can change its name. No problem.
       

      2. Is this limited to be used as a PWA, or can it also just be used as a replacement for the Odoo web portal? In my view, a "PWA" is something that has a service worker and can be "installed" to your system. Otherwise something like "web-app-engine" would be more appropriate (analogous to reporting-engine: housing an alternative OCA reporting engine)

      Potentially you can build any kind of PWA on top of it. Up to you. The backend is separated from the front, see below. 
      Keeping PWA in the name sounds a bit more in line with what you'll end up with: an installable app. If you use it also as a website is up to you but you don't need it for creating a website only.

      3. Considering that it's based on VueJS, wouldn't a better name be "web-app-vuejs" or "pwa-vuejs", in order to separate it from efforts by any future OCA member companies who prefer Angular or React as their tool of choice, and want to open source their alternative engine?

      No, it's not for VueJS only. There's a backend part and a frontend part. Today the front is based on VueJS but if you want to rewrite the front w/ ReactJS, you could.
      The backend part - as far as possible - is conceived to provide configuration, routes and specific endpoints to retrieve core info for the app.

      Hope is more clear now :)

      Bests



      _______________________________________________
      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, in love with open source.

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



      --
      Raphaël Reverdy
      Mobile +33 6 38 02 03 93
      Fixe +33 4 82 53 84 60
      by Raphaël Reverdy - 04:41 - 21 Jun 2022
    • Re: New repos proposal
      Hi,

      On Thu, Jun 16, 2022 at 11:37 AM Tom Blauwendraat <tom@sunflowerweb.nl> wrote:

      To make these scope statements more concrete:

      1. web-api : collect modules to expose or deal with web api (eg: custom management for routes and endpoints, generic tools to handle calls to ext api, etc).
      This description as a scope statement IMO should be better, it should be crystal clear why this is not part of "OCA/rest-framework". As it stands now, this text does not teach or convince me why it should be separate. Could we come up with a better text?

      It's not about REST, it's about any kind of WEB related API that you might want to expose or call.
      Examples:
      * inbound - an endpoint to accept a file upload or to create a record
      * outbound - configuration of an external web service to call + reusable tools or api to make this happen

      In any case, the text I wrote in my first email was not intended to be the readme of the repo, was just to have an idea ;)
      2. pwa-builder : collect modules that allow to create and manage standalone PWA apps. As many of you know I split the core of the shopfloor wms app some time ago and this core now allows you to create - potentially - any kind of PWA app w/ its backend (based on rest services) and frontend tools (VueJS based). This core is now in OCA/wms but that's not really the right place. The name is not adequate too (shopfloor_base) so I think I'm going to rename it to pwa_core or pwa_builder or something similar.

      For this the reason to separate is much more clear. OCA/wms is definitely the wrong place, as you want to be able to use this framework for "any app".

      Three questions though:

      1. Why "builder" ? Does this actually build apps for you, or is it just a framework. A builder sounds to me as a tool that allows you to generate an app from building blocks. If a framework, "pwa", "pwa-core", "pwa-engine" or "pwa-framework" sounds more appropriate to me.


      To be honest I don't care that much about this name, I'm open for suggestions ;) "builder" sounded in line with "mis-builder" and generic enough to not require another repo for additional modules. I mean, if we call it pwa-core (which I like more) then I won't put any other module there which is not for the "core" and then we'll need a new one like pwa-contribs (or any similar name). I don't dislike this option. 
      Hence, if everybody prefers `-framework` or another option, I can change its name. No problem.
       

      2. Is this limited to be used as a PWA, or can it also just be used as a replacement for the Odoo web portal? In my view, a "PWA" is something that has a service worker and can be "installed" to your system. Otherwise something like "web-app-engine" would be more appropriate (analogous to reporting-engine: housing an alternative OCA reporting engine)

      Potentially you can build any kind of PWA on top of it. Up to you. The backend is separated from the front, see below. 
      Keeping PWA in the name sounds a bit more in line with what you'll end up with: an installable app. If you use it also as a website is up to you but you don't need it for creating a website only.

      3. Considering that it's based on VueJS, wouldn't a better name be "web-app-vuejs" or "pwa-vuejs", in order to separate it from efforts by any future OCA member companies who prefer Angular or React as their tool of choice, and want to open source their alternative engine?

      No, it's not for VueJS only. There's a backend part and a frontend part. Today the front is based on VueJS but if you want to rewrite the front w/ ReactJS, you could.
      The backend part - as far as possible - is conceived to provide configuration, routes and specific endpoints to retrieve core info for the app.

      Hope is more clear now :)

      Bests



      _______________________________________________
      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, in love with open source.
      by Simone Orsi. - 11:36 - 21 Jun 2022
    • Re: New repos proposal



      On 6/16/22 10:22, Daniel Reis wrote:

      Adding multiple repos makes it harder for contributors to know where to submit a new module.

      Can we make sure there are clear scope statements in the READMEs, and that these also link to the closely related ropes, helping contributors know about them.
      Agree with this totally.

      To make these scope statements more concrete:

      1. web-api : collect modules to expose or deal with web api (eg: custom management for routes and endpoints, generic tools to handle calls to ext api, etc).
      This description as a scope statement IMO should be better, it should be crystal clear why this is not part of "OCA/rest-framework". As it stands now, this text does not teach or convince me why it should be separate. Could we come up with a better text?

      2. pwa-builder : collect modules that allow to create and manage standalone PWA apps. As many of you know I split the core of the shopfloor wms app some time ago and this core now allows you to create - potentially - any kind of PWA app w/ its backend (based on rest services) and frontend tools (VueJS based). This core is now in OCA/wms but that's not really the right place. The name is not adequate too (shopfloor_base) so I think I'm going to rename it to pwa_core or pwa_builder or something similar.

      For this the reason to separate is much more clear. OCA/wms is definitely the wrong place, as you want to be able to use this framework for "any app".

      Three questions though:

      1. Why "builder" ? Does this actually build apps for you, or is it just a framework. A builder sounds to me as a tool that allows you to generate an app from building blocks. If a framework, "pwa", "pwa-core", "pwa-engine" or "pwa-framework" sounds more appropriate to me.

      2. Is this limited to be used as a PWA, or can it also just be used as a replacement for the Odoo web portal? In my view, a "PWA" is something that has a service worker and can be "installed" to your system. Otherwise something like "web-app-engine" would be more appropriate (analogous to reporting-engine: housing an alternative OCA reporting engine)

      3. Considering that it's based on VueJS, wouldn't a better name be "web-app-vuejs" or "pwa-vuejs", in order to separate it from efforts by any future OCA member companies who prefer Angular or React as their tool of choice, and want to open source their alternative engine?



      by Tom Blauwendraat - 11:35 - 16 Jun 2022
    • Re: New repos proposal
      I have a concern here:

      Adding multiple repos makes it harder for contributors to know where to submit a new module.

      Can we make sure there are clear scope statements in the READMEs, and that these also link to the closely related ropes, helping contributors know about them.

      Does this make sense?

      --dr 

      No dia 14/06/2022, às 10:52, Antonio M. Vigliotti (gmail) <antoniomaria.vigliotti@gmail.com> escreveu:

      
      1.  web-api: may be useful if full documentation will be available; most of api and/or rest could not be used without documentation

      2. pwa-builder: great idea! pwa applications are very very interesting and the give a lot of value to Odoo. Good! Good! Good!
       

      Antonio M. Vigliotti

      Mobile (+39) 342.8740910



      Il 14/06/22 09:22, Simone Orsi ha scritto:
      Hi all,

      I'd like to propose 2 new repos:

      1. web-api : collect modules to expose or deal with web api (eg: custom management for routes and endpoints, generic tools to handle calls to ext api, etc).

      2. pwa-builder : collect modules that allow to create and manage standalone PWA apps. As many of you know I split the core of the shopfloor wms app some time ago and this core now allows you to create - potentially - any kind of PWA app w/ its backend (based on rest services) and frontend tools (VueJS based). This core is now in OCA/wms but that's not really the right place. The name is not adequate too (shopfloor_base) so I think I'm going to rename it to pwa_core or pwa_builder or something similar.

      I'd say each of them should have its own PSC but maybe having one is fine too.

      Looking fwd to your feedback.

      Bests,

      --
      Simone Orsi

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

      _______________________________________________
      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 Daniel Reis - 10:20 - 16 Jun 2022

  • l10n-estonia status and proposing myself as PSC
    Dear all,

    It seems that PSC for l10n-estonia is inactive entirely as it's been quite over a year since I've requested attention to https://github.com/OCA/l10n-estonia/pull/4 (https://github.com/OCA/l10n-estonia/pull/4#issuecomment-839124178).

    Also, I'd like to apply for l10n-estonia PSC.

    Kind regards,
    Alexey
    by "Alexey Pelykh" <alexey.pelykh@corphub.eu> - 07:16 - 11 Jun 2022

    8 replies 8 replies

  • Problem when 2 person click same button on the same state at the same time.
    Dear community,

    I don't know technical word to describe this. As we knew, Odoo's view is not refreshed in real time as data got updated backend. And this is problematic.

    For example,
    • 2 users open the same document at state Draft, and a Confirm Button visible.
    • 1st user clicks Confirm, and document sequence set to 1001
    • 2nd user still see the same Confirm button (as page not refreshed), and click it, sequence now change to 1002 without consent of the first person.
    Because Odoo don't have mechanism to prevent this by the framework, and this can happen easily on less mature code.

    Anyone have good techniques to prevent this, rather than writing the blocking everywhere?

    Thanks!
    by Kitti Upariphutthiphong - 07:20 - 9 Jun 2022

    6 replies 6 replies

    • Re: Problem when 2 person click same button on the same state at the same time.
      Thanks Raph for confirming. 

      I am also testing, def _check_concurrency(self): without success

      Seems to be useless without passing __last_update from the client side. May we we keep our hope on v16 OWL.


      On Fri, Jun 10, 2022 at 10:46 AM Raphaël Valyi <rvalyi@akretion.com> wrote:
      Yes an old one... A few years ago, some Odoo employee told me they planned to push live changes to all Odoo open sessions (server push). Might be a way to make such possibility extremely unlikely enough. But so far it seems they didn't developp the idea further. I guess the web client JS/OWL overhaul would come first anyway.

      Well in the places were this is extremely important like accounting move posting or stock reservation, we should ensure we have some sort of checking. In the other places, cross fingers, detect and fix later, try to partition the records processing over the users in ways that tend to avoid concurrent updates...

      May be leaving tabs open forever should also be avoided. May be some minimal autoresfresh could help and cost little dev...

      On Thu, Jun 9, 2022, 3:42 PM Kitti U. <kittiu@ecosoft.co.th> wrote:
      Found this problem discussed wayed back by our OCA people, https://github.com/odoo/odoo/issues/6737

      After reading, sound not quite possible, does it?

      On Fri, Jun 10, 2022 at 1:02 AM Kitti U. <kittiu@ecosoft.co.th> wrote:
      OK, I think it called the page is "Dirty"

      I found from ERPNext on the same scenario, the 2nd person attempt to update, it will show warning like following,

      Error: Document has been modified after you have opened it (2022-06-10 00:59:10.014101, 2022-06-10 00:59:24.963271). Please refresh to get the latest document.

      This would be good too.

      On Fri, Jun 10, 2022 at 12:45 AM Kitti U. <kittiu@ecosoft.co.th> wrote:
      Yes Tom, but with that we need to write checking code everywhere. I wonder if there are better way (or yet some base server module in OCA).

      I know that in other big name ERP., such an issue was prevented at the framework level, no way it can happen at all. Such things, when occur in accounting documents, can be a serious one.

      Another thing (of the same technical shallowness of Odoo) I experienced iwas, user somehow click reverse document twice (because slow response), and it produce reverse entries twice!

      On Fri, Jun 10, 2022 at 12:26 AM Tom Blauwendraat <tom@sunflowerweb.nl> wrote:

      Regular way is just to check if the sale order is already confirmed, and then don't increase the sequence again.

      On 6/9/22 19:22, Kitti U. wrote:
      Dear community,

      I don't know technical word to describe this. As we knew, Odoo's view is not refreshed in real time as data got updated backend. And this is problematic.

      For example,
      • 2 users open the same document at state Draft, and a Confirm Button visible.
      • 1st user clicks Confirm, and document sequence set to 1001
      • 2nd user still see the same Confirm button (as page not refreshed), and click it, sequence now change to 1002 without consent of the first person.
      Because Odoo don't have mechanism to prevent this by the framework, and this can happen easily on less mature code.

      Anyone have good techniques to prevent this, rather than writing the blocking everywhere?

      Thanks!

      _______________________________________________
      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

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

      by Kitti Upariphutthiphong - 06:36 - 10 Jun 2022
    • Re: Problem when 2 person click same button on the same state at the same time.
      Yes an old one... A few years ago, some Odoo employee told me they planned to push live changes to all Odoo open sessions (server push). Might be a way to make such possibility extremely unlikely enough. But so far it seems they didn't developp the idea further. I guess the web client JS/OWL overhaul would come first anyway.

      Well in the places were this is extremely important like accounting move posting or stock reservation, we should ensure we have some sort of checking. In the other places, cross fingers, detect and fix later, try to partition the records processing over the users in ways that tend to avoid concurrent updates...

      May be leaving tabs open forever should also be avoided. May be some minimal autoresfresh could help and cost little dev...

      On Thu, Jun 9, 2022, 3:42 PM Kitti U. <kittiu@ecosoft.co.th> wrote:
      Found this problem discussed wayed back by our OCA people, https://github.com/odoo/odoo/issues/6737

      After reading, sound not quite possible, does it?

      On Fri, Jun 10, 2022 at 1:02 AM Kitti U. <kittiu@ecosoft.co.th> wrote:
      OK, I think it called the page is "Dirty"

      I found from ERPNext on the same scenario, the 2nd person attempt to update, it will show warning like following,

      Error: Document has been modified after you have opened it (2022-06-10 00:59:10.014101, 2022-06-10 00:59:24.963271). Please refresh to get the latest document.

      This would be good too.

      On Fri, Jun 10, 2022 at 12:45 AM Kitti U. <kittiu@ecosoft.co.th> wrote:
      Yes Tom, but with that we need to write checking code everywhere. I wonder if there are better way (or yet some base server module in OCA).

      I know that in other big name ERP., such an issue was prevented at the framework level, no way it can happen at all. Such things, when occur in accounting documents, can be a serious one.

      Another thing (of the same technical shallowness of Odoo) I experienced iwas, user somehow click reverse document twice (because slow response), and it produce reverse entries twice!

      On Fri, Jun 10, 2022 at 12:26 AM Tom Blauwendraat <tom@sunflowerweb.nl> wrote:

      Regular way is just to check if the sale order is already confirmed, and then don't increase the sequence again.

      On 6/9/22 19:22, Kitti U. wrote:
      Dear community,

      I don't know technical word to describe this. As we knew, Odoo's view is not refreshed in real time as data got updated backend. And this is problematic.

      For example,
      • 2 users open the same document at state Draft, and a Confirm Button visible.
      • 1st user clicks Confirm, and document sequence set to 1001
      • 2nd user still see the same Confirm button (as page not refreshed), and click it, sequence now change to 1002 without consent of the first person.
      Because Odoo don't have mechanism to prevent this by the framework, and this can happen easily on less mature code.

      Anyone have good techniques to prevent this, rather than writing the blocking everywhere?

      Thanks!

      _______________________________________________
      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 "Raphaël Valyi" <rvalyi@akretion.com> - 05:45 - 10 Jun 2022
    • Re: Problem when 2 person click same button on the same state at the same time.
      Found this problem discussed wayed back by our OCA people, https://github.com/odoo/odoo/issues/6737

      After reading, sound not quite possible, does it?

      On Fri, Jun 10, 2022 at 1:02 AM Kitti U. <kittiu@ecosoft.co.th> wrote:
      OK, I think it called the page is "Dirty"

      I found from ERPNext on the same scenario, the 2nd person attempt to update, it will show warning like following,

      Error: Document has been modified after you have opened it (2022-06-10 00:59:10.014101, 2022-06-10 00:59:24.963271). Please refresh to get the latest document.

      This would be good too.

      On Fri, Jun 10, 2022 at 12:45 AM Kitti U. <kittiu@ecosoft.co.th> wrote:
      Yes Tom, but with that we need to write checking code everywhere. I wonder if there are better way (or yet some base server module in OCA).

      I know that in other big name ERP., such an issue was prevented at the framework level, no way it can happen at all. Such things, when occur in accounting documents, can be a serious one.

      Another thing (of the same technical shallowness of Odoo) I experienced iwas, user somehow click reverse document twice (because slow response), and it produce reverse entries twice!

      On Fri, Jun 10, 2022 at 12:26 AM Tom Blauwendraat <tom@sunflowerweb.nl> wrote:

      Regular way is just to check if the sale order is already confirmed, and then don't increase the sequence again.

      On 6/9/22 19:22, Kitti U. wrote:
      Dear community,

      I don't know technical word to describe this. As we knew, Odoo's view is not refreshed in real time as data got updated backend. And this is problematic.

      For example,
      • 2 users open the same document at state Draft, and a Confirm Button visible.
      • 1st user clicks Confirm, and document sequence set to 1001
      • 2nd user still see the same Confirm button (as page not refreshed), and click it, sequence now change to 1002 without consent of the first person.
      Because Odoo don't have mechanism to prevent this by the framework, and this can happen easily on less mature code.

      Anyone have good techniques to prevent this, rather than writing the blocking everywhere?

      Thanks!

      _______________________________________________
      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 Kitti Upariphutthiphong - 08:41 - 9 Jun 2022
    • Re: Problem when 2 person click same button on the same state at the same time.
      OK, I think it called the page is "Dirty"

      I found from ERPNext on the same scenario, the 2nd person attempt to update, it will show warning like following,

      Error: Document has been modified after you have opened it (2022-06-10 00:59:10.014101, 2022-06-10 00:59:24.963271). Please refresh to get the latest document.

      This would be good too.

      On Fri, Jun 10, 2022 at 12:45 AM Kitti U. <kittiu@ecosoft.co.th> wrote:
      Yes Tom, but with that we need to write checking code everywhere. I wonder if there are better way (or yet some base server module in OCA).

      I know that in other big name ERP., such an issue was prevented at the framework level, no way it can happen at all. Such things, when occur in accounting documents, can be a serious one.

      Another thing (of the same technical shallowness of Odoo) I experienced iwas, user somehow click reverse document twice (because slow response), and it produce reverse entries twice!

      On Fri, Jun 10, 2022 at 12:26 AM Tom Blauwendraat <tom@sunflowerweb.nl> wrote:

      Regular way is just to check if the sale order is already confirmed, and then don't increase the sequence again.

      On 6/9/22 19:22, Kitti U. wrote:
      Dear community,

      I don't know technical word to describe this. As we knew, Odoo's view is not refreshed in real time as data got updated backend. And this is problematic.

      For example,
      • 2 users open the same document at state Draft, and a Confirm Button visible.
      • 1st user clicks Confirm, and document sequence set to 1001
      • 2nd user still see the same Confirm button (as page not refreshed), and click it, sequence now change to 1002 without consent of the first person.
      Because Odoo don't have mechanism to prevent this by the framework, and this can happen easily on less mature code.

      Anyone have good techniques to prevent this, rather than writing the blocking everywhere?

      Thanks!

      _______________________________________________
      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 Kitti Upariphutthiphong - 08:06 - 9 Jun 2022
    • Re: Problem when 2 person click same button on the same state at the same time.
      Yes Tom, but with that we need to write checking code everywhere. I wonder if there are better way (or yet some base server module in OCA).

      I know that in other big name ERP., such an issue was prevented at the framework level, no way it can happen at all. Such things, when occur in accounting documents, can be a serious one.

      Another thing (of the same technical shallowness of Odoo) I experienced iwas, user somehow click reverse document twice (because slow response), and it produce reverse entries twice!

      On Fri, Jun 10, 2022 at 12:26 AM Tom Blauwendraat <tom@sunflowerweb.nl> wrote:

      Regular way is just to check if the sale order is already confirmed, and then don't increase the sequence again.

      On 6/9/22 19:22, Kitti U. wrote:
      Dear community,

      I don't know technical word to describe this. As we knew, Odoo's view is not refreshed in real time as data got updated backend. And this is problematic.

      For example,
      • 2 users open the same document at state Draft, and a Confirm Button visible.
      • 1st user clicks Confirm, and document sequence set to 1001
      • 2nd user still see the same Confirm button (as page not refreshed), and click it, sequence now change to 1002 without consent of the first person.
      Because Odoo don't have mechanism to prevent this by the framework, and this can happen easily on less mature code.

      Anyone have good techniques to prevent this, rather than writing the blocking everywhere?

      Thanks!

      _______________________________________________
      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 Kitti Upariphutthiphong - 07:45 - 9 Jun 2022

  • Weblate translation locked down for account-analytic-15-0
    Hi,

    This module translation project is set read-only:

    Due to this error:
    fatal: bad revision 'origin/15.0..'
 (128)

    Can someone unlock it ?

    Note that I tried the Push button in repository maintenance but it does not update the lock status even if data seems to be fetched correctly.

    Repository for account-analytic-15.0/account-analytic-15.0-account_analytic_parent

    Source code repository git@github.com:OCA/account-analytic.git
    Repository branch 15.0
    Last remote commit [ADD] setup.py 2d8aa95

    OCA-git-bot authored 3 weeks ago
    Weblate repository https://translation.odoo-community.org/git/account-analytic-15-0/account-analytic-15-0-account_analytic_parent/
    Repository details 
    On branch 15.0
Your branch is up to date with 'origin/15.0'.

nothing to commit, working tree clean


    --
    Yann PAPOUIN, Ingénieur R&D | DEC
    by Yann Papouin - 04:40 - 9 Jun 2022

    2 replies 2 replies

  • How to import old invoices from legacy system 
    Hello,

I would kindly ask if there is some guide on how to import old invoices from a legacy system. These were processed and paid long time ago so I just need them to be able to see customers' history. However accounting features get in my way when I attempt to import Journal Items (account.move.line) saying "Cannot create unbalanced entry". I guess this has to do with Journal Entries (not) being created as they'd normally do.

Is there a way to do this somewhat easily? Or should I better map the data into Sale Orders? Any advice is greatly welcomed.

Thank you. Best regards

	Radovan Skolnik
    by Radovan Skolnik - 11:25 - 9 Jun 2022

    6 replies 6 replies

    • Re: How to import old invoices from legacy system
      I dealt with importing at scale and it did not work well. Though I was able to import and get all the lines, etc. but then balancing tax ids and numbers was a really a challenge and we gave up at the end. I like David's approach of creating your own model and just move the meta data for reporting purposes and not use account.move.

      Regards,
      Vishal Mehra

      cell: (972) 853-1805

      BizAlytics Consulting
      Analyzing Your Business for Success


      On Thu, Jun 9, 2022 at 11:22 AM David Beal <david.beal@akretion.com> wrote:
      Hi Radovan,

      I think that a good approach to bring legacy data in Odoo is to create a model like in your case account.move.imported or account.invoice.imported.
      In this table you'll create some of important fields to use for comparison with new data.
      Don't set too many constraints on these fields even if you can setup many2one.

      After imported data, you can create sql views (query in init function of the new model including the 2 previous ones) in which you can aggregate the two models with Union sql

      With this you can have real statistics on whole history without too many headaches on import

      You may customize functions used in Smart Buttons to have a real count or create new ones to have the 2 stats

      My 2 cents.

      Regards

      David BEAL
      Consultant ERP Odoo


      Le jeu. 9 juin 2022 à 14:02, Dominique k <dominique.k@elico-corp.com.sg> a écrit :
      importing old and paid invoices is complicated.

      you need to import invoices
      and the payment entries. then you would need to reconcile them. consequently, they won't appear any longer in your list of unpaid invoices

      next you need to reverse them: let me explain. as you enter old invoices, they would generate revenue and the yearly balance will go to accumulated profit on the balance sheet. But this will be double counted when you will import your actual opening accounting balances. so.. the easiest method would be to reverse (to zero-ise) the entries so that you start with a clean balance sheet.

      hope this helps

      On Thu, 9 Jun 2022 at 6:27 PM, Radovan Skolnik <radovan@skolnik.info> wrote:
      That makes sense but I guess this will enter into "accounting" and affect many 
things (accounting-wise). These are invoices spanning more than 15 years and 
have been "processed" (for the lack of better term on my side). Also not sure 
I am able to create those balanced entries. So I guess I'd stick with Sale 
Orders.

Best regards

	Radovan

On štvrtok 9. júna 2022 12:17:26 CEST Pedro M. Baeza (Tecnativa) wrote:




> You have to create the whole `account.move` with `line_ids` one2many totally




> filled and balanced.




> 




> 




> Regards.




> 




> 




> _______________________________________________




> 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

      --
      Dominique KON-SUN-TACK  [Project Manager]
      Odoo Gold Partner, best Odoo Partner 2014 for APAC

      Mobile: + 65 8502 2399
      Skype: dominique_elico


      _______________________________________________
      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 - 12:51 - 9 Aug 2022
    • Re: How to import old invoices from legacy system
      Hi Radovan,

      I think that a good approach to bring legacy data in Odoo is to create a model like in your case account.move.imported or account.invoice.imported.
      In this table you'll create some of important fields to use for comparison with new data.
      Don't set too many constraints on these fields even if you can setup many2one.

      After imported data, you can create sql views (query in init function of the new model including the 2 previous ones) in which you can aggregate the two models with Union sql

      With this you can have real statistics on whole history without too many headaches on import

      You may customize functions used in Smart Buttons to have a real count or create new ones to have the 2 stats

      My 2 cents.

      Regards

      David BEAL
      Consultant ERP Odoo


      Le jeu. 9 juin 2022 à 14:02, Dominique k <dominique.k@elico-corp.com.sg> a écrit :
      importing old and paid invoices is complicated.

      you need to import invoices
      and the payment entries. then you would need to reconcile them. consequently, they won't appear any longer in your list of unpaid invoices

      next you need to reverse them: let me explain. as you enter old invoices, they would generate revenue and the yearly balance will go to accumulated profit on the balance sheet. But this will be double counted when you will import your actual opening accounting balances. so.. the easiest method would be to reverse (to zero-ise) the entries so that you start with a clean balance sheet.

      hope this helps

      On Thu, 9 Jun 2022 at 6:27 PM, Radovan Skolnik <radovan@skolnik.info> wrote:
      That makes sense but I guess this will enter into "accounting" and affect many 
things (accounting-wise). These are invoices spanning more than 15 years and 
have been "processed" (for the lack of better term on my side). Also not sure 
I am able to create those balanced entries. So I guess I'd stick with Sale 
Orders.

Best regards

	Radovan

On štvrtok 9. júna 2022 12:17:26 CEST Pedro M. Baeza (Tecnativa) wrote:



> You have to create the whole `account.move` with `line_ids` one2many totally



> filled and balanced.



> 



> 



> Regards.



> 



> 



> _______________________________________________



> 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

      --
      Dominique KON-SUN-TACK  [Project Manager]
      Odoo Gold Partner, best Odoo Partner 2014 for APAC

      Mobile: + 65 8502 2399
      Skype: dominique_elico


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

      by David BEAL - 06:20 - 9 Jun 2022
    • Re: How to import old invoices from legacy system
      importing old and paid invoices is complicated.

      you need to import invoices
      and the payment entries. then you would need to reconcile them. consequently, they won't appear any longer in your list of unpaid invoices

      next you need to reverse them: let me explain. as you enter old invoices, they would generate revenue and the yearly balance will go to accumulated profit on the balance sheet. But this will be double counted when you will import your actual opening accounting balances. so.. the easiest method would be to reverse (to zero-ise) the entries so that you start with a clean balance sheet.

      hope this helps

      On Thu, 9 Jun 2022 at 6:27 PM, Radovan Skolnik <radovan@skolnik.info> wrote:
      That makes sense but I guess this will enter into "accounting" and affect many 
things (accounting-wise). These are invoices spanning more than 15 years and 
have been "processed" (for the lack of better term on my side). Also not sure 
I am able to create those balanced entries. So I guess I'd stick with Sale 
Orders.

Best regards

	Radovan

On štvrtok 9. júna 2022 12:17:26 CEST Pedro M. Baeza (Tecnativa) wrote:


> You have to create the whole `account.move` with `line_ids` one2many totally


> filled and balanced.


> 


> 


> Regards.


> 


> 


> _______________________________________________


> 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

      --
      Dominique KON-SUN-TACK  [Project Manager]
      Odoo Gold Partner, best Odoo Partner 2014 for APAC

      Mobile: + 65 8502 2399
      Skype: dominique_elico


      by dominique.k - 02:00 - 9 Jun 2022
    • Re: How to import old invoices from legacy system 
      That makes sense but I guess this will enter into "accounting" and affect many 
things (accounting-wise). These are invoices spanning more than 15 years and 
have been "processed" (for the lack of better term on my side). Also not sure 
I am able to create those balanced entries. So I guess I'd stick with Sale 
Orders.

Best regards

	Radovan

On štvrtok 9. júna 2022 12:17:26 CEST Pedro M. Baeza (Tecnativa) wrote:

> You have to create the whole `account.move` with `line_ids` one2many totally

> filled and balanced.

> 

> 

> Regards.

> 

> 

> _______________________________________________

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

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

> Unsubscribe: https://odoo-community.org/groups?unsubscribe
      by Radovan Skolnik - 12:26 - 9 Jun 2022
    • Re: How to import old invoices from legacy system
      You have to create the whole `account.move` with `line_ids` one2many totally filled and balanced.

      Regards.
      by Pedro M. Baeza - 12:16 - 9 Jun 2022

  • queue_job commit
    Hello,

    I would like to commit fix for queue_job but am not able to do that with git. Is it enough if I send it to you in email so I don't break something in the repo itself? The description and code itself is below.
    Thanks!

    queue_job: split autovacuum execution

    Sometimes autovacuum method reach thread max execution time and fail (for us it is 120 seconds). Therefore stop its execution if takes long time and run it again as a new job.

    @@ -282,13 +282,19 @@ class QueueJob(models.Model):
             """Delete all jobs done based on the removal interval defined on the
                channel
     
             Called from a cron.
             """
    +        start = datetime.now()
    +        time_exceeded = False
             for channel in self.env["queue.job.channel"].search([]):
                 deadline = datetime.now() - timedelta(days=int(channel.removal_interval))
                 while True:
    +                if (datetime.now() - start).total_seconds() > 60:
    +                    # we don't want to have thread max execution time exceeded exception
    +                    time_exceeded = True
    +                    break
                     jobs = self.search(
                         [
                             ("date_done", "<=", deadline),
                             ("channel", "=", channel.complete_name),
                         ],
    @@ -296,10 +302,15 @@ class QueueJob(models.Model):
                     )
                     if jobs:
                         jobs.unlink()
                     else:
                         break
    +            if time_exceeded:
    +                break
    +        if time_exceeded:
    +            # there is probably still something to cleanup so run it again
    +            self.env.ref("queue_job.ir_cron_autovacuum_queue_jobs").with_delay().method_direct_trigger()
             return True
     
         def requeue_stuck_jobs(self, enqueued_delta=5, started_delta=0):
             """Fix jobs that are in a bad states
     

    Code of the autovacuum method:

        def autovacuum(self):
            """Delete all jobs done based on the removal interval defined on the
               channel

            Called from a cron.
            """
            start = datetime.now()
            time_exceeded = False
            for channel in self.env["queue.job.channel"].search([]):
                deadline = datetime.now() - timedelta(days=int(channel.removal_interval))
                while True:
                    if (datetime.now() - start).total_seconds() > 60:
                        # we don't want to have thread max execution time exceeded exception
                        time_exceeded = True
                        break
                    jobs = self.search(
                        [
                            ("date_done", "<=", deadline),
                            ("channel", "=", channel.complete_name),
                        ],
                        limit=1000,
                    )
                    if jobs:
                        jobs.unlink()
                    else:
                        break
                if time_exceeded:
                    break
            if time_exceeded:
                # there is probably still something to cleanup so run it again
                self.env.ref("queue_job.ir_cron_autovacuum_queue_jobs").with_delay().method_direct_trigger()
            return True

    Kind regards,
    Martin

    image.png
    by "Martin Fraňo" <waky007@gmail.com> - 10:06 - 9 Jun 2022

    1 attachments 1 attachments

    image.png

    1 replies 1 replies

    • Re: queue_job commit
      Hi,

      There is already a pending PR there : https://github.com/OCA/queue/pull/417

      You can maybe review it ?

      Thanks

      On Thu, Jun 9, 2022 at 10:07 AM Martin Fraňo <waky007@gmail.com> wrote:
      Hello,

      I would like to commit fix for queue_job but am not able to do that with git. Is it enough if I send it to you in email so I don't break something in the repo itself? The description and code itself is below.
      Thanks!

      queue_job: split autovacuum execution

      Sometimes autovacuum method reach thread max execution time and fail (for us it is 120 seconds). Therefore stop its execution if takes long time and run it again as a new job.

      @@ -282,13 +282,19 @@ class QueueJob(models.Model):
               """Delete all jobs done based on the removal interval defined on the
                  channel
       
               Called from a cron.
               """
      +        start = datetime.now()
      +        time_exceeded = False
               for channel in self.env["queue.job.channel"].search([]):
                   deadline = datetime.now() - timedelta(days=int(channel.removal_interval))
                   while True:
      +                if (datetime.now() - start).total_seconds() > 60:
      +                    # we don't want to have thread max execution time exceeded exception
      +                    time_exceeded = True
      +                    break
                       jobs = self.search(
                           [
                               ("date_done", "<=", deadline),
                               ("channel", "=", channel.complete_name),
                           ],
      @@ -296,10 +302,15 @@ class QueueJob(models.Model):
                       )
                       if jobs:
                           jobs.unlink()
                       else:
                           break
      +            if time_exceeded:
      +                break
      +        if time_exceeded:
      +            # there is probably still something to cleanup so run it again
      +            self.env.ref("queue_job.ir_cron_autovacuum_queue_jobs").with_delay().method_direct_trigger()
               return True
       
           def requeue_stuck_jobs(self, enqueued_delta=5, started_delta=0):
               """Fix jobs that are in a bad states
       

      Code of the autovacuum method:

          def autovacuum(self):
              """Delete all jobs done based on the removal interval defined on the
                 channel

              Called from a cron.
              """
              start = datetime.now()
              time_exceeded = False
              for channel in self.env["queue.job.channel"].search([]):
                  deadline = datetime.now() - timedelta(days=int(channel.removal_interval))
                  while True:
                      if (datetime.now() - start).total_seconds() > 60:
                          # we don't want to have thread max execution time exceeded exception
                          time_exceeded = True
                          break
                      jobs = self.search(
                          [
                              ("date_done", "<=", deadline),
                              ("channel", "=", channel.complete_name),
                          ],
                          limit=1000,
                      )
                      if jobs:
                          jobs.unlink()
                      else:
                          break
                  if time_exceeded:
                      break
              if time_exceeded:
                  # there is probably still something to cleanup so run it again
                  self.env.ref("queue_job.ir_cron_autovacuum_queue_jobs").with_delay().method_direct_trigger()
              return True

      Kind regards,
      Martin

      image.png

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



      --

      Denis Roussel
      Software Engineer
      T    : +32 2 888 31 49
      M : +32 472 22 00 57


      Val Benoit, Quai Banning 6 | B-4000 Liège | Belgium
      Atrium Building, Drève Richelle 167 | B-1410 Waterloo | Belgium
      Zone industrielle 22 | L-8287 Kehlen | Luxembourg
      by Denis Roussel. - 10:31 - 9 Jun 2022
  • Creation of Wallet repository
    Hi all,

    As some people are requesting wallet functionalities (aka Financial Reserve), I request the creation of 'wallet' repository under the umbrella of Accounting PSC.

    As soon as it is created, we are going to propose PR's with our current work.

    So, see you there!


    Many thanks.

    --

    Denis Roussel
    Software Engineer
    T    : +32 2 888 31 49
    M : +32 472 22 00 57


    Val Benoit, Quai Banning 6 | B-4000 Liège | Belgium
    Atrium Building, Drève Richelle 167 | B-1410 Waterloo | Belgium
    Zone industrielle 22 | L-8287 Kehlen | Luxembourg
    by Denis Roussel. - 02:36 - 8 Jun 2022

    7 replies 7 replies

  • Migration from V11 to V15 -> Fields on account.invoice.line
    Hello dear contributors,

    I have an issue, what some of you might have an easy solution for: After the migration from V11 to V15, obviously the account.invoice.line model was replaced in favor of account.move.line . There were custom fields on account.invoice.line which need to be migrated to account.move.line now in order that a custom module works and the data stays correct.

    The migration was done by Odoo.com (Enterprise). The account.invoice.line table is still there with the custom fields, but I can't see a link to the migrated counterparts on account.move.line. Does anyone know what I could use as a link to copy over the values of my custom fields?

    Any hint is appreciated!

    Thanks and cheers,
    --
    Labusch Portrait Laurence Lars Labusch
    Chief Technology Officer
    phone-icon +1 833-767-6366
    email-icon llabusch@archeti.com
    web-icon archeti.com
    address-icon 2348 Jean Talon Est, #403
    Montreal, Quebec, H2E 1V7
    Canada
    ARCHE TI Logo
    linkedin github gitlab
    		Meeting Banner
    by "Laurence Labusch" <llabusch@archeti.com> - 11:11 - 1 Jun 2022

    1 attachments 1 attachments

    signature.asc
  • Odoo Integration for SAP Ariba 
    Hello dear contributors,

we are right now in search for an Odoo module which could connect to the 
API of the SAP Ariba application.

I tried to find information about that, but it seems there is definitely 
not much in that regard.

Do you have any clues or is there possibly even something in the OCA 
that I did simply miss during research?

Best greetings,

Manuel


-- 
Mit freundlichen Grüßen

Manuel Engel
Trainee Anwendungsentwicklung


initOS GmbH
Innungsstraße 7
21224 Buchholz i.d.N.

Phone:   +49 4105 13503-22
Fax:     +49 4105 13503-10

Email:   manuel.engel@initos.com
Web:     http://www.initos.com

Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Buchholz i.d.N.
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr: DE815580155
    by Manuel Engel - 03:30 - 30 May 2022

    1 replies 1 replies

  • OCA Migration
    Hello!

    I have a PR in the e-commerce repository but my module depends on another module in the repo sale-workflow, this module is not migrated yet causing the checks in my PR fail.
    I would love to know what I can do in those cases?
    How can I pass the checks or do I need to wait until the other PR is merged ?

    Thanks in advance,
    Carmen

    AVIS DE CONFIDENTIALITÉ Ce message peut contenir de l'information légalement privilégiée ou confidentielle. Si vous n'êtes pas le destinataire ou croyez avoir reçu par erreur ce message, nous vous saurions gré d'en aviser l'émetteur et d'en détruire le contenu sans le communiquer à d'autres ou le reproduire. À moins d'avis contraire de sa part, le destinataire autorise l'utilisation du courriel non sécurisé pour la transmission de renseignements confidentiels.
    CONFIDENTIALITY NOTICE This communication may contain privileged or confidential information. If you are not the intended recipient or received this communication by error, please notify the sender and delete the message without copying or disclosing it. Unless explicitly indicated, the receiver hereby authorizes the use of unsecured and unencrypted e-mail for the future transmission of confidential information.
    by "Carmen Rondo" <crondon@archeti.com> - 10:55 - 27 May 2022
  • PSC proposal
    Dear community members,

    I would like to propose myself as a new PSC of the website project. As you can see on Github I'm quite active reviewing and migrating modules. I'm already PSC of the web project, I just really like frontend development especially the javascript framework.

    My Github profile: https://github.com/tarteo

    Kind regards,

    Dennis Sluijk
    Onestein
    by Dennis Sluijk - 01:26 - 19 May 2022

    9 replies 9 replies

  • Subscribe l10n-br

    Good afternoon, I am a senior developer in python and we are implementing Odoo in Brazil. We would like to contribute to the community.

     

    Best regards

     

    Rafael Sabino Vieira

    Diretor de Desenvolvimento

    Mobile: +55 62 9 9913-2635

     

    R. Castelo de Alcázar, 125 - Castelo,
    Belo Horizonte, MG, Brasil CEP 31330-310

    rafael.sabino@webvirtual.com.br

    https://webvirtual.com.br

     

    AVISO DE CONFIDENCIALIDADE: Este e-mail, incluindo anexos e/ou documentos vinculados, destina-se ao uso exclusivo do destinatário pretendido e pode conter informações privilegiadas, confidenciais, proprietárias ou protegidas por lei. É proibida qualquer revisão, disseminação, distribuição ou cópia não autorizada. Se você recebeu esta comunicação por engano, entre em contato imediatamente com o remetente original por resposta de e-mail e destrua todas as cópias da mensagem original e todos os anexos. Observe que quaisquer visualizações ou opiniões apresentadas neste e-mail são exclusivamente do autor e não representam necessariamente as da ALLIANCE TECH SYSTEM.

     

    CONFIDENTIALITY NOTICE: This e-mail, including any attachments and/or linked documents, is intended for the sole use of the intended addressee and may contain information that is privileged, confidential, proprietary, or otherwise protected by law. Any unauthorized review, dissemination, distribution, or copying is prohibited. If you have received this communication in error, please contact the original sender immediately by reply email and destroy all copies of the original message and any attachments. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ALLIANCE TECH SYSTEM.

     

    by "Rafael Sabino" <rafael.sabino@hotmail.com.br> - 06:30 - 16 May 2022
  • Contract PSC
    Hi all,

    As I've been part of development of contract modules for months, I would like to be part of the PSC that manage it (https://odoo-community.org/psc-teams/project-service-28).

    Here under my current work in it: 




    Thanks.

    Let's contribute!

    --

    Denis Roussel
    Software Engineer
    T    : +32 2 888 31 49
    M : +32 472 22 00 57


    Val Benoit, Quai Banning 6 | B-4000 Liège | Belgium
    Atrium Building, Drève Richelle 167 | B-1410 Waterloo | Belgium
    Zone industrielle 22 | L-8287 Kehlen | Luxembourg
    by Denis Roussel. - 10:25 - 16 May 2022

    11 replies 11 replies

  • Proposing myself as l10n-spain PSC

    Dear contributors,

    I would like to apply as PSC for Spanish Localization

    I have deep knowledge in accounting and legal and fiscal requirements from Spanish administration. In fact, this Code Sprint I will focus only in reviewing and fixing Fiscal issues.

    I’m already PSC of other repositories like accounting.

    I think I can help to Spanish localization and maintain it up to date, as you know, reviewing functionally, testing, and organizing.

    https://github.com/rafaelbn

    Thanks to consider my request

    Regards,

    Rafael Blasco

     

    by "Rafael Blasco" <rblasco@moduon.team> - 05:56 - 13 May 2022

    20 replies 20 replies

    • RE: Proposing myself as l10n-spain PSC

      Hello Ignacio,

       

      > “I need more information. Why this change?”

       

      I was on holidays in the beach, someone wrote me by WhatsApp asking if I know something about all the proposal PSC in that day, I didn’t know anything. The sea, the beach and 30º magic degrees was enough for me with my family. But I’m human and I was so curious, so I check my email.

       

      I realize that in my PSC proposal was a few answers, all positive except one, why now there was too many answers?

       

      I remembered the important Issue that odoo-community.org Odoo had with SPAM and that Jairo fixed with Stephan Bidoul couples weeks ago (you can check it in discord). So, I thought, hey! Maybe my proposal was saw for a few contributors as all the emails went to spam!

       

      The prove is that you didn’t receive the answer of Omar while it is there! à https://odoo-community.org/groups/contributors-15/contributors-243662?mode=&date_begin=&date_end=

      The email from Omar was rejected by your mail server.

       

      I just wanted to know the opinion of more contributors; (and that day looked like everyone would read it). In my first proposal I didn’t want to argument more after a decade in Odoo. I'm pretty tired of endless discussions with Pedro, I didn't want to argue anymore. But seeing so much movement, I thought, let's see what more people think, Pedro is a great contributor, but he is not the community nor is the location his, he is from everyone to everyone.

       

      Right now, honestly, I am very happy to see how great contributors and accounting experts like Vicent or Omar are PSC for a stronger, more united, more plural and higher quality localization.

       

      I am so happy that if you consider that the community will be better with me from PSC, great and if not, great too!

       

      For a more plural, more united, and more participatory community. With quality yes, but with kindness and empathy.

       

      Best regards for everyone and happy holidays!

       

      Rafael

       

       

      De: Ignacio Ibeas (Acysos S.L.) <notifications@odoo-community.org>
      Enviado el: jueves, 14 de julio de 2022 17:52
      Para: Contributors <contributors@odoo-community.org>
      Asunto: Re: Proposing myself as l10n-spain PSC

       

      Hello,

      I'm the oldest PSC, but I know that now I'm less active.

      I don't understand. You request a several weeks ago, but you withdraw the request. Now I see you get the approve from the new PSC.

      Now you has this votes from PSC:

      -1 Pedro M. Baeza (PSC)
      +1 Harald  Panten (PSC)

      For the moment I don't make a vote. The last time I went to study the request and you tell me that is not necessary.

      Now you add the positive vote of Omar Castiñeira, but I don't see the mail form him.

      I need more information. Why this change?

      Greetings,
      Ignacio

       

      El 14/7/22 a las 13:27, Jairo Llopis escribió:

      El jue, 14 de jul de 2022 a las 11:21:53 AM, Rafael Blasco <notifications@odoo-community.org> escribió:

      Due the issue in OCA about mailing list and Spam which was solved by Jairo and Stefan surely my proposition wasn’t received by the Spanish community, and today looks like the best day to refresh

       

      Of course +1

      --
      Ignacio Ibeas
      Acysos S.L. (www.acysos.com)
      Odoo Partner (https://www.odoo.com/es_ES/partners/acysos-s-l-80090)
      Asociado Asociación Española de Odoo (https://www.aeodoo.org/members/acysos-s-l-24)
      Odoo Community Association (https://odoo-community.org/members/acysos-s-l-ignacio-ibeas-760)
      Github (http://www.github.com/acysos)
      Odoo Apps (https://www.odoo.com/apps/modules/browse?author=Acysos S.L.)
      C/ Miguel Astrain 18, 1º Oficina A
      31006 Pamplona, Navarra.
      ignacio@acysos.com
      Tel. 948238905
      ---------------------- // -------------------
      La información contenida en este mensaje de correo electrónico es
      confidencial, para ser leída por la(s) persona(s) a quién se dirige. El
      acceso a este mensaje por otras personas no está autorizado. Si Ud. no es la
      persona a la que va dirigido, cualquier divulgación, copia o distribución de
      la información queda prohibida y puede ser ilegal. Asimismo, cualquier acción
      tomada o dejada de tomar basada en la información contenida en este mensaje
      queda prohibida y puede ser ilegal.
      The information in this e-mail is confidential and may be legally privileged.
      It is intended solely for the addressee. Access to this e-mail by anyone is
      unauthorised. If you are not the intended recipient, any disclousure,
      copying, distribuition or any action taken or omited to be taken in reliance
      on it, is prohibited and may be unlawful.

      by Rafael Blasco (Moduon) - 10:16 - 18 Jul 2022
    • Re: Proposing myself as l10n-spain PSC

      Hello,

      I'm the oldest PSC, but I know that now I'm less active.

      I don't understand. You request a several weeks ago, but you withdraw the request. Now I see you get the approve from the new PSC.

      Now you has this votes from PSC:

      -1 Pedro M. Baeza (PSC)
      +1 Harald  Panten (PSC)

      For the moment I don't make a vote. The last time I went to study the request and you tell me that is not neccesary.

      Now you add the positve vote of Omar Castiñeira, but I don't see the mail form him.

      I need more information. Why this change?

      Greetings,
      Ignacio


      El 14/7/22 a las 13:27, Jairo Llopis escribió:
      El jue, 14 de jul de 2022 a las 11:21:53 AM, Rafael Blasco <notifications@odoo-community.org> escribió:

      Due the issue in OCA about mailing list and Spam which was solved by Jairo and Stefan surely my proposition wasn’t received by the Spanish community, and today looks like the best day to refresh


      Of course +1

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

      --
      Ignacio Ibeas
      Acysos S.L. (www.acysos.com)
      Odoo Partner (https://www.odoo.com/es_ES/partners/acysos-s-l-80090)
      Asociado Asociación Española de Odoo (https://www.aeodoo.org/members/acysos-s-l-24)
      Odoo Community Association (https://odoo-community.org/members/acysos-s-l-ignacio-ibeas-760)
      Github (http://www.github.com/acysos)
      Odoo Apps (https://www.odoo.com/apps/modules/browse?author=Acysos S.L.)
      C/ Miguel Astrain 18, 1º Oficina A
      31006 Pamplona, Navarra.
      ignacio@acysos.com
      Tel. 948238905
      ---------------------- // -------------------
      La información contenida en este mensaje de correo electrónico es
      confidencial, para ser leída por la(s) persona(s) a quién se dirige. El
      acceso a este mensaje por otras personas no está autorizado. Si Ud. no es la
      persona a la que va dirigido, cualquier divulgación, copia o distribución de
      la información queda prohibida y puede ser ilegal. Asimismo, cualquier acción
      tomada o dejada de tomar basada en la información contenida en este mensaje
      queda prohibida y puede ser ilegal.
      The information in this e-mail is confidential and may be legally privileged.
      It is intended solely for the addressee. Access to this e-mail by anyone is
      unauthorised. If you are not the intended recipient, any disclousure,
      copying, distribuition or any action taken or omited to be taken in reliance
      on it, is prohibited and may be unlawful.
      by Ignacio Ibeas - 05:50 - 14 Jul 2022
    • Re: Proposing myself as l10n-spain PSC

      Hello,

      I'm the oldest PSC, but I know that now I'm less active.

      I don't understand. You request a several weeks ago, but you withdraw the request. Now I see you get the approve from the new PSC.

      Now you has this votes from PSC:

      -1 Pedro M. Baeza (PSC)
      +1 Harald  Panten (PSC)

      For the moment I don't make a vote. The last time I went to study the request and you tell me that is not neccesary.

      Now you add the positve vote of Omar Castiñeira, but I don't see the mail form him.

      I need more information. Why this change?

      Greetings,
      Ignacio

      El 14/7/22 a las 13:27, Jairo Llopis escribió:
      El jue, 14 de jul de 2022 a las 11:21:53 AM, Rafael Blasco <notifications@odoo-community.org> escribió:

      Due the issue in OCA about mailing list and Spam which was solved by Jairo and Stefan surely my proposition wasn’t received by the Spanish community, and today looks like the best day to refresh


      Of course +1

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

      --
      Ignacio Ibeas
      Acysos S.L. (www.acysos.com)
      Odoo Partner (https://www.odoo.com/es_ES/partners/acysos-s-l-80090)
      Asociado Asociación Española de Odoo (https://www.aeodoo.org/members/acysos-s-l-24)
      Odoo Community Association (https://odoo-community.org/members/acysos-s-l-ignacio-ibeas-760)
      Github (http://www.github.com/acysos)
      Odoo Apps (https://www.odoo.com/apps/modules/browse?author=Acysos S.L.)
      C/ Miguel Astrain 18, 1º Oficina A
      31006 Pamplona, Navarra.
      ignacio@acysos.com
      Tel. 948238905
      ---------------------- // -------------------
      La información contenida en este mensaje de correo electrónico es
      confidencial, para ser leída por la(s) persona(s) a quién se dirige. El
      acceso a este mensaje por otras personas no está autorizado. Si Ud. no es la
      persona a la que va dirigido, cualquier divulgación, copia o distribución de
      la información queda prohibida y puede ser ilegal. Asimismo, cualquier acción
      tomada o dejada de tomar basada en la información contenida en este mensaje
      queda prohibida y puede ser ilegal.
      The information in this e-mail is confidential and may be legally privileged.
      It is intended solely for the addressee. Access to this e-mail by anyone is
      unauthorised. If you are not the intended recipient, any disclousure,
      copying, distribuition or any action taken or omited to be taken in reliance
      on it, is prohibited and may be unlawful.
      by Ignacio Ibeas - 05:46 - 14 Jul 2022
    • Re: Proposing myself as l10n-spain PSC
      +1 for Rafa

      It's another case of very useful contributor and I believe he will never merge modules out of his expertise.

      -----------------------------------------------------------
      Josean Soroa


      El jue., 14 jul. 2022 13:21, Rafael Blasco <notifications@odoo-community.org> escribió:

      Hello,

       

      Due the issue in OCA about mailing list and Spam which was solved by Jairo and Stefan surely my proposition wasn’t received by the Spanish community, and today looks like the best day to refresh

       

      Furthermore, I would like to help and contribute and more active with the new waves’ con contributors with my experience and knowledge.

       

      I got     1x   “-1” from Pedro M. Baeza (PSC)

      I got     1x   “+1” from Harald Panten (PSC)

      I got     3x   “+1” from Omar Castiñeira (actually PSC from today), Valentin Vinagre, Alex Comba

       

      I would like that other contributors lis Vicent Cubells (Actually PSC from Today), Ignacio Ibeas (PSC), and the most of you give an opinion about if you think if it would be helpful to be PSC

       

      As I said

       

      • I’m PSC actually in OCA in Accounting, Sales and other repos
      • I’m OCA contributor from 2015
      • I have a deep and long knowledge in Finance and Taxation In Spain, Certified by Madrid Chamber of Commerce since 2013.

       

      Thanks in adnvace!

       

      Regards

      Rafael Blasco

       

       

       

      De: Pedro M. Baeza (Tecnativa) pedro.baeza@tecnativa.com
      Enviado el: lunes, 16 de mayo de 2022 9:12
      Para: Contributors contributors@odoo-community.org
      Asunto: Re: Proposing myself as l10n-spain PSC

       

      Sorry, but as PSC administrative of the Spanish localization, I have to decline this offer, as I don't consider him to have enough knowledge about this, and I don't want merges without enough review, as this is very critical. Anyways, this repo is perfectly maintained right now.

       

      Regards.

       

       

      De: Alex Comba alex.comba@agilebg.com
      Enviado el: lunes, 16 de mayo de 2022 9:03
      Para: Contributors       contributors@odoo-community.org
      Asunto: Re: Proposing myself as l10n-spain PSC

       

      +1

       

       

      De: Valentin Vinagre Urteaga valentin.vinagre@sygel.es
      Enviado el: domingo, 15 de mayo de 2022 22:22
      Para: Contributors contributors@odoo-community.org
      Asunto: Re: Proposing myself as l10n-spain PSC

       

      +1

       

       

      De: Omar Castiñeira omar@comunitea.com
      Enviado el: domingo, 15 de mayo de 2022 20:03
      Para: Contributors contributors@odoo-community.org
      Asunto: Re: Proposing myself as l10n-spain PSC

       

      +1

       

       

      De: Harald Panten Lopez harald.panten@sygel.es
      Enviado el: sábado, 14 de mayo de 2022 0:48
      Para: Contributors contributors@odoo-community.org
      Asunto: Re: Proposing myself as l10n-spain PSC

       

      +1!

       

       

      De: Rafael Blasco rblasco@rbnpro.com
      Enviado el: lunes, 16 de mayo de 2022 17:34
      Para: 'Odoo Community Association (OCA) Contributors' contributors@odoo-community.org
      Asunto: RE: Proposing myself as l10n-spain PSC

       

      In my side, the request is closed. Don’t worry I won’t be PSC, I’m a functional contributor!

       

      Do you mean, I don’t have enough technical knowledge? Or functional? 😃

       

      So, without technical knowledge I can’t be PSC?

       

      If Pedro thinks they don’t need help I don’t have to be PSC, no problem 😊 I will happy and kindly contribute. I don’t need to be PSC.

       

      But to clarify, I don’t have enough technical knowledge because even though I’m a Computer Science Engineer I don’t develop. I agree.

       

      Harald is PSC, also don’t develop, is functional, and he have a really well knowledge and we are together in the OCA Code Sprint fixing together issues around Spanish Localization https://github.com/odoo/odoo/pull/91455

       

      In the other hand, I don’t want any contributor miss understand Pedro’s opinion (technical opinion) about my knowledge:

       

      • I have a deep and long knowledge in Finance and Taxation In Spain, Certified by Madrid Chamber of Commerce since 2013.

       

      • I have contributed with design and legal validation Spanish Localization Modules since 2015 catching BUGs like this one. Or validating legally like here.

       

       

      • I’ve been implementing Odoo Accounting with Spanish Localization since OpenERP 6.1 in Antiun Ingeniería. You can check attached an Excel with the 119 OCA Modules we contribute o create in OCA from Antiun Ingeniería where I was the Odoo Project Manager. Been Antiun Top10 contributor in Odoo Apps.

       

      • I was in the OCA Board

       

      • Finish, I haven’t broke anythink merging PRs since 2015 (see image 3D from Github Bellow)

       

      😃 Don’t worry and be happy!

       

       

      De: Valentin Vinagre Urteaga <valentin.vinagre@sygel.es>
      Enviado el: domingo, 15 de mayo de 2022 22:22
      Para: Contributors <contributors@odoo-community.org>
      Asunto: Re: Proposing myself as l10n-spain PSC

       

      +1



      El 15 may 2022, a las 20:02, Omar Castiñeira <omar@comunitea.com> escribió:

      

      +1

       

      El sáb, 14 may 2022 0:47, Harald Panten Lopez <harald.panten@sygel.es> escribió:

      +1!

       

      El vie., 13 may. 2022 18:42, Rafael Blasco <rblasco@rbnpro.com> escribió:

      Dear contributors,

      I would like to apply as PSC for Spanish Localization

      I have deep knowledge in accounting and legal and fiscal requirements from Spanish administration. In fact, this Code Sprint I will focus only in reviewing and fixing Fiscal issues.

      I’m already PSC of other repositories like accounting.

      I think I can help to Spanish localization and maintain it up to date, as you know, reviewing functionally, testing, and organizing.

      https://github.com/rafaelbn

      Thanks to consider my request

      Regards,

      Rafael Blasco

       

      _______________________________________________
      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 Josean Soroa - 05:30 - 14 Jul 2022
    • RE: Proposing myself as l10n-spain PSC
      El jue, 14 de jul de 2022 a las 11:21:53 AM, Rafael Blasco <notifications@odoo-community.org> escribió:

      Due the issue in OCA about mailing list and Spam which was solved by Jairo and Stefan surely my proposition wasn’t received by the Spanish community, and today looks like the best day to refresh


      Of course +1
      by Jairo Llopis - 01:26 - 14 Jul 2022

  • RFQ for OCA 2022 Graphic Designer closes this Friday 13th May.
    Hello OCA Contributors.

    Just a quick reminder that the RFQ for OCA 2022 Graphic Designer closes this Friday 13th May.

    We would love to hear from you if you or someone in your team has the skills to help us.

    We are looking for someone to maintain the marketing materials, including but not limited to:
    ○ Logos
    ○ Brochures
    ○ T-shirts
    ○ Banners
    ○ Flags
    ○ Flyers
    ○ Goodies
    ○ Presentations

    Any questions please get in touch: rfq@odoo-community.org

    Have a great day,
    Rebecca
    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association
    by Rebecca Gellatly - 06:56 - 11 May 2022
  • multi company: how many companies is too many? 
    What is the largest number of companies you ever ran in a single (recent 
version) odoo instance?

When does the performance start to degrade because of the record rules 
or company properties?


-- 
Alexandre Fayolle
Senior Software Engineer
Tel : +33 4 58 48 20 30

Camptocamp France SAS
18 rue du Lac Saint André
73 370 Le Bourget-du-Lac
France

http://www.camptocamp.com
    by Alexandre Fayolle - 11:46 - 10 May 2022

    3 replies 3 replies

    • Re: multi company: how many companies is too many?
      Hi,

      Record rules make little difference, neither does properties in my experience. The one that can get you if you have a lot of products or customers is cost / pricelist / payment term lookups that table can get slow but a set of partial index resolves those (take care of the NULL case in each one). But you see that issue with as few as 1 company, just obviously the problem multiplies. 

      What can make a difference is postgres performance due to query execution plans on weirdly shaped queries due to the distribution of company_ids in what are naturally much larger tables. You can get some truly awful query planning. However again it is really just a subset of the large data issues.

      In general the standard mitigations, if you have 1 large company and lots of little ones you might do a partial on the large and a partial on everything but the large. You may have to build a lot of composites with company_id as well (I'm not sure postgres optimizes the NOT NULL attribute when ORM searches for NULL companies even when required - such a simple optimization they could do).

      So I guess unlike Pedro, I see issues at 10 companies, but wildly different data distributions and the largest table at 50,000,000 lines. Although usually the worst issues are reserved for enterprise reports which actually access relatively small tables, say 5m records or less, like reconcile tables, but they are date and company dependent and in big joins.

      On Tue, May 10, 2022 at 9:52 PM Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> wrote:
      We have one with 89 without a performance penalty. Maybe the problem is some specific unoptimized rule/s?

      Regards.

      _______________________________________________
      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 - 11:30 - 10 May 2022
    • Re: multi company: how many companies is too many?
      Running a multicompany instances (96 companies) on Odoo V12.

      Didn't observed performance degradation due to the quantity of companies.

      Some slowness seems to be due to slow functions. (validation of stock moves for example on large orders, or creation of very large invoices).

      However my research regarding the origin of some slowness is limited. if you have a deep analyze, feel free to share !

      Thanks.

      Sylvain LE GAL - Twitter
      GRAP - Service informatique (Groupement Régional Alimentaire de Proximité)
      Site Web | FramaSphere | Facebook
      3 Grande rue des Feuillants, 69001 Lyon
      Standard : (+33) 09.72.32.33.17
      Service Informatique : (+33) 09.73.79.64.40
      Astreinte Informatique : (+33) 06.81.85.61.43
      Member of the OCA (Odoo Community Association)


      Le mar. 10 mai 2022 à 11:47, Alexandre Fayolle <alexandre.fayolle@camptocamp.com> a écrit :
      What is the largest number of companies you ever ran in a single (recent 
version) odoo instance?

When does the performance start to degrade because of the record rules 
or company properties?



-- 
Alexandre Fayolle
Senior Software Engineer
Tel : +33 4 58 48 20 30

Camptocamp France SAS
18 rue du Lac Saint André
73 370 Le Bourget-du-Lac
France

http://www.camptocamp.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 Sylvain LE GAL - 01:16 - 10 May 2022
    • Re: multi company: how many companies is too many?
      We have one with 89 without a performance penalty. Maybe the problem is some specific unoptimized rule/s?

      Regards.
      by Pedro M. Baeza - 11:51 - 10 May 2022