How to sync frePPLe and Odoo products
Timo
https://youtu.be/XmbF7b34_sc shows how to run frePPLe from within Odoo.
Is there a way to automatically sync the configured production items in frePPLe to Odoo, or is this a manual task?
Either way, how is this done properly?
Timo
Johan De Taeye
Timo,
>>Is there a way to automatically sync the configured production items in frePPLe to Odoo, or is this a manual task?
>>Either way, how is this done properly?
The video is not up to date with the latest state of the connector.
The video shows the old-style connector running as a separate task.
The new-style connector is a part of the regular frePPLe planning process. It will communicate with the odoo instance as a “live data source” to get the data. In this way we are guaranteed that we use the latest data when planning. See: http://frepple.com/docs/2.4/extension-modules/odoo-connector.html
Regards,
Johan
Johan De Taeye +32 477.385.362 Skype jdetaeye | Visit us http://frepple.com Woluwestraat 17, 1930 Zaventem, Belgium |
|
--
You received this message because you are subscribed to the Google Groups "frePPLe users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to frepple-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Timo
is there anyone on in the group that is using this odoo integration actively in production? We use frePPLe daily in our production and would now like to integrate it into odoo.
I tried it using the advice below. The sync fails with an Error -1. The end of error log looks like follows after removing about 100 lines of "... already exists" lines before this.
-----------------------------
Error: Load of 'WAH/TR 12: Release kayak from moulds' and 'Worker 1' already exists
Error: Load of 'WAH/TR 12: Release kayak from moulds' and 'XX Wahoo deck mould' already exists
Error: Load of 'WAH/TR 12: Release kayak from moulds' and 'XX Wahoo hull mould' already exists
Error: Load of 'WAH/TR 13: 1st finish' and 'Worker 1' already exists
Error: Load of 'WAH/TR 14: Final finish' and 'Worker 2' already exists
Error: Load of 'WAH/TR 15: Quality check' and 'Worker 3' already exists
Loaded 1532 loads in 0.20 seconds
Importing operationplans...
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/usr/lib/python2.7/dist-packages/freppledb/odoo/commands.py", line 239, in <module>
loadData(database=db, filter="source is null or source<>'odoo'").run()
File "/usr/lib/python2.7/dist-packages/freppledb/execute/load.py", line 727, in run
self.loadOperationPlans()
File "/usr/lib/python2.7/dist-packages/freppledb/execute/load.py", line 656, in loadOperationPlans
).locked = i[5]
frepple.DataException: Operation '' doesn't exist
Error: Error executing Python command
--------------------
The documentation is very thin on syncing frePPLe and Odoo and trial and error is not the method I would like to use here. Anyone using this wonderful ability of joining Odoo and frePPLe?
br, Timo
Johan De Taeye
Timo,
The fact is that the connector will always require some level of adaption to the customer situation.
Odoo is (just as any other ERP system) always configured and tailored to the company’s business processes.
Similarly, a planning tool like frePPLe is also configured to the specific planning requirements of a company.
A connector between those is not feasible out-of-the-box.
Some degree is customization is to be expected. The standard connector provides a 80%-90% starting point only.
More specific to the messages below:
The errors about the duplicate loads are most likely innocent. It’s not clear to me what configuration in odoo could trigger these duplicates.
The fatal error at the end is on an open manufacturing order or purchase order with a blank name. Need to check in more detail how it ended up like that.
The best approach for debugging is to look at the XML data odoo sends to frePPLe, and then trace trouble data back to the records in odoo.
Regards,
Johan
Johan De Taeye +32 477.385.362 Skype jdetaeye | Visit us http://frepple.com Woluwestraat 17, 1930 Zaventem, Belgium |
|
From: freppl...@googlegroups.com [mailto:freppl...@googlegroups.com] On Behalf Of Timo
Sent: Thursday, July 16, 2015 9:35 AM
To: freppl...@googlegroups.com
Subject: Re: How to sync frePPLe and Odoo products
Hi,
From: freppl...@googlegroups.com [mailto:freppl...@googlegroups.com] On Behalf Of Timo
Sent: Monday, July 13, 2015 8:11 AM
To: freppl...@googlegroups.com
Subject: How to sync frePPLe and Odoo products
Hi,
https://youtu.be/XmbF7b34_sc shows how to run frePPLe from within Odoo.
Is there a way to automatically sync the configured production items in frePPLe to Odoo, or is this a manual task?
Either way, how is this done properly?
Timo--
You received this message because you are subscribed to the Google Groups "frePPLe users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to frepple-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.