Archives
Contributors
-
Re: Special way of searching for products
Graeme, thanx for input. This part of your email caught my attention: > Stored computed sanitized code, then sanitize search args on way in. Trigram > index that stored field Stored computed sanitized code - no problem. I can do that and had that in mind. Sanitize search args on way in - you say search for bank accounts shows how to do this? Will check that out. Trigram index that stored field - I am on odoo.sh not sure if that is possible there. However if I am able to sanitize both stored code and input that should generally be enough. I am looking specifcally to work with internal reference (default_code) so no need to handle cases like "Red Cat" or "Cat Red" although it would nice also. Best regards Radovan Skolnik On štvrtok 29. apríla 2021 1:01:59 CEST Graeme Gellatly wrote: > I've done this for years in one way or another. OCA does have trgm module > which allows similarity search but for most use cases I find mostly the > issue is one of order of search terms. Product search is particularly > sucky because it has all sorts of overrides. This is in general my simple > approach. > 1. Install pg_trgm or else you will feel the pain. 2. Override search and > split the name argument into multiple ilikes. In my case I typically split > on spaces, which means users can search "Red Car" or "Car Red" and get same > result. I do it on spaces only. I know you want to avoid but actually for > your use case you are better just copying the way bank accounts are > sanitized and searched. Stored computed sanitized code, then sanitize > search args on way in. Trigram index that stored field On Thu, Apr 29, 2021 > at 9:42 AM Pierre Verkest < pierreverkest84@gmail.com [1] > wrote: Few > ideas based on postgresql: > * not sure if it's possible with SIMILAR TO or ~ operators > * investigate extension * fuzzystrmatch: > https://www.postgresql.org/docs/13/fuzzystrmatch.html [2] * pgtrgm: > https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 [3] * > create your own unaccent rules: > https://www.postgresql.org/docs/current/unaccent.html [4] regards, > Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik < radovan@skolnik.info [5] > a > écrit : Hello, > I have been asked few times by users if it is possible to search for > products in a way omitting special characters (like dash or space for > exmaple) from product's default_code (or even input string). Let me give an > example: Let's say we have a product with default_code like CD-12345-XYZ In > current situation if user enteres "CD12345" or "CD 12345" nothing is > retrieved. Vice versa, if the default_code is CD12345XYZ and user enters > "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would > be to first remove those special characters from the string being searched > for and then search for default_code transformed with some (SQL?) function. > Is anything like that possible? One idea comes to mind using computed field > where that stripped deault_code would be stored and extending default search > to use this. However that would require stored computed field. Any way to > prevent this? > Thank you. Best regards > Radovan Skolnik > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [6] > Post to: mailto: contributors@odoo-community.org [7] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [8] > > -- > Pierre > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [9] > Post to: mailto: contributors@odoo-community.org [10] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [11] > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [12] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [13] > > > > [1] mailto:pierreverkest84@gmail.com > [2] https://www.postgresql.org/docs/13/fuzzystrmatch.html > [3] https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 > [4] https://www.postgresql.org/docs/current/unaccent.html > [5] mailto:radovan@skolnik.info > [6] https://odoo-community.org/groups/contributors-15 > [7] mailto:contributors@odoo-community.org > [8] https://odoo-community.org/groups?unsubscribe > [9] https://odoo-community.org/groups/contributors-15 > [10] mailto:contributors@odoo-community.org > [11] https://odoo-community.org/groups?unsubscribe > [12] https://odoo-community.org/groups/contributors-15 > [13] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 11:06 - 29 Apr 2021 -
Re: 30 Checkout Operations per Minute A job for Odoo or not ?
Hi Joel, hi Jordi, thanks for your valuable answers. For the time being we don't really know about the real scenarios as this is a bolt pitch claim of a VC driven startup for now. But from the business model it seems reasonably realistic for me to ask before claiming something that doesn't hold true if it materialized. I am pretty sure that - given the business model - there will be rush hours. So yes, i could even conceive 50 instead of 30 orders a minute. In similar use cases that you just explained, we have been applying both of the strategies you mention 1.) Decoupling stock moves 2.) Batch processing in off-peak times In the use case at stake both does not really work as the entire transaction from Checkout to Delivery (incl. Picking) is supposed to take less then 10 min incl. pyhsical transport. Nevertheless i think all of that may be doable but, i will certainly not claim "without hassle and much invest". Thanks for your answers Am Donnerstag, den 29.04.2021, 07:32 +0000 schrieb Joël Grand- Guillaume: > Hi Frederik, > > > Yes this is a big number ! Look, first before anything else, how many > lines on average for those orders ? According to my XP, this matters > a lot. > > Second question is: Are there rushing hours and more calm hours ? > > In our XP we could not record more than 10 orders per minute. Was on > V 12 though, so it might have improved a bit by now. In our case, we > had a rush and calm hour. So the jobs could be recorded during rush > hours and processed during calm ones. It worked well, but that was > for not that many numbers... > > An idea would be to decoule the order confirmation from the stock > move generation and do this in two different times. You could ensure > the reservation using our stock allocation module. > > Cannot really help much at this stage, > > Joël > > > On Thu, Apr 29, 2021 at 1:32 AM Jordi Ballester Alomar < > jordi.ballester@forgeflow.com> wrote: > > We have a use case with approx 5000/day. I can see how 50000/day > > can become a hell. Imagine recomputing a field, or migrating > > between versions. > > > > It's a challenge, I give you that. > > > > On Wed, Apr 28, 2021 at 10:35 PM Frederik Kramer < > > frederik.kramer@initos.com> wrote: > > > Hi Folks, > > > > > > i have a project proposal on my desk that will ultimately end up > > > in > > > approx. 30 checkout transactions per minute. Has anybody got a > > > project > > > with that order volume done with a relatively recent version of > > > Odoo > > > and provide a good reference. Please bear in mind that the > > > project > > > ahead involves a similarly high volume of stock moves. > > > > > > Any suggestion / comment like (but not limited to) > > > > > > Odoo is the wrong technology for that, forget it, because.... > > > > > > over > > > > > > You can do it but, a), b), c) .... > > > > > > to > > > > > > If you really want that beast flying involve us over here because > > > we > > > are among the few ones that already did soemthing similar > > > > > > would be appreciated. > > > > > > From our load intensive projects at initOS i know that 10000 > > > orders a > > > day can be handled but almost 50000 is a different story and > > > thats why > > > i am asking the most experienced resource out there ;-) > > > > > > Thanks in advance for your replay > > > > > > Cheers Frederik > > > > > > > > > > > > -- > > > 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 > > > > > > -- > > Jordi Ballester Alomar > > CEO & Founder | ForgeFlow > > (+34) 629530707 | jordi.ballester@forgeflow.com | > > https://www.forgeflow.com > > Twitter: https://twitter.com/jordibforgeflow | Linkedin: > > https://www.linkedin.com/in/jordiballesteralomar > > _______________________________________________ > > 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 - 09:51 - 29 Apr 2021 -
Confirm unsubscription to Contributors
Your Channel
Contributors
Hello,
You have requested to be unsubscribed to the mailing list Contributors.
To confirm, please visit the following link: https://odoo-community.org/groups/unsubscribe/15/16398/2eb67cc745fb1534875df5daebaf9183.
If this was a mistake or you did not requested this action, please ignore this message.
Odoo Community Association (OCA) info@odoo-community.org | http://odoo-community.org Powered by Odoo _______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by info@odoo-community.org - 09:51 - 29 Apr 2021 -
Re: 30 Checkout Operations per Minute A job for Odoo or not ?
Hi Frederik,Yes this is a big number ! Look, first before anything else, how many lines on average for those orders ? According to my XP, this matters a lot.Second question is: Are there rushing hours and more calm hours ?In our XP we could not record more than 10 orders per minute. Was on V 12 though, so it might have improved a bit by now. In our case, we had a rush and calm hour. So the jobs could be recorded during rush hours and processed during calm ones. It worked well, but that was for not that many numbers...An idea would be to decoule the order confirmation from the stock move generation and do this in two different times. You could ensure the reservation using our stock allocation module.Cannot really help much at this stage,JoëlOn Thu, Apr 29, 2021 at 1:32 AM Jordi Ballester Alomar <jordi.ballester@forgeflow.com> wrote:We have a use case with approx 5000/day. I can see how 50000/day can become a hell. Imagine recomputing a field, or migrating between versions.It's a challenge, I give you that.On Wed, Apr 28, 2021 at 10:35 PM Frederik Kramer <frederik.kramer@initos.com> wrote:Hi Folks, i have a project proposal on my desk that will ultimately end up in approx. 30 checkout transactions per minute. Has anybody got a project with that order volume done with a relatively recent version of Odoo and provide a good reference. Please bear in mind that the project ahead involves a similarly high volume of stock moves. Any suggestion / comment like (but not limited to) Odoo is the wrong technology for that, forget it, because.... over You can do it but, a), b), c) .... to If you really want that beast flying involve us over here because we are among the few ones that already did soemthing similar would be appreciated. From our load intensive projects at initOS i know that 10000 orders a day can be handled but almost 50000 is a different story and thats why i am asking the most experienced resource out there ;-) Thanks in advance for your replay Cheers Frederik -- 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
--Jordi Ballester AlomarCEO & Founder | ForgeFlow(+34) 629530707 | jordi.ballester@forgeflow.com | https://www.forgeflow.comTwitter: https://twitter.com/jordibforgeflow | Linkedin: https://www.linkedin.com/in/jordiballesteralomar_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--camptocampINNOVATIVE SOLUTIONSBY OPEN SOURCE EXPERTSJoël Grand-GuillaumeDepartment HeadBusiness Solutions
by Joël Grand Guillaume - 09:30 - 29 Apr 2021 -
Re: Rename a module with migration script
You can't do the operation from the migrations scripts of the module with the new name itself, as they are not going to be ever triggered.You need to add the rename in the file https://github.com/OCA/OpenUpgrade/blob/13.0/odoo/addons/openupgrade_records/lib/apriori.py (or https://github.com/OCA/OpenUpgrade/blob/14.0/openupgrade_scripts/apriori.py for v14) for taking effect.Regards.
by Pedro M. Baeza - 08:15 - 29 Apr 2021 -
Re: Proposing Dorin Hongu as Romanian PSC member
Hi Stéphane,thanks for adding him.Cheers,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.roOn Wed, Apr 28, 2021 at 11:11 PM Stéphane Bidoul <stephane.bidoul@acsone.eu> wrote:Hi Mihai,I added Dorin in the Romania PSC. He should receive the invite by tomorrow.Best regards,-sbiOn Wed, Apr 14, 2021 at 12:57 PM Mihai-Adrian Fekete <feketemihai@nexterp.ro> wrote:Hello,i would like to propose Dorin Hongu as a Romanian PSC memberso that he can help us manage issues and pull requests.He is involved a lot in the project:https://github.com/OCA/l10n-romania/commits?author=dhonguThanksRegards,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.ro_______________________________________________
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 Mihai Fekete - 07:25 - 29 Apr 2021 -
Re: 30 Checkout Operations per Minute A job for Odoo or not ?
We have a use case with approx 5000/day. I can see how 50000/day can become a hell. Imagine recomputing a field, or migrating between versions.It's a challenge, I give you that.On Wed, Apr 28, 2021 at 10:35 PM Frederik Kramer <frederik.kramer@initos.com> wrote:Hi Folks, i have a project proposal on my desk that will ultimately end up in approx. 30 checkout transactions per minute. Has anybody got a project with that order volume done with a relatively recent version of Odoo and provide a good reference. Please bear in mind that the project ahead involves a similarly high volume of stock moves. Any suggestion / comment like (but not limited to) Odoo is the wrong technology for that, forget it, because.... over You can do it but, a), b), c) .... to If you really want that beast flying involve us over here because we are among the few ones that already did soemthing similar would be appreciated. From our load intensive projects at initOS i know that 10000 orders a day can be handled but almost 50000 is a different story and thats why i am asking the most experienced resource out there ;-) Thanks in advance for your replay Cheers Frederik -- 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
--Jordi Ballester AlomarCEO & Founder | ForgeFlow(+34) 629530707 | jordi.ballester@forgeflow.com | https://www.forgeflow.comTwitter: https://twitter.com/jordibforgeflow | Linkedin: https://www.linkedin.com/in/jordiballesteralomar
by Jordi Ballester Alomar - 01:31 - 29 Apr 2021 -
Re: Special way of searching for products
I've done this for years in one way or another. OCA does have trgm module which allows similarity search but for most use cases I find mostly the issue is one of order of search terms. Product search is particularly sucky because it has all sorts of overrides.This is in general my simple approach.1. Install pg_trgm or else you will feel the pain.2. Override search and split the name argument into multiple ilikes. In my case I typically split on spaces, which means users can search "Red Car" or "Car Red" and get same result. I do it on spaces only.I know you want to avoid but actually for your use case you are better just copying the way bank accounts are sanitized and searched. Stored computed sanitized code, then sanitize search args on way in. Trigram index that stored fieldOn Thu, Apr 29, 2021 at 9:42 AM Pierre Verkest <pierreverkest84@gmail.com> wrote:Few ideas based on postgresql:* not sure if it's possible with SIMILAR TO or ~ operators* investigate extension* fuzzystrmatch: https://www.postgresql.org/docs/13/fuzzystrmatch.html* create your own unaccent rules: https://www.postgresql.org/docs/current/unaccent.htmlregards,Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik <radovan@skolnik.info> a écrit :Hello, I have been asked few times by users if it is possible to search for products in a way omitting special characters (like dash or space for exmaple) from product's default_code (or even input string). Let me give an example: Let's say we have a product with default_code like CD-12345-XYZ In current situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would be to first remove those special characters from the string being searched for and then search for default_code transformed with some (SQL?) function. Is anything like that possible? One idea comes to mind using computed field where that stripped deault_code would be stored and extending default search to use this. However that would require stored computed field. Any way to prevent this? Thank you. Best regards Radovan Skolnik
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Pierre_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Graeme Gellatly - 01:00 - 29 Apr 2021 -
Re: Special way of searching for products
"Similar to" operator is the % sign.
You can train users to use it, but I don't think this is what they are expecting.
PostgreSQL fuzzy matching might work.
You can try https://odoo-community.org/shop/product/fuzzy-search-698
Or, you can add a stored computed field to use for search, that copies the product code removing special character.
Then use that field as the search target.
/Daniel
On 28/04/2021 22:41, Pierre Verkest wrote:
Few ideas based on postgresql:
* not sure if it's possible with SIMILAR TO or ~ operators
* investigate extension* fuzzystrmatch: https://www.postgresql.org/docs/13/fuzzystrmatch.html* create your own unaccent rules: https://www.postgresql.org/docs/current/unaccent.html
regards,
Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik <radovan@skolnik.info> a écrit :
Hello, I have been asked few times by users if it is possible to search for products in a way omitting special characters (like dash or space for exmaple) from product's default_code (or even input string). Let me give an example: Let's say we have a product with default_code like CD-12345-XYZ In current situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would be to first remove those special characters from the string being searched for and then search for default_code transformed with some (SQL?) function. Is anything like that possible? One idea comes to mind using computed field where that stripped deault_code would be stored and extending default search to use this. However that would require stored computed field. Any way to prevent this? Thank you. Best regards Radovan Skolnik
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Pierre
_______________________________________________
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.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal 
by Daniel Reis - 12:11 - 29 Apr 2021 -
Re: Special way of searching for products
Few ideas based on postgresql:* not sure if it's possible with SIMILAR TO or ~ operators* investigate extension* fuzzystrmatch: https://www.postgresql.org/docs/13/fuzzystrmatch.html* create your own unaccent rules: https://www.postgresql.org/docs/current/unaccent.htmlregards,Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik <radovan@skolnik.info> a écrit :Hello, I have been asked few times by users if it is possible to search for products in a way omitting special characters (like dash or space for exmaple) from product's default_code (or even input string). Let me give an example: Let's say we have a product with default_code like CD-12345-XYZ In current situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would be to first remove those special characters from the string being searched for and then search for default_code transformed with some (SQL?) function. Is anything like that possible? One idea comes to mind using computed field where that stripped deault_code would be stored and extending default search to use this. However that would require stored computed field. Any way to prevent this? Thank you. Best regards Radovan Skolnik
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Pierre
by Pierre Verkest - 11:41 - 28 Apr 2021 -
30 Checkout Operations per Minute A job for Odoo or not ?
Hi Folks, i have a project proposal on my desk that will ultimately end up in approx. 30 checkout transactions per minute. Has anybody got a project with that order volume done with a relatively recent version of Odoo and provide a good reference. Please bear in mind that the project ahead involves a similarly high volume of stock moves. Any suggestion / comment like (but not limited to) Odoo is the wrong technology for that, forget it, because.... over You can do it but, a), b), c) .... to If you really want that beast flying involve us over here because we are among the few ones that already did soemthing similar would be appreciated. From our load intensive projects at initOS i know that 10000 orders a day can be handled but almost 50000 is a different story and thats why i am asking the most experienced resource out there ;-) Thanks in advance for your replay Cheers Frederik -- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH An der Eisenbahn 1 21224 Rosengarten Phone: +49 4105 56156-12 Fax: +49 4105 56156-10 Mobil: +49 179 3901819 Email: frederik.kramer@initos.com Web: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Rosengarten – Klecken Amtsgericht Tostedt, HRB 205226 Steuer-Nr: 15/200/53247 USt-IdNr.: DE815580155
by Frederik Kramer - 10:16 - 28 Apr 2021 -
Rename a module with migration script
Hello all! We are trying to rename a module. The main purpose is to change the name of the module itself, as well as xmlids, models and tables. Preliminary step: - Add a pre-migrate script like this one in new_name_module (bumping the version number): https://github.com/OCA/l10n-italy/pull/2220/commits/d6c790525e1892be1d04391054ccb779092c354c#diff-a86bc87cb07b27f04908e90baeb089a9182ad568d8e7205f40f3e689272bb76c Test steps: 1) old_name module installation 2) add/change some data in Odoo 3) checkout to commit containing new_name module, migration script and version bumped 4) launch old_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u old_name_module --stop-after-init Output: old_name_module: not installable, skipped In fact pre-migrate script is not triggered. As an alternative to 4), we tried this: 4) launch new_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u new_name_module --stop-after-init But it didn't work as well. The only way (we have found so far) to trigger pre-migrate script is this: 1) old_name module installation 2) add/change some data 3) checkout to commit containing new_name module, migration script and version bumped 4) execute odoo shell >>> from openupgradelib import openupgrade >>> openupgrade.update_module_names(env.cr, [('old_name_module', 'new_name_module'),], merge_modules=False,) >>> env.cr.commit() 5) launch new_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u new_name_module --stop-after-init Do you know a way to trigger the migration script without using odoo shell? Thanks in advance. S.
by Sergio Zanchetta - 10:16 - 28 Apr 2021 -
RFQ - OCA Communication Strategy Expert
Dear OCA Contributors,
I hope your week's have started well.
Late last week we shared through our social media our latest RFQ. To share further please find the information below.The OCA is looking for a Communication Strategy Expert to help define our Communication Strategy for the next 3 years.
To find out about the work schedule and deliverables please see here: https://drive.google.com/file/d/19EL646MjjpI4lN47v4P18tHMk2q_1ktR/viewIf you have any questions please email: rfq@odoo-community.orgWarmest regards,Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 10:15 - 28 Apr 2021 -
RFQ - OCA Communication Strategy Expert
Dear Contributors,
I hope your week's have started well.
Late last week we shared through our social media our latest RFQ. To share further please find the information below.The OCA is looking for a Communication Strategy Expert to help define our Communication Strategy for the next 3 years.
To find out about the work schedule and deliverables please see here: https://drive.google.com/file/d/19EL646MjjpI4lN47v4P18tHMk2q_1ktR/viewIf you have any questions please email: rfq@odoo-community.orgWarmest regards,Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 10:15 - 28 Apr 2021 -
Re: How to test v14 upgrade scripts
Il giorno ven 29 gen 2021 alle ore 11:27 Holger Brunn <mail@hunki-enterprises.com> ha scritto: > > > In general, is it possible to test v14 upgrade scripts before OpenUpgrade is > > > available for v14? > > yes, you don't need OpenUpgrade for that. We did some test using a pre-migrate script like the one linked by Lorenzo (*). The main purpose is to change the name of the module, as well as rename xmlids, model and tables. Steps: 1) old_name module installation 2) add/change some data 3) checkout to commit containing new_name module, migration script and version bumped 4) launch old_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u old_name_module --stop-after-init Output: old_name_module: not installable, skipped In fact pre-migrate script is not triggered. We tried this also: 4) launch new_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u new_name_module --stop-after-init But it didn't work as well. The only way (we have found so far) to trigger pre-migrate script is this: 1) old_name module installation 2) add/change some data 3) checkout to commit containing new_name module, migration script and version bumped 4) execute odoo shell >>> from openupgradelib import openupgrade >>> openupgrade.update_module_names(env.cr, [('old_name_module', 'new_name_module'),], merge_modules=False,) >>> env.cr.commit() 5) launch new_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u new_name_module --stop-after-init Do you know a way to trigger the migration script without using odoo shell? Thanks in advance. S. (*) https://github.com/OCA/l10n-italy/blob/0d65b1f7fa23facd9ef52749571a4a18a58f4045/l10n_it_vat_payability/migrations/14.0.1.0.0/pre-migrate.py
by Sergio Zanchetta - 10:15 - 28 Apr 2021 -
Enable Github Discussions for l10n-brazil
HiSomeone with permission to configure OCA´s projects, could kindly activate the github discussions of the Brazilian Localization project?Thanks in advanceLuis Felipe Miléo
CEOphone: +55 11 3090-9303
mobile: +55 35 988 763 663
R. Coronel Renó, 07 - Sala PC.2.3.01
Itajubá - MGkmee.com.br 
by Luis F Miléo - 10:15 - 28 Apr 2021 -
Re: How to test v14 upgrade scripts
Il giorno ven 23 apr 2021 alle ore 15:20 Sergio Zanchetta <primes2h@gmail.com> ha scritto: > > Il giorno ven 29 gen 2021 alle ore 11:27 Holger Brunn > <mail@hunki-enterprises.com> ha scritto: > > > The only way (we have found so far) to trigger pre-migrate script is this: > > 1) old_name module installation > 2) add/change some data > 3) checkout to commit containing new_name module, migration script and > version bumped > 4) execute odoo shell > >>> from openupgradelib import openupgrade > >>> openupgrade.update_module_names(env.cr, [('l10n_it_codici_carica', 'l10n_it_appointment_code'),], merge_modules=False,) Sorry, this one is obviously: >>> openupgrade.update_module_names(env.cr, [('old_name_module', 'new_name_module'),], merge_modules=False,)
by Sergio Zanchetta - 10:14 - 28 Apr 2021 -
Re: How to test v14 upgrade scripts
Il giorno ven 29 gen 2021 alle ore 11:27 Holger Brunn <mail@hunki-enterprises.com> ha scritto: > > > In general, is it possible to test v14 upgrade scripts before OpenUpgrade is > > > available for v14? > > yes, you don't need OpenUpgrade for that. We did some test using a pre-migrate script like the one linked by Lorenzo (*). The main purpose is to change the name of the module, as well as rename xmlids, model and tables. Steps: 1) old_name module installation 2) add/change some data 3) checkout to commit containing new_name module, migration script and version bumped 4) launch old_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u old_name_module --stop-after-init Output: old_name_module: not installable, skipped In fact pre-migrate script is not triggered. We tried this also: 4) launch new_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u new_name_module --stop-after-init But it didn't work as well. The only way (we have found so far) to trigger pre-migrate script is this: 1) old_name module installation 2) add/change some data 3) checkout to commit containing new_name module, migration script and version bumped 4) execute odoo shell >>> from openupgradelib import openupgrade >>> openupgrade.update_module_names(env.cr, [('l10n_it_codici_carica', 'l10n_it_appointment_code'),], merge_modules=False,) >>> env.cr.commit() 5) launch new_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u new_name_module --stop-after-init Do you know a way to trigger the migration script without using odoo shell? Thanks in advance. S. (*) https://github.com/OCA/l10n-italy/blob/0d65b1f7fa23facd9ef52749571a4a18a58f4045/l10n_it_vat_payability/migrations/14.0.1.0.0/pre-migrate.py
by Sergio Zanchetta - 10:14 - 28 Apr 2021 -
punchout and cxml
Hello One of our customers would like to have his Odoo instance available through "punchout", possibly using cXML """ PunchOut is not a link to a web site. PunchOut is an easy-to-implement protocol for interactive sessions managed across the Internet. PunchOut is a communication from one application to another, achieved through a dialog of real-time, synchronous cXML messages, which support user interaction at a remote site. It is the best way to manage user sessions distributed across web applications. This protocol is most commonly used today in the form of Procurement PunchOut, which specifically supports interactions between a procurement application and a supplier’s eCommerce web site and possibly includes an intermediary for authentication and version matching. Procurement PunchOut describes the "traditional" PunchOut scenarios that use the regular PunchOut Setup Request and PunchOut Setup Response. The PunchOut session is initiated with a PunchOutSetupRequest and terminates with a posting of a PunchOutOrderMessage, which contains the initiating transaction’s cookie and a shopping cart or “quote”. """ (http://cxml.org/faq.html) Anyone already faced a similar requirement? Thanks for your feedback -- 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 - 10:14 - 28 Apr 2021