[6.1] VAT mapping error - with Customer import and Sales Order import

[Vincent Bersier]

Hi,

OpenERP 6.1, Prestashop Connector rev 113,

Import of Customer brings the following error:

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/prestashoperpconnect/external_referential.py", line 223, in import_customers
    self.import_resources(cr, uid, ids, 'res.partner.address', context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 559, in import_resources
    res = self.pool.get(resource_name)._import_resources(cr, uid, external_session, defaults, method=method, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 597, in _import_resources
    res = self._record_external_resources(cr, uid, external_session, resources, defaults=defaults, mapping=mapping, mapping_id=mapping_id, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 676, in _record_external_resources
    res = self._record_one_external_resource(cr, uid, external_session, resource, defaults=defaults, mapping=mapping, mapping_id=mapping_id, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/decorator.py", line 49, in wrapped
    return func(self, cr, uid, argument, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/addons/prestashoperpconnect/prestashop_osv.py", line 206, in _record_one_external_resource
    resource, defaults=defaults, mapping=mapping, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 698, in _record_one_external_resource
    vals = self._transform_one_resource(cr, uid, external_session, 'from_external_to_openerp', resource, mapping=mapping, mapping_id=mapping_id, defaults=defaults, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base_sale_multichannels/partner.py", line 52, in _transform_one_resource
    return super(res_partner_address, self)._transform_one_resource(*args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 1413, in _transform_one_resource
    raise MappingError(e, mapping_line['name'], self._name)
MappingError: the mapping line: VAT for the object res.partner.address has this error: exec: arg 1 must be a string, file, or code object

Import of sales order brings the following error:

(u'Error with the mapping : VAT. Error details : exec: arg 1 must be a string, file, or code object',)

<class 'openerp.addons.base_external_referentials.message_error.MappingError'>
Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/decorator.py", line 130, in wrapper response = func(self, import_cr, uid, external_session, resource, *args, **kwargs) File "/usr/lib/pymodules/python2.7/openerp/addons/base_sale_multichannels/sale.py", line 591, in _record_one_external_resource defaults=defaults, mapping=mapping, mapping_id=mapping_id, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/decorator.py", line 49, in wrapped return func(self, cr, uid, argument, *args, **kwargs) File "/usr/lib/pymodules/python2.7/openerp/addons/prestashoperpconnect/prestashop_osv.py", line 206, in _record_one_external_resource resource, defaults=defaults, mapping=mapping, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 698, in _record_one_external_resource vals = self._transform_one_resource(cr, uid, external_session, 'from_external_to_openerp', resource, mapping=mapping, mapping_id=mapping_id, defaults=defaults, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 1381, in _transform_one_resource context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 1471, in _transform_field return related_obj.get_or_create_oeid(cr, uid, external_session, field_value, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 359, in get_or_create_oeid return self._import_one_resource(cr, uid, external_session, external_id, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 647, in _import_one_resource res = self._record_external_resources(cr, uid, external_session, resources, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 676, in _record_external_resources res = self._record_one_external_resource(cr, uid, external_session, resource, defaults=defaults, mapping=mapping, mapping_id=mapping_id, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/decorator.py", line 49, in wrapped return func(self, cr, uid, argument, *args, **kwargs) File "/usr/lib/pymodules/python2.7/openerp/addons/prestashoperpconnect/prestashop_osv.py", line 206, in _record_one_external_resource resource, defaults=defaults, mapping=mapping, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 698, in _record_one_external_resource vals = self._transform_one_resource(cr, uid, external_session, 'from_external_to_openerp', resource, mapping=mapping, mapping_id=mapping_id, defaults=defaults, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base_sale_multichannels/partner.py", line 52, in _transform_one_resource return super(res_partner_address, self)._transform_one_resource(*args, **kwargs) File "/usr/lib/pymodules/python2.7/openerp/addons/base_external_referentials/external_osv.py", line 1413, in _transform_one_resource raise MappingError(e, mapping_line['name'], self._name)

MappingError: the mapping line: VAT for the object res.partner.address has this error: exec: arg 1 must be a string, file, or code object

Thanks

[Caner Candan (canercandan)]

Got the same issue.

[Alexis de Lattre (alexis-via)]

In the current code :

prestashoperpconnect/settings/1.5.0.0/res.partner.address/external.mappinglines.template.csv

The mapping for VAT is a "function" mapping, "out" only. So it should not raise issues with importing customers... but I guess we should update this to import the VAT number. The difficulty is that, in OpenERP, the VAT number is on the "customer" object, where as in PrestaShop it is on the "address" object.