Import products during initial setup

Asked by Shaun at hejhog on 2012-04-06

Hello,

I am currently testing the following

OpenERP 6.1 (local server - Ubuntu 10.04LTS )
Magento 1.6.2 (hosted)

Openlabs_OpenERPConnector 1.3.1 (beta) (Web Service Role created and Resources set to All)
magentoerpconnect 6.1.1.0 + dependancies

Additionally Installed Accounting, Warehouse, Sales, Purchase, UK accounts for basic setup.

All installed fine.

During OpenERPConnector set up followed the steps below.

1. Reload referential map settings - No Errors
2. Synchronize Referential settings - No Errors

1) import Customer Groups - Connects and Imports with No Errors
2) import product categories - Connects and Imports with No Errors
3) import product attributes sets - Connects and Imports with No Errors
4) import attribute groups - Connects and Imports with No Errors
5) import product attributes - Connects and Imports with No Errors

All is fine until
6) import products
I then receive the following error:

Client Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/common/http.py", line 180, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1004, in call_button
    action = self.call_common(req, model, method, args, domain_id, context_id)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 948, in call_common
    return self._call_kw(req, model, method, args, {})
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 962, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/opt/openerp/server/openerp/addons/web/common/openerplib/main.py", line 250, in proxy
    args, kw)
  File "/opt/openerp/server/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/opt/openerp/server/openerp/addons/web/common/http.py", line 611, in send
    raise fault

Server Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/common/http.py", line 592, in send
    result = openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 360, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 572, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/server/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/openerp/addons/magentoerpconnect/magerp_core.py", line 217, in sync_products
    ext_product_ids = attr_conn.call('ol_catalog_product.search', filter)
  File "/opt/openerp/server/openerp/addons/magentoerpconnect/magerp_osv.py", line 83, 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 838, in close
    raise Fault(**self._stack[0])
Fault: <Fault 3: 'Invalid api path.'>

Can anyone help??

Many Thanks,
Shaun

Question information

Language:
English Edit question
Status:
Solved
For:
Magento OpenERP Connector Edit question
Assignee:
No assignee Edit question
Solved by:
Josef Tesar
Solved:
2012-04-18
Last query:
2012-04-18
Last reply:
2012-04-16
Shaun at hejhog (shau7) said : #1

Hello,

Have tried on 3 separate installs and all have the error in previous post.

Magento instances
1. Reload referential map settings - No Errors
2. Synchronize Referential settings - No Errors

1) import Customer Groups - Connects and Imports with No Errors
2) import product categories - Connects and Imports with No Errors
3) import product attributes sets - Connects and Imports with No Errors
4) import attribute groups - Connects and Imports with No Errors
5) import product attributes - Connects and Imports with No Errors

6)import products - Error as in previous post *****************************************

7)import images - Connects and Imports with No Errors
8)import Product Links - Connects and Imports with No Errors

Magento Shops view
Export Catalogue - Connects and Exports with No Errors

Export Stock Levels Only - Intermittent
If creating a product within openerp and then uploading to Magento it does not update stock. However will update after the stock levels have been altered in Openerp. However , from the Product edit page the Export Stock and Levels works fine.

Export Images - Connects and Exports with No Errors

Import Orders - Error similar to previous post. **********************************

Update Order Status - Not tested as cannot import orders.
Export Shipping - ???????

Update Partners - Reports no errors - but does not export or Import and customers ??

As I have tried on 3 separate installs, is the error caused by the Magento Module being out of date for version 1.62 ?????

Are there any updates recommended???

Many Thanks,
Shaun

Josef Tesar (tesar-j) said : #2

Pleas Help und repair the connector or please post help.

Shaun at hejhog (shau7) said : #3

Is there anyone with any pointers on this???

Josef Tesar (tesar-j) said : #4

Solution: Deaktivate the Compiler in Magento-Shop and recompile the Compiler-Files. This help me an my Connector is ready for Product import and export.

Shaun at hejhog (shau7) said : #5

Hello Josef,

Thank you for your reply.

Compiler was already deactivated.

Recompiled as suggested.

Unfortunately still received the error as above - with compiler active and then disabled.

Many Thanks,
Shaun

Best Josef Tesar (tesar-j) said : #6

Load the Modules (my Modules from my Openerp 6.1) from http://www.satprofi.at/openerp ... this Modules for Openerp 6.1 (Linux-Server) and Magento 1.6.2. Incl. Connector (Connector_fuer_Magento.zip) for Shopsstem Magento 1.6.2.

Shaun at hejhog (shau7) said : #7

Hello Josef,

Thank you very much for your assistance.

The Connector_fuer_Magento.zip file solved the problem.

I have not yet updated the Openerp modules and am using the download from the trunk.

Are the files in your magentoerp.zip file updated in any way?

Many Thanks,

Shaun

Shaun at hejhog (shau7) said : #8

Thanks Josef Tesar, that solved my question.

Josef Tesar (tesar-j) said : #9

I have loaded as they are, but I can not remember where exactly.