Earlier this year

• Nov 03, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) commented on by italolofino   -   Hello this happen to me and delete all the category. Data/Tree/Dbp.php on line 315. I hope there is a solution.Thank you

  Hello this happen to me and delete all the category. Data/Tree/Dbp.php on line 315. I hope there is a solution.Thank you
• Nov 01, 2009

  issue 51 ( <Fault 2:'Access deniend'>) commented on by bogdan.hurezeanu   -   no one ?

  no one ?
• Oct 31, 2009

  issue 51 ( <Fault 2:'Access deniend'>) reported by bogdan.hurezeanu   -   What steps will reproduce the problem? 1. install magento 2. install openerp 3. install module What is the expected output? What do you see instead? Magento returned <Fault 2:'Access deniend'> What version of the product are you using? On what operating system? Windows Xp v5.0.6 Please provide any additional information below. -

  What steps will reproduce the problem? 1. install magento 2. install openerp 3. install module What is the expected output? What do you see instead? Magento returned <Fault 2:'Access deniend'> What version of the product are you using? On what operating system? Windows Xp v5.0.6 Please provide any additional information below. -
• Oct 02, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) commented on by sanderspedro   -   That's happen becouse you delete a category(or product) in OpenERP and then try to sinchronize this categories or products that no exist any more(is suppose to be automaticaly :s). To workaraound it, just set to empty magento_id in product_product and product_category tables. Sorry for my english :s El problema ocurre cuando OpenERP intenta sincronizar un producto/categoría que ya no existe en Magento(por que fue eliminado sólo en Magento).Una forma rápida de solucionar eso seria: ir directo a la base de datos y dejar vacíos el campo magento_id en las tablas product_product y product_category.

  That's happen becouse you delete a category(or product) in OpenERP and then try to sinchronize this categories or products that no exist any more(is suppose to be automaticaly :s). To workaraound it, just set to empty magento_id in product_product and product_category tables. Sorry for my english :s El problema ocurre cuando OpenERP intenta sincronizar un producto/categoría que ya no existe en Magento(por que fue eliminado sólo en Magento).Una forma rápida de solucionar eso seria: ir directo a la base de datos y dejar vacíos el campo magento_id en las tablas product_product y product_category.
• Sep 02, 2009

  issue 50 (Error with customer no registered) reported by freeridedatch   -   When you do a buy with a magento user twice, that is not registered, and you import the order in the openerp , it displays this: Traceback (most recent call last): File "/usr/lib/openerp-server/netsvc.py", line 231, in dispatch result = LocalService(service_name)(method, *params) File "/usr/lib/openerp-server/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/usr/lib/openerp-server/service/web_services.py", line 552, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/usr/lib/openerp-server/service/web_services.py", line 532, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/usr/lib/openerp-server/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/usr/lib/openerp-server/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/usr/lib/openerp-server/addons/magento_openerp_synchro.zip/magento_openerp_synchro/wizard/magento_so_import.py", line 129, in _do_import 'magento_id': so['customer']['customer_id'], File "/usr/lib/openerp-server/osv/orm.py", line 2446, in create cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2)) File "/usr/lib/openerp-server/sql_db.py", line 76, in wrapper return f(self, *args, **kwargs) File "/usr/lib/openerp-server/sql_db.py", line 118, in execute res = self._obj.execute(query, params) IntegrityError: duplicate key value violates unique constraint "res_partner_name_uniq" This error is because the program identify with the same costumer id the second invite magento user!! Anybody Knows how can I solve it? I don't know!

  When you do a buy with a magento user twice, that is not registered, and you import the order in the openerp , it displays this: Traceback (most recent call last): File "/usr/lib/openerp-server/netsvc.py", line 231, in dispatch result = LocalService(service_name)(method, *params) File "/usr/lib/openerp-server/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/usr/lib/openerp-server/service/web_services.py", line 552, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/usr/lib/openerp-server/service/web_services.py", line 532, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/usr/lib/openerp-server/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/usr/lib/openerp-server/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/usr/lib/openerp-server/addons/magento_openerp_synchro.zip/magento_openerp_synchro/wizard/magento_so_import.py", line 129, in _do_import 'magento_id': so['customer']['customer_id'], File "/usr/lib/openerp-server/osv/orm.py", line 2446, in create cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2)) File "/usr/lib/openerp-server/sql_db.py", line 76, in wrapper return f(self, *args, **kwargs) File "/usr/lib/openerp-server/sql_db.py", line 118, in execute res = self._obj.execute(query, params) IntegrityError: duplicate key value violates unique constraint "res_partner_name_uniq" This error is because the program identify with the same costumer id the second invite magento user!! Anybody Knows how can I solve it? I don't know!
• Aug 31, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) commented on by paco.j.navarrete   -   You can't export more than 2 levels of categories The rest dissapear.

  You can't export more than 2 levels of categories The rest dissapear.
• Aug 28, 2009

  GettingStartedWithOpenERPDev (You might be coming to OpenERP from Magento, so you might wo...) Wiki page commented on by dongavipul   -   Hi, i got same comment as jpbarba. but my server and desktop and web client is running successfully. bu i want to debug the "openerp-server.py file" in windows (Operating system). bu i got the error. So please give some solution how to debug the openerp-server.py file. if you want any other detail please ask me on this email id : vipul@cybercomcreation.com. i am waiting for replay.

  Hi, i got same comment as jpbarba. but my server and desktop and web client is running successfully. bu i want to debug the "openerp-server.py file" in windows (Operating system). bu i got the error. So please give some solution how to debug the openerp-server.py file. if you want any other detail please ask me on this email id : vipul@cybercomcreation.com. i am waiting for replay.
• Aug 28, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) commented on by paco.j.navarrete   -   Finally, we got WHY (not how to fix): Looks like when we create new categories in openerp and do the export, something rewrites the magento category id, and only a few appear as new categories and the rest are treated as ''updated'' (overwrited). It seems to there is an 'autoincremental' problem.

  Finally, we got WHY (not how to fix): Looks like when we create new categories in openerp and do the export, something rewrites the magento category id, and only a few appear as new categories and the rest are treated as ''updated'' (overwrited). It seems to there is an 'autoincremental' problem.
• Aug 28, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) commented on by paco.j.navarrete   -   OpenERP doesn't give error reinstalling, but in magento, when went to admin menu for manage categories: Fatal error: Call to a member function getId() on a non-object in /opt/www_data/shop_venyashop_magento/lib/Varien/Data/Tree/Dbp.php on line 315

  OpenERP doesn't give error reinstalling, but in magento, when went to admin menu for manage categories: Fatal error: Call to a member function getId() on a non-object in /opt/www_data/shop_venyashop_magento/lib/Varien/Data/Tree/Dbp.php on line 315
• Aug 28, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) commented on by paco.j.navarrete   -   Reinstalling magento exports well (doing the classic 0.9.9 patches to magento_export_categories.py). ¿?

  Reinstalling magento exports well (doing the classic 0.9.9 patches to magento_export_categories.py). ¿?
• Aug 28, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) commented on by paco.j.navarrete   -   In the Wiki FAQ says: you should log the detailed error message, so change temporarily your xmlrpc.py library file, in def parse_response(self, file, sock): (close to line 1321), add a print response statement so you get: while 1: if sock: response = sock.recv(1024) else: response = file.read(1024) print response But the file only has around 400 lines.

  In the Wiki FAQ says: you should log the detailed error message, so change temporarily your xmlrpc.py library file, in def parse_response(self, file, sock): (close to line 1321), add a print response statement so you get: while 1: if sock: response = sock.recv(1024) else: response = file.read(1024) print response But the file only has around 400 lines.
• Aug 27, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) commented on by paco.j.navarrete   -   This is an High priority i think, because it corrupts database. Apologies for putting it as medium.

  This is an High priority i think, because it corrupts database. Apologies for putting it as medium.
• Aug 27, 2009

  issue 49 (An error occured : junk after document element: line 2, colu...) reported by paco.j.navarrete   -   What steps will reproduce the problem? 1. Sync categories 2. Returns An error occured : junk after document element: line 2, column 0 What is the expected output? What do you see instead? Expected new categories in magento An error occured : junk after document element: line 2, column 0 Then, in magento, when went to admin menu for manage categories: Fatal error: Call to a member function getId() on a non-object in /opt/www_data/shop_venyashop_magento/lib/Varien/Data/Tree/Dbp.php on line 315 Maybe corrupted database. What version of the product are you using? On what operating system? Latest/Latest Please provide any additional information below. Openerp log: [2009-08-28 00:24:42,521] INFO:Magento Export:Successfully updated category with OpenERP id 4 and Magento id 19 [2009-08-28 00:24:42,951] INFO:Magento Export:Successfully created category with OpenERP id 49 and Magento id 48 [2009-08-28 00:24:43,393] INFO:Magento Export:Successfully created category with OpenERP id 5 and Magento id 49 [2009-08-28 00:24:43,763] INFO:Magento Export:Successfully created category with OpenERP id 6 and Magento id 50 [2009-08-28 00:24:45,429] INFO:Magento Export:Successfully created category with OpenERP id 31 and Magento id 51 [2009-08-28 00:24:46,025] INFO:Magento Export:Successfully created category with OpenERP id 37 and Magento id 52 [2009-08-28 00:24:46,492] INFO:Magento Export:Successfully updated category with OpenERP id 43 and Magento id 22 [2009-08-28 00:24:46,845] INFO:Magento Export:Successfully updated category with OpenERP id 1 and Magento id 9 [2009-08-28 00:24:47,296] INFO:Magento Export:Successfully created category with OpenERP id 7 and Magento id 53 [2009-08-28 00:24:47,664] INFO:Magento Export:Successfully created category with OpenERP id 9 and Magento id 54 [2009-08-28 00:24:48,144] INFO:Magento Export:Successfully created category with OpenERP id 10 and Magento id 55 [2009-08-28 00:24:48,529] INFO:Magento Export:Successfully created category with OpenERP id 11 and Magento id 56 [2009-08-28 00:24:48,889] INFO:Magento Export:Successfully created category with OpenERP id 12 and Magento id 57 [2009-08-28 00:24:49,314] INFO:Magento Export:Successfully created category with OpenERP id 13 and Magento id 58 [2009-08-28 00:24:49,675] INFO:Magento Export:Successfully created category with OpenERP id 14 and Magento id 59 [2009-08-28 00:24:50,111] INFO:Magento Export:Successfully created category with OpenERP id 15 and Magento id 60 [2009-08-28 00:24:50,482] INFO:Magento Export:Successfully created category with OpenERP id 16 and Magento id 61 [2009-08-28 00:24:50,834] INFO:Magento Export:Successfully updated category with OpenERP id 17 and Magento id 20 [2009-08-28 00:24:51,262] INFO:Magento Export:Successfully created category with OpenERP id 18 and Magento id 62 [2009-08-28 00:24:56,623] INFO:Magento Export:Successfully created category with OpenERP id 20 and Magento id 63 [2009-08-28 00:24:56,972] INFO:Magento Export:Successfully created category with OpenERP id 21 and Magento id 64 [2009-08-28 00:24:57,431] INFO:Magento Export:Successfully created category with OpenERP id 22 and Magento id 65 [2009-08-28 00:24:57,788] INFO:Magento Export:Successfully updated category with OpenERP id 19 and Magento id 21 [2009-08-28 00:24:58,225] INFO:Magento Export:Successfully created category with OpenERP id 23 and Magento id 66 [2009-08-28 00:24:58,610] INFO:Magento Export:Successfully created category with OpenERP id 24 and Magento id 67 [2009-08-28 00:24:58,977] INFO:Magento Export:Successfully created category with OpenERP id 25 and Magento id 68 [2009-08-28 00:24:59,438] INFO:Magento Export:Successfully created category with OpenERP id 26 and Magento id 69 [2009-08-28 00:24:59,797] INFO:Magento Export:Successfully created category with OpenERP id 27 and Magento id 70 [2009-08-28 00:25:00,233] INFO:Magento Export:Successfully created category with OpenERP id 28 and Magento id 71 [2009-08-28 00:25:00,587] INFO:Magento Export:Successfully created category with OpenERP id 29 and Magento id 72 [2009-08-28 00:25:00,939] INFO:Magento Export:Successfully created category with OpenERP id 30 and Magento id 73 [2009-08-28 00:25:01,403] INFO:Magento Export:Successfully created category with OpenERP id 32 and Magento id 74 [2009-08-28 00:25:01,852] INFO:Magento Export:Successfully created category with OpenERP id 33 and Magento id 75 [2009-08-28 00:25:02,282] INFO:Magento Export:Successfully created category with OpenERP id 34 and Magento id 76 [2009-08-28 00:25:02,633] INFO:Magento Export:Successfully updated category with OpenERP id 35 and Magento id 1 [2009-08-28 00:25:03,004] INFO:Magento Export:Successfully created category with OpenERP id 36 and Magento id 77 [2009-08-28 00:25:03,446] INFO:Magento Export:Successfully created category with OpenERP id 38 and Magento id 78 [2009-08-28 00:25:03,810] INFO:Magento Export:Successfully created category with OpenERP id 39 and Magento id 79 [2009-08-28 00:25:04,224] INFO:Magento Export:Successfully created category with OpenERP id 40 and Magento id 80 [2009-08-28 00:25:04,572] INFO:Magento Export:Successfully created category with OpenERP id 41 and Magento id 81 [2009-08-28 00:25:04,956] INFO:Magento Export:Successfully created category with OpenERP id 42 and Magento id 82

  What steps will reproduce the problem? 1. Sync categories 2. Returns An error occured : junk after document element: line 2, column 0 What is the expected output? What do you see instead? Expected new categories in magento An error occured : junk after document element: line 2, column 0 Then, in magento, when went to admin menu for manage categories: Fatal error: Call to a member function getId() on a non-object in /opt/www_data/shop_venyashop_magento/lib/Varien/Data/Tree/Dbp.php on line 315 Maybe corrupted database. What version of the product are you using? On what operating system? Latest/Latest Please provide any additional information below. Openerp log: [2009-08-28 00:24:42,521] INFO:Magento Export:Successfully updated category with OpenERP id 4 and Magento id 19 [2009-08-28 00:24:42,951] INFO:Magento Export:Successfully created category with OpenERP id 49 and Magento id 48 [2009-08-28 00:24:43,393] INFO:Magento Export:Successfully created category with OpenERP id 5 and Magento id 49 [2009-08-28 00:24:43,763] INFO:Magento Export:Successfully created category with OpenERP id 6 and Magento id 50 [2009-08-28 00:24:45,429] INFO:Magento Export:Successfully created category with OpenERP id 31 and Magento id 51 [2009-08-28 00:24:46,025] INFO:Magento Export:Successfully created category with OpenERP id 37 and Magento id 52 [2009-08-28 00:24:46,492] INFO:Magento Export:Successfully updated category with OpenERP id 43 and Magento id 22 [2009-08-28 00:24:46,845] INFO:Magento Export:Successfully updated category with OpenERP id 1 and Magento id 9 [2009-08-28 00:24:47,296] INFO:Magento Export:Successfully created category with OpenERP id 7 and Magento id 53 [2009-08-28 00:24:47,664] INFO:Magento Export:Successfully created category with OpenERP id 9 and Magento id 54 [2009-08-28 00:24:48,144] INFO:Magento Export:Successfully created category with OpenERP id 10 and Magento id 55 [2009-08-28 00:24:48,529] INFO:Magento Export:Successfully created category with OpenERP id 11 and Magento id 56 [2009-08-28 00:24:48,889] INFO:Magento Export:Successfully created category with OpenERP id 12 and Magento id 57 [2009-08-28 00:24:49,314] INFO:Magento Export:Successfully created category with OpenERP id 13 and Magento id 58 [2009-08-28 00:24:49,675] INFO:Magento Export:Successfully created category with OpenERP id 14 and Magento id 59 [2009-08-28 00:24:50,111] INFO:Magento Export:Successfully created category with OpenERP id 15 and Magento id 60 [2009-08-28 00:24:50,482] INFO:Magento Export:Successfully created category with OpenERP id 16 and Magento id 61 [2009-08-28 00:24:50,834] INFO:Magento Export:Successfully updated category with OpenERP id 17 and Magento id 20 [2009-08-28 00:24:51,262] INFO:Magento Export:Successfully created category with OpenERP id 18 and Magento id 62 [2009-08-28 00:24:56,623] INFO:Magento Export:Successfully created category with OpenERP id 20 and Magento id 63 [2009-08-28 00:24:56,972] INFO:Magento Export:Successfully created category with OpenERP id 21 and Magento id 64 [2009-08-28 00:24:57,431] INFO:Magento Export:Successfully created category with OpenERP id 22 and Magento id 65 [2009-08-28 00:24:57,788] INFO:Magento Export:Successfully updated category with OpenERP id 19 and Magento id 21 [2009-08-28 00:24:58,225] INFO:Magento Export:Successfully created category with OpenERP id 23 and Magento id 66 [2009-08-28 00:24:58,610] INFO:Magento Export:Successfully created category with OpenERP id 24 and Magento id 67 [2009-08-28 00:24:58,977] INFO:Magento Export:Successfully created category with OpenERP id 25 and Magento id 68 [2009-08-28 00:24:59,438] INFO:Magento Export:Successfully created category with OpenERP id 26 and Magento id 69 [2009-08-28 00:24:59,797] INFO:Magento Export:Successfully created category with OpenERP id 27 and Magento id 70 [2009-08-28 00:25:00,233] INFO:Magento Export:Successfully created category with OpenERP id 28 and Magento id 71 [2009-08-28 00:25:00,587] INFO:Magento Export:Successfully created category with OpenERP id 29 and Magento id 72 [2009-08-28 00:25:00,939] INFO:Magento Export:Successfully created category with OpenERP id 30 and Magento id 73 [2009-08-28 00:25:01,403] INFO:Magento Export:Successfully created category with OpenERP id 32 and Magento id 74 [2009-08-28 00:25:01,852] INFO:Magento Export:Successfully created category with OpenERP id 33 and Magento id 75 [2009-08-28 00:25:02,282] INFO:Magento Export:Successfully created category with OpenERP id 34 and Magento id 76 [2009-08-28 00:25:02,633] INFO:Magento Export:Successfully updated category with OpenERP id 35 and Magento id 1 [2009-08-28 00:25:03,004] INFO:Magento Export:Successfully created category with OpenERP id 36 and Magento id 77 [2009-08-28 00:25:03,446] INFO:Magento Export:Successfully created category with OpenERP id 38 and Magento id 78 [2009-08-28 00:25:03,810] INFO:Magento Export:Successfully created category with OpenERP id 39 and Magento id 79 [2009-08-28 00:25:04,224] INFO:Magento Export:Successfully created category with OpenERP id 40 and Magento id 80 [2009-08-28 00:25:04,572] INFO:Magento Export:Successfully created category with OpenERP id 41 and Magento id 81 [2009-08-28 00:25:04,956] INFO:Magento Export:Successfully created category with OpenERP id 42 and Magento id 82
• Aug 17, 2009

  issue 48 (Magento api protected with SSL and client certificate) reported by przemyslaw.sitarz   -   Hello, I wish protect the Magento API with SSL and a client certficate (Apache option: ClientVerify require). But I cannot specify the certficate file to use when I specify the url of the store... Can you help me ? Regards, Przmyslaw

  Hello, I wish protect the Magento API with SSL and a client certficate (Apache option: ClientVerify require). But I cannot specify the certficate file to use when I specify the url of the store... Can you help me ? Regards, Przmyslaw
• Aug 12, 2009

  issue 6 (use native Magento ACL based security for the PHP webservice...) commented on by lanshunfang   -   thx rvalyi, you guys have been doing terrific stuff! So does your appspot!

  thx rvalyi, you guys have been doing terrific stuff! So does your appspot!
• Jul 29, 2009

  issue 47 (error trying to import an invoice order) reported by chris.jo...@ankhhealth.com   -   What steps will reproduce the problem? 1. Import Sales Orders from Open ERP What is the expected output? What do you see instead? Traceback (most recent call last): File "/opt/openerp/openerp-server-5.0.1-0/bin/netsvc.py", line 235, in dispatch result = LocalService(service_name)(method, *params) File "/opt/openerp/openerp-server-5.0.1-0/bin/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/opt/openerp/openerp-server-5.0.1-0/bin/service/web_services.py", line 582, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/opt/openerp/openerp-server-5.0.1-0/bin/service/web_services.py", line 562, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/opt/openerp/openerp-server-5.0.1-0/bin/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/opt/openerp/openerp-server-5.0.1-0/bin/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/root/openerp/openerp-server-5.0.0- 3/bin/addons/magento_openerp_synchro/wizard/magento_so_import.py", line 187, in _do_import KeyError: 'purchaseorder' What version of the product are you using? On what operating system? latest Magento-openerp build. Ubuntu 8.04 Please provide any additional information below. The order in Magento is an invoice order. I tried to enter a credit card order but it's still saying the same thing. The synchro module has been modified somewhat by my developer but unfortunately I don't know what they've done and they've gone MIA on me so I'm trying to figure this out myself. thanks! Chris

  What steps will reproduce the problem? 1. Import Sales Orders from Open ERP What is the expected output? What do you see instead? Traceback (most recent call last): File "/opt/openerp/openerp-server-5.0.1-0/bin/netsvc.py", line 235, in dispatch result = LocalService(service_name)(method, *params) File "/opt/openerp/openerp-server-5.0.1-0/bin/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/opt/openerp/openerp-server-5.0.1-0/bin/service/web_services.py", line 582, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/opt/openerp/openerp-server-5.0.1-0/bin/service/web_services.py", line 562, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/opt/openerp/openerp-server-5.0.1-0/bin/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/opt/openerp/openerp-server-5.0.1-0/bin/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/root/openerp/openerp-server-5.0.0- 3/bin/addons/magento_openerp_synchro/wizard/magento_so_import.py", line 187, in _do_import KeyError: 'purchaseorder' What version of the product are you using? On what operating system? latest Magento-openerp build. Ubuntu 8.04 Please provide any additional information below. The order in Magento is an invoice order. I tried to enter a credit card order but it's still saying the same thing. The synchro module has been modified somewhat by my developer but unfortunately I don't know what they've done and they've gone MIA on me so I'm trying to figure this out myself. thanks! Chris
• Jul 27, 2009

  issue 46 (Openerp has access to Magento's web services, but when I cli...) reported by 20abril09   -   What steps will reproduce the problem? 1. Openerp Client -> Magento -> Synchronization -> Import sale orders 2. 3. What is the expected output? What do you see instead? Expected Output: import sales orders should import the sales orders. Current Output: import sales orders only import "shipment costs" recorded as "Shipping and Handling" sales. What version of the product are you using? On what operating system? openerp-server 5.0.0-3-1 magento_openerp_synchro 5.0.0.9.9 Magento 1.3.2.3 Latest trunk of Magento Extension for Openerp (with date of July 27th) Ubuntu Server 9.04 Please provide any additional information below. Hi there, I'm testing magento_openerp_synchro 5.0.0.9.9 on openerp-server 5.0.0-3-1 (ubuntu) to synchronize with Magento 1.3.2.3. Latest trunk of Magento Extension for Openerp has beed added. Openerp has access to Magento's web services, but when I click on "import sales orders" only "Shipping and Handling" sales haven been added (only shipment costs) to Sale Orders menu. Product Catalog is managed by Magento and not by Openerp. Any help will be appreciated Kind regards, I. Fernandez

  What steps will reproduce the problem? 1. Openerp Client -> Magento -> Synchronization -> Import sale orders 2. 3. What is the expected output? What do you see instead? Expected Output: import sales orders should import the sales orders. Current Output: import sales orders only import "shipment costs" recorded as "Shipping and Handling" sales. What version of the product are you using? On what operating system? openerp-server 5.0.0-3-1 magento_openerp_synchro 5.0.0.9.9 Magento 1.3.2.3 Latest trunk of Magento Extension for Openerp (with date of July 27th) Ubuntu Server 9.04 Please provide any additional information below. Hi there, I'm testing magento_openerp_synchro 5.0.0.9.9 on openerp-server 5.0.0-3-1 (ubuntu) to synchronize with Magento 1.3.2.3. Latest trunk of Magento Extension for Openerp has beed added. Openerp has access to Magento's web services, but when I click on "import sales orders" only "Shipping and Handling" sales haven been added (only shipment costs) to Sale Orders menu. Product Catalog is managed by Magento and not by Openerp. Any help will be appreciated Kind regards, I. Fernandez
• Jul 05, 2009

  issue 6 (use native Magento ACL based security for the PHP webservice...) commented on by mvanderboom   -   I might be overlooking something here, but the bzr on launchpad show the last change to be somewhere in march. ( http://bazaar.launchpad.net/%7Eopenerp-commiter/openobject- addons/trunk-extra-addons/files/head%3A/magento_openerp_synchro/ ) Am I looking in the wrong place?

  I might be overlooking something here, but the bzr on launchpad show the last change to be somewhere in march. ( http://bazaar.launchpad.net/%7Eopenerp-commiter/openobject- addons/trunk-extra-addons/files/head%3A/magento_openerp_synchro/ ) Am I looking in the wrong place?
• Jun 16, 2009

  issue 44 (A small change) commented on by i...@dappers.nl   -   Extra info: you schould alter the product SHIP and make it a product with tax. Now the module finds the tax ( 'tax_id' : [(6, 0, [x.id for x in ship_product.taxes_id])]). And the according shipping-cost on the invoices in OpenERP will be calculated with that tax. You should also tell magento (configuration->Sales->tax) that the shipping/delivery are in a certain tax group. So the calculated total on the site is the same as in OpenERP.

  Extra info: you schould alter the product SHIP and make it a product with tax. Now the module finds the tax ( 'tax_id' : [(6, 0, [x.id for x in ship_product.taxes_id])]). And the according shipping-cost on the invoices in OpenERP will be calculated with that tax. You should also tell magento (configuration->Sales->tax) that the shipping/delivery are in a certain tax group. So the calculated total on the site is the same as in OpenERP.
• Jun 12, 2009

  issue 44 (A small change) commented on by hansje.haas   -   Do you have entered the tax in the product SHIP in OpenERP it self?

  Do you have entered the tax in the product SHIP in OpenERP it self?
• Jun 12, 2009

  issue 45 (Salesorder import of configurable pproducts) reported by hansje.haas   -   What steps will reproduce the problem? 1. Enter an order of with configurable product 2. Import sales order in Oper ERP What is the expected output? What do you see instead? In Openerp 1 line with the SKU of the simple product, price and qty. Currently there are two lines: 1 Configurable product(SKU of configurable product, price in order, qty in order. 2 Simple product (SKU of simple product, price=0, qty as in configurable product. What version of the product are you using? On what operating system? Magento 1.3.1 Openerp 5 stable magento-openerp-smile-synchro: trunk Please provide any additional information below.

  What steps will reproduce the problem? 1. Enter an order of with configurable product 2. Import sales order in Oper ERP What is the expected output? What do you see instead? In Openerp 1 line with the SKU of the simple product, price and qty. Currently there are two lines: 1 Configurable product(SKU of configurable product, price in order, qty in order. 2 Simple product (SKU of simple product, price=0, qty as in configurable product. What version of the product are you using? On what operating system? Magento 1.3.1 Openerp 5 stable magento-openerp-smile-synchro: trunk Please provide any additional information below.
• Jun 08, 2009

  issue 6 (use native Magento ACL based security for the PHP webservice...) commented on by rvalyi   -   We are almost done with that one folks; the PHP part at least is done, see bzr logs, will hopefully be over in the very next days! Stay tuned. Raphaël Valyi

  We are almost done with that one folks; the PHP part at least is done, see bzr logs, will hopefully be over in the very next days! Stay tuned. Raphaël Valyi
• Jun 04, 2009

  issue 44 (A small change) reported by i...@dappers.nl   -   What steps will reproduce the problem? 1. I use shipping cost with tax! Now the tax_id is still empty when importing the shipping line. Maybe you would consider changing it to: self.pool.get('sale.order.line').create(cr, uid, { 'product_id': ship_product_id[0], 'name': ship_product.name, 'order_id': order_id, 'product_uom': ship_product.uom_id.id, 'product_uom_qty': 1, 'price_unit': so['shipping_amount'], 'tax_id' : [(6, 0, [x.id for x in ship_product.taxes_id])] # extra, in case shippingcost are inclusive VAT/TAX }) Kind regards, Peter

  What steps will reproduce the problem? 1. I use shipping cost with tax! Now the tax_id is still empty when importing the shipping line. Maybe you would consider changing it to: self.pool.get('sale.order.line').create(cr, uid, { 'product_id': ship_product_id[0], 'name': ship_product.name, 'order_id': order_id, 'product_uom': ship_product.uom_id.id, 'product_uom_qty': 1, 'price_unit': so['shipping_amount'], 'tax_id' : [(6, 0, [x.id for x in ship_product.taxes_id])] # extra, in case shippingcost are inclusive VAT/TAX }) Kind regards, Peter
• May 19, 2009

  issue 43 (column magento_web.magento_id does not exist) reported by tragost   -   Hello, I'm working on OpenErp v5.0 with Magento_OpenErp v5.0.0.9.9 and I managed to get Sales Order and category Order working. When I try to Synchronise product, I have this error : Traceback (most recent call last): File "netsvc.pyo", line 231, in dispatch File "netsvc.pyo", line 74, in __call__ File "service\web_services.pyo", line 552, in execute File "service\web_services.pyo", line 532, in _execute File "wizard\__init__.pyo", line 178, in execute File "wizard\__init__.pyo", line 74, in execute_cr File "C:\Program Files\OpenERP AllInOne\Server\addons\magento_openerp.zip\magento_openerp\wizard\magento_product_synchronize.py", line 57, in do_export File "C:\Program Files\OpenERP AllInOne\Server\addons\magento_openerp.zip\magento_openerp\wizard\server_common.py", line 13, in __init__ File "osv\orm.pyo", line 2620, in search File "sql_db.pyo", line 76, in wrapper File "sql_db.pyo", line 118, in execute ProgrammingError: column magento_web.magento_id does not exist LINE 1: select magento_web.id from "magento_web" where (magento_web.... Any Idea ?

  Hello, I'm working on OpenErp v5.0 with Magento_OpenErp v5.0.0.9.9 and I managed to get Sales Order and category Order working. When I try to Synchronise product, I have this error : Traceback (most recent call last): File "netsvc.pyo", line 231, in dispatch File "netsvc.pyo", line 74, in __call__ File "service\web_services.pyo", line 552, in execute File "service\web_services.pyo", line 532, in _execute File "wizard\__init__.pyo", line 178, in execute File "wizard\__init__.pyo", line 74, in execute_cr File "C:\Program Files\OpenERP AllInOne\Server\addons\magento_openerp.zip\magento_openerp\wizard\magento_product_synchronize.py", line 57, in do_export File "C:\Program Files\OpenERP AllInOne\Server\addons\magento_openerp.zip\magento_openerp\wizard\server_common.py", line 13, in __init__ File "osv\orm.pyo", line 2620, in search File "sql_db.pyo", line 76, in wrapper File "sql_db.pyo", line 118, in execute ProgrammingError: column magento_web.magento_id does not exist LINE 1: select magento_web.id from "magento_web" where (magento_web.... Any Idea ?
• May 19, 2009

  issue 39 (Magento Sync Issue) commented on by bouke.steemers   -   I have a simular problem with OpenERP 5.0.0.0_3 (15000 products) with Magento 1.3.1 while synchronizing. I am also using magento-openerp-smile-synchro 0.9.9 When I upload the products the flag "updated" is set to "true" when the synchrnization is broken. Is there a python command to invoke a database write after each product, or serie of products.

  I have a simular problem with OpenERP 5.0.0.0_3 (15000 products) with Magento 1.3.1 while synchronizing. I am also using magento-openerp-smile-synchro 0.9.9 When I upload the products the flag "updated" is set to "true" when the synchrnization is broken. Is there a python command to invoke a database write after each product, or serie of products.
• May 14, 2009

  issue 42 (magento and openerp problems) reported by broly972   -   In my case , I have also problems with magento and openerp ....For the moment, I don't know what I must do... -In my pdf invoice or my pdf order of openerp ,I see twice the name of the partner. -I don't know how to import the company name of the magento customer from magento to openerp.It always the name of the company contact that I import. -I have also a problem with the ecotax(DEEE).I don't know how I can manage it in order to export it to magento. -How I can export a field which already exists from magento to openerp? -A product can have several VAT(tax) for several countries .How I can manage this in order to export it from openerp to magento? -How I can manage the french tax of Martinique("tva non perçue récupérable") in openerp in order to export it from openerp to magento? It's a tax with a rate of 8,5% on a product.This tax must be display on the invoice but it isn't in the total amount. In reality, it's a subvention with a rate of 8,5% on the product. If you have the solution for these problems , let me know.

  In my case , I have also problems with magento and openerp ....For the moment, I don't know what I must do... -In my pdf invoice or my pdf order of openerp ,I see twice the name of the partner. -I don't know how to import the company name of the magento customer from magento to openerp.It always the name of the company contact that I import. -I have also a problem with the ecotax(DEEE).I don't know how I can manage it in order to export it to magento. -How I can export a field which already exists from magento to openerp? -A product can have several VAT(tax) for several countries .How I can manage this in order to export it from openerp to magento? -How I can manage the french tax of Martinique("tva non perçue récupérable") in openerp in order to export it from openerp to magento? It's a tax with a rate of 8,5% on a product.This tax must be display on the invoice but it isn't in the total amount. In reality, it's a subvention with a rate of 8,5% on the product. If you have the solution for these problems , let me know.
• May 06, 2009

  issue 40 (Import Sales) commented on by broly972   -   hi it was a problem with .htaccess http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=19

  hi it was a problem with .htaccess http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=19
• May 06, 2009

  issue 35 (import sales orders) commented on by broly972   -   hi it's was a problem with .htaccess http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=19

  hi it's was a problem with .htaccess http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=19
• May 06, 2009

  issue 25 (Import sale orders) commented on by broly972   -   hi it's was a problem with .htaccess http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=19

  hi it's was a problem with .htaccess http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=19
• May 06, 2009

  issue 28 (Import sales orders) commented on by broly972   -   hi it's was a problem with .htaccess http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=19

  hi it's was a problem with .htaccess http://code.google.com/p/magento-openerp-smile-synchro/issues/detail?id=19
• May 03, 2009

  issue 11 (Installing on Magento Connect Wrong) commented on by sonawanemanohar   -   hi i m installing module magento_openerp_synchro & able to synchronize categories & product but while synchronizing import sale i got this error "Error, can't connect to Magento OpenERP sale import PHP extension at http://69.10.62.18/magentosite/ ! Are you sure you installed it? Error: <ProtocolError for 69.10.62.18/magentosite/app/code/community/Smile_OpenERP_Synchro-0.9.9/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden>" & i also install Smile_OpenERP_Synchro-0.9.9 into magentosite/community folder but still its giving problem can anyone help me out?

  hi i m installing module magento_openerp_synchro & able to synchronize categories & product but while synchronizing import sale i got this error "Error, can't connect to Magento OpenERP sale import PHP extension at http://69.10.62.18/magentosite/ ! Are you sure you installed it? Error: <ProtocolError for 69.10.62.18/magentosite/app/code/community/Smile_OpenERP_Synchro-0.9.9/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden>" & i also install Smile_OpenERP_Synchro-0.9.9 into magentosite/community folder but still its giving problem can anyone help me out?
• May 03, 2009

  issue 41 (automating the synchronization of sales orders) reported by siham.makhloufi   -   Hi, I want to automate the synchronization of sales orders, without passing by a link "import sale order" best regards

  Hi, I want to automate the synchronization of sales orders, without passing by a link "import sale order" best regards
• May 02, 2009

  issue 40 (Import Sales) reported by hm.in.vegas   -   I am having the same issue as many others. I have read through all the post but none of them really make sense to me to be honest. If someone could help me out with a more structured solution that would be much appreciated. Couldn't connect to Magento with URL http://www.xxxx.com/index.php/api/xmlrpc Thanks in advance

  I am having the same issue as many others. I have read through all the post but none of them really make sense to me to be honest. If someone could help me out with a more structured solution that would be much appreciated. Couldn't connect to Magento with URL http://www.xxxx.com/index.php/api/xmlrpc Thanks in advance
• May 02, 2009

  issue 35 (import sales orders) commented on by hm.in.vegas   -   Any luck with this?

  Any luck with this?
• May 02, 2009

  issue 25 (Import sale orders) commented on by hm.in.vegas   -   anyone find a solution to this?

  anyone find a solution to this?
• May 02, 2009

  issue 28 (Import sales orders) commented on by hm.in.vegas   -   Hi broly972, Did you find a solution to the below issue? ConnectionError Couldn't connect to Magento with URL http://www.mydomain.com.au/index.php/api/xmlrpc If so, I'd appreciate a hand trying to resolve the issue. Perhaps you can email me hm.in.vegas@gmail.com

  Hi broly972, Did you find a solution to the below issue? ConnectionError Couldn't connect to Magento with URL http://www.mydomain.com.au/index.php/api/xmlrpc If so, I'd appreciate a hand trying to resolve the issue. Perhaps you can email me hm.in.vegas@gmail.com
• Apr 24, 2009

  issue 39 (Magento Sync Issue) reported by anushankar   -   I have a small issue with OpenERP 4.2.2.3 with Magento 1.2.0 while synchronizing. I am also using magento-openerp-smile-synchro 0.9.9 I synchronized 6400 products from OpenERP to Magento. At one point of time the synchronization stopped nearly at 5000 products when I checked the Magento I can see 5000 products has been synchronized at which is a good thing. But when I checked the products at OpenERP the 5000 products doesn’t have Magento product id. When I restarted the synchronization again the synchronization went ok and remaining 1400 of 6400 has been also synchronized and those 1400 products has magento product id at OpenERP and the 5000 products doesn’t have the Magento product id. When I checked the Magento it has all 6400 synchronized. Any idea why?

  I have a small issue with OpenERP 4.2.2.3 with Magento 1.2.0 while synchronizing. I am also using magento-openerp-smile-synchro 0.9.9 I synchronized 6400 products from OpenERP to Magento. At one point of time the synchronization stopped nearly at 5000 products when I checked the Magento I can see 5000 products has been synchronized at which is a good thing. But when I checked the products at OpenERP the 5000 products doesn’t have Magento product id. When I restarted the synchronization again the synchronization went ok and remaining 1400 of 6400 has been also synchronized and those 1400 products has magento product id at OpenERP and the 5000 products doesn’t have the Magento product id. When I checked the Magento it has all 6400 synchronized. Any idea why?
• Apr 03, 2009

  issue 38 (import sales orders) commented on by broly972   -   ok it's good! import sales orders works! I have deleted the constraint res_country_name_uniq in pgadmin3.

  ok it's good! import sales orders works! I have deleted the constraint res_country_name_uniq in pgadmin3.
• Mar 23, 2009

  issue 37 (import sales orders) commented on by broly972   -   là j'ai pu résoudre mon problème en téléchargeant le pageant de putty... http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html Mais bon,j'ai toujours le problème de import sales order lol.

  là j'ai pu résoudre mon problème en téléchargeant le pageant de putty... http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html Mais bon,j'ai toujours le problème de import sales order lol.
• Mar 22, 2009

  issue 28 (Import sales orders) commented on by broly972   -   il y avait un problème de .htaccess pour les erreurs ci-dessous.. Mais bon , d'autres erreurs sont apparues.. Et j'utilise les derniers trunks de bazaar maintenant... Mon problème de import sales orders n'est toujours pas réglés lol... ConnectionError Couldn't connect to Magento with URL http://XXXXX.com/magento/index.php/api/xmlrpc ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden>

  il y avait un problème de .htaccess pour les erreurs ci-dessous.. Mais bon , d'autres erreurs sont apparues.. Et j'utilise les derniers trunks de bazaar maintenant... Mon problème de import sales orders n'est toujours pas réglés lol... ConnectionError Couldn't connect to Magento with URL http://XXXXX.com/magento/index.php/api/xmlrpc ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden>
• Mar 22, 2009

  issue 38 (import sales orders) commented on by broly972   -   I think it's a problem with the constraint but I don't know how to delete the constraint... Please help. When you will install this module, Open ERP will automatically import the partners and then the address and recreate efficiently the link between the two records. When installing a module, Open ERP will test and apply the constraints for consistency of the data. So, when you install this module, it may crash, for example, because you may have different partners with the same name in the system. (due to the uniq constraint on the name of a partner). So, you have to clean your data before importing them. If you plan to upload thousands of records through this technique, you should consider using the argument ‘-P’ when running the server. openerp_server.py -P status.pickle –init=data_yourcompany This method provides a faster importation of the data and, if it crashes in the middle of the import, it will continue at the same line after rerunning the server. This may preserves hours of testing when importing big files. http://doc.openerp.com/developer/12_DataMigration/index.html

  I think it's a problem with the constraint but I don't know how to delete the constraint... Please help. When you will install this module, Open ERP will automatically import the partners and then the address and recreate efficiently the link between the two records. When installing a module, Open ERP will test and apply the constraints for consistency of the data. So, when you install this module, it may crash, for example, because you may have different partners with the same name in the system. (due to the uniq constraint on the name of a partner). So, you have to clean your data before importing them. If you plan to upload thousands of records through this technique, you should consider using the argument ‘-P’ when running the server. openerp_server.py -P status.pickle –init=data_yourcompany This method provides a faster importation of the data and, if it crashes in the middle of the import, it will continue at the same line after rerunning the server. This may preserves hours of testing when importing big files. http://doc.openerp.com/developer/12_DataMigration/index.html
• Mar 22, 2009

  issue 38 (import sales orders) commented on by broly972   -   I think it's the same problem for oscommerce... But I don't know what is the attribute that I must change for magento... Please help. Changed file /tinyerp/bin/addons/oscommerce_interface/wizard/wizard_esale_oscom_import_sos.py on line 28: ORIG : search_country = country_pooler.search(cr,uid,[('code','=',data['code'])]) NEW : search_country = country_pooler.search(cr,uid,[('name','=',data['name'])]) REASON : Without this change I could not import orders as I got an error that the country already existed (ERROR: duplicate key violates unique constraint "res_country_name_uniq") http://openerp.com/forum/topic5714.html?highlight=server%20addons%20terp

  I think it's the same problem for oscommerce... But I don't know what is the attribute that I must change for magento... Please help. Changed file /tinyerp/bin/addons/oscommerce_interface/wizard/wizard_esale_oscom_import_sos.py on line 28: ORIG : search_country = country_pooler.search(cr,uid,[('code','=',data['code'])]) NEW : search_country = country_pooler.search(cr,uid,[('name','=',data['name'])]) REASON : Without this change I could not import orders as I got an error that the country already existed (ERROR: duplicate key violates unique constraint "res_country_name_uniq") http://openerp.com/forum/topic5714.html?highlight=server%20addons%20terp
• Mar 21, 2009

  issue 38 (import sales orders) reported by broly972   -   Hi I am on latest trunk revisions. I use Open ERP 5.0.3 (stable 5: http://sisalp.net/pages/documentation.html#menu ) and magento 1.2.1. I have this error when I try to synchronize openerp and magento for only import sales orders... Traceback (most recent call last): File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/netsvc.py", line 231, in dispatch result = LocalService(service_name)(method, *params) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/service/web_services.py", line 552, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/service/web_services.py", line 532, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/addons/magento_openerp_synchro.zip/magento_openerp_synchro/wizard/magento_so_import.py", line 129, in _do_import 'magento_id': so['customer']['customer_id'], File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/osv/orm.py", line 2446, in create cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2)) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/sql_db.py", line 76, in wrapper return f(self, *args, **kwargs) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/sql_db.py", line 118, in execute res = self._obj.execute(query, params) IntegrityError: duplicate key value violates unique constraint "res_partner_name_uniq"

  Hi I am on latest trunk revisions. I use Open ERP 5.0.3 (stable 5: http://sisalp.net/pages/documentation.html#menu ) and magento 1.2.1. I have this error when I try to synchronize openerp and magento for only import sales orders... Traceback (most recent call last): File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/netsvc.py", line 231, in dispatch result = LocalService(service_name)(method, *params) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/service/web_services.py", line 552, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/service/web_services.py", line 532, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/addons/magento_openerp_synchro.zip/magento_openerp_synchro/wizard/magento_so_import.py", line 129, in _do_import 'magento_id': so['customer']['customer_id'], File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/osv/orm.py", line 2446, in create cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2)) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/sql_db.py", line 76, in wrapper return f(self, *args, **kwargs) File "/home/sisalpuser/openerp/stable5/openerp-server-5.0.0-3/bin/sql_db.py", line 118, in execute res = self._obj.execute(query, params) IntegrityError: duplicate key value violates unique constraint "res_partner_name_uniq"
• Mar 17, 2009

  issue 37 (import sales orders) reported by broly972   -   Slt J'utilise open erp 5.0.0 "all in one" et magento 1.2.1 et l'extension Smile_OpenERP_Synchro 0.9.9 (beta) et magento_openerp_smile-0.9.9.zip J'ai cette erreur quand j'essaye d'importer les commandes de magento sur openerp: ConnectionError Couldn't connect to Magento with URL http://XXXXX.com/magento/index.php/api/xmlrpc Par contre ça marche parfaitement pour l'import de produit et de catégories... Si j'ajoute les dernières mise à jour béta des fichiers du module du connecteur de openerp de ce site : http://code.google.com/p/magento-openerp-smile-synchro/source/browse/#svn/trunk j'ai l'erreur "ProtocolError" ci desssous quand je fais une importation de commande sur openerp... ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden> Traceback (most recent call last): File "/home/sisalpuser/openerp/dev5/server/bin/netsvc.py", line 231, in dispatch result = LocalService(service_name)(method, *params) File "/home/sisalpuser/openerp/dev5/server/bin/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/home/sisalpuser/openerp/dev5/server/bin/service/web_services.py", line 552, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/home/sisalpuser/openerp/dev5/server/bin/service/web_services.py", line 532, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/home/sisalpuser/openerp/dev5/server/bin/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/home/sisalpuser/openerp/dev5/server/bin/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/home/sisalpuser/openerp/dev5/server/bin/addons/exmagen.zip/exmagen/wizard/magento_so_import.py", line 75, in _do_import sale_order_array = server.sale_orders_sync(last_order_id) File "/usr/lib/python2.5/xmlrpclib.py", line 1147, in __call__ return self.__send(self.__name, args) File "/usr/lib/python2.5/xmlrpclib.py", line 1437, in __request verbose=self.__verbose File "/usr/lib/python2.5/xmlrpclib.py", line 1191, in request headers ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden> Ceci dit, l'auteur du site rvalyi dit que son site est obsolète et de se rediriger vers le nouveau.. Donc je suis son lien: http://rvalyi.blogspot.com/2009/03/magento-openerp-synchro-module-we-moved.html Et son lien me redirige vers un autre site: https://code.launchpad.net/~openerp-commiter/openobject-addons/trunk-extra-addons Mais avant je dois m'enregistrer , on me demande une clé SSH donc je suis le tuto https://help.launchpad.net/YourAccount/CreatingAnSSHKeyPair Donc là tout est OK En fait mon but est de télécharger le module du connecteur de openerp pour magento. Donc je prends le programme bazaar sur ce site: https://launchpad.net/bzr/+download Je tente alors d'exécuter la commande pour télécharger le répertoire du module de openerp pour magento: bzr branch lp:~openerp-commiter/openobject-addons/trunk-extra-addons J Et là , ça me demande un mot de passe! j'essaye de mettre le mot de passe de mon compte, ça passe pas! j'essaye de mettre la clé privé ou la clé publique, ça passe pas! Donc j'aurais voulu savoir où prendre ce mot de passe! lol Bazaar -- a free distributed version-control tool http://bazaar-vcs.org/ Basic commands: bzr init makes this directory a versioned branch bzr branch make a copy of another branch bzr add make files or directories versioned bzr ignore ignore a file or pattern bzr mv move or rename a versioned file bzr status summarize changes in working copy bzr diff show detailed diffs bzr merge pull in changes from another branch bzr commit save some or all changes bzr send send changes via email bzr log show history of changes bzr check validate storage bzr help init more help on e.g. init command bzr help commands list all commands bzr help topics list all help topics C:\Program Files\Bazaar> C:\Program Files\Bazaar>bzr branch lp:~openerp-commiter/openobject-addons/trunk- extra-addons Connected (version 2.0, client Twisted) SSH broly972@bazaar.launchpad.net password: Authentication type (password) not permitted. bzr: ERROR: Connection error: Unable to authenticate to SSH host as broly972@baz aar.launchpad.net Bad authentication type (allowed_types=['publickey']) Ensuite, j'ai essayé de prendre tous les fichiers du module du connecter de openerp de magento manuellement sur ce site http://bazaar.launchpad.net/~openerp-commiter/openobject-addons/trunk-extra-addons/files/head%3A/magento_openerp_synchro/ Je précise que je fais tous mes test sur ce site gratos où ya un openerp gratos... http://sisalp.net/pages/documentation.html#menu Quand j'importe donc ce module , il n'apparait même pas dans ma liste de module... Donc au final, J'arrive toujours pas à importer les commandes sur magento... et ça me freine donc terriblement dans mon développement! lol Donc si quelq'un sait comment faire pour faire fonctionner "import sales orders" ,ce serait cool! Merci d'avance!

  Slt J'utilise open erp 5.0.0 "all in one" et magento 1.2.1 et l'extension Smile_OpenERP_Synchro 0.9.9 (beta) et magento_openerp_smile-0.9.9.zip J'ai cette erreur quand j'essaye d'importer les commandes de magento sur openerp: ConnectionError Couldn't connect to Magento with URL http://XXXXX.com/magento/index.php/api/xmlrpc Par contre ça marche parfaitement pour l'import de produit et de catégories... Si j'ajoute les dernières mise à jour béta des fichiers du module du connecteur de openerp de ce site : http://code.google.com/p/magento-openerp-smile-synchro/source/browse/#svn/trunk j'ai l'erreur "ProtocolError" ci desssous quand je fais une importation de commande sur openerp... ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden> Traceback (most recent call last): File "/home/sisalpuser/openerp/dev5/server/bin/netsvc.py", line 231, in dispatch result = LocalService(service_name)(method, *params) File "/home/sisalpuser/openerp/dev5/server/bin/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/home/sisalpuser/openerp/dev5/server/bin/service/web_services.py", line 552, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/home/sisalpuser/openerp/dev5/server/bin/service/web_services.py", line 532, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/home/sisalpuser/openerp/dev5/server/bin/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/home/sisalpuser/openerp/dev5/server/bin/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/home/sisalpuser/openerp/dev5/server/bin/addons/exmagen.zip/exmagen/wizard/magento_so_import.py", line 75, in _do_import sale_order_array = server.sale_orders_sync(last_order_id) File "/usr/lib/python2.5/xmlrpclib.py", line 1147, in __call__ return self.__send(self.__name, args) File "/usr/lib/python2.5/xmlrpclib.py", line 1437, in __request verbose=self.__verbose File "/usr/lib/python2.5/xmlrpclib.py", line 1191, in request headers ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden> Ceci dit, l'auteur du site rvalyi dit que son site est obsolète et de se rediriger vers le nouveau.. Donc je suis son lien: http://rvalyi.blogspot.com/2009/03/magento-openerp-synchro-module-we-moved.html Et son lien me redirige vers un autre site: https://code.launchpad.net/~openerp-commiter/openobject-addons/trunk-extra-addons Mais avant je dois m'enregistrer , on me demande une clé SSH donc je suis le tuto https://help.launchpad.net/YourAccount/CreatingAnSSHKeyPair Donc là tout est OK En fait mon but est de télécharger le module du connecteur de openerp pour magento. Donc je prends le programme bazaar sur ce site: https://launchpad.net/bzr/+download Je tente alors d'exécuter la commande pour télécharger le répertoire du module de openerp pour magento: bzr branch lp:~openerp-commiter/openobject-addons/trunk-extra-addons J Et là , ça me demande un mot de passe! j'essaye de mettre le mot de passe de mon compte, ça passe pas! j'essaye de mettre la clé privé ou la clé publique, ça passe pas! Donc j'aurais voulu savoir où prendre ce mot de passe! lol Bazaar -- a free distributed version-control tool http://bazaar-vcs.org/ Basic commands: bzr init makes this directory a versioned branch bzr branch make a copy of another branch bzr add make files or directories versioned bzr ignore ignore a file or pattern bzr mv move or rename a versioned file bzr status summarize changes in working copy bzr diff show detailed diffs bzr merge pull in changes from another branch bzr commit save some or all changes bzr send send changes via email bzr log show history of changes bzr check validate storage bzr help init more help on e.g. init command bzr help commands list all commands bzr help topics list all help topics C:\Program Files\Bazaar> C:\Program Files\Bazaar>bzr branch lp:~openerp-commiter/openobject-addons/trunk- extra-addons Connected (version 2.0, client Twisted) SSH broly972@bazaar.launchpad.net password: Authentication type (password) not permitted. bzr: ERROR: Connection error: Unable to authenticate to SSH host as broly972@baz aar.launchpad.net Bad authentication type (allowed_types=['publickey']) Ensuite, j'ai essayé de prendre tous les fichiers du module du connecter de openerp de magento manuellement sur ce site http://bazaar.launchpad.net/~openerp-commiter/openobject-addons/trunk-extra-addons/files/head%3A/magento_openerp_synchro/ Je précise que je fais tous mes test sur ce site gratos où ya un openerp gratos... http://sisalp.net/pages/documentation.html#menu Quand j'importe donc ce module , il n'apparait même pas dans ma liste de module... Donc au final, J'arrive toujours pas à importer les commandes sur magento... et ça me freine donc terriblement dans mon développement! lol Donc si quelq'un sait comment faire pour faire fonctionner "import sales orders" ,ce serait cool! Merci d'avance!
• Mar 17, 2009

  issue 1 (Product Image synchronization) commented on by siham.makhloufi   -   Hi, please, someone has the same problem ??? regards,

  Hi, please, someone has the same problem ??? regards,
• Mar 16, 2009

  issue 36 (Large import problem) reported by i...@dappers.nl   -   I would like to start with thanking the people who helped to develop this nice connector! My question /remark is probably not common to a lot of users, but maybe there is a solution I frequently would have to make a large import/synchronisation to magento. But due to the way OpenERP works and the way Magento works a poblem rises. With the connector synchronisting, it immediedly makes changes to the magento database. While the OpenERP database makes a create/write-action at the end of his complete run. So, with a large sychronisation (+16.000 products) those changes are made after 2 days. During that run PHP, MySQL, phyton, PostgreSQL and the TCP-IP layer (differrent server) must be stable. ... well, one hopes. Otherwise, OpenERP has no knowlage of an export, while magento has products. And with a new synchronisation there is trouble, duplicate products.... Would there be a possibility to make a 'safe mode'. If there is this kind of error, OpenERP checks if the product (SKU-productcode) exits in Magento and then writes down the Magento-id for that product. I hope I am not the only one with this problem (as a comlete newby, my scripting would be terrible) With kind regards, Peter

  I would like to start with thanking the people who helped to develop this nice connector! My question /remark is probably not common to a lot of users, but maybe there is a solution I frequently would have to make a large import/synchronisation to magento. But due to the way OpenERP works and the way Magento works a poblem rises. With the connector synchronisting, it immediedly makes changes to the magento database. While the OpenERP database makes a create/write-action at the end of his complete run. So, with a large sychronisation (+16.000 products) those changes are made after 2 days. During that run PHP, MySQL, phyton, PostgreSQL and the TCP-IP layer (differrent server) must be stable. ... well, one hopes. Otherwise, OpenERP has no knowlage of an export, while magento has products. And with a new synchronisation there is trouble, duplicate products.... Would there be a possibility to make a 'safe mode'. If there is this kind of error, OpenERP checks if the product (SKU-productcode) exits in Magento and then writes down the Magento-id for that product. I hope I am not the only one with this problem (as a comlete newby, my scripting would be terrible) With kind regards, Peter
• Mar 15, 2009

  issue 35 (import sales orders) reported by broly972   -   Hi I use Open ERP 4.2.3.3 "all in one" and magento 1.2.1 and the extension Smile_OpenERP_Synchro 0.9.9 (beta) and magento_openerp_smile-0.9.9.zip and windows xp. I do the tests with my website wich is already on a webhosting internet and the openerp which is in my localhost computer. I have this when I try to synchronize openerp and magento for only import sales orders... ConnectionError Couldn't connect to Magento with URL http://XXXXX.com/magento/index.php/api/xmlrpc

  Hi I use Open ERP 4.2.3.3 "all in one" and magento 1.2.1 and the extension Smile_OpenERP_Synchro 0.9.9 (beta) and magento_openerp_smile-0.9.9.zip and windows xp. I do the tests with my website wich is already on a webhosting internet and the openerp which is in my localhost computer. I have this when I try to synchronize openerp and magento for only import sales orders... ConnectionError Couldn't connect to Magento with URL http://XXXXX.com/magento/index.php/api/xmlrpc
• Mar 15, 2009

  issue 34 (import sales order,products ,categories) reported by broly972   -   Hi I use Open ERP 4.2.3.3 "all in one" and magento 1.2.1 and the extension Smile_OpenERP_Synchro 0.9.9 (beta) and the last trunk of magento_openerp_smile of your site in the source. I do the tests with my website wich is already on a webhosting internet and the openerp whis is in my localhost computer. I have this errero when I try to synchronize openerp and magento for only import sales orders,product and category... please help. code de l'erreur: connect() takes at least 4 arguments (1 given) Traceback (most recent call last): File "netsvc.pyo", line 338, in run File "service\web_services.pyo", line 422, in execute File "service\web_services.pyo", line 402, in _execute File "wizard\__init__.pyo", line 160, in execute File "wizard\__init__.pyo", line 75, in execute_cr File "C:\Program Files\TinyERP Server\addons\exmagen.zip\exmagen\wizard\magento_product_synchronize.py", line 52, in do_export TypeError: connect() takes at least 4 arguments (1 given) PS: I'm french so you can speak french or english..

  Hi I use Open ERP 4.2.3.3 "all in one" and magento 1.2.1 and the extension Smile_OpenERP_Synchro 0.9.9 (beta) and the last trunk of magento_openerp_smile of your site in the source. I do the tests with my website wich is already on a webhosting internet and the openerp whis is in my localhost computer. I have this errero when I try to synchronize openerp and magento for only import sales orders,product and category... please help. code de l'erreur: connect() takes at least 4 arguments (1 given) Traceback (most recent call last): File "netsvc.pyo", line 338, in run File "service\web_services.pyo", line 422, in execute File "service\web_services.pyo", line 402, in _execute File "wizard\__init__.pyo", line 160, in execute File "wizard\__init__.pyo", line 75, in execute_cr File "C:\Program Files\TinyERP Server\addons\exmagen.zip\exmagen\wizard\magento_product_synchronize.py", line 52, in do_export TypeError: connect() takes at least 4 arguments (1 given) PS: I'm french so you can speak french or english..
• Mar 15, 2009

  issue 28 (Import sales orders) commented on by broly972   -   ah oui , je précise que je suis français donc vous pouvez vous exprimez soit en anglais ou français...

  ah oui , je précise que je suis français donc vous pouvez vous exprimez soit en anglais ou français...
• Mar 15, 2009

  issue 28 (Import sales orders) commented on by broly972   -   Hello the cause of the previous problem is because I have installed several magento connectors in the same openerpweb... assert not netsvc.service_exist('wizard.'+name), 'The wizard "%s" already exists!'%name AssertionError: The wizard "magento.products.sync" already exists! But I have another error now when I try "import sale orders": ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden> I have another question: what is the best trunk revision connector for magento 1.2.1? is it the trunk revision 150? 140? 139? and what is also the best openerp version for magento 1.2.1 please help me. Traceback (most recent call last): File "/home/sisalpuser/openerp/dev5/server/bin/netsvc.py", line 231, in dispatch result = LocalService(service_name)(method, *params) File "/home/sisalpuser/openerp/dev5/server/bin/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/home/sisalpuser/openerp/dev5/server/bin/service/web_services.py", line 552, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/home/sisalpuser/openerp/dev5/server/bin/service/web_services.py", line 532, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/home/sisalpuser/openerp/dev5/server/bin/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/home/sisalpuser/openerp/dev5/server/bin/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/home/sisalpuser/openerp/dev5/server/bin/addons/exmagen.zip/exmagen/wizard/magento_so_import.py", line 75, in _do_import sale_order_array = server.sale_orders_sync(last_order_id) File "/usr/lib/python2.5/xmlrpclib.py", line 1147, in __call__ return self.__send(self.__name, args) File "/usr/lib/python2.5/xmlrpclib.py", line 1437, in __request verbose=self.__verbose File "/usr/lib/python2.5/xmlrpclib.py", line 1191, in request headers ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden>

  Hello the cause of the previous problem is because I have installed several magento connectors in the same openerpweb... assert not netsvc.service_exist('wizard.'+name), 'The wizard "%s" already exists!'%name AssertionError: The wizard "magento.products.sync" already exists! But I have another error now when I try "import sale orders": ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden> I have another question: what is the best trunk revision connector for magento 1.2.1? is it the trunk revision 150? 140? 139? and what is also the best openerp version for magento 1.2.1 please help me. Traceback (most recent call last): File "/home/sisalpuser/openerp/dev5/server/bin/netsvc.py", line 231, in dispatch result = LocalService(service_name)(method, *params) File "/home/sisalpuser/openerp/dev5/server/bin/netsvc.py", line 74, in __call__ return getattr(self, method)(*params) File "/home/sisalpuser/openerp/dev5/server/bin/service/web_services.py", line 552, in execute return self._execute(db, uid, wiz_id, datas, action, context) File "/home/sisalpuser/openerp/dev5/server/bin/service/web_services.py", line 532, in _execute return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context) File "/home/sisalpuser/openerp/dev5/server/bin/wizard/__init__.py", line 178, in execute res = self.execute_cr(cr, uid, data, state, context) File "/home/sisalpuser/openerp/dev5/server/bin/wizard/__init__.py", line 74, in execute_cr action_res = action(self, cr, uid, data, context) File "/home/sisalpuser/openerp/dev5/server/bin/addons/exmagen.zip/exmagen/wizard/magento_so_import.py", line 75, in _do_import sale_order_array = server.sale_orders_sync(last_order_id) File "/usr/lib/python2.5/xmlrpclib.py", line 1147, in __call__ return self.__send(self.__name, args) File "/usr/lib/python2.5/xmlrpclib.py", line 1437, in __request verbose=self.__verbose File "/usr/lib/python2.5/xmlrpclib.py", line 1191, in request headers ProtocolError: <ProtocolError for XXXXXX.com/magento/app/code/local/Smile/OpenERPSync/openerp-synchro.php: 403 Forbidden>