c2c-oerpscenario team mailing list archive

[Raphaël Valyi - http://www.akretion.com <617905@xxxxxxxxxxxxxxxxxx>]

Kyle,

may be it's because your initial sale order list is too large to be
downloaded. We have a customer with around 10 000 sale orders. Given the
Magento API crap I described, the connector is unable to download the list
of all sale orders (because Magento API does a "read" instead, the
bastard!). So what we do, is we tweak the connector to make the initial
import, we use to edit the magentoerpconnect/sale.py and tweak the filter
around line 102 in order to download orders say 500 by 500 instead.

Notice that after the initial import is done, there isn't such a problem
because only new orders since the last one imported will be downloaded.
Does this helps you?

Raphaël Valyi


On Tue, Nov 9, 2010 at 4:27 PM, Kyle Waid <617905@xxxxxxxxxxxxxxxxxx> wrote:

> [2010-11-09 12:24:32,304][openerp] ERROR:web-services:[22]:
> listinvoices = server.call(session,
> 'sales_order_invoice.list',[{'entity_id': {'gt':
> magento_params[0].last_invoice_id}}])
> [2010-11-09 12:24:32,305][openerp] ERROR:web-services:[23]:   File
> "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
> [2010-11-09 12:24:32,306][openerp] ERROR:web-services:[24]:     return
> self.__send(self.__name, args)
> [2010-11-09 12:24:32,306][openerp] ERROR:web-services:[25]:   File
> "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
> [2010-11-09 12:24:32,306][openerp] ERROR:web-services:[26]:
> verbose=self.__verbose
> [2010-11-09 12:24:32,306][openerp] ERROR:web-services:[27]:   File
> "/usr/lib/python2.6/xmlrpclib.py", line 1243, in request
> [2010-11-09 12:24:32,307][openerp] ERROR:web-services:[28]:     headers
> [2010-11-09 12:24:32,307][openerp] ERROR:web-services:[29]: ProtocolError:
> <ProtocolError for 192.168.1.34/index.php/api/xmlrpc/?wsdl: 408 Request
> Time-out>
>
> --
> Product Import fails
> https://bugs.launchpad.net/bugs/617905
> You received this bug notification because you are subscribed to Magento
> Open ERP Connector.
>
> Status in Magento Open ERP Connector: Invalid
>
> Bug description:
> I'm using current stable (5.0.12) on an Amazon EC2 ubuntu 10.4 instance. I
> have installed and configured the openerpconnect module ok and the
> corresponding magento module.
>
> In OpenERP, clicking on the referential actions in turn (1 - Import
> Customer Groups through to 5 - Import Product Attributes) works fine but
> when I click on 6 - Import products I get the following error. We have
> approx 2000 products, is this a timeout problem, or something else?
>
> Traceback (most recent call last):
>  File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py",
> line 247, in dispatch
>    result = LocalService(service_name)(method, *params)
>  File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py",
> line 76, in __call__
>    return getattr(self, method)(*params)
>  File
> "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py",
> line 577, in execute
>    res = service.execute(db, uid, object, method, *args)
>  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py",
> line 58, in wrapper
>    return f(self, dbname, *args, **kwargs)
>  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py",
> line 119, in execute
>    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
>  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py",
> line 111, in execute_cr
>    return getattr(object, method)(cr, uid, *args, **kw)
>  File
> "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_core.py",
> line 137, in sync_products
>    list_prods = attr_conn.call('catalog_product.list')
>  File
> "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_osv.py",
> line 53, in call
>    res = self.ser.call(self.session, method, arguments)
>  File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
>    return self.__send(self.__name, args)
>  File "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
>    verbose=self.__verbose
>  File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
>    return self._parse_response(h.getfile(), sock)
>  File "/usr/lib/python2.6/xmlrpclib.py", line 1392, in _parse_response
>    return u.close()
>  File "/usr/lib/python2.6/xmlrpclib.py", line 836, in close
>    raise ResponseError()
> ResponseError: ResponseError()
>
>
>

-- 
Product Import fails
https://bugs.launchpad.net/bugs/617905
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in Magento Open ERP Connector: Invalid

Bug description:
I'm using current stable (5.0.12) on an Amazon EC2 ubuntu 10.4 instance. I have installed and configured the openerpconnect module ok and the corresponding magento module.

In OpenERP, clicking on the referential actions in turn (1 - Import Customer Groups through to 5 - Import Product Attributes) works fine but when I click on 6 - Import products I get the following error. We have approx 2000 products, is this a timeout problem, or something else?

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 247, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 577, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_core.py", line 137, in sync_products
    list_prods = attr_conn.call('catalog_product.list')
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_osv.py", line 53, in call
    res = self.ser.call(self.session, method, arguments)
  File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
    return self._parse_response(h.getfile(), sock)
  File "/usr/lib/python2.6/xmlrpclib.py", line 1392, in _parse_response
    return u.close()
  File "/usr/lib/python2.6/xmlrpclib.py", line 836, in close
    raise ResponseError()
ResponseError: ResponseError()