Archives
Contributors
-
Can we improve our 2024 OCA Membership numbers in the next few days and set a new record?
Dear OCA Community,
I apologize for being direct, but I believe we can increase the total number of OCA members in 2024 significantly.
As of today, only 47 OCA members are listed in the 2024 directory.
It seems that many 2023 OCA members prefer being served rather than taking the initiative to purchase their memberships online (see my previous email encouraging online membership purchases).
AND,
• You don’t need to buy the OCA 2024 membership to ask questions this year.
• Nor do you need an OCA membership to receive answers from our wonderful community regarding Odoo and the OCA apps.
BUT,
If you asked a question in 2023 and received valuable assistance from our community that benefited:
• your business,
• the company you work for,
• or helped your customer,
Isn’t that reason enough to buy the 2024 OCA Membership?
Let’s significantly increase our total membership in the next few days and set a new record in total OCA members.
Have a great day, and don’t forget to purchase the 2024 OCA Membership TODAY – it’s only 50 Euros.
OCA Membership 2024: https://odoo-community.org/shop/24-msm-2024-oca-member-503809#attr=
Best regards,
Michel Stroom
OCA member 2023 and 2024
Using Odoo since version 8
by Michel Stroom - 02:35 - 21 Jan 2024 -
Re: Filling in product catalogue by vendors (external parties - i.e. portal users)
Hi,My 5c suggestion is, before going farer and further here, to look at the following existing functionalities, I must admit not exhausted list:I hope (believe) that you can figure out your first-step working scenario which will satisfy your desire not to rely on "external hands" data management.However, because your initial more important business requirement looks like to be minimising or eliminating the internal workload of the procurement team, still a process that is implementing a "horizontal integration" across vendors must be architected (designed), which is also possible, but probably not with the existing (like above) functionalities. Eventually, that might be the second-step scenario which will meet your business functional requirements to decrease the internal workload of the procuring people. Another e-catalog-based approach is also feasible but that would require adapting the purchasing strategy and operations of the company' sourcing process.On Fri, Jan 19, 2024 at 5:12 AM Radovan Skolnik <notifications@odoo-community.org> wrote:Hello, I am working with a client that works in food supply industry - i.e. they purchase groceries and other food stuff and prepare food on large scale. An example would be hundreds/thousands portions of bolognese sauce made of beef, tomato sauce, ... Now the company is just starting their operations and are collecting information about possible suppliers and products available. Their idea is something like sending out Rf? (P as proposal maybe) let's say for that tomato sauce where the vendors would provide information such as: description, origin, packaging, price, ... My experience strongly suggests not allowing external parties to be allowed to create business records such as products in the system but this is the kind of scenario they describe as the desired outcome. I have used a 3rd party module which extends the RfQ functionality to fill in the prices by suppliers (so effectively changing one attribute in purchase.order.line). But in this case the scenario should lead to creation of new product.[template|product] and also product.supplierinfo by the suppliers. AFAIK Odoo out-of-the-box does not have anything even close to this. Has anyone faced similar requirement? Any recommendations on how to tackle this one? Any advice is greatly welcome. 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
by milori2006 - 11:21 - 20 Jan 2024 -
Re: Procedure for migration of OCA modules
Hi,The Odoo and OpenUpgrade processes are technically very similar, except Openupgrade offers a more complete migration than Enterprise migration. Enterprise has a few more things like reports. Openupgrade allows you to take a lot more control over timing and scope and allows you to retain sovereignty over your own data.If you have ever viewed the Odoo migration logs they migrate 1 version at a time then next (indeed they do this for every single version like SaaS etc), but only for their own code.For Openupgrade the process is the same, except 1. You need to have a system to trigger each version migration. The most common system is when it finishes I manually trigger the next migration, and 2. You can migrate any and all code you want along the way but typically it looks like this.- For every version migrated install all of the Odoo and OCA modules you are using.
- For the final version migration, for your own custom code, you write the migration scripts to go from the original version to the target version. This saves the code effort of migrating custom code to work on 3 or 4 different versions of Odoo.
With Enterprise you need to write migration scripts for all non Odoo S.A modules from the current version to target version. Usually, if there are a lot of these, and you are using primarily good quality modules such as OCA, that already will have migration scripts, the effort is much less with Openupgrade IMO, and many many Enterprise customers use OpenUpgrade for this reason.On Sat, Jan 20, 2024 at 12:39 AM David Ramia <notifications@odoo-community.org> wrote:Hello, I have a question about migrating a database when we want to jump several versions, for example from v14 to v16.
Odoo allows you to migrate your modules without problem between several versions, but what would be the correct procedure for OCA modules since if I go from v14 to v16 all the v15 migration scripts are not executed. I know that OpenUpgrade exists, but I see that it is to migrate Odoo modules, I don't see anything with OCA modules.
Is there any procedure for this?
ThanksDavid Ramia
Consultor Programadordavid.ramia@processcontrol.es
www.processcontrol.es
93 229 68 10Este mensaje va dirigido exclusivamente a su destinatario, pudiendo contener información confidencial sometida a secreto profesional. No está permitida su comunicación, reproducción o distribución sin la autorización expresa de PROCESS CONTROL S.C.C.L. De conformidad con lo dispuesto en el GDPR, y la LOPDGDD, sus datos personales y el email del interesado, se tratarán bajo la responsabilidad de PROCESS CONTROL S.C.C.L. por un interés legítimo y para el envío de comunicaciones sobre nuestros productos y servicios, y se conservarán mientras ninguna de las partes se oponga a ello. Los datos podrán comunicarse a las empresas del grupo con el mismo fin antes descrito. Le informamos de que puede ejercer los derechos de acceso, rectificación, portabilidad y supresión de sus datos y los de limitación y oposición a su tratamiento dirigiéndose a rgpd@processcontrol.es. Si considera que el tratamiento no se ajusta a la normativa vigente, podrá presentar una reclamación ante la autoridad de control en www.aepd.es.
This message are addressed exclusively to the recipient and may contain confidential information subject to professional secrecy. It may not be communicated, reproduced or distributed without the express authorisation of PROCESS CONTROL S.C.C.L.. In accordance with the provisions of GDPR and LOPDGDD, your personal data and email addresses collected under the responsibility of PROCESS CONTROL S.C.C.L. for a legitimate interest and for the purpose of sending communications about our products and services and will be retained for as long as none of the parties object. The data may be communicated to companies in the same group for the same purposes as described above. You can exercise your rights of access, rectification, portability and erasure of your data and those of restriction and objection to their processing by mailing rgpd@processcontrol.es. If you consider that the processing does not comply with current legislation, you may file a complaint with the Spanish supervisory authority at www.aepd.es._______________________________________________
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" <graeme@moahub.nz> - 07:30 - 19 Jan 2024 -
Re: [SPAM] Re: Procedure for migration of OCA modules
Hello,You might find a lot of useful information in the latest Open Upgrade documentation, that was updated lately by Sylvain Le Gal.Happy migration!--
Virginie+32 477 64 17 20Info : 2j/semaine sont dédiés à Chaf et 3j/semaine sont dédiés à Coop IT Easy-----Original Message-----From: David Vidal <notifications@odoo-community.org>Reply-To: Contributors <contributors@odoo-community.org>To: Contributors <contributors@odoo-community.org>Subject: [SPAM] Re: Procedure for migration of OCA modulesDate: Fri, 19 Jan 2024 12:02:44 -0000Normally (hopefully) every migrated OCA module contains that version migration scripts. And then with OpenUpgrade they're triggered in order along with the core migration scripts. Even more, when an OCA module is merged into another or renamed, it can be (should be) declared in a dictionary declared in OpenUpgrade (apriori.py) and that perform some automatic migration tasks that ease that kind of situation.On the other hand, you should pass your database through each version migration, as otherwise you'd be missing important data transformations and your result would be very likely inconsistent.El vie, 19 ene 2024 a las 12:39, David Ramia (<notifications@odoo-community.org>) escribió:Hello, I have a question about migrating a database when we want to jump several versions, for example from v14 to v16.
Odoo allows you to migrate your modules without problem between several versions, but what would be the correct procedure for OCA modules since if I go from v14 to v16 all the v15 migration scripts are not executed. I know that OpenUpgrade exists, but I see that it is to migrate Odoo modules, I don't see anything with OCA modules.
Is there any procedure for this?
ThanksDavid Ramia
Consultor Programadordavid.ramia@processcontrol.es
www.processcontrol.es
93 229 68 10Este mensaje va dirigido exclusivamente a su destinatario, pudiendo contener información confidencial sometida a secreto profesional. No está permitida su comunicación, reproducción o distribución sin la autorización expresa de PROCESS CONTROL S.C.C.L. De conformidad con lo dispuesto en el GDPR, y la LOPDGDD, sus datos personales y el email del interesado, se tratarán bajo la responsabilidad de PROCESS CONTROL S.C.C.L. por un interés legítimo y para el envío de comunicaciones sobre nuestros productos y servicios, y se conservarán mientras ninguna de las partes se oponga a ello. Los datos podrán comunicarse a las empresas del grupo con el mismo fin antes descrito. Le informamos de que puede ejercer los derechos de acceso, rectificación, portabilidad y supresión de sus datos y los de limitación y oposición a su tratamiento dirigiéndose a rgpd@processcontrol.es. Si considera que el tratamiento no se ajusta a la normativa vigente, podrá presentar una reclamación ante la autoridad de control en www.aepd.es.
This message are addressed exclusively to the recipient and may contain confidential information subject to professional secrecy. It may not be communicated, reproduced or distributed without the express authorisation of PROCESS CONTROL S.C.C.L.. In accordance with the provisions of GDPR and LOPDGDD, your personal data and email addresses collected under the responsibility of PROCESS CONTROL S.C.C.L. for a legitimate interest and for the purpose of sending communications about our products and services and will be retained for as long as none of the parties object. The data may be communicated to companies in the same group for the same purposes as described above. You can exercise your rights of access, rectification, portability and erasure of your data and those of restriction and objection to their processing by mailing rgpd@processcontrol.es. If you consider that the processing does not comply with current legislation, you may file a complaint with the Spanish supervisory authority at www.aepd.es._______________________________________________
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 Virginie Dewulf. - 01:26 - 19 Jan 2024 -
Re: Procedure for migration of OCA modules
Normally (hopefully) every migrated OCA module contains that version migration scripts. And then with OpenUpgrade they're triggered in order along with the core migration scripts. Even more, when an OCA module is merged into another or renamed, it can be (should be) declared in a dictionary declared in OpenUpgrade (apriori.py) and that perform some automatic migration tasks that ease that kind of situation.On the other hand, you should pass your database through each version migration, as otherwise you'd be missing important data transformations and your result would be very likely inconsistent.El vie, 19 ene 2024 a las 12:39, David Ramia (<notifications@odoo-community.org>) escribió:Hello, I have a question about migrating a database when we want to jump several versions, for example from v14 to v16.
Odoo allows you to migrate your modules without problem between several versions, but what would be the correct procedure for OCA modules since if I go from v14 to v16 all the v15 migration scripts are not executed. I know that OpenUpgrade exists, but I see that it is to migrate Odoo modules, I don't see anything with OCA modules.
Is there any procedure for this?
ThanksDavid Ramia
Consultor Programadordavid.ramia@processcontrol.es
www.processcontrol.es
93 229 68 10Este mensaje va dirigido exclusivamente a su destinatario, pudiendo contener información confidencial sometida a secreto profesional. No está permitida su comunicación, reproducción o distribución sin la autorización expresa de PROCESS CONTROL S.C.C.L. De conformidad con lo dispuesto en el GDPR, y la LOPDGDD, sus datos personales y el email del interesado, se tratarán bajo la responsabilidad de PROCESS CONTROL S.C.C.L. por un interés legítimo y para el envío de comunicaciones sobre nuestros productos y servicios, y se conservarán mientras ninguna de las partes se oponga a ello. Los datos podrán comunicarse a las empresas del grupo con el mismo fin antes descrito. Le informamos de que puede ejercer los derechos de acceso, rectificación, portabilidad y supresión de sus datos y los de limitación y oposición a su tratamiento dirigiéndose a rgpd@processcontrol.es. Si considera que el tratamiento no se ajusta a la normativa vigente, podrá presentar una reclamación ante la autoridad de control en www.aepd.es.
This message are addressed exclusively to the recipient and may contain confidential information subject to professional secrecy. It may not be communicated, reproduced or distributed without the express authorisation of PROCESS CONTROL S.C.C.L.. In accordance with the provisions of GDPR and LOPDGDD, your personal data and email addresses collected under the responsibility of PROCESS CONTROL S.C.C.L. for a legitimate interest and for the purpose of sending communications about our products and services and will be retained for as long as none of the parties object. The data may be communicated to companies in the same group for the same purposes as described above. You can exercise your rights of access, rectification, portability and erasure of your data and those of restriction and objection to their processing by mailing rgpd@processcontrol.es. If you consider that the processing does not comply with current legislation, you may file a complaint with the Spanish supervisory authority at www.aepd.es._______________________________________________
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 Vidal - 01:01 - 19 Jan 2024 -
Procedure for migration of OCA modules
Hello, I have a question about migrating a database when we want to jump several versions, for example from v14 to v16.
Odoo allows you to migrate your modules without problem between several versions, but what would be the correct procedure for OCA modules since if I go from v14 to v16 all the v15 migration scripts are not executed. I know that OpenUpgrade exists, but I see that it is to migrate Odoo modules, I don't see anything with OCA modules.
Is there any procedure for this?
ThanksDavid Ramia
Consultor Programadordavid.ramia@processcontrol.es
www.processcontrol.es
93 229 68 10Este mensaje va dirigido exclusivamente a su destinatario, pudiendo contener información confidencial sometida a secreto profesional. No está permitida su comunicación, reproducción o distribución sin la autorización expresa de PROCESS CONTROL S.C.C.L. De conformidad con lo dispuesto en el GDPR, y la LOPDGDD, sus datos personales y el email del interesado, se tratarán bajo la responsabilidad de PROCESS CONTROL S.C.C.L. por un interés legítimo y para el envío de comunicaciones sobre nuestros productos y servicios, y se conservarán mientras ninguna de las partes se oponga a ello. Los datos podrán comunicarse a las empresas del grupo con el mismo fin antes descrito. Le informamos de que puede ejercer los derechos de acceso, rectificación, portabilidad y supresión de sus datos y los de limitación y oposición a su tratamiento dirigiéndose a rgpd@processcontrol.es. Si considera que el tratamiento no se ajusta a la normativa vigente, podrá presentar una reclamación ante la autoridad de control en www.aepd.es.
This message are addressed exclusively to the recipient and may contain confidential information subject to professional secrecy. It may not be communicated, reproduced or distributed without the express authorisation of PROCESS CONTROL S.C.C.L.. In accordance with the provisions of GDPR and LOPDGDD, your personal data and email addresses collected under the responsibility of PROCESS CONTROL S.C.C.L. for a legitimate interest and for the purpose of sending communications about our products and services and will be retained for as long as none of the parties object. The data may be communicated to companies in the same group for the same purposes as described above. You can exercise your rights of access, rectification, portability and erasure of your data and those of restriction and objection to their processing by mailing rgpd@processcontrol.es. If you consider that the processing does not comply with current legislation, you may file a complaint with the Spanish supervisory authority at www.aepd.es.
by David Ramia - 12:38 - 19 Jan 2024 -
v.17.0 on Weblate
Hi all.A simple question: why I don't find nothing on OCA-Weblate (https://translation.odoo-community.org/accounts/profile/#notifications) if I look for the 17.0 version but actually there are some modules ported as https://github.com/OCA/pos/tree/17.0 ?ThanksStefano Consolarowww.mymage.it
by Stefano Consolaro - 10:05 - 19 Jan 2024 -
Re: OCA 2024 Membership
Hello everyone, Please I would like you to help me automate the sending of emails every time a product goes out of stock or out of stock. Thank you for helping me with automated actions
Le ven. 19 janv. 2024 à 00:12, Luis A. Pinzón <notifications@odoo-community.org> a écrit :Hi Rebecca. Please, could you tell me how I can update my profile photo? In the details I have no option to do so. thank you so much Luis Pinzón
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--SY Hawa Diallo - (IngéniEure SI)
InfOrmation SystEms EnginEer
by hawa1 - 10:01 - 19 Jan 2024 -
OCA 2024 Membership
Hi Rebecca. Please, could you tell me how I can update my profile photo? In the details I have no option to do so. thank you so much Luis Pinzón
by Luis Pinzon - 01:11 - 19 Jan 2024 -
Filling in product catalogue by vendors (external parties - i.e. portal users)
Hello, I am working with a client that works in food supply industry - i.e. they purchase groceries and other food stuff and prepare food on large scale. An example would be hundreds/thousands portions of bolognese sauce made of beef, tomato sauce, ... Now the company is just starting their operations and are collecting information about possible suppliers and products available. Their idea is something like sending out Rf? (P as proposal maybe) let's say for that tomato sauce where the vendors would provide information such as: description, origin, packaging, price, ... My experience strongly suggests not allowing external parties to be allowed to create business records such as products in the system but this is the kind of scenario they describe as the desired outcome. I have used a 3rd party module which extends the RfQ functionality to fill in the prices by suppliers (so effectively changing one attribute in purchase.order.line). But in this case the scenario should lead to creation of new product.[template|product] and also product.supplierinfo by the suppliers. AFAIK Odoo out-of-the-box does not have anything even close to this. Has anyone faced similar requirement? Any recommendations on how to tackle this one? Any advice is greatly welcome. Best regards Radovan Skolnik
by Radovan Skolnik - 11:10 - 18 Jan 2024 -
Re: MQTT client for Odoo
Hello, I would also throw my approach in the ring https://github.com/fkantelberg/interfaces/tree/15.0/mqtt There are basically events you can configure which trigger on specific things (like create, write, delete of records, there is an extra module to trigger on user login) and convert the record/changes to a MQTT payload and send it on the bus. The sub side is handled by the processors where you can define code which handles incoming payload. It also includes a small framework to subscribe model functions directly (see readme/USAGE.rst). The demo basically demonstrates a sync between 2 Odoo systems of some fields for res.partner. Should be portable to any newer Odoo versions quite well and I can make sure to push it to the OCA. (got distracted and forgot about it) Best regards, Florian Am 13.01.24 um 08:06 schrieb Apm Consultancy: > Dears, > > Please can one who already experienced to pub/sub on topics of MQTT > broker share the approach or the pieces of use? > > > Best regards, > MiroL > > > - iPhone - > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe > -- Mit freundlichen Grüßen Florian Kantelberg Softwareentwickler initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Tel.: +49 (0) 4181 1350344 Fax: +49 (0) 4181 1350310 Email: florian.kantelberg@initos.com Internet: https://www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht: Tostedt, HRB 205226 USt-IdNr: DE 815580155 Steuer-Nr: 15/200/53247
by Florian Kantelberg - 06:31 - 18 Jan 2024 -
Re: Elimination of multi-company transactions
Thank you everyone for the valuable suggestions.This helps us understand the what is available / lacking and know what needs to be developed further if we want to proceed with this requirement.On Wed, Jan 17, 2024 at 4:06 PM Oleg Kuryan <notifications@odoo-community.org> wrote:Hello,About Odoo consolidation/multi-company. This is indeed in standard good only for basic needs. Though OCA did a great job to improve it. But because it is opensource not everything is migrated to latest version:1) Like consolidation module that Pedro have sent you might check (but only available for Odoo 14)2) For multi company improvements check this repository https://github.com/OCA/multi-company (from amount of modules you may see how many gaps there are)3) I in general encourage you to at least once per quarter check what's new in repositories here https://github.com/oca4) In my company experience we ended up our own consolidation approach that works for our managerial accounting so I can see company financial KPIs across branches/departments/service lines etc. in single currency (and I can say this is quite a struggle as if you work in different currencies (we work with 3 currencies) you will end up with lots of challenges related to exchange rates difference in order to have proper consolidated view for standard reports in single currency.About other topics on if Odoo is a ready solution or not. Also I do not want to start a long discussion. But still want to say that Odoo is selected not because it is ready OOTB solution, but because:(1) it can be adapted to your needs easily (because of framework and popular programming language)(2) it has great community (BTW, if you see Odoo comparison with other software like with Accounting, CRM and etc - then what you need to understand that if it is no done by Odoo themselves, it is based on feedback by Odoo community - that is very active and vote very active for Odoo - and this is really strong point of Odoo, not features)I guess you might be misled by Odoo marketing. I suggest not to pay too much attention to it - this is just marketing (though I agree it is confusing).When choosing Odoo you need to understand what it is all about and what you are purchasing. I would say that Odoo is a LEGO constructor (not Business solution, but a business framework). I wrote an article about it some time ago and it is still valid https://www.linkedin.com/pulse/odoo-really-saporacle-killer-oleg-kuryan/Once you understand the above, there will be no confusion. To convert Odoo into ERP for your company (if it is not a small company around 1-5 employees) you require quite a bit of investment. This is a photo from the Odoo conference from 2022. To understand pretty much about average costs of the project (not including license cost). Also you can read more about Total Cost of Ownership in this article https://ventor.tech/odoo/the-true-cost-of-odoo-erp-pricing-and-ownership-insights/On Wed, Jan 17, 2024 at 9:27 AM Pedro M. Baeza <notifications@odoo-community.org> wrote:Check https://github.com/OCA/account-consolidation/tree/14.0/account_consolidation_oca to see if it meets your requirements.Regards._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Kitti Upariphutthiphong - 04:26 - 18 Jan 2024 -
Re: Inquiry on Preferred BI Tools and Connection Methods for Odoo
Good luck Rafael and thanks to share your first decision.
Bruno JoliveauArchitecte solutions - Président+1 514-317-7944
Nouveau
Suivez les publications des Numigiens 👀Découvrir Le mer. 17 janv. 2024 à 14:02, Rafael Blasco <notifications@odoo-community.org> a écrit :Hello all!
Thank you for all your answers.
We decided to go for PowerBI using this connector:
https://github.com/tmijail/Odoo-Power-BI-Connector
The time Will show us if this solution fits or not depending the volume of data and the size of reports.
😊
Best regards,
Rafael Blasco
Moduon
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Bruno Joliveau - 08:36 - 17 Jan 2024 -
RE: Inquiry on Preferred BI Tools and Connection Methods for Odoo
Hello all!
Thank you for all your answers.
We decided to go for PowerBI using this connector:
https://github.com/tmijail/Odoo-Power-BI-Connector
The time Will show us if this solution fits or not depending the volume of data and the size of reports.
😊
Best regards,
Rafael Blasco
Moduon
by Rafael Blasco (Moduon) - 08:00 - 17 Jan 2024 -
Re: Inquiry on Preferred BI Tools and Connection Methods for Odoo
Hi Rafael,
Here the tools we are using in my cooperative, I hope it is helpful.
- Preferred BI Tools: Which BI tools have you found most effective or
user-friendly when integrated with Odoo? Any par ticular
reasons for your preference, such as ease of use,
comprehensive features, or compatibility?
We are using Apache Superset, for us, it is the powerfulest open source BI tool and has a good community behind.
It has a lot of different charts, including maps.
- Connection Method: What type of connection method do you commonly
use for integrating BI tools with Odoo? Have you predominantly
been using XML-RPC, or are there other methods that you find
more efficient or reliable?
We make queries directly from database.
We are useing Postgres Foreign Datawrapper in order to map all odoo, and any other source, incuding flat files, in other postgres instance and then we build datasets in order to make charts in superset.
We also use DBT if we need to persist any query for performance purposes.
With this solution we can show the informations in our dashboards in real time.
- Experiences and Recommendations: Any specific experiences, challenges, or
success stories you can share about integrating BI tools with
Odoo? Your insights could be incredibly valuable for others in
the community who are navigating similar decisions.
We have some financial dashboards (mis reports extended, profit and loss, balance situation) in superset.
We also have dashboards for companies like Som Conexió (telecomunications), Som Mobilitat (carsharing) that takes some information from Odoo and information from other datasources.
We can mount dashboards for any model in Odoo, and if it's necessary, joining the data with other datasources with foreign data wrapper.
Regards,Konstantina Tsagkaricoopdevs.coop
On 9/1/24 16:47, Rafael Blasco wrote:
Dear OCA Contributors,
I hope this message finds you well. I am reaching out to the knowledgeable and experienced members of the Odoo Community Association to gather insights on a topic that is of growing importance in our field - the integration of Business Intelligence (BI) tools with Odoo.
As we continuously strive to improve our business processes and data analysis capabilities, understanding the most effective tools and techniques for integrating BI solutions with Odoo is crucial. Therefore, I would be immensely grateful if you could share your experiences and preferences in this area. Specifically, I am interested in the following questions:
- Preferred BI Tools: Which BI tools have you found most effective or user-friendly when integrated with Odoo? Any par ticular reasons for your preference, such as ease of use, comprehensive features, or compatibility?
- Connection Method: What type of connection method do you commonly use for integrating BI tools with Odoo? Have you predominantly been using XML-RPC, or are there other methods that you find more efficient or reliable?
- Experiences and Recommendations: Any specific experiences, challenges, or success stories you can share about integrating BI tools with Odoo? Your insights could be incredibly valuable for others in the community who are navigating similar decisions.
Your feedback and insights will not only assist me in making informed decisions for my current projects but will al so benefit the broader OCA community as we all work towards optimizing our use of Odoo in various business scenarios.
Thank you in advance for taking the time to share your knowledge and experiences. I look forward to your valuable responses.
Best regards,
Rafael Blasco
Moduon
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Konstantina Tsagkari
kon.tsagari@coopdevs.orgcoopdevs.org
AVÍS LEGAL:Aquest missatge i els seus arxius adjunts van dirigits exclusivament al seu destinatari, i poden contenir informació confidencial sotmesa a secret professional. No n’és permesa la comunicació, reproducció o distribució sense l’autorització expressa de COOPDEVS TREBALL S.C.C.L.. Si no en sou el destinatari final, si us plau, elimineu-lo i informeu-nos-en per aquesta via.
PROTECCIÓ DE DADES: De conformitat amb el que estableix el Reglament (UE) 2016/679, de 27 d’abril (GDPR), i la Llei Orgànica 3/2018, de 5 de desembre (LOPDGDD), l’informem que les dades personals i adreça de correu electrònic de l’interessat es tractaran sota la responsabilitat de COOPDEVS TREBALL S.C.C.L. per un interès legítim i per enviar comunicacions sobre els nostres productes i serveis, i es conservaran mentre cap de les parts s’hi oposi. No es comunicaran les dades a tercers, tret que sigui obligació legal. Us informem que podeu exercir els drets d’accés, rectificació, portabilitat i supressió de les vostres dades i els de limitació i oposició al seu tractament tot adreçant-vos a Can Batlló Bloc 8 Constitució 19-25, - 08014 Barcelona (Barcelona). E-mail: info@coopdevs.org. Si considereu que el tractament no s’ajusta a la normativa vigent, podeu presentar una reclamació davant l’autoritat de control a www.aepd.es.
by Konstantina Tsagkari - 01:00 - 17 Jan 2024 - Preferred BI Tools: Which BI tools have you found most effective or
user-friendly when integrated with Odoo? Any par ticular
reasons for your preference, such as ease of use,
comprehensive features, or compatibility?
-
Re: Elimination of multi-company transactions
Hello,About Odoo consolidation/multi-company. This is indeed in standard good only for basic needs. Though OCA did a great job to improve it. But because it is opensource not everything is migrated to latest version:1) Like consolidation module that Pedro have sent you might check (but only available for Odoo 14)2) For multi company improvements check this repository https://github.com/OCA/multi-company (from amount of modules you may see how many gaps there are)3) I in general encourage you to at least once per quarter check what's new in repositories here https://github.com/oca4) In my company experience we ended up our own consolidation approach that works for our managerial accounting so I can see company financial KPIs across branches/departments/service lines etc. in single currency (and I can say this is quite a struggle as if you work in different currencies (we work with 3 currencies) you will end up with lots of challenges related to exchange rates difference in order to have proper consolidated view for standard reports in single currency.About other topics on if Odoo is a ready solution or not. Also I do not want to start a long discussion. But still want to say that Odoo is selected not because it is ready OOTB solution, but because:(1) it can be adapted to your needs easily (because of framework and popular programming language)(2) it has great community (BTW, if you see Odoo comparison with other software like with Accounting, CRM and etc - then what you need to understand that if it is no done by Odoo themselves, it is based on feedback by Odoo community - that is very active and vote very active for Odoo - and this is really strong point of Odoo, not features)I guess you might be misled by Odoo marketing. I suggest not to pay too much attention to it - this is just marketing (though I agree it is confusing).When choosing Odoo you need to understand what it is all about and what you are purchasing. I would say that Odoo is a LEGO constructor (not Business solution, but a business framework). I wrote an article about it some time ago and it is still valid https://www.linkedin.com/pulse/odoo-really-saporacle-killer-oleg-kuryan/Once you understand the above, there will be no confusion. To convert Odoo into ERP for your company (if it is not a small company around 1-5 employees) you require quite a bit of investment. This is a photo from the Odoo conference from 2022. To understand pretty much about average costs of the project (not including license cost). Also you can read more about Total Cost of Ownership in this article https://ventor.tech/odoo/the-true-cost-of-odoo-erp-pricing-and-ownership-insights/On Wed, Jan 17, 2024 at 9:27 AM Pedro M. Baeza <notifications@odoo-community.org> wrote:Check https://github.com/OCA/account-consolidation/tree/14.0/account_consolidation_oca to see if it meets your requirements.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 Oleg Kuryan - 10:05 - 17 Jan 2024 -
Re: Elimination of multi-company transactions
Check https://github.com/OCA/account-consolidation/tree/14.0/account_consolidation_oca to see if it meets your requirements.Regards.
by Pedro M. Baeza - 09:26 - 17 Jan 2024 -
Re: Elimination of multi-company transactions
Hi,it is a very good point bcs I am also exploring to which extents (if at all) Odoo is a real-real enterprise ERP : multicompanies, multicountries, multiCA, running in parallel COCA and LOCA (corporate and local country' Chart of Accounts). We call a vehicle and a car and a truck but car is not truck and vs.I don't intentd to step into "run in battle" here (or elsewhere) but I was overimpressed by a recent presentation how Odoo is overcoming another ERP (well known big brand) bcs of this , bcs of that... and am puzzled if one involving them in public presentations are actually well prepeared what the "E" in ERP really stands for.Coming back to the consolidation topic - looking forward to learn more about it from the experiences of others.Have a nice day!On Wed, 17 Jan 2024, 13:57 Kitti Upariphutthiphong, <notifications@odoo-community.org> wrote:Dear community,I have been researching, multi-company in Odoo is not great. For consolidation, it seem possible through some appstore module purchase (not OCA, so I am not very confident)Elimination of multi company transactions for consolidation purposes is nowhere we could find.Anyone have experiences with this?Thanks!
_______________________________________________
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 - 09:16 - 17 Jan 2024 -
Elimination of multi-company transactions
Dear community,I have been researching, multi-company in Odoo is not great. For consolidation, it seem possible through some appstore module purchase (not OCA, so I am not very confident)Elimination of multi company transactions for consolidation purposes is nowhere we could find.Anyone have experiences with this?Thanks!
by Kitti Upariphutthiphong - 07:55 - 17 Jan 2024 -
Odoo 12 / Creating Invoice from Sale Order
Hello all, happy new yearI'm working on Odoo12 and i try to understand the process of creation an Invoice from a Sale Order. In some of my Sales Orders, i've got some product line (with quantity and price) and also some sections and notes. When i create the invoice the note lines are not created and the section are created only if there is at least on product line after. Why this restrictions? Is there a possibility to workaround? Any OCA module? For those who work on Odoo 13,14,15,16, is this operating mode persist?Thanks
Cedric DEBARD
by Cedric DEBARD - 09:27 - 15 Jan 2024
