c2c-oerpscenario team mailing list archive

[OCL <620483@xxxxxxxxxxxxxxxxxx>]

Hello Guewen

I have the same problem, you already know how to fix it

-- 
Import Orders function : 'NoneType' object has no attribute 'translate' 
https://bugs.launchpad.net/bugs/620483
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP OpenObject.

Status in Magento Open ERP Connector: New

Bug description:
Hello,

I have done an installation of Open ERP 5.0 stable with Magento 1.4.1.1.
I have installed the connector on magento with Magento Connect (version 1.3.1 (beta)).
I have installed the last OpenERP addon from bazaar (revision 338).
I have configured the magento instance into OpenERP imported the referentials and exported the catalog.

I have created a client on the magento website and have ordered a product.

Now, in OpenERP if I go to : Magento-connection > Core Settings > Magento Shops and I click on "Import Orders", I get the following error : AttributeError: 'NoneType' object has no attribute 'translate'

data_record['customer_taxvat'] contains "None", do you know why ?

Here is the stack
[2010-08-19 16:59:30,882] ERROR:web-services:[01]: 
[2010-08-19 16:59:30,885] ERROR:web-services:[02]: Environment Information : 
[2010-08-19 16:59:30,886] ERROR:web-services:[03]: System : Linux-2.6.26-2-686-i686-with-debian-5.0.5
[2010-08-19 16:59:30,887] ERROR:web-services:[04]: OS Name : posix
[2010-08-19 16:59:30,888] ERROR:web-services:[05]: Operating System Release : 2.6.26-2-686
[2010-08-19 16:59:30,889] ERROR:web-services:[06]: Operating System Version : #1 SMP Mon Jun 21 05:58:44 UTC 2010
[2010-08-19 16:59:30,890] ERROR:web-services:[07]: Operating System Architecture : 32bit
[2010-08-19 16:59:30,891] ERROR:web-services:[08]: Operating System Locale : en_US.UTF8
[2010-08-19 16:59:30,892] ERROR:web-services:[09]: Python Version : 2.5.2
[2010-08-19 16:59:30,893] ERROR:web-services:[10]: OpenERP-Server Version : 5.0.12
[2010-08-19 16:59:30,894] ERROR:web-services:[11]: Last revision No. & ID : 
[2010-08-19 16:59:30,894] ERROR:web-services:[12]: Traceback (most recent call last):
[2010-08-19 16:59:30,895] ERROR:web-services:[13]:   File "/srv/openerp/instances/stable_lp/server/bin/osv/osv.py", line 58, in wrapper
[2010-08-19 16:59:30,896] ERROR:web-services:[14]:     return f(self, dbname, *args, **kwargs)
[2010-08-19 16:59:30,897] ERROR:web-services:[15]:   File "/srv/openerp/instances/stable_lp/server/bin/osv/osv.py", line 119, in execute
[2010-08-19 16:59:30,898] ERROR:web-services:[16]:     res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
[2010-08-19 16:59:30,899] ERROR:web-services:[17]:   File "/srv/openerp/instances/stable_lp/server/bin/osv/osv.py", line 111, in execute_cr
[2010-08-19 16:59:30,900] ERROR:web-services:[18]:     return getattr(object, method)(cr, uid, *args, **kw)
[2010-08-19 16:59:30,901] ERROR:web-services:[19]:   File "/srv/openerp/instances/stable_lp/server/bin/addons/base_sale_multichannels/sale.py", line 216, in import_orders
[2010-08-19 16:59:30,902] ERROR:web-services:[20]:     self.import_shop_orders(cr, uid, shop, defaults, ctx)
[2010-08-19 16:59:30,903] ERROR:web-services:[21]:   File "/srv/openerp/instances/stable_lp/server/bin/addons/magentoerpconnect/sale.py", line 113, in import_shop_orders
[2010-08-19 16:59:30,904] ERROR:web-services:[22]:     'ids_or_filter':ids_or_filter
[2010-08-19 16:59:30,904] ERROR:web-services:[23]:   File "/srv/openerp/instances/stable_lp/server/bin/addons/magentoerpconnect/magerp_osv.py", line 232, in mage_import_base
[2010-08-19 16:59:30,906] ERROR:web-services:[24]:     rec_result = self.ext_import(cr, uid, rec_data, external_referential_id, defaults, context)
[2010-08-19 16:59:30,907] ERROR:web-services:[25]:   File "/srv/openerp/instances/stable_lp/server/bin/addons/base_external_referentials/external_osv.py", line 167, in ext_import
[2010-08-19 16:59:30,908] ERROR:web-services:[26]:     vals = self.oevals_from_extdata(cr, uid, external_referential_id, each_row, for_key_field, mapping_lines, defaults, context)
[2010-08-19 16:59:30,908] ERROR:web-services:[27]:   File "/srv/openerp/instances/stable_lp/server/bin/addons/magentoerpconnect/sale.py", line 360, in oevals_from_extdata
[2010-08-19 16:59:30,909] ERROR:web-services:[28]:     res = self.get_order_addresses(cr, uid, res, external_referential_id, data_record, key_field, mapping_lines, defaults, context)
[2010-08-19 16:59:30,910] ERROR:web-services:[29]:   File "/srv/openerp/instances/stable_lp/server/bin/addons/magentoerpconnect/sale.py", line 300, in get_order_addresses
[2010-08-19 16:59:30,911] ERROR:web-services:[30]:     vat = data_record['customer_taxvat'].translate(allchars, delchars).upper()
[2010-08-19 16:59:30,911] ERROR:web-services:[31]: AttributeError: 'NoneType' object has no attribute 'translate'

Thank you

Regards
Guewen