Magento OpenERP Connector

Installation error openerp6.1-stable

Asked by Diego Madrigali

I get the following error when trying to install to openerp6.1 running on linux. I have all latest branches for ecommerce addons, oerp6.1stable, obenobject extension and product-extra-addons.

Any help?

Client Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 180, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1052, in call_button
    action = self.call_common(req, model, method, args, domain_id, context_id)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 996, in call_common
    return self._call_kw(req, model, method, args, {})
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1010, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 250, in proxy
    args, kw)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 608, in send
    raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

Server Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 593, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/module/module.py", line 361, in button_immediate_install
    db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/lib/pymodules/python2.7/openerp/pooler.py", line 39, in restart_pool
    registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
  File "/usr/lib/pymodules/python2.7/openerp/modules/registry.py", line 202, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 338, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 253, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 192, in load_module_graph
    load_update_xml(module_name, idref, mode)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 90, in <lambda>
    load_update_xml = lambda *args: _load_data(cr, *args, kind='update_xml')
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 132, in _load_data
    tools.convert_csv_import(cr, module_name, pathname, fp.read(), idref, mode, noupdate)
  File "/usr/lib/pymodules/python2.7/openerp/tools/convert.py", line 974, in convert_csv_import
    raise Exception(_('Module loading failed: file %s/%s could not be processed:\n %s') % (module, fname, warning_msg))
Exception: Module loading failed: file base_sale_multichannels/base_sale_multichannels/settings/sale.exception.csv could not be processed:
 Line 3 : null value in column "name" violates not-null constraint

Question information

Language:
English Edit question
Status:
Solved
For:
Magento OpenERP Connector Edit question
Assignee:
No assignee Edit question
Solved by:
Diego Madrigali
Solved:
Last query:
Last reply:
Revision history for this message
Diego Madrigali (burdo3417) said : 		#1

The first line in the sale.exception.csv is
id,name,description,sequence,model,code

Could it be because it should be with the ""?
"id","name","description","sequence","model","code"

Revision history for this message
nikko (nikkowang) said : 		#2

Not the first line problem.

Delete last line like "","","",7,""

this line contain null value of many column like "name" and cuase this error.

Revision history for this message
Diego Madrigali (burdo3417) said : 		#3

Well. Deleting that line completely worked for the install base on the very last branches.

I wonder if it is going to affect how something worked. Testing now. I'll let you asap.

Revision history for this message
Diego Madrigali (burdo3417) said : 		#4

Everything working. The only problem is:

I can import orders fine. If the order is invoiced and shipped (completed) it will still be unpaid and unshipped. Not a big issue, but when i try to confirm the order on OpenERP i get the following error:

  File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 863, in action_ship_create
    self._create_pickings_and_procurements(cr, uid, order, order.order_line, None, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 831, in _create_pickings_and_procurements
    move_id = move_obj.create(cr, uid, self._prepare_order_line_move(cr, uid, order, line, picking_id, date_planned, context=context))
  File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 728, in _prepare_order_line_move
    location_id = order.shop_id.warehouse_id.lot_stock_id.id
AttributeError: 'NoneType' object has no attribute 'id'

The stock level from Magento to OpenERP is not importing. But I think this is not an error. It's supposed to be this way.

Revision history for this message
nikko (nikkowang) said : 		#5

Regarding order.shop_id.warehouse_id.lot_stock_id.id problem, try to set warehouse of the magento shop.

Revision history for this message
Diego Madrigali (burdo3417) said : 		#6

That worked

Revision history for this message
El Hadji Dem (http://www.savoirfairelinux.com) (eh-dem) said : 		#7

Hello , I got this error message when I try to export product from OpenErp 6.1 :

Traceback (most recent call last):
  File "/opt/openerp/openerp-6.1-1/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/openerp-6.1-1/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_sale_export_product/wizard/export_product.py", line 77, in export_product
    return self.export(cr, uid, id, ['export_product'], context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_sale_export_product/wizard/export_product.py", line 73, in export
    self._export_one_product(cr, uid, external_session, product_id, options, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/product_links_sync/product.py", line 128, in _export_one_product
    res = super(product_export_wizard, self)._export_one_product(cr, uid, external_session, product_id, options, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_sale_export_product/wizard/export_product.py", line 40, in _export_one_product
    product_obj._export_one_resource(cr, uid, external_session, product_id, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/external_osv.py", line 1129, in _export_one_resource
    False, mapping, mapping_id, defaults=defaults, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/decorator.py", line 49, in wrapped
    return func(self, cr, uid, argument, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/decorator.py", line 110, in wrapper
    return func(self, cr, uid, external_session, resource, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/magerp_osv.py", line 47, in _transform_and_send_one_resource
    return self.mag_transform_and_send_one_resource(cr, uid, external_session, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/external_osv.py", line 1110, in _transform_and_send_one_resource
    return self.send_to_external(cr, uid, external_session, {resource_id : resource}, mapping, mapping_id, update_date, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/product.py", line 1067, in send_to_external
    self.export_inventory(cr, uid, external_session, product_ids, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/product.py", line 1436, in export_inventory
    self._export_inventory(cr, uid, external_session, product_id, context=location_ctx)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/decorator.py", line 110, in wrapper
    return func(self, cr, uid, external_session, resource, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/product.py", line 1452, in _export_inventory
    [mag_product_id, inventory_vals])
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/magerp_osv.py", line 223, in call
    res = self.ser.call(self.session, method, arguments)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
    return self.single_request(host, handler, request_body, verbose)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
    return self.parse_response(response)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
    return u.close()
  File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
    raise Fault(**self._stack[0])
Fault: <Fault 3: 'Invalid api path.'>

Have you any idea ??????

Revision history for this message
André Savi (contato-p) said : 		#8

@eh.dem (eh-dem) , probably this is an Magento side error.

Try to install the Magento Path, https://code.launchpad.net/~magentoerpconnect-core-editors/magentoerpconnect/module-magento-trunk

Good luck!!!

Revision history for this message
Gestion-Ressources (mareeting) said : 		#9

Thanks André Savi (contato-p) , finally I resolved this issue