c2c-oerpscenario team mailing list archive

[Peter Glock <617905@xxxxxxxxxxxxxxxxxx>]

no, that didn't fix it. Still getting same error:

[2010-11-24 20:04:55,906][splattest1] ERROR:db.cursor:bad query: insert into "product_template" (id,"supply_method","list_price","description","weight_net","standard_price","mes_type","uom_id","description_sale","cost_method","categ_id","name","uos_coeff","sale_delay","procure_method","sale_ok","purchase_ok","company_id","produce_delay","uom_po_id","rental","type",create_uid,create_date) values (5,E'buy',E'12.95',E'Ahoy there me hearties, do me bidding or I''ll run ya through wi'' my cutlass - sorry getting a bit carried away, maybe I shoudn''t watch Pirates of the Caribbean so often!  Anyway, this is a fab sword with a cut out bit for the handle, great with our skull and cross bones and parrot cutter.  Lovely big copper cutter 10cm x 17.5cm',0.1,E'0.00',E'fixed',1,E'Ahoy there me hearties. Lovely big copper cutter 10cm x 17.5cm',E'standard',NULL,E'Pirate Sword or Cutlass Big Copper Cookie Cutter',1.0,7.0,E'make_to_stock',E'True',E'True',1,1.0,1,E'False',E'consu',1,now())
Traceback (most recent call last):
  File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openerp-server/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "categ_id" violates not-null constraint

MODEL 29 38 categ_id

The product details downloads ok, it seems to choke on adding the
product into OpenERP itself.

I've checked the database, all products have at least one category, and
the category ids are being downloaded. Any ideas?

-- 
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()