Archives
Contributors
-
Re: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
+1On Mon, Mar 1, 2021 at 2:07 PM David Beal <david.beal@akretion.com> wrote:+1CordialementAkretion, créateur de ShopInvaderLe lun. 1 mars 2021 à 17:56, Houssine BAKKALI <houssine@coopiteasy.be> a écrit :+1
On 01/03/2021 17:52, Jordi Ballester Alomar wrote:
+1
El lun., 1 mar. 2021 17:47, Enric Tobella Alomar <etobella@creublanca.es> escribió:
+1Enric Tobella AlomarCentros Médicos Creu BlancaTel: 902 202 230Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: Raphaël Reverdy <raphael.reverdy@akretion.com>
To: "Contributors" <contributors@odoo-community.org>
Date: Mon, 01 Mar 2021 15:42:19 -0000
Subject: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
Dear community,I'd like to be a PSC for the following teams:- Logistics- Field Services- StorageYou can see my activity on OCA here : https://github.com/pulls?q=is%3Apr+user%3AOCA+author%3AhparfrGithub profile : https://github.com/hparfrThanks,
--Raphaël Reverdy_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Raphaël ValyiFounder and consultant
by "Raphaël Valyi" <rvalyi@akretion.com> - 08:41 - 1 Mar 2021 -
Re: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
+1CordialementAkretion, créateur de ShopInvaderLe lun. 1 mars 2021 à 17:56, Houssine BAKKALI <houssine@coopiteasy.be> a écrit :+1
On 01/03/2021 17:52, Jordi Ballester Alomar wrote:
+1
El lun., 1 mar. 2021 17:47, Enric Tobella Alomar <etobella@creublanca.es> escribió:
+1Enric Tobella AlomarCentros Médicos Creu BlancaTel: 902 202 230Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: Raphaël Reverdy <raphael.reverdy@akretion.com>
To: "Contributors" <contributors@odoo-community.org>
Date: Mon, 01 Mar 2021 15:42:19 -0000
Subject: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
Dear community,I'd like to be a PSC for the following teams:- Logistics- Field Services- StorageYou can see my activity on OCA here : https://github.com/pulls?q=is%3Apr+user%3AOCA+author%3AhparfrGithub profile : https://github.com/hparfrThanks,
--Raphaël Reverdy_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.
_______________________________________________
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 David BEAL - 06:05 - 1 Mar 2021 -
Re: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
+1
On 01/03/2021 17:52, Jordi Ballester Alomar wrote:
+1
El lun., 1 mar. 2021 17:47, Enric Tobella Alomar <etobella@creublanca.es> escribió:
+1Enric Tobella AlomarCentros Médicos Creu BlancaTel: 902 202 230Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: Raphaël Reverdy <raphael.reverdy@akretion.com>
To: "Contributors" <contributors@odoo-community.org>
Date: Mon, 01 Mar 2021 15:42:19 -0000
Subject: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
Dear community,I'd like to be a PSC for the following teams:- Logistics- Field Services- StorageYou can see my activity on OCA here : https://github.com/pulls?q=is%3Apr+user%3AOCA+author%3AhparfrGithub profile : https://github.com/hparfrThanks,
--Raphaël Reverdy_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.
_______________________________________________
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 Houssine BAKKALI - 05:56 - 1 Mar 2021 -
Re: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
+1El lun., 1 mar. 2021 17:47, Enric Tobella Alomar <etobella@creublanca.es> escribió:+1Enric Tobella AlomarCentros Médicos Creu BlancaTel: 902 202 230Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: Raphaël Reverdy <raphael.reverdy@akretion.com>
To: "Contributors" <contributors@odoo-community.org>
Date: Mon, 01 Mar 2021 15:42:19 -0000
Subject: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
Dear community,I'd like to be a PSC for the following teams:- Logistics- Field Services- StorageYou can see my activity on OCA here : https://github.com/pulls?q=is%3Apr+user%3AOCA+author%3AhparfrGithub profile : https://github.com/hparfrThanks,
--Raphaël Reverdy_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Jordi Ballester Alomar - 05:51 - 1 Mar 2021 -
Re: OCA BOT can't merge PRs in OCA/l10n-italy branch 11.0
Hi Francesco,For the second one, the error can be seen on the last commit here:So it seems to be a real test error, but one that does not appear during all builds.Also, it seems that Odoo's .pot file exporter has difficulties producing a stable result, with several commits updating the same .pot file.I'd suggest first trying to understand the test failure, then we can see if the pot file issue needs addressing (maybe by upgrading to python 3.6).-sbiOn Mon, Mar 1, 2021 at 2:21 PM Francesco Apruzzese <cescoap@gmail.com> wrote:Can anyone help us to understand why the BOT can't merge this PRor this one?Thank you.--Francesco ApruzzeseProfilo professionale: http://it.linkedin.com/in/francescoapruzzese
Il contenuto di questo messaggio elettronico è riservato e tutelato dal segreto professionale ed è rivolto esclusivamente al/ai destinatario/i identificato/i. Pertanto è proibito leggerlo, copiarlo, divulgarlo o utilizzarlo da parte di chiunque salvo il/i destinatario/i. Se non siete il destinatario, vi invitiamo a cancellare il messaggio ed eventuali allegati dandocene immediatamente comunicazione scritta a mezzo posta elettronica.
This e-mail and any attachments are confidential and may contain information intended for the addressee(s) only. Reading, copying, disclosure or use by anybody else is unauthorised. If you are not the intended recipient, please delete this message and any attachments and advise the sender by return e-mail.
Non stampare questa email se non strettamente necessario. Aiuta te ed aiuta l'ambiente._______________________________________________
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 - 05:51 - 1 Mar 2021 -
Re: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
+1On Mon, Mar 1, 2021 at 4:42 PM Raphaël Reverdy <raphael.reverdy@akretion.com> wrote:Dear community,I'd like to be a PSC for the following teams:- Logistics- Field Services- StorageYou can see my activity on OCA here : https://github.com/pulls?q=is%3Apr+user%3AOCA+author%3AhparfrGithub profile : https://github.com/hparfrThanks,
--Raphaël Reverdy_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Alex Comba
Tel (CH): +41 91 210 23 40
by Alex Comba. - 05:51 - 1 Mar 2021 -
Re: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
+1Enric Tobella Alomaretobella@creublanca.esCentros Médicos Creu BlancaTel: 902 202 230Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: Raphaël Reverdy <raphael.reverdy@akretion.com>
To: "Contributors" <contributors@odoo-community.org>
Date: Mon, 01 Mar 2021 15:42:19 -0000
Subject: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
Dear community,I'd like to be a PSC for the following teams:- Logistics- Field Services- StorageYou can see my activity on OCA here : https://github.com/pulls?q=is%3Apr+user%3AOCA+author%3AhparfrGithub profile : https://github.com/hparfrThanks,
--Raphaël Reverdy_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.
by Enric Tobella Alomar - 05:45 - 1 Mar 2021 -
RE: Async import external employee data from db view to Odoo.
Nice modules :-)
In Odoo 12, I currently using very small modules for importing from MSSQL.
https://github.com/Bilbonet/external-dbsource
In Odoo 13 I will start to use these modules and help if is possible.
Thank you!
De: Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
Enviado el: lunes, 1 de marzo de 2021 10:07
Para: Contributors <contributors@odoo-community.org>
Asunto: Re: Async import external employee data from db view to Odoo.Thank you very much Simone, for the helpful hint.
I guess I will do "connector_importer_external_dbsource".
Thank you!
On Mon, Mar 1, 2021 at 3:06 PM Simone Orsi <simahawk@gmail.com> wrote:
On Mon, Mar 1, 2021 at 7:47 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:
Thank you Simon! I could help to write more readme afterwards :)
I checked it and it looks like what we wanted to do, except it only deal with .CSV file at the moment. So I will need to create the new import component handler for MSSQL, right?
As you mentioned, you did it for Oracle DB?
Yes, but it's quite easy.
Each step of the import machinery it's separated. What you have to do is to create your own source model which provides a `_get_lines` method which returns a list of dict. The rest of the system does not care where you pick data from.
Here you see an example using another Odoo instance as source (I've used it to migrate records from an old v9 to a new v11 live).
Then depending on the complexity of your import you'll have to define one or mappers. It's unlikely that you have to define specific importers, especially if you use https://github.com/OCA/connector-interfaces/pull/76 (which might benefit from some reviews ;) ).
Kitti U.
On Sun, Feb 28, 2021 at 6:11 PM Simone Orsi <simahawk@gmail.com> wrote:
Hi Kitti,
connector_importer was born exactly for this reason: recurring imports.
I've used it for importing employees and users and more (even from Oracle DB).
Docs are missing so if you have questions, don't hesitate to ask.
Cheers,
S.
On Sun, Feb 28, 2021 at 9:52 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:
Dear Community,
We need to get data from external HR applications (they will provide an mssql database view), for users and employee data into Odoo.
It seems to be quite a generic use case, to become an addon, so I want to check with community, would be nice to know how you normally cope with this.
I checked OCA and plan to use the followings as starting point.
Thank you!
Kitti U.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Simone Orsi
Full stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source.
_______________________________________________
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
--Simone Orsi
Full stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
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 Jesús Ramiro Martinez - 05:31 - 1 Mar 2021 -
Re: Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
+1Regards.El lun, 1 mar 2021 a las 16:42, Raphaël Reverdy (<raphael.reverdy@akretion.com>) escribió:Dear community,I'd like to be a PSC for the following teams:- Logistics- Field Services- StorageYou can see my activity on OCA here : https://github.com/pulls?q=is%3Apr+user%3AOCA+author%3AhparfrGithub profile : https://github.com/hparfrThanks,
--Raphaël Reverdy_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Pedro M. Baeza - 05:31 - 1 Mar 2021 -
Proposing myself (@hparfr) to be PSC of Logistics, FSM, Storage
Dear community,I'd like to be a PSC for the following teams:- Logistics- Field Services- StorageYou can see my activity on OCA here : https://github.com/pulls?q=is%3Apr+user%3AOCA+author%3AhparfrGithub profile : https://github.com/hparfrThanks,
--Raphaël Reverdy
by Raphaël Reverdy - 04:41 - 1 Mar 2021 -
OCA BOT can't merge PRs in OCA/l10n-italy branch 11.0
Can anyone help us to understand why the BOT can't merge this PRor this one?Thank you.--Francesco ApruzzeseProfilo professionale: http://it.linkedin.com/in/francescoapruzzese
Il contenuto di questo messaggio elettronico è riservato e tutelato dal segreto professionale ed è rivolto esclusivamente al/ai destinatario/i identificato/i. Pertanto è proibito leggerlo, copiarlo, divulgarlo o utilizzarlo da parte di chiunque salvo il/i destinatario/i. Se non siete il destinatario, vi invitiamo a cancellare il messaggio ed eventuali allegati dandocene immediatamente comunicazione scritta a mezzo posta elettronica.
This e-mail and any attachments are confidential and may contain information intended for the addressee(s) only. Reading, copying, disclosure or use by anybody else is unauthorised. If you are not the intended recipient, please delete this message and any attachments and advise the sender by return e-mail.
Non stampare questa email se non strettamente necessario. Aiuta te ed aiuta l'ambiente.
by Francesco Apruzzese - 02:21 - 1 Mar 2021 -
Re: Async import external employee data from db view to Odoo.
Thank you very much Simone, for the helpful hint.I guess I will do "connector_importer_external_dbsource".Thank you!On Mon, Mar 1, 2021 at 3:06 PM Simone Orsi <simahawk@gmail.com> wrote:On Mon, Mar 1, 2021 at 7:47 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:Thank you Simon! I could help to write more readme afterwards :)I checked it and it looks like what we wanted to do, except it only deal with .CSV file at the moment. So I will need to create the new import component handler for MSSQL, right?As you mentioned, you did it for Oracle DB?Yes, but it's quite easy.Each step of the import machinery it's separated. What you have to do is to create your own source model which provides a `_get_lines` method which returns a list of dict. The rest of the system does not care where you pick data from.Here you see an example using another Odoo instance as source (I've used it to migrate records from an old v9 to a new v11 live).Then depending on the complexity of your import you'll have to define one or mappers. It's unlikely that you have to define specific importers, especially if you use https://github.com/OCA/connector-interfaces/pull/76 (which might benefit from some reviews ;) ).Kitti U.On Sun, Feb 28, 2021 at 6:11 PM Simone Orsi <simahawk@gmail.com> wrote:Hi Kitti,connector_importer was born exactly for this reason: recurring imports.I've used it for importing employees and users and more (even from Oracle DB).Docs are missing so if you have questions, don't hesitate to ask.Cheers,S.On Sun, Feb 28, 2021 at 9:52 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:Dear Community,We need to get data from external HR applications (they will provide an mssql database view), for users and employee data into Odoo.It seems to be quite a generic use case, to become an addon, so I want to check with community, would be nice to know how you normally cope with this.I checked OCA and plan to use the followings as starting point.Thank you!Kitti U._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Simone OrsiFull stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
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
--Simone OrsiFull stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Kitti Upariphutthiphong - 10:06 - 1 Mar 2021 -
Re: Async import external employee data from db view to Odoo.
On Mon, Mar 1, 2021 at 7:47 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:Thank you Simon! I could help to write more readme afterwards :)I checked it and it looks like what we wanted to do, except it only deal with .CSV file at the moment. So I will need to create the new import component handler for MSSQL, right?As you mentioned, you did it for Oracle DB?Yes, but it's quite easy.Each step of the import machinery it's separated. What you have to do is to create your own source model which provides a `_get_lines` method which returns a list of dict. The rest of the system does not care where you pick data from.Here you see an example using another Odoo instance as source (I've used it to migrate records from an old v9 to a new v11 live).Then depending on the complexity of your import you'll have to define one or mappers. It's unlikely that you have to define specific importers, especially if you use https://github.com/OCA/connector-interfaces/pull/76 (which might benefit from some reviews ;) ).Kitti U.On Sun, Feb 28, 2021 at 6:11 PM Simone Orsi <simahawk@gmail.com> wrote:Hi Kitti,connector_importer was born exactly for this reason: recurring imports.I've used it for importing employees and users and more (even from Oracle DB).Docs are missing so if you have questions, don't hesitate to ask.Cheers,S.On Sun, Feb 28, 2021 at 9:52 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:Dear Community,We need to get data from external HR applications (they will provide an mssql database view), for users and employee data into Odoo.It seems to be quite a generic use case, to become an addon, so I want to check with community, would be nice to know how you normally cope with this.I checked OCA and plan to use the followings as starting point.Thank you!Kitti U._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Simone OrsiFull stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
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
--Simone OrsiFull stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source.
by Simone Orsi - 09:06 - 1 Mar 2021 -
Re: Async import external employee data from db view to Odoo.
Thank you Simon! I could help to write more readme afterwards :)I checked it and it looks like what we wanted to do, except it only deal with .CSV file at the moment. So I will need to create the new import component handler for MSSQL, right?As you mentioned, you did it for Oracle DB?Kitti U.On Sun, Feb 28, 2021 at 6:11 PM Simone Orsi <simahawk@gmail.com> wrote:Hi Kitti,connector_importer was born exactly for this reason: recurring imports.I've used it for importing employees and users and more (even from Oracle DB).Docs are missing so if you have questions, don't hesitate to ask.Cheers,S.On Sun, Feb 28, 2021 at 9:52 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:Dear Community,We need to get data from external HR applications (they will provide an mssql database view), for users and employee data into Odoo.It seems to be quite a generic use case, to become an addon, so I want to check with community, would be nice to know how you normally cope with this.I checked OCA and plan to use the followings as starting point.Thank you!Kitti U.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Simone OrsiFull stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Kitti Upariphutthiphong - 07:46 - 1 Mar 2021 -
Re: Async import external employee data from db view to Odoo.
Hi Kitti,connector_importer was born exactly for this reason: recurring imports.I've used it for importing employees and users and more (even from Oracle DB).Docs are missing so if you have questions, don't hesitate to ask.Cheers,S.On Sun, Feb 28, 2021 at 9:52 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:Dear Community,We need to get data from external HR applications (they will provide an mssql database view), for users and employee data into Odoo.It seems to be quite a generic use case, to become an addon, so I want to check with community, would be nice to know how you normally cope with this.I checked OCA and plan to use the followings as starting point.Thank you!Kitti U.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Simone OrsiFull stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source.
by Simone Orsi - 12:11 - 28 Feb 2021 -
Async import external employee data from db view to Odoo.
Dear Community,We need to get data from external HR applications (they will provide an mssql database view), for users and employee data into Odoo.It seems to be quite a generic use case, to become an addon, so I want to check with community, would be nice to know how you normally cope with this.I checked OCA and plan to use the followings as starting point.Thank you!Kitti U.
by Kitti Upariphutthiphong - 09:51 - 28 Feb 2021 -
Re: Postgresql Table partitioning in Odoo
Graeme,I have considered for example to create materialized views for aggregated data in connection with the financial reports, MIS Builder, etc. The drawback is that it essentially requires you to introduce a lot of changes to the application logic in order to make use of those materialized views. At this stage partitioning seems to me like a better idea, because the change is (almost) limited to the database, and you can continue to use the application as it has been designed.I'm not concerned (yet) by the 32 bits limitation of id's.On Sat, Feb 27, 2021 at 3:12 AM Graeme Gellatly <gdgellatly@gmail.com> wrote:Hi,It's not really practical unfortunately. You can't just decide to use partitions. Well I suppose maybe you could rename the existing table, create a new one partitioned and then attach the renamed table as a partition if you were doing partition by date or id. I think a lot of the problem with aml in particular is the rows have gotten very wide as well.Materialized views, partial indexes, clustering tables, even just good GIN indexing are all quite a lot simpler and can offer far better performance depending on need. Indeed I remember 8 or 9 years ago there was a popular module for account move lines which implemented what could best be described as homegrown matviews to store aggregate AML data. However, all these solutions are still constrained by Odoo 32 bit id's. So if by getting large you mean approaching the billions, then that's a new set of problems.There is one set of solutions which I'm quite interested in for performance. That is using logical BDR to partition the write server of multi master databases. It seems this is doable without too much change but Odoo's id model doesn't meet the requirements, needing either GUID or BIGSERIAL. My idea is essentially to partition tables say geographically on some field, say company id, or create_uid and then run local Odoo instances in those geographies with their own pg cluster but achieving global consistency.On Sat, Feb 27, 2021 at 8:17 AM Jordi Ballester Alomar <jordi.ballester@forgeflow.com> wrote:Dear contributors,We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?Looking forward to hearing your thoughts.Regards,--Jordi Ballester 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
_______________________________________________
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 - 07:26 - 27 Feb 2021 -
Re: Postgresql Table partitioning in Odoo
Nhomar,In this case the account_move_line table is larger than 10 millions records. The company is using inventory accounting, and does a lot of inventory transactions. That does not help, as it creates a big number of inventory related AML's. I'd like to get rid of inventory accounting, of course! :)We refactored the OCA financial reports completely, for example, and certainly this has added a lot of benefits.What makes sense for me with partitioning a table, especially in accounting, is that you don't often make use of previous years move lines, except when you are computing an initial balance.I tried to manually transform the account_move_line to a partitioned table with success. See https://github.com/odoo/odoo/pull/66964. I would need to test with a large database now to check if this really brings the expected benefits.As Daniel Reis suggestested, using partial indexes seems interesting. However the Postgres recommends not to use them when partitioning really makes more sense. https://www.postgresql.org/docs/current/indexes-partial.html"If your table is large enough that a single index really is a bad idea, you should look into using partitioning instead (see Section 5.11). With that mechanism, the system does understand that the tables and indexes are non-overlapping, so far better performance is possible."Partitioning in odoo must be limited to using always the "id" column in the partitions, as the primary key must be contained in all partitions.On Fri, Feb 26, 2021 at 8:57 PM Nhomar Hernández <nhomar@vauxoo.com> wrote:How many records is for you **Absurd**.?
We try to fix odoo performance in the views or tools that are slow with records over between 1 and 10 millions.But not always touch postgres will help.. Did you make the measurement?El vie, 26 de feb. de 2021 a la(s) 13:17, Jordi Ballester Alomar (jordi.ballester@forgeflow.com) escribió:Dear contributors,We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?Looking forward to hearing your thoughts.Regards,--Jordi Ballester 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
--Nhomar G Hernández
Vauxoo | CEO
¡Construyamos algo genial!
Cel: +52 (477) 393.3942 | Telegram: nhomar | Twitter: @nhomarMéxico · Venezuela · Costa Rica · Perú
_______________________________________________
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 - 07:21 - 27 Feb 2021 -
Re: Postgresql Table partitioning in Odoo
Hi,It's not really practical unfortunately. You can't just decide to use partitions. Well I suppose maybe you could rename the existing table, create a new one partitioned and then attach the renamed table as a partition if you were doing partition by date or id. I think a lot of the problem with aml in particular is the rows have gotten very wide as well.Materialized views, partial indexes, clustering tables, even just good GIN indexing are all quite a lot simpler and can offer far better performance depending on need. Indeed I remember 8 or 9 years ago there was a popular module for account move lines which implemented what could best be described as homegrown matviews to store aggregate AML data. However, all these solutions are still constrained by Odoo 32 bit id's. So if by getting large you mean approaching the billions, then that's a new set of problems.There is one set of solutions which I'm quite interested in for performance. That is using logical BDR to partition the write server of multi master databases. It seems this is doable without too much change but Odoo's id model doesn't meet the requirements, needing either GUID or BIGSERIAL. My idea is essentially to partition tables say geographically on some field, say company id, or create_uid and then run local Odoo instances in those geographies with their own pg cluster but achieving global consistency.On Sat, Feb 27, 2021 at 8:17 AM Jordi Ballester Alomar <jordi.ballester@forgeflow.com> wrote:Dear contributors,We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?Looking forward to hearing your thoughts.Regards,--Jordi Ballester 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
by Graeme Gellatly - 03:11 - 27 Feb 2021 -
Re: Postgresql Table partitioning in Odoo
Hello Jordi,In some cases Partial Indexes can do the trick.For example, you could have a partial index only for active records. Since most of the time there is filter condition on the active field, the smaller partial index can be used instead of a full index.This can give you the same benefits as a partitioned table, with a simpler solution (no need to push data around).More info:--drNo dia 26/02/2021, às 19:17, Jordi Ballester Alomar <jordi.ballester@forgeflow.com> escreveu:
Dear contributors,We have a case of a database where some tables, like account.move.line are growing to absurd numbers of records. At this point we are considering using Postgresql Table partitioning to speed up performance. Has anyone of you had experience with table partitioning?Looking forward to hearing your thoughts.Regards,--Jordi Ballester 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
by Daniel Reis - 09:36 - 26 Feb 2021
