Archives
Contributors
-
Re: Intercompany confirmations
My, how could I have missed that. Thanks!!!
On 5/30/24 15:17, Carlos Lopez wrote:
Hi, check this module and other modules into same repo
El jue, 30 may 2024 a las 7:53, Tom Blauwendraat (<notifications@odoo-community.org>) escribió:
Hi OCA, Enterprise sale_purchase_intercompany modules are not that great. Does anyone know of an alternative? -Tom
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Saludos Cordiales.
_______________________________________________
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 - 04:17 - 30 May 2024 -
Re: Intercompany confirmations
Hi, check this module and other modules into same repoEl jue, 30 may 2024 a las 7:53, Tom Blauwendraat (<notifications@odoo-community.org>) escribió:Hi OCA, Enterprise sale_purchase_intercompany modules are not that great. Does anyone know of an alternative? -Tom
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Saludos Cordiales.
by Carlos Lopez - 03:16 - 30 May 2024 -
Intercompany confirmations
Hi OCA, Enterprise sale_purchase_intercompany modules are not that great. Does anyone know of an alternative? -Tom
by Tom Blauwendraat - 02:51 - 30 May 2024 -
Re: Empty SQL argument and ANY operator
After a few months, I'm coming back on this issue as my initial dirty fix was wrong, the culprit comes from the hard-coded SQL query because the following statement is invalid:and p.id != ANY(%s)and should be replaced with following statement to have the expected resultand not p.id = ANY(%s)That's awkward as it works perfectly forand (p.email != ANY(%s) or p.email is null)---------------------------------------------------------------SELECT
P.ID, P.EMAIL
FROM
RES_PARTNER P
"id","email"
1,"contact1@dec.sarl"
2,"contact2@dec.sarl"
3,"contact3@dec.sarl"
4,null
---------------------------------------------------------------
SELECT
P.ID,
P.EMAIL
FROM
RES_PARTNER P
WHERE
p.id != ANY((ARRAY[1,2]))
"id","email"
1,"contact1@dec.sarl"
2,"contact2@dec.sarl"
3,"contact3@dec.sarl"
4,NULL
---------------------------------------------------------------
SELECT
P.ID,
P.EMAIL
FROM
RES_PARTNER P
WHERE
not p.id = ANY((ARRAY[1,2]))
"id","email"
3,"contact3@dec.sarl"
4,NULL
---------------------------------------------------------------
SELECT
P.ID,
P.EMAIL
FROM
RES_PARTNER P
WHERE
NOT P.EMAIL = ANY ((ARRAY['contact1@dec.sarl']))
OR P.EMAIL IS NULL
"id","email"
2,"contact2@dec.sarl"
3,"contact3@dec.sarl"
4,NULL
---------------------------------------------------------------
SELECT
P.ID,
P.EMAIL
FROM
RES_PARTNER P
WHERE
P.EMAIL != ANY ((ARRAY['contact1@dec.sarl']))
OR P.EMAIL IS NULL
"id","email"
2,"contact2@dec.sarl"
3,"contact3@dec.sarl"
4,NULL
by Yann Papouin - 09:09 - 29 May 2024 -
Re: Application for PSC Role - OCA Helpdesk Repository
Hello Harold,Thank you for the guidance! Following your suggestion:Thanks.Em seg., 27 de mai. de 2024 às 13:27, Harald Panten Lopez <notifications@odoo-community.org> escreveu:Hi,You should create a Pull Request for adding you here --> https://github.com/OCA/repo-maintainer-conf/blob/master/conf/psc/helpdesk.ymlRegards.El lun, 27 may 2024 a las 18:07, Marcel Savegnago (<notifications@odoo-community.org>) escribió:Hello everyone,
I would like to apply to become one of the PSCs for the OCA Helpdesk repository.
Currently, I am a member of the PSC for the Brazilian localization and have been actively contributing to various OCA repositories for a considerable time.
Over the years, I have been working extensively with Odoo, developing modules, performing migrations, and contributing to the community. I believe my experience can add significant value to the Helpdesk project.
Thank you for your consideration. I am available for any questions or further discussions.
Best regards,Marcel Savegnago_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Harald Panten López
CEO
Sygel Technology S.L
+34 613 04 76 66 
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
--Marcel Savegnago marcel.savegnago@escodoo.com.br +55 16 99122-7649 A informação transmitida destina-se apenas a pessoa ou entidade a quem foi endereçada e pode conter informação confidencial, legalmente protegida e para conhecimento exclusivo do destinatário. Se o leitor desta advertência não for o seu destinatário, fica ciente de que sua leitura, divulgação, distribuição ou copia é estritamente proibida. Caso a mensagem tenha sido recebida por engano, favor comunicar ao remetente e apagar o texto do computador.
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
by Marcel Savegnago - 03:16 - 28 May 2024 -
Re: Tracking packagings in stock
Probably I am missing something here.However, please let me offer my 2c by asking the following:- wouldn't it be that the natural solution is to manage the type of packaging in parallel to the type of products? In my experience, dealing with products in various physical structures (solid, gas, liquid, powder) and not having the various types of packaging is "insane" :-).On Tue, May 28, 2024 at 12:17 AM Kevin Khao <notifications@odoo-community.org> wrote:Dear OCA members,I have been confronted with the following issue, and made a module with the link below for something of a fix.Here is the use case: in addition to knowing how many units of products we have in stock, we want to know under what packagings there products are. For example: not only do I want to know I have 95 units in stock, I want to know that I have 5 packages of 10 units and 2 packages of 25 (because one has been opened and 5 units taken out from it).It seems modifying the stock.quant model to take into account these packagings would be a hairy task as it is a core model that is read to/written to in a bunch of places.Our simple solution is to create an intermediary model and a computed field on stock.quants and products that will store this information:This allows to preserve native Odoo functionality but also serves our requirement (we only care about showing this, for some data that we receive from a connector to another WMS). It works in our situation but someone out there might have thought of a more general approach, what do you think ?Best 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 milori2006 - 12:21 - 28 May 2024 -
Re: Tracking packagings in stock
On 27/05/2024 19:17, Kevin Khao wrote: > Dear OCA members, > > I have been confronted with the following issue, and made a module with > the link below for something of a fix. > > Here is the use case: in addition to knowing how many units of products > we have in stock, we want to know under what packagings there products > are. For example: not only do I want to know I have 95 units in stock, I > want to know that I have 5 packages of 10 units and 2 packages of 25 > (because one has been opened and 5 units taken out from it). > > It seems modifying the stock.quant model to take into account these > packagings would be a hairy task as it is a core model that is read > to/written to in a bunch of places. > > Our simple solution is to create an intermediary model and a computed > field on stock.quants and products that will store this information: > > https://github.com/OCA/stock-logistics-warehouse/pull/2050/files > <https://github.com/OCA/stock-logistics-warehouse/pull/2050/files> > > This allows to preserve native Odoo functionality but also serves our > requirement (we only care about showing this, for some data that we > receive from a connector to another WMS). It works in our situation but > someone out there might have thought of a more general approach, what do > you think ? Did you check https://github.com/OCA/stock-logistics-warehouse/tree/16.0/stock_product_qty_by_packaging ? -- 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 - 12:11 - 28 May 2024 -
Re: Application for PSC Role - OCA Helpdesk Repository
Hi,You should create a Pull Request for adding you here --> https://github.com/OCA/repo-maintainer-conf/blob/master/conf/psc/helpdesk.ymlRegards.El lun, 27 may 2024 a las 18:07, Marcel Savegnago (<notifications@odoo-community.org>) escribió:Hello everyone,
I would like to apply to become one of the PSCs for the OCA Helpdesk repository.
Currently, I am a member of the PSC for the Brazilian localization and have been actively contributing to various OCA repositories for a considerable time.
Over the years, I have been working extensively with Odoo, developing modules, performing migrations, and contributing to the community. I believe my experience can add significant value to the Helpdesk project.
Thank you for your consideration. I am available for any questions or further discussions.
Best regards,Marcel Savegnago_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Harald Panten López
CEO
Sygel Technology S.L
+34 613 04 76 66 harald.panten@sygel.es https://www.sygel.es C/ Àlaba 61, 5ª planta, 08005, Barcelona
by Harald Panten Lopez - 06:25 - 27 May 2024 -
Encrypt personal data in French/European Medical legislations (GPDR++)
Dear allWhat you be your advice to encrypt personal data at low level ?Thanks in advance--------------------------------
Cyril VINH-TUNG
INVITU
Computer & Network Engineering
BP 32 - 98713 Papeete - French Polynesia
Tél: +689 40 46 11 99
contact@invitu.com
www.invitu.com
by Cyril VINH-TUNG - 04:41 - 25 May 2024 -
Re: field extraction rule for funny date format
Hi,
reading the source there probably isn't but I haven't tested it. Looking at it I see 2 ways going forward:
1) Extending the options for date formats with this specific one - may be a bit tricky
2) Adding an option for usage of dateparser library and possible mask
Regarding dateparser it's quite easy:
>>> dateparser.parse('02.April 2024', date_formats=['%d.%B %Y'])
datetime.datetime(2024, 4, 2, 0, 0)I would even suggest reworking the date handling using the library...
Best regards
Radovan
On štvrtok 23. mája 2024 14:32:10 CEST Jan Suhr | Nitrokey wrote:
> Hi!
> The module account_invoice_import_simple_pdf allows to define field
> extraction rules. UPS sends invoices with date in format "02.April 2024"
> so the first separator is a dot and the second a space. Is it possible
> to define a field extraction rule for such format?
> Best regards
> Jan
>
> _______________________________________________
> Mailing-List: https://odoo-community.org/groups/contributors-15 [1]
> Post to: mailto:contributors@odoo-community.org
> Unsubscribe: https://odoo-community.org/groups?unsubscribe [2]
>
>
>
> [1] https://odoo-community.org/groups/contributors-15
> [2] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 02:50 - 23 May 2024 -
field extraction rule for funny date format
Hi! The module account_invoice_import_simple_pdf allows to define field extraction rules. UPS sends invoices with date in format "02.April 2024" so the first separator is a dot and the second a space. Is it possible to define a field extraction rule for such format? Best regards Jan
by Jan Suhr - 02:32 - 23 May 2024 -
Re: Addendas for Audi, Mabe, Ford, Whirlpool, Volkswagen
Have a look here: https://github.com/OCA/edi There are some modules implementing for example Factur-X or UBL standards. It would be helpful if you found out what the actual standard for these addendas was.
Best regards
Radovan Skolnik
On utorok 21. mája 2024 15:27:21 CEST Samuel Macias Oropeza wrote:
> Addenda are complements to mexican electronic invoices. They don't affect
> the invoice itself, but provide additional commercial information requested
> by the client. Some large companies require their providers to issue an
> addendum with every invoice, and the information required in the addendum
> varies from company to company On Mon, May 20, 2024 at 8:37 AM Radovan
> Skolnik < notifications@odoo-community.org [1] > wrote: Hello,
> what are "addends" if I may ask.
> Best regards,
> Radovan Skolnik
> On May 20, 2024 16:27, Samuel Macias Oropeza <
> notifications@odoo-community.org [2] > wrote: Hello We have a client that
> needs the addendas for Audi, Mabe, Ford, Whirlpool and Volkswagen. Does
> anyone have any of these? For what version? Please get in contact with us
> with a quotation for your services. Thank you!
> --
> SAMUEL MACIAS OROPEZA
> TECH LEAD
> smacias@opensourceintegrators.com [3]
> P.O. BOX 940, HIGLEY, AZ 85236
>
> _______________________________________________
> Mailing-List: https://odoo-community.org/groups/contributors-15 [4]
> Post to: mailto: contributors@odoo-community.org [5]
> Unsubscribe: https://odoo-community.org/groups?unsubscribe [6]
>
>
> _______________________________________________
> Mailing-List: https://odoo-community.org/groups/contributors-15 [7]
> Post to: mailto: contributors@odoo-community.org [8]
> Unsubscribe: https://odoo-community.org/groups?unsubscribe [9]
>
>
> _______________________________________________
> Mailing-List: https://odoo-community.org/groups/contributors-15 [10]
> Post to: mailto:contributors@odoo-community.org
> Unsubscribe: https://odoo-community.org/groups?unsubscribe [11]
>
>
>
> [1] mailto:notifications@odoo-community.org
> [2] mailto:notifications@odoo-community.org
> [3] mailto:smacias@opensourceintegrators.com
> [4] https://odoo-community.org/groups/contributors-15
> [5] mailto:contributors@odoo-community.org
> [6] https://odoo-community.org/groups?unsubscribe
> [7] https://odoo-community.org/groups/contributors-15
> [8] mailto:contributors@odoo-community.org
> [9] https://odoo-community.org/groups?unsubscribe
> [10] https://odoo-community.org/groups/contributors-15
> [11] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 03:51 - 21 May 2024 -
Re: Addendas for Audi, Mabe, Ford, Whirlpool, Volkswagen
Addenda are complements to mexican electronic invoices. They don't affect the invoice itself, but provide additional commercial information requested by the client. Some large companies require their providers to issue an addendum with every invoice, and the information required in the addendum varies from company to companyOn Mon, May 20, 2024 at 8:37 AM Radovan Skolnik <notifications@odoo-community.org> wrote:Hello,what are "addends" if I may ask.Best regards,Radovan SkolnikOn May 20, 2024 16:27, Samuel Macias Oropeza <notifications@odoo-community.org> wrote:HelloWe have a client that needs the addendas for Audi, Mabe, Ford, Whirlpool and Volkswagen.Does anyone have any of these? For what version? Please get in contact with us with a quotation for your services.Thank you!--_______________________________________________
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 Samuel Macias Oropeza - 03:26 - 21 May 2024 -
Re: Session storage in S3
Hello Stéphane,> We recently tested the OCA/session_db module with success, but if anyone had any experience to share on the multi-tenant side we'd be more confident ;-).We have good experience with session_db. It has the advantage of being simple to deploy.Multi-tenant is not an issue provided you use a dedicated db for sessions.Do you have specific worries regarding multi tenancy?Intuitively I suspect session_db or session_redis would have better performance than an s3 solution, but I'd be interested about the results if you do any measurements.Best regards,--Stéphane BidoulOn Sun, May 19, 2024 at 10:16 PM Stéphane Van Erp <notifications@odoo-community.org> wrote:Hello OCA community,
As part of a multi-tenant deployment with several replicas, we are looking to persist Odoo sessions elsewhere than in the container.
We recently tested the OCA/session_db module with success, but if anyone had any experience to share on the multi-tenant side we'd be more confident ;-).
Nevertheless, since we also use the OCA/fs_storage and OCA/fs_attachment modules to store attached files in an S3 environment, we'd be tempted to use S3 instead of the DB.
Do any of you know of such a module? Is it a good idea?
I'm sure I'll have other questions about multi-tenant deployment with k8s, but I'd rather keep this to one subject per e-mail.
Thank you in advance for any help you can provide.Stéphane Van Erp for iMio_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Stéphane Bidoul - 11:16 - 21 May 2024 -
Re: Session storage in S3
We use session_redis https://github.com/camptocamp/odoo-cloud-platform/tree/16.0/session_redis Alexandre Fayolle On 19/05/2024 22:16, Stéphane Van Erp wrote: > Hello OCA community, > > As part of a multi-tenant deployment with several replicas, we are > looking to persist Odoo sessions elsewhere than in the container. > > We recently tested the OCA/session_db module with success, but if anyone > had any experience to share on the multi-tenant side we'd be more > confident ;-). > > Nevertheless, since we also use the OCA/fs_storage and OCA/fs_attachment > modules to store attached files in an S3 environment, we'd be tempted to > use S3 instead of the DB. > Do any of you know of such a module? Is it a good idea? > > I'm sure I'll have other questions about multi-tenant deployment with > k8s, but I'd rather keep this to one subject per e-mail. > > Thank you in advance for any help you can provide. > > Stéphane Van Erp for iMio <https://imio.be> > > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 > <https://odoo-community.org/groups/contributors-15> > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe > <https://odoo-community.org/groups?unsubscribe> > -- 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 - 08:53 - 21 May 2024 -
Re: Addendas for Audi, Mabe, Ford, Whirlpool, Volkswagen
Hello,what are "addends" if I may ask.Best regards,Radovan SkolnikOn May 20, 2024 16:27, Samuel Macias Oropeza <notifications@odoo-community.org> wrote:HelloWe have a client that needs the addendas for Audi, Mabe, Ford, Whirlpool and Volkswagen.Does anyone have any of these? For what version? Please get in contact with us with a quotation for your services.Thank you!--
_______________________________________________
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 - 04:36 - 20 May 2024 -
Addendas for Audi, Mabe, Ford, Whirlpool, Volkswagen
HelloWe have a client that needs the addendas for Audi, Mabe, Ford, Whirlpool and Volkswagen.Does anyone have any of these? For what version? Please get in contact with us with a quotation for your services.Thank you!--SAMUEL MACIAS OROPEZA
TECH LEAD
smacias@opensourceintegrators.com
P.O. BOX 940, HIGLEY, AZ 85236
by Samuel Macias Oropeza - 04:26 - 20 May 2024 -
Re: Session storage in S3
HelloNot tested but I would mount session folder (as we actually do with filestore in our infra) with nfs in your containersMaybe there will be some security issues with that...I let experts give their povBest regards--------------------------------
Cyril VINH-TUNG
INVITU
Computer & Network Engineering
BP 32 - 98713 Papeete - French Polynesia
Tél: +689 40 46 11 99
contact@invitu.com
www.invitu.comLe dim. 19 mai 2024, 10:16, Stéphane Van Erp <notifications@odoo-community.org> a écrit :Hello OCA community,
As part of a multi-tenant deployment with several replicas, we are looking to persist Odoo sessions elsewhere than in the container.
We recently tested the OCA/session_db module with success, but if anyone had any experience to share on the multi-tenant side we'd be more confident ;-).
Nevertheless, since we also use the OCA/fs_storage and OCA/fs_attachment modules to store attached files in an S3 environment, we'd be tempted to use S3 instead of the DB.
Do any of you know of such a module? Is it a good idea?
I'm sure I'll have other questions about multi-tenant deployment with k8s, but I'd rather keep this to one subject per e-mail.
Thank you in advance for any help you can provide.Stéphane Van Erp for iMio_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Cyril VINH-TUNG - 10:46 - 19 May 2024
