Hi Jonathan, I am testing your code. When I place an order on satchmo a contact in openerp is created (yes!), but not the sale.order object (yet).
The first error message is : 2013-02-04 21:56:14,842 - openerplib.main.connection - Authenticated with user id 3 2013-02-04 21:56:14,842 - openerplib.main.object.sale.order - ({'shop_id': 1, 'fiscal_position': 6, 'name': '/', 'partner_shipping_id': 5, 'payment_term': 1, 'picking_policy': 'one', 'order_policy': 'prepaid', 'company_id': 1, 'state': 'draft', 'invoice_quantity': 'order', 'partner_invoice_id': 4, 'pricelist_id': 1, 'partner_id': 4},) 2013-02-04 21:56:14,842 - openerplib.main.service.object - method: 'execute_kw' 2013-02-04 21:56:14,842 - openerplib.main.service.object - args: ('cmoerp', 3, 'cmo', 'sale.order', 'create', ({'shop_id': 1, 'fiscal_position': 6, 'name': '/', 'partner_shipping_id': 5, 'payment_term': 1, 'picking_policy': 'one', 'order_policy': 'prepaid', 'company_id': 1, 'state': 'draft', 'invoice_quantity': 'order', 'partner_invoice_id': 4, 'pricelist_id': 1, 'partner_id': 4},), {}) 2013-02-04 21:56:14,850 - OESync - Sync failed -- Creation failed (improper data?): <Fault warning -- Integrity Error The operation cannot be completed, probably due to the following: - deletion: you may be trying to delete a record while other records still reference it - creation/update: a mandatory field is not correctly set Any idea how I can debug this sync failure? BTW, I have found this presentation http://fr.slideshare.net/openobject/openerp-how-to-connect-openerp-with-external-systems-akretionakretion-base-externalreferentialsopenerpdays about http://doc.openerp.com/v6.1/technical_guide/base_external_referentials.html It might be worth trying to use this, don't you think so? Regards, Le samedi 2 février 2013 17:39:04 UTC+1, Clément Moreau a écrit : > > Great. I will keep you posted with my progresses. > > > Clément Moreau > > > Le 2 févr. 2013 à 02:21, Jonathan Binas <jbi...@gmail.com <javascript:>> > a écrit : > > > I just added product_m2mcategories to the repo, so people don't have to > modify it themselves...: > https://github.com/jeame/satchmo-openerp > > > On Saturday, February 2, 2013 1:53:54 AM UTC+1, Jonathan Binas wrote: >> >> Hi Clément, >> >> It's not exactly obvious, especially because I got the name slightly >> wrong... >> In fact, the addon is called product_m2mcategories and can be found on >> launchpad: >> >> http://bazaar.launchpad.net/~openerp-commiter/openobject-addons/extra-6.0/files/head:/product_m2mcategories/ >> >> Unfortunately, the addon is made for OE version 6, while my connector has >> been tested with version 7, that's why you have to patch it... >> The addon simply allows you to have more than one category per product in >> OE. If you want to try without this feature (for testing purposes) you can >> simply delete the 'categ_ids' field in the mapping of the 'Product' model. >> In this case, only the product's primary category will be synced (and you >> don't need m2mcategories), which should be OK for testing. >> >> Hope this helps, >> Jonathan >> >> >> On Friday, February 1, 2013 10:41:37 PM UTC+1, Clément Moreau wrote: >>> >>> Hi, >>> >>> I am not able to find the "m2m_categories" addon for openerp that you >>> are mentioning in your documentation. Could you point me in the right >>> direction please? >>> Sorry if the answer is obvious. >>> >>> Regards >>> >>> >>> On Wednesday, January 30, 2013 11:31:31 PM UTC+1, Jonathan Binas wrote: >>>> >>>> >>>> Hi Clément, sounds great! >>>> >>>> I've just committed a first version of my OpenERP connector: >>>> https://github.com/jeame/satchmo-openerp >>>> >>>> This allows synchronization of arbitrary Satchmo models with OpenERP >>>> (by now, only Satchmo -> OpenERP) as well as automatic creation of orders, >>>> invoices and payments in OE. >>>> >>>> I'll start working on the OE -> Satchmo part soon.... >>>> >>>> Best, J >>>> >>>> >>>> >>>> On Tuesday, January 29, 2013 10:15:28 PM UTC+1, Clément Moreau wrote: >>>>> >>>>> Hi Jonathan >>>>> >>>>> I am also in this process, but right at the beginning (ie : the step >>>>> whose name is "be sure that you are not reinventing the wheel"). My >>>>> company >>>>> uses satchmo for a couple of years now. I implemented some erp features >>>>> inside (ie : clear separation between invoice and orders, delayed payment >>>>> tracking, etc etc), but we will need a proper erp to keep going sane. >>>>> I am sure we can contribute once we get in the stream. >>>>> >>>>> Regards, >>>>> >>>>> On Monday, January 21, 2013 10:55:42 AM UTC+1, Jonathan Binas wrote: >>>>>> >>>>>> >>>>>> I'm working on an OpenERP connector right now. Will upload a first >>>>>> version in the coming days... >>>>>> >>>>>> I am close to completing the Satchmo -> OE part, but haven't worked >>>>>> on the other direction yet. Mark, are you still interested in >>>>>> contributing >>>>>> to this? >>>>>> >>>>>> Cheers, J >>>>>> >>>>>> >>>>>> On Monday, August 6, 2012 11:50:59 AM UTC+2, Mark van Schijndel wrote: >>>>>>> >>>>>>> Dear all, >>>>>>> >>>>>>> This post is from some time back: >>>>>>> does anyone have some news on this? >>>>>>> I am very willing to contribute to building the OpenERP connector! >>>>>>> >>>>>>> best regards, >>>>>>> Mark >>>>>>> >>>>>>> On Thursday, December 15, 2011 5:03:43 AM UTC+1, Alec Taylor wrote: >>>>>>>> >>>>>>>> Good afternoon, >>>>>>>> >>>>>>>> What work has been done integrating ERP into satchmo? >>>>>>>> >>>>>>>> Specifically I am looking for the following features: >>>>>>>> - Supply chain management (incl. POS) >>>>>>>> - Customer relationship management >>>>>>>> >>>>>>>> The only thing I could find from Googling was Tryton integration >>>>>>>> (http://code.google.com/p/tryton-satchmo/ >>>>>>>> http://code.google.com/p/satchmo-tryton/). But the project looks >>>>>>>> odd, >>>>>>>> it seems that only one of the projects have code in them. >>>>>>>> >>>>>>>> Would I be better off building the aforementioned features from >>>>>>>> scratch; or is there something pre-built to work off? >>>>>>>> >>>>>>>> Thanks for all suggestions, >>>>>>>> >>>>>>>> Alec Taylor >>>>>>>> >>>>>>>> >>>>>>> On Thursday, December 15, 2011 5:03:43 AM UTC+1, Alec Taylor wrote: >>>>>>>> >>>>>>>> Good afternoon, >>>>>>>> >>>>>>>> What work has been done integrating ERP into satchmo? >>>>>>>> >>>>>>>> Specifically I am looking for the following features: >>>>>>>> - Supply chain management (incl. POS) >>>>>>>> - Customer relationship management >>>>>>>> >>>>>>>> The only thing I could find from Googling was Tryton integration >>>>>>>> (http://code.google.com/p/tryton-satchmo/ >>>>>>>> http://code.google.com/p/satchmo-tryton/). But the project looks >>>>>>>> odd, >>>>>>>> it seems that only one of the projects have code in them. >>>>>>>> >>>>>>>> Would I be better off building the aforementioned features from >>>>>>>> scratch; or is there something pre-built to work off? >>>>>>>> >>>>>>>> Thanks for all suggestions, >>>>>>>> >>>>>>>> Alec Taylor >>>>>>>> >>>>>>>> >>>>>>> On Thursday, December 15, 2011 5:03:43 AM UTC+1, Alec Taylor wrote: >>>>>>>> >>>>>>>> Good afternoon, >>>>>>>> >>>>>>>> What work has been done integrating ERP into satchmo? >>>>>>>> >>>>>>>> Specifically I am looking for the following features: >>>>>>>> - Supply chain management (incl. POS) >>>>>>>> - Customer relationship management >>>>>>>> >>>>>>>> The only thing I could find from Googling was Tryton integration >>>>>>>> (http://code.google.com/p/tryton-satchmo/ >>>>>>>> http://code.google.com/p/satchmo-tryton/). But the project looks >>>>>>>> odd, >>>>>>>> it seems that only one of the projects have code in them. >>>>>>>> >>>>>>>> Would I be better off building the aforementioned features from >>>>>>>> scratch; or is there something pre-built to work off? >>>>>>>> >>>>>>>> Thanks for all suggestions, >>>>>>>> >>>>>>>> Alec Taylor >>>>>>>> >>>>>>>> >>>>>>> On Thursday, December 15, 2011 5:03:43 AM UTC+1, Alec Taylor wrote: >>>>>>>> >>>>>>>> Good afternoon, >>>>>>>> >>>>>>>> What work has been done integrating ERP into satchmo? >>>>>>>> >>>>>>>> Specifically I am looking for the following features: >>>>>>>> - Supply chain management (incl. POS) >>>>>>>> - Customer relationship management >>>>>>>> >>>>>>>> The only thing I could find from Googling was Tryton integration >>>>>>>> (http://code.google.com/p/tryton-satchmo/ >>>>>>>> http://code.google.com/p/satchmo-tryton/). But the project looks >>>>>>>> odd, >>>>>>>> it seems that only one of the projects have code in them. >>>>>>>> >>>>>>>> Would I be better off building the aforementioned features from >>>>>>>> scratch; or is there something pre-built to work off? >>>>>>>> >>>>>>>> Thanks for all suggestions, >>>>>>>> >>>>>>>> Alec Taylor >>>>>>>> >>>>>>>> -- > You received this message because you are subscribed to the Google Groups > "Satchmo users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to satchmo-user...@googlegroups.com <javascript:>. > To post to this group, send email to satchm...@googlegroups.com<javascript:> > . > Visit this group at http://groups.google.com/group/satchmo-users?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To unsubscribe from this group and stop receiving emails from it, send an email to satchmo-users+unsubscr...@googlegroups.com. To post to this group, send email to satchmo-users@googlegroups.com. Visit this group at http://groups.google.com/group/satchmo-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.