Skip to Content

Contributors

  • Re: l10n-italy 14.0 on apps.odoo.com
    Ciao Andrea,

    checked: the 14.0 branch was not registered yet.
    I added it and it's scanning now. I'll let you know if there's any problem.

    Unfortunately - as the apps mgmt s***ks - you have to register every single branch as a new repo :(

    @all: if you spot modules from other repos on missing for v14 let us know, thanks!

    Cheers

    On Wed, Jul 7, 2021 at 10:27 AM Andrea Cometa - Apulia Software srl <a.cometa@apuliasoftware.it> wrote:

    Hi all,

    is it possible to check if there are problems or conflicts with l10n-italy 14.0 and apps.odoo.com ?

    thank you

    --
    Andrea Cometa - Presidente Associazione Odoo Italia
    Apulia Software srl - Responsabile Commerciale ed Amministrativo
    Taranto / Milano / Potenza
    Tel: 0999915404 http://www.apuliasoftware.it
    a.cometa@apuliasoftware.it pec: apulia.software@pec.it
    linkedin: http://it.linkedin.com/in/andreacometa

    _______________________________________________
    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 - 10:46 - 7 Jul 2021
  • l10n-italy 14.0 on apps.odoo.com

    Hi all,

    is it possible to check if there are problems or conflicts with l10n-italy 14.0 and apps.odoo.com ?

    thank you

    --
    Andrea Cometa - Presidente Associazione Odoo Italia
    Apulia Software srl - Responsabile Commerciale ed Amministrativo
    Taranto / Milano / Potenza
    Tel: 0999915404 http://www.apuliasoftware.it
    a.cometa@apuliasoftware.it pec: apulia.software@pec.it
    linkedin: http://it.linkedin.com/in/andreacometa

    by Andrea Cometa - 10:25 - 7 Jul 2021
  • Re: European Union One-Stop-Shop
    Hello all,

    A quick update on this.

    There was a great team effort on this feature, to develop, review and port across multiple Odoo versions.
    The l10n_eu_oss module can be found at:
    https://github.com/OCA/account-fiscal-rule

    In the meanwhile, Odoo released their support for this.
    It is an improvement to the l10n_eu_service module, available in Odoo CE.
    There were later fixes, but the main implementation is here:
    https://github.com/odoo/odoo/commit/d347eae1646639e2b346d404d1eb68ce9eac005c#diff-6299170bf4eb194cb23d4b799e0ce09b17a250b11e6eeb6aa3c58f63cea04c95

    So there are two different solutions right now.
    I started an Issue to discuss the differences.
    Right now contributors feeling is that the OCA version probably does a better job.
    You can check the details here:
    https://github.com/OCA/account-fiscal-rule/issues/226

    Have a nice day
    Daniel


    Às 11:27 de 10/06/21, Harald Panten Lopez escreveu:
    Hi Community,

    As you know, a major tax change will be implemented shortly (1st of July) that will affect all EU countries.

    More info:
    https://ec.europa.eu/taxation_customs/business/vat/oss_en

    For the newest versions, (from V14) Odoo is planning a "kind of solution", but what happens with older versions? Is any European partner working on this?

    Some of the Spanish partners started this project, and we were wondering if anybody else will do the same. The main idea is to "join our efforts" and offer a global solution according to the ideology proposed by OCA.

    Regards,
    --


    Harald Panten López

    CEO

    Sygel Technology S.L




    +34 637 88 42 41
    harald.panten@sygel.es
    https://www.sygel.es
    C/ Àlaba 61, 5ª planta, 08005, Barcelona



    _______________________________________________
    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 - 05:51 - 6 Jul 2021
  • We found our Communication Agency!
    Hello Community,

    The board has a great news to share: 
    We found our Communication Agency!

    To discover who will share this adventure with us, read this article on our blog.
    We'll come back to you soon to get you on board.

    Have a nice day and enjoy your week-end!
    Virginie
    0477/64.17.20

    by Virginie Dewulf. - 08:06 - 2 Jul 2021
  • Re: Odoo automatic code documentation
    Hi,

    You may probably use https://github.com/acsone/click-odoo and build your own python package.


    Specifically about Odoo, we could imagine generating functional documentation coming from code split by models.
    We all have a lot of custom code in our projects.

    There is a major problem with custom code:
    Your colleagues who know odoo perfectly and are aware of OCA modules don't know the specificity of your project.
    Then to quickly dive into your project, it could be sufficient to read documentation from the custom part of the project.

    But as you know, documentation lies, not the code.

    So if functional doc is near the code (then attached to a model), then it could be easier to be updated.

    Everybody could win: consultant and customer.

    My 2 cts

    Regards

    David BEAL
    Consultant ERP Odoo


    Le jeu. 24 juin 2021 à 15:17, Daniel Reis <dreis@opensourceintegrators.com> a écrit :
    Hello,

    Try "cd /path/to/odoo && pip install ."
    You will then be able to "import odoo"

    Thanks
    Daniel

    On 24/06/2021 09:42, Joerg Lorenz wrote:
    Hi Guys, today we are asking for your insightfullness.
    Our quest:  how the python code of odoo can be automatically documented from the code itself. 

    But the approach with the various toos that there are fails:  

    We have tested: 
    • pdoc, a simple Python 3 command line tool and library to auto-generate API documentation for Python modules. Supports Numpydoc / Google-style docstrings, doctests, reST directives, PEP 484 type annotations, custom templates ...

    • pdoc3, a fork of pdoc for Python 3 with support for Numpydoc / Google-style docstrings, doctests, LaTeX math, reST directives, PEP 484 type annotations, custom templates ...

    • PyDoc, a documentation browser (in HTML) and/or an off-line reference manual. Also in the standard library as pydoc.

    • pydoctor, a replacement for now inactive Epydoc, born for the needs of Twisted project.

    and all of them fail.  It has to do that odoo as such is not a python module itself and thus cannot be imported. 

    problem in models/res_company.py - <type 'exceptions.ImportError'>: No module named odoo

    If anyone has some experience, ideas, or pointer towards a solution, it would be highly appreaciated. 

    Best, Joe

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


    --
    Daniel Reis
    Managing Director
    M: +351 919991307
    E: DReis@OpenSourceIntegrators.com
    Av. Republica 3000, Edificio Estoril Office, B Piso 3 - 34 • 2649-517 Alcabideche, Portugal


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


    by David BEAL - 05:05 - 24 Jun 2021
  • Re: Odoo automatic code documentation
    Hello,

    Try "cd /path/to/odoo && pip install ."
    You will then be able to "import odoo"

    Thanks
    Daniel

    On 24/06/2021 09:42, Joerg Lorenz wrote:
    Hi Guys, today we are asking for your insightfullness.
    Our quest:  how the python code of odoo can be automatically documented from the code itself. 

    But the approach with the various toos that there are fails:  

    We have tested: 
    • pdoc, a simple Python 3 command line tool and library to auto-generate API documentation for Python modules. Supports Numpydoc / Google-style docstrings, doctests, reST directives, PEP 484 type annotations, custom templates ...

    • pdoc3, a fork of pdoc for Python 3 with support for Numpydoc / Google-style docstrings, doctests, LaTeX math, reST directives, PEP 484 type annotations, custom templates ...

    • PyDoc, a documentation browser (in HTML) and/or an off-line reference manual. Also in the standard library as pydoc.

    • pydoctor, a replacement for now inactive Epydoc, born for the needs of Twisted project.

    and all of them fail.  It has to do that odoo as such is not a python module itself and thus cannot be imported. 

    problem in models/res_company.py - <type 'exceptions.ImportError'>: No module named odoo

    If anyone has some experience, ideas, or pointer towards a solution, it would be highly appreaciated. 

    Best, Joe

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


    --
    Daniel Reis
    Managing Director
    M: +351 919991307
    E: DReis@OpenSourceIntegrators.com
    Av. Republica 3000, Edificio Estoril Office, B Piso 3 - 34 • 2649-517 Alcabideche, Portugal



    by Daniel Reis - 03:16 - 24 Jun 2021
  • Re: Odoo automatic code documentation

    Hi Joerg

    when using an Odoo installation framework such as Doodba or Waft, the package "odoo" is installed in the (virtual) environment at the end, making it available to everything that runs in the venv.

    Am sure that it can also be achieved easily without using those frameworks, using 'pip install' directly, but I didn't try...

    https://github.com/Tecnativa/doodba/blob/master/build.d/700-odoo-install

    Tom


    Op 6/24/21 om 10:42 AM schreef Joerg Lorenz:
    Hi Guys, today we are asking for your insightfullness.
    Our quest:  how the python code of odoo can be automatically documented from the code itself. 

    But the approach with the various toos that there are fails:  

    We have tested: 
    • pdoc, a simple Python 3 command line tool and library to auto-generate API documentation for Python modules. Supports Numpydoc / Google-style docstrings, doctests, reST directives, PEP 484 type annotations, custom templates ...

    • pdoc3, a fork of pdoc for Python 3 with support for Numpydoc / Google-style docstrings, doctests, LaTeX math, reST directives, PEP 484 type annotations, custom templates ...

    • PyDoc, a documentation browser (in HTML) and/or an off-line reference manual. Also in the standard library as pydoc.

    • pydoctor, a replacement for now inactive Epydoc, born for the needs of Twisted project.

    and all of them fail.  It has to do that odoo as such is not a python module itself and thus cannot be imported. 

    problem in models/res_company.py - <type 'exceptions.ImportError'>: No module named odoo

    If anyone has some experience, ideas, or pointer towards a solution, it would be highly appreaciated. 

    Best, Joe

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


    by Tom Blauwendraat - 11:01 - 24 Jun 2021
  • Odoo automatic code documentation
    Hi Guys, today we are asking for your insightfullness.
    Our quest:  how the python code of odoo can be automatically documented from the code itself. 

    But the approach with the various toos that there are fails:  

    We have tested: 
    • pdoc, a simple Python 3 command line tool and library to auto-generate API documentation for Python modules. Supports Numpydoc / Google-style docstrings, doctests, reST directives, PEP 484 type annotations, custom templates ...

    • pdoc3, a fork of pdoc for Python 3 with support for Numpydoc / Google-style docstrings, doctests, LaTeX math, reST directives, PEP 484 type annotations, custom templates ...

    • PyDoc, a documentation browser (in HTML) and/or an off-line reference manual. Also in the standard library as pydoc.

    • pydoctor, a replacement for now inactive Epydoc, born for the needs of Twisted project.

    and all of them fail.  It has to do that odoo as such is not a python module itself and thus cannot be imported. 

    problem in models/res_company.py - <type 'exceptions.ImportError'>: No module named odoo

    If anyone has some experience, ideas, or pointer towards a solution, it would be highly appreaciated. 

    Best, Joe

    by Joerg Lorenz. - 10:41 - 24 Jun 2021
  • Re: Full text search
    Hi Lorenzo,
    I agree that having an implementation of postgres full text search would be a great improvement and would solve many use cases without needed integrations and other softwares.

    The Holger module could be a good starting point https://github.com/Therp/fulltextsearch

    I believe it would be great to make an implementation of full text search configurable by the user on each model similar as done here. Basically it would be:
    * user can choose on each models fields to be included on the full text search
    * user can choose to enable that search as the "name_search" one
    * user can choose to enable "smart search" it would be the first available option on the "search view" that would implement the full text search.

    So, for eg:
    * user choose on product.product the following fields to be used: name, barcode, default_code, brand
    * user enable "smart search" + " name search"
    * then:
    a) on a sale order, user can search a product with a very flexible way
    b) on the product.product tree view user can search with same flexible way

    All this searches are already implemented with native "ilike" searches but are not so powerful and performant. It's also integrated on ecommerce here

     


    Ing. Juan José Scarafía

    (+54 9 341) 3 278039

    twitter: @jjscarafia

    github: @jjscarafia



    El mar, 22 de jun. de 2021 a la(s) 06:22, Lorenzo Battistini (elbaddy@gmail.com) escribió:
    Thanks everyone for your helpful advice.

    My primary goal is to improve search mechanisms of some frontend pages, like e-commerce products or slides.
    Of course a solution at framework level, which would allow to apply the improved search to any model, would be great.

    I like the postgres approach because
    1. It seems powerful enough to cover our needs
    2. We don't have to install other (big) softwares, hard and onerous to maintain
    So, in the first place, I will have a look at Holger's and Anders's works.

    Thanks a lot!


    On Tue, 22 Jun 2021 at 08:12, Mignon, Laurent <laurent.mignon@acsone.eu> wrote:
    Hello everyone,

    I think Simone has given a good summary of the problem. I don't have much more to say. I would however just like to clarify a technical point about https://github.com/OCA/search-engine and more specifically the module dedicated to Elasticsearch. This module has been developed based of versions of Elasticsearch licensed under Apache 2.0. This module uses a limited number of methods from the api provided by Elasticsearch to publish and synchronize data in the indexes. I have personally used it with the Opendistro distribution of ES and I am confident that it will work seamlessly with Opensearh (https://opensearch.org/) which is a fork of ES based on the latest version released under Apache 2.0. If this is not the case, it is very likely that the adaptations to be made will be minor. These are just a few technical considerations of no importance until the functional needs are clearly defined.

    Regards,

    lmi


    On Tue, Jun 22, 2021 at 7:27 AM Simone Orsi <simahawk@gmail.com> wrote:
    Hello everyone,

    guys, let's get back on track! I think none of these topics is relevant for Lorenzo. At least not at this stage.
    Nobody is asking what's the final goal. Me included ;)

    @Lorenzo: What are you looking for?

    From my perspective:

    a) if you need something pluggable in the backend, something that works w/ "normal" odoo models you should have a look at what Holger did. It's a bit complex and many implementation details should be rewritten completely but it gives you an idea on how to get there.

    b) If you need something for the frontend, I'd definitely go for ES (especially if you want faceted search). Once you have ES in place you can use SearchKit JS to easily build a search UI.

    c) If you don't want to maintain the search engine and you want a reliable and easy to use configuration you can use Algolia (yes, a proprietary servivce! :P)  but watch out because it can be very expensive.

    Both b and c are feasible w/ the search-engine framework.

    d) If you only need a full text index for one very particular model in one very particular form, I'd go for basic postgres full text indexing + some custom code.

    HTH. If you need help on setting up the search engine stuff let me know ;)

    Bests,

    On Mon, Jun 21, 2021 at 8:57 PM Frederik Kramer <frederik.kramer@initos.com> wrote:
    Holger of course you are right, 
    
    but just hiding crap in a container doesn't make it significantly less
    cumbersome at the detailed level. But of course if you have a nicely
    built docker-compose oder kubernetes service defintion at hand much is
    done anywhere else an you only have to handle ENV variables.
    
    Best
    Frederik
    
    Am Montag, den 21.06.2021, 18:31 +0000 schrieb Holger Brunn:
    
    
    
    
    
    > > Neverthless all Java ;-)
    
    
    
    
    
    > 
    
    
    
    
    
    > when I was young I would complain about Java, but now you just stick
    
    
    
    
    
    > it into a 
    
    
    
    
    
    > container and be done with it
    
    
    
    
    
    > _______________________________________________
    
    
    
    
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15
    
    
    
    
    
    > Post to: mailto:contributors@odoo-community.org
    
    
    
    
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe
    
    
    
    
    
    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
            
    initOS GmbH
    An der Eisenbahn 1
    21224 Rosengarten
            
    Phone:  +49 4105 56156-12
    Fax:    +49 4105 56156-10
    Mobil:  +49 179 3901819
            
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
            
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
    
    Sitz der Gesellschaft: Rosengarten – Klecken
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155
    
    

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



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



    --

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


    by Juan José Scarafía - 04:16 - 23 Jun 2021
  • Re: Full text search
    Thanks everyone for your helpful advice.

    My primary goal is to improve search mechanisms of some frontend pages, like e-commerce products or slides.
    Of course a solution at framework level, which would allow to apply the improved search to any model, would be great.

    I like the postgres approach because
    1. It seems powerful enough to cover our needs
    2. We don't have to install other (big) softwares, hard and onerous to maintain
    So, in the first place, I will have a look at Holger's and Anders's works.

    Thanks a lot!


    On Tue, 22 Jun 2021 at 08:12, Mignon, Laurent <laurent.mignon@acsone.eu> wrote:
    Hello everyone,

    I think Simone has given a good summary of the problem. I don't have much more to say. I would however just like to clarify a technical point about https://github.com/OCA/search-engine and more specifically the module dedicated to Elasticsearch. This module has been developed based of versions of Elasticsearch licensed under Apache 2.0. This module uses a limited number of methods from the api provided by Elasticsearch to publish and synchronize data in the indexes. I have personally used it with the Opendistro distribution of ES and I am confident that it will work seamlessly with Opensearh (https://opensearch.org/) which is a fork of ES based on the latest version released under Apache 2.0. If this is not the case, it is very likely that the adaptations to be made will be minor. These are just a few technical considerations of no importance until the functional needs are clearly defined.

    Regards,

    lmi


    On Tue, Jun 22, 2021 at 7:27 AM Simone Orsi <simahawk@gmail.com> wrote:
    Hello everyone,

    guys, let's get back on track! I think none of these topics is relevant for Lorenzo. At least not at this stage.
    Nobody is asking what's the final goal. Me included ;)

    @Lorenzo: What are you looking for?

    From my perspective:

    a) if you need something pluggable in the backend, something that works w/ "normal" odoo models you should have a look at what Holger did. It's a bit complex and many implementation details should be rewritten completely but it gives you an idea on how to get there.

    b) If you need something for the frontend, I'd definitely go for ES (especially if you want faceted search). Once you have ES in place you can use SearchKit JS to easily build a search UI.

    c) If you don't want to maintain the search engine and you want a reliable and easy to use configuration you can use Algolia (yes, a proprietary servivce! :P)  but watch out because it can be very expensive.

    Both b and c are feasible w/ the search-engine framework.

    d) If you only need a full text index for one very particular model in one very particular form, I'd go for basic postgres full text indexing + some custom code.

    HTH. If you need help on setting up the search engine stuff let me know ;)

    Bests,

    On Mon, Jun 21, 2021 at 8:57 PM Frederik Kramer <frederik.kramer@initos.com> wrote:
    Holger of course you are right, 
    
    but just hiding crap in a container doesn't make it significantly less
    cumbersome at the detailed level. But of course if you have a nicely
    built docker-compose oder kubernetes service defintion at hand much is
    done anywhere else an you only have to handle ENV variables.
    
    Best
    Frederik
    
    Am Montag, den 21.06.2021, 18:31 +0000 schrieb Holger Brunn:
    
    
    
    
    > > Neverthless all Java ;-)
    
    
    
    
    > 
    
    
    
    
    > when I was young I would complain about Java, but now you just stick
    
    
    
    
    > it into a 
    
    
    
    
    > container and be done with it
    
    
    
    
    > _______________________________________________
    
    
    
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15
    
    
    
    
    > Post to: mailto:contributors@odoo-community.org
    
    
    
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe
    
    
    
    
    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
            
    initOS GmbH
    An der Eisenbahn 1
    21224 Rosengarten
            
    Phone:  +49 4105 56156-12
    Fax:    +49 4105 56156-10
    Mobil:  +49 179 3901819
            
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
            
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
    
    Sitz der Gesellschaft: Rosengarten – Klecken
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155
    
    

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



    --
    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 Lorenzo Battistini. - 11:21 - 22 Jun 2021
  • Re: Full text search
    Hello everyone,

    I think Simone has given a good summary of the problem. I don't have much more to say. I would however just like to clarify a technical point about https://github.com/OCA/search-engine and more specifically the module dedicated to Elasticsearch. This module has been developed based of versions of Elasticsearch licensed under Apache 2.0. This module uses a limited number of methods from the api provided by Elasticsearch to publish and synchronize data in the indexes. I have personally used it with the Opendistro distribution of ES and I am confident that it will work seamlessly with Opensearh (https://opensearch.org/) which is a fork of ES based on the latest version released under Apache 2.0. If this is not the case, it is very likely that the adaptations to be made will be minor. These are just a few technical considerations of no importance until the functional needs are clearly defined.

    Regards,

    lmi


    On Tue, Jun 22, 2021 at 7:27 AM Simone Orsi <simahawk@gmail.com> wrote:
    Hello everyone,

    guys, let's get back on track! I think none of these topics is relevant for Lorenzo. At least not at this stage.
    Nobody is asking what's the final goal. Me included ;)

    @Lorenzo: What are you looking for?

    From my perspective:

    a) if you need something pluggable in the backend, something that works w/ "normal" odoo models you should have a look at what Holger did. It's a bit complex and many implementation details should be rewritten completely but it gives you an idea on how to get there.

    b) If you need something for the frontend, I'd definitely go for ES (especially if you want faceted search). Once you have ES in place you can use SearchKit JS to easily build a search UI.

    c) If you don't want to maintain the search engine and you want a reliable and easy to use configuration you can use Algolia (yes, a proprietary servivce! :P)  but watch out because it can be very expensive.

    Both b and c are feasible w/ the search-engine framework.

    d) If you only need a full text index for one very particular model in one very particular form, I'd go for basic postgres full text indexing + some custom code.

    HTH. If you need help on setting up the search engine stuff let me know ;)

    Bests,

    On Mon, Jun 21, 2021 at 8:57 PM Frederik Kramer <frederik.kramer@initos.com> wrote:
    Holger of course you are right, 
    
    but just hiding crap in a container doesn't make it significantly less
    cumbersome at the detailed level. But of course if you have a nicely
    built docker-compose oder kubernetes service defintion at hand much is
    done anywhere else an you only have to handle ENV variables.
    
    Best
    Frederik
    
    Am Montag, den 21.06.2021, 18:31 +0000 schrieb Holger Brunn:
    
    
    
    > > Neverthless all Java ;-)
    
    
    
    > 
    
    
    
    > when I was young I would complain about Java, but now you just stick
    
    
    
    > it into a 
    
    
    
    > container and be done with it
    
    
    
    > _______________________________________________
    
    
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15
    
    
    
    > Post to: mailto:contributors@odoo-community.org
    
    
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe
    
    
    
    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
            
    initOS GmbH
    An der Eisenbahn 1
    21224 Rosengarten
            
    Phone:  +49 4105 56156-12
    Fax:    +49 4105 56156-10
    Mobil:  +49 179 3901819
            
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
            
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
    
    Sitz der Gesellschaft: Rosengarten – Klecken
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155
    
    

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



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


    by Laurent Mignon - 08:11 - 22 Jun 2021
  • Re: Full text search
    Hello everyone,

    guys, let's get back on track! I think none of these topics is relevant for Lorenzo. At least not at this stage.
    Nobody is asking what's the final goal. Me included ;)

    @Lorenzo: What are you looking for?

    From my perspective:

    a) if you need something pluggable in the backend, something that works w/ "normal" odoo models you should have a look at what Holger did. It's a bit complex and many implementation details should be rewritten completely but it gives you an idea on how to get there.

    b) If you need something for the frontend, I'd definitely go for ES (especially if you want faceted search). Once you have ES in place you can use SearchKit JS to easily build a search UI.

    c) If you don't want to maintain the search engine and you want a reliable and easy to use configuration you can use Algolia (yes, a proprietary servivce! :P)  but watch out because it can be very expensive.

    Both b and c are feasible w/ the search-engine framework.

    d) If you only need a full text index for one very particular model in one very particular form, I'd go for basic postgres full text indexing + some custom code.

    HTH. If you need help on setting up the search engine stuff let me know ;)

    Bests,

    On Mon, Jun 21, 2021 at 8:57 PM Frederik Kramer <frederik.kramer@initos.com> wrote:
    Holger of course you are right, 
    
    but just hiding crap in a container doesn't make it significantly less
    cumbersome at the detailed level. But of course if you have a nicely
    built docker-compose oder kubernetes service defintion at hand much is
    done anywhere else an you only have to handle ENV variables.
    
    Best
    Frederik
    
    Am Montag, den 21.06.2021, 18:31 +0000 schrieb Holger Brunn:
    
    
    > > Neverthless all Java ;-)
    
    
    > 
    
    
    > when I was young I would complain about Java, but now you just stick
    
    
    > it into a 
    
    
    > container and be done with it
    
    
    > _______________________________________________
    
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15
    
    
    > Post to: mailto:contributors@odoo-community.org
    
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe
    
    
    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
            
    initOS GmbH
    An der Eisenbahn 1
    21224 Rosengarten
            
    Phone:  +49 4105 56156-12
    Fax:    +49 4105 56156-10
    Mobil:  +49 179 3901819
            
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
            
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
    
    Sitz der Gesellschaft: Rosengarten – Klecken
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155
    
    

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



    --
    Simone Orsi

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

    by Simone Orsi - 07:26 - 22 Jun 2021
  • OCA Codesprint 2021/2022 - help us choose the dates
    Dear OCA Contributors,

    I hope this finds you all well.

    We are getting ourselves geared for the OCA Days 2021 - 28th- 29th October.
    With the caliber of talks given during the online event in 2020 we found that the codesprint side of things wasn't as well attended due to people not wanting to miss out on the presentations.

    There has been discussion within the OCA Board about delaying the codesprint to help accommodate the busy time. We wanted to get a gauge from you, the Community, as to which dates/time of year  people think would work.

    We are conscious when having 3 events (Odoo XP, OCA Days Talks and OCA Days Codesprint) of interest so close together, it can be difficult for attendees to juggle these events with work. High on our list of criteria is trying to find a time slot close enough (but not too close to the other events) that it wouldn't interfere with expected outcomes within your companies and mean a high attendance at the codesprint.

    A quick survey has been set up below - please take a minute (it is less than a minute really) to complete to help.
    We appreciate your time in helping us get the best dates for the next OCA codesprint.

    Warmest regards,
    Rebecca
    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

    by Rebecca Gellatly - 02:30 - 22 Jun 2021
  • Re: Full text search
    Holger of course you are right, 
    
    but just hiding crap in a container doesn't make it significantly less
    cumbersome at the detailed level. But of course if you have a nicely
    built docker-compose oder kubernetes service defintion at hand much is
    done anywhere else an you only have to handle ENV variables.
    
    Best
    Frederik
    
    Am Montag, den 21.06.2021, 18:31 +0000 schrieb Holger Brunn:
    
    > > Neverthless all Java ;-)
    
    > 
    
    > when I was young I would complain about Java, but now you just stick
    
    > it into a 
    
    > container and be done with it
    
    > _______________________________________________
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15
    
    > Post to: mailto:contributors@odoo-community.org
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe
    
    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
            
    initOS GmbH
    An der Eisenbahn 1
    21224 Rosengarten
            
    Phone:  +49 4105 56156-12
    Fax:    +49 4105 56156-10
    Mobil:  +49 179 3901819
            
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
            
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
    
    Sitz der Gesellschaft: Rosengarten – Klecken
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155
    
    

    by Frederik Kramer - 08:55 - 21 Jun 2021
  • Re: Full text search
    > Neverthless all Java ;-)
    
    when I was young I would complain about Java, but now you just stick it into a 
    container and be done with it

    by "Holger Brunn" <holger@brunn.email> - 08:31 - 21 Jun 2021
  • Re: Full text search
    Hi Holger, hi all, 
    
    more so as Elasticsearch isn'T Open Source any longer. If you can
    afford to do the whole Scaling and Usability / Json convenience stuff
    with other software or own development Lucene is probably the purest
    you can get. Otherwise there is (or will be) OpenSearch
    
    https://t3n.de/news/opensearch-amazon-elasticsearch-fork-1372115/
    
    Neverthless all Java ;-)
    
    Best Frederik
    
    Am Montag, den 21.06.2021, 18:06 +0000 schrieb Holger Brunn:
    
    > > Have you by any chance - allready started covering some of the
    
    > 
    
    > > topics you marked as open in your presentation, like ranking,
    
    > highlighting,
    
    > 
    
    > > proximity, parser tuning and dictionary training?
    
    > 
    
    > none at all, the first PoC was good enough for what the customer
    
    > wanted back 
    
    > then unfortunately. But I'm very confident that with just postgres'
    
    > gist/gin 
    
    > indexes we can already come very far.
    
    > And yes, I more thought of using some lucene thing than elasticsearch
    
    > itself, 
    
    > I made the mistake of getting to know the former through the latter
    
    > 
    
    > 
    
    > -- 
    
    > Your partner for the hard Odoo problems
    
    > https://hunki-enterprises.com
    
    > _______________________________________________
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15
    
    > Post to: mailto:contributors@odoo-community.org
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe
    
    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
            
    initOS GmbH
    An der Eisenbahn 1
    21224 Rosengarten
            
    Phone:  +49 4105 56156-12
    Fax:    +49 4105 56156-10
    Mobil:  +49 179 3901819
            
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
            
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
    
    Sitz der Gesellschaft: Rosengarten – Klecken
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155
    
    

    by Frederik Kramer - 08:16 - 21 Jun 2021
  • Re: Full text search
    Hi,

    From an open source point of view, I suggest use https://opendistro.github.io/for-elasticsearch/

    It is an interesting project, and if you want a PCI DSS compliant server or GDPR with https://documentation.wazuh.com/current/getting-started/index.html you can.

    And for e-commerce full text search we'll need some custom integration with another ES index with products and with like a kibana-odoo-ui integration, maybe something around could be possible...

    Juan

    El lun, 21 jun 2021 a las 19:27, Joerg Lorenz (<jlorenz@itis.de>) escribió:
    Hi Holger, 

    Personally, I found your approach of using pure PostGreSQL insteresting here, given that elasticsearch requires an addtl service stack (docker container, or alike), and (as I learned the other day from Fred) Elasticsearch is developed in Java  (boo :-() Maybe not so much boo for me, as some of you know). For us, if connected with ITISeasy.docs, Solr comes as an option, too (built on lucene as well). 

    Also a quick search retrieved this: https://rocky.dev/full-text-search. Performance is important. 

    Have you by any chance - allready started covering some of the topics you marked as open in your presentation, like ranking, highlighting, proximity, parser tuning and dictionary training? 
    Best, Joe 


    Von: "Holger Brunn" <mail@hunki-enterprises.com>
    An: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
    Gesendet: Montag, 21. Juni 2021 18:46:45
    Betreff: Re: Full text search

    I did some work on this a long time ago in
    https://github.com/Therp/fulltextsearch
    That's basically a framework to make the postgres fulltext search operators 
    usable via the Odoo UI. Something like this could still be helpful in v14 I 
    think, but if I was tasked to start something from scratch I'd go the 
    elasticsearch route nowadays I guess if there weren't any constraints.
    
    
    
    -- 
    Your partner for the hard Odoo problems
    https://hunki-enterprises.com

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


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


    by Juan Del Castillo Gómez - 08:11 - 21 Jun 2021
  • Re: Full text search
    > Have you by any chance - allready started covering some of the
    
    > topics you marked as open in your presentation, like ranking, highlighting,
    
    > proximity, parser tuning and dictionary training?
    
    none at all, the first PoC was good enough for what the customer wanted back 
    then unfortunately. But I'm very confident that with just postgres' gist/gin 
    indexes we can already come very far.
    And yes, I more thought of using some lucene thing than elasticsearch itself, 
    I made the mistake of getting to know the former through the latter
    
    
    -- 
    Your partner for the hard Odoo problems
    https://hunki-enterprises.com

    by Holger Brunn - 08:05 - 21 Jun 2021
  • Re: Full text search
    Hi Holger, 

    Personally, I found your approach of using pure PostGreSQL insteresting here, given that elasticsearch requires an addtl service stack (docker container, or alike), and (as I learned the other day from Fred) Elasticsearch is developed in Java  (boo :-() Maybe not so much boo for me, as some of you know). For us, if connected with ITISeasy.docs, Solr comes as an option, too (built on lucene as well). 

    Also a quick search retrieved this: https://rocky.dev/full-text-search. Performance is important. 

    Have you by any chance - allready started covering some of the topics you marked as open in your presentation, like ranking, highlighting, proximity, parser tuning and dictionary training? 
    Best, Joe 


    Von: "Holger Brunn" <mail@hunki-enterprises.com>
    An: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
    Gesendet: Montag, 21. Juni 2021 18:46:45
    Betreff: Re: Full text search

    I did some work on this a long time ago in
    https://github.com/Therp/fulltextsearch
    That's basically a framework to make the postgres fulltext search operators 
    usable via the Odoo UI. Something like this could still be helpful in v14 I 
    think, but if I was tasked to start something from scratch I'd go the 
    elasticsearch route nowadays I guess if there weren't any constraints.
    
    
    -- 
    Your partner for the hard Odoo problems
    https://hunki-enterprises.com

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



    by Joerg Lorenz. - 07:26 - 21 Jun 2021
  • Re: Full text search
    I did some work on this a long time ago in
    https://github.com/Therp/fulltextsearch
    That's basically a framework to make the postgres fulltext search operators 
    usable via the Odoo UI. Something like this could still be helpful in v14 I 
    think, but if I was tasked to start something from scratch I'd go the 
    elasticsearch route nowadays I guess if there weren't any constraints.
    
    
    -- 
    Your partner for the hard Odoo problems
    https://hunki-enterprises.com

    by Holger Brunn - 06:46 - 21 Jun 2021