Community mailing list archives

community@mail.odoo.com

Avatar

Re: RFQ: Advise on a Business Scenario for Odoo 10 CE Multi-Company/Operations - Multi-Website

by
Axel Mendoza
- 05/03/2017 19:06:36
For me it will always more easily to do it all in the same database, distributed stuffs are very useful in several scenarios but in Odoo can be tricky. We have done some implementations that involve that kind of features but the synchronization and consolidation was not the primary target besides it was included too. We have used 2 approaches for get the goal: Sync and Async ways to handle remote data. The Sync one was using direclty an xmlrpclib wrapper module to code for the remote db like if it's there locally and maintaining remote odoo connections credentials. this sync approach was needed due to we use different odoo instance with different addons_path, if you have different odoo instances or the same but sharing the same addons_path then you could also use another technique that is to access the other databases like if they were locally by creating a env(pool) of that database and code like it where your local thread database also calling methods on models and doing any kind of crazy stuffs without the need of an xmlrpc connection. For the Async way to do stuffs, more automatically we used Rabbit MQ as a persistent message queue where we could keep data updated in any number of Odoo Instance/databases and also execute remote models and also by specifying the channels we could be able to choose where the changes or executions will be happening
But again if you think that you could cover all the features in the same database, the multi-website is not crazy at all in the odoo v10, it just will need son views/templates duplications for every website to allow each one to have their own, and also check and fix the theme installer to only affect the website views needed and allow it to install multiple themes by associating them with the target website or something. I don't see the problem with multi-pos since you could create multiple companies, warehouses, users to configure the point of sale specifically for every config and each user could also have it's own point of sale associated to restrict others to use it or something

Best Regards

On Wed, May 3, 2017 at 9:26 AM, Ermin Trevisan <trevi@twanda.com> wrote:

Thanks Gustavo

I'm still not able to decide on which direction I should go. But I'll revert to you if I go the multi-database way.

Best, trevi


On 02.05.2017 14:51, Gustavo Marino wrote:
Ermin:
We have developed a set of modules to implement a Master / Multi-Slave DB concept.

In this a scenario, one Odoo DB act as Master, interacting with one or several Remote DBs.

In the first use was to implement a Master / Multi-Slave POS system.
Master DB will push common data to all remotes (like products, pricelists, product categories, etc). Remote DB will send back POS orders, stock moves and invoices. Provided the right setup, the Master will get a consolidated view of all movements (stock, accounting), while the Remotes could work in a desconnected scenario, synching periodically to the master

The system is prepared as a general solution, that can be used in others scenarios. A couple of modules will setup the system for the POS. As a general rule, all configuration is made at master while slave will be automatically configured on first synch (almost without operator setup)

If you are interested, please get in touch for more details. We are looking for projects to help on funding
Best regards

Gustavo Adrian Marino

 

Mobile:  +54 911 5498 2515

Email: gamarino@numaes.com

Skype: gustavo.adrian.marino

 

Descripción: Numa
                        Logo V 1-0



2017-05-02 4:40 GMT-03:00 Ermin Trevisan <trevi@twanda.com>:

Thanks Jos for your valuable input.

The more I think about it, the more I like the idea of a setup running each operation on its own DB. Maybe based on Serpent's DB-Synchronization module it could be possible to develop a more and more sophisticated cross-DB consolidation, which would solve the multi-website issue by eliminating it.


On 02.05.2017 09:11, Jos De Graeve wrote:
Hello Ermin,

Doing a multi-website setup is quite tricky.  If you want to proceed with that option, you will need to assess if that is the right solution for you.

The advantage of a multi-website solution is that it runs on a single DB.  So if the maintenance of this DB is heavy ( creating / updating products, prices, customer records etc, reporting requirements ) then you might consider a multi-website odoo DB.

With multi-website there are a lot of constraints:
* it is not very stable ( i have seen strange issues with it on v10 ) - pages appearing on the wrong website etc.
* very hard to have each website its own theme ( ie- not possible without customization )
* website modules are not multi-website aware.  A lot of these issues can be solved with multi-company access rules, but that is not very easy.

regards,

Jos De Graeve - Apertoso business ICT


Guido Gezellelaan 16 - B-9800 Deinze - Belgium
 

2017-04-29 11:15 GMT+02:00 Ermin Trevisan <trevi@twanda.com>:

On 29.04.2017 11:05, Jordi Ballester Alomar wrote:
For POS I do not think that it would be a big deal. For website I am not sure. Would need to be analyzed.

But you have a good opportunity to have something nice and integrated here, using operating units.


I'm well aware of it and it would be my favorite approach, but I'm not at all sure about the website/domain issue and I definitely woud need atleast a ballpark figure about the expected cost.

-- 
twanda AG
Ermin Trevisan
Artherstrasse 19
CH-6318 Walchwil 
T    +41 41 758 1515
M    +41 79 208 7373
E    trevi@twanda.com 
www.twanda.ch
www.gastrosoftware.ch

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


-- 
twanda AG
Ermin Trevisan
Artherstrasse 19
CH-6318 Walchwil 
T    +41 41 758 1515
M    +41 79 208 7373
E    trevi@twanda.com 
www.twanda.ch
www.gastrosoftware.ch

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


-- 
twanda AG
Ermin Trevisan
Artherstrasse 19
CH-6318 Walchwil 
T    +41 41 758 1515
M    +41 79 208 7373
E    trevi@twanda.com 
www.twanda.ch
www.gastrosoftware.ch

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


Reference