This question has been flagged
1 Reply
4098 Views

I am trying to create a product.template. The product name contains accent marks from the source database I am importing from. These appear to be causing an issue. Has anyone else ran into this and what is the solution? No matter what I do I can't seem to fix this issue.  I even tried encoding it like row['product_nm'].encode('utf8').

Product Name Example:Super Café (Notice the accent e)

Traceback (most recent call last):

File "import_products.py", line 180, in <module>

template_id=sock.execute(dbname, uid,pwd, 'product.template','create',product_template)

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 1312, in single_request

response.msg,

xmlrpclib.ProtocolError: <ProtocolError for localhost:8069/xmlrpc/object: 500 INTERNAL SERVER ERROR>

Avatar
Discard
Author Best Answer

I believe I figured out my problem. The character was 8859 and needed to be decode and then encoded in utf8

product_name = product_name.decode('8859').encode('utf8'


Once this change was made it worked.

Avatar
Discard