thaond / magento-openerp-smile-synchro Goto Github PK

the OpenERP module version 0.9.3 depends on Python 2.5 due to constructions
such as:
{{{
File
"/usr/lib/python2.4/site-packages/tinyerp-server/addons/magento_openerp_smile/wi
zard/magento_so_import.py",
line 152
'partner_id': partner_id[0] if type(partner_id)== list else partner_id, 
}}}

Of course we recommend to use Python 2.5, but we could certainly change
those constructs to accept Python 2.4.

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..

When installing through magento connect the php page installs in: 
magento/app/code/local/  instead of magento/app/code/community/

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

1. Creating a product in openERP checking "Export to website" (product is
listed in magento)
2. Editing the product in openERP unchecking "Export to website"
3. Getting "No module named wizard"

openerp-server says:

Traceback (most recent call last):
File "/usr/src/openerp-server-5.0.0-rc1.1/bin/osv/osv.py", line 85, in
execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/root/openerp-server/bin/addons/magento_openerp/magento.py", line 60,
in write
wizard.magento_product_synchronize.do_export(self, cr, uid, datas, context)
File
"/root/openerp-server/bin/addons/magento_openerp/wizard/magento_product_synchron
ize.py",
line 72, in do_export
raise wizard.except_wizard("Error", "you asked to export non-exportable
products : IDs %s" % prod_not)
except_wizard: ('Error', 'you asked to export non-exportable products : IDs
[2]')


It happens with openerp-server-5.0.0-rc1.1 and Magento 1.1.8

Trying to set "Magento product id" to 0, openERP saves product, but magento
returns "Magento Export:Magento API return an error on product id 2 . Error
<Fault 1: 'Il valore dell\'attributo "SKU" deve essere unico'>" (value of
attribute SKU must be unique)

What steps will reproduce the problem?
1. Install the addons to both magento and openerp
2. Try sync categories 

What is the expected output? What do you see instead?

Expect to see an attempt to sync categories. Instead I get 

  File
"/usr/lib/python2.4/site-packages/tinyerp-server/addons/magento_openerp_smile/wi
zard/magento_cat
e.py", line 112, in _do_export
    category_id = server.category_sync([webcategory])
  File "/usr/lib/python2.4/xmlrpclib.py", line 1096, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.4/xmlrpclib.py", line 1383, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.4/xmlrpclib.py", line 1147, in request
    return self._parse_response(h.getfile(), sock)
  File "/usr/lib/python2.4/xmlrpclib.py", line 1286, in _parse_response
    return u.close()
  File "/usr/lib/python2.4/xmlrpclib.py", line 744, in close
    raise Fault(**self._stack[0])
Fault: <Fault 620: 'Method "category_sync" does not exist'>


This method simply doesn't exist. 

The contributed code by Charles Galpin to provide sale order push to
Magento has not been tested enough and, moreover, it's not properly done.

Mostly, we don't want Magento to do himself all the work of pushing orders
back to OpenERP. Instead, what we want is Magento to CALL OpenERP to tell
him to grab the given (with id) sale order from Magento using the usual
sale order import method. This will maximize code reuse and avoid doing
complex things on the Magento side.

Consenquently, I believe the magento_utils.py should be removed totally
after refactoring. Of course the PHP part should take this into account.

Finally, the feature should deal about possible network/OpenERP errors.
Meaning that if Magento don't manage to have a sale order imported by
OpenERP then he should remember it somewhere for later re-import.

Currently, product images should be manually uploaded in the Magento catalog.
Of course, having images attached to product inside OpenERP (via the
product_image existing module) and send upload them along with the whole
catalog export to Magento would be a must.

Don't hesitate to contribute that feature. What might be used is the the
new Magento product image API documented here:
http://www.magentocommerce.com/wiki/doc/webservices-api/api#product_images_api
, especially the create and update webservices.

In the current code, wizard tend to do everything. But this is bad because
wizard are hardly OOP. To be more OOP we should move most of wizard code
back to the OpenERP object overriders and just call those methods from the
wizards.

Currently, because we were unsure about how the Magento muti-store feature
works, we allow only one OpenERP shop to have a corresponding Magento id
and then we actually synchronize everything inside Magento according to
that unique OpenERP shop.

But since an OpenERP shop defaults to a specific warehouse, that we
actually be a good opportunity to add advanced multi-warehouse capabilities
to Magento. To do that, we would ideally map one Magento store to one
OpenERP shop.

Our demo video could finally live inside our wiki webpages, see:
http://google-code-updates.blogspot.com/2008/10/gadgets-and-google-code.html

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 5.0.0 "all in one"   and  magento 1.2.1and the extension
Smile_OpenERP_Synchro  0.9.9 (beta)
and magento_openerp_smile-0.9.9.zip
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 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



It  works perfectly for the installation but when i want to use the
function "import sales orders", it doesn't work....
With the function "import categories" and "import products" , it works...
when I replaced all the files of  magento_openerp_smile-0.9.9.zip module
with your files trunk , it doesn't work also:
 Changelog  2.7 KB  r128    Nov 18, 2008    GrouhPamart
__init__.py 51 bytes    r128    Nov 18, 2008    GrouhPamart
__terp__.py 789 bytes   r135    Jan 15, 2009    rvalyi
magento.py  9.3 KB  r136    Jan 15, 2009    rvalyi
magento_data.xml    1.7 KB  r136    Jan 15, 2009    rvalyi
magento_utils.py    8.6 KB  r128    Nov 18, 2008    GrouhPamart
magento_view.xml    6.7 KB  r131    Dec 10, 2008    GrouhPamart
magento_wizard.xml  1.7 KB  r131    Dec 10, 2008    GrouhPamart

Filename    Size    Rev     Date    Author
__init__.py 172 bytes   r121    Nov 11, 2008    rvalyi
magento_category_synchronize.py 7.2 KB  r136    Jan 15, 2009    rvalyi
magento_product_synchronize.py  8.7 KB  r136    Jan 15, 2009    rvalyi
magento_so_correct.py   5.8 KB  r136    Jan 15, 2009    rvalyi
magento_so_import.py    12.3 KB r136    Jan 15, 2009    rvalyi
magento_so_update.py    4.0 KB  r149    Jan 31, 2009    rvalyi

1. I uploaded products to Magento
2. Magento user creates an order
3. Through OpenERP, Magento->Synchronization->Import sale orders

I get in openerp-server console:

File
"/root/openerp-server/bin/addons/magento_openerp/wizard/magento_so_import.py",
line 224, in do_import
    ship_product=self.pool.get('product.product').browse(cr, uid,
ship_product_id[0])
IndexError: list index out of range


This happens with openerp-server-5.0.0-rc1.1 and Magento 1.1.8

What about this "ship_product_id"? What should it contain?

Regards,
LB

What steps will reproduce the problem?
1. Try grab the source code using svn per
http://code.google.com/p/magento-openerp-smile-synchro/source/checkout
which says

svn checkout http://magento-openerp-smile-synchro.googlecode.com/svn/trunk/
magento-openerp-smile-synchro-read-only

What is the expected output? What do you see instead?

I expected to get the most recent source code, but instead got a empty
directory

Please use labels and text to provide additional information.

The work around is

svn checkout
http://magento-openerp-smile-synchro.googlecode.com/svn/magento_openerp_smile/
magento-openerp-smile-synchro

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

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

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_sync
hro/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!

Ideally, uploadable records such as products that can be many should have a
wizard button in their OpenERP form view so that one can update the edited
record on Magento in a single click.

Ideally, the upload wizard would take an 'ids' argument that would be only
[the_current_id] when displaying a specific record (form view) or a list of
several ids if selecting the records to update from a list view.
This is provided by the standard OpenERP system. Only the upload action
should be coded with the appropriate signature.

Also, that upload action should actually have most of its code multualized
with the already existing mass upload wizard that upload all products fro
instance without getting the ids passed currently.

So for instance, to upload selected products, one would use most of the
code of the def _do_export(self, cr, uid, data, context) method in wizard/
magento_product_synchronize.py
but instead of getting products ids with prod_ids =
pool.get('product.product').search(cr, uid, [('exportable','=',True)]) , we
would use the passed ids in the wizard method signature.


That wouldn't make uploading 25 000 products any faster, but that could
make it easier to maintain them in synch.

Any taker?

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?

For some unknown reason, it looks like the products you export from OpenERP
to Magento aren't displayed in the Magento back-office while they seem to
be correctly entered inside the database.

It looks like this bugs only affect version 1.1.1 of Magento and not
version 1.1. We are investigating the issue and hope to find a fix quickly.

Raphaël Valyi.

category tree export was failing in Magento 1.1.6 because we were not
exporting products in the right order according to their category hierarchy
(you can't add a child before it's root category). A fix will be committed
in 5 minutes

Raphaël Valyi.

When i try to sync or import sales orders.. i get this..

Traceback (most recent call last):
  File "netsvc.pyo", line 200, in _dispatch
  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\magento_openerp_smile.zip\magento_openerp_smile\wizard\magent
o_so_import.py", line 97, in _do_import
  File "xmlrpclib.pyo", line 1147, in __call__
  File "xmlrpclib.pyo", line 1437, in __request
  File "xmlrpclib.pyo", line 1183, in request
  File "xmlrpclib.pyo", line 1297, in send_content
  File "httplib.pyo", line 856, in endheaders
  File "httplib.pyo", line 728, in _send_output
  File "httplib.pyo", line 695, in send
  File "httplib.pyo", line 679, in connect
error: (10060, 'Operation timed out')

What steps will reproduce the problem?
1. Fresh install of a new openerp database (service profile)
2. Donwloaded and installed the latest trunk
3. Synchronize categories

What is the expected output? What do you see instead?
When the category is not yet in Magento (Magento Category ID in magento is
still 0) the upload works OK en the Category is created in Magento.
When changing same category and run a synchroniss i get this Error:

global name 'category_magento_id' is not defined.


What version of the product are you using? On what operating system?
Window XP Media Center SP3
OpenERP AllinOne 5.0.0.3 stable
Magento store 1.2.1
Latest Magento OpenERP Smile Synchro


Please provide any additional information below.

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

The connector web services are currently exposed in an unprotected manner
to the world. This is very important you prevent anyone from connecting to
the webservice page (
http://localhost/magento/app/code/community/Smile_OpenERP_Synchro/openerp-synchr
o.php
) by tunning your server (probably Apache). Ideally only the OpenERP server
could connect to that page (same as the test page). Using Magento ACL based
webservices would improve that situation a lot. Please don't hesitate to
contribute such an improvement. the Magento webservices API guidelines have
just been published here:
http://www.magentocommerce.com/wiki/doc/webservices-api/custom-api 

Any taker?

What steps will reproduce the problem?
1. In Open ERP Client -> Sales Management -> Magento -> Synchronize
Products and Stocks

What is the expected output? What do you see instead?

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_smile.zip\magento_openerp_smile\wizard\ma
gento_product_synchronize.py",
line 117, in _do_export
  File "xmlrpclib.pyo", line 1147, in __call__
  File "xmlrpclib.pyo", line 1437, in __request
  File "xmlrpclib.pyo", line 1201, in request
  File "xmlrpclib.pyo", line 1340, in _parse_response
  File "xmlrpclib.pyo", line 785, in close
ResponseError: ResponseError()


What version of the product are you using? On what operating system?
Open ERP 5.0 (downloaded 3 days ago). Latest version of the Magento synchro
downloaded from here. 

Under the Magento Web section in Open ERP it only asks for Magento Web
Name, magento web id and url. It does not ask for the username/password
like I see on screen shots on here. 

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.

the current XML/RPC from http://phpxmlrpc.sourceforge.net/
looks pretty crappy and PHP4 targeted. Let's try to move out of that.

I try to run the php in the browser and i get

Fatal error: Call to undefined function getallheaders() 
in /public_html/magento/app/code/community/Smile_OpenERP_Synchro/openerp-
synchro.php on line 220


getallheaders() function is not in the php file at all..

[deleted issue]

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

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_service
s.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_service
s.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_open
erp_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"

See report here:
http://groups.google.com/group/magento-openerp/browse_thread/thread/16d89cdff0cd
0b10

Workaround: change 'esearch' into 'search' as suggested. We will soon make
a new release!

Raphaël Valyi.

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_produc
t_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 ?

while  I was trying to synchronize 20000 products, I got the following error. 


Thu, 18 Sep 2008 14:48:25 ERROR:web-services:Exception in call: Traceback
(most recent call last):
  File "/usr/lib/python2.4/site-packages/tinyerp-server/netsvc.py", line
200, in _dispatch
    r=m(*params)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/service/web_services.py",
line 422, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/service/web_services.py",
line 402, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/wizard/__init__.py", line
160, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/wizard/__init__.py", line
75, in execute_cr
    action_res = action(self, cr, uid, data, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/addons/magento_openerp_smile.zi
p/magento_openerp_smile/wizard/magento_product_synchronize.py",
line 87, in _do_export
  File "/usr/lib/python2.4/site-packages/tinyerp-server/osv/orm.py", line
196, in __getattr__
    return self[name]
  File "/usr/lib/python2.4/site-packages/tinyerp-server/osv/orm.py", line
173, in __getitem__
    datas = self._table.read(self._cr, self._uid, ids, map(lambda x: x[0],
ffields), context=self._context, load="_classic_write")
  File "/usr/lib/python2.4/site-packages/tinyerp-server/osv/orm.py", line
821, in read
    result =  self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/python2.4/site-packages/tinyerp-server/osv/orm.py", line
852, in _read_flat
    cr.execute('select %s from \"%s\" where id in (%s) order by %s' %
(','.join(fields_pre2 + ['id']), self._table, ','.join([str(x) for x in
ids]), self._order))
  File "/usr/lib/python2.4/site-packages/tinyerp-server/sql_db.py", line
75, in execute
    res = self.obj.execute(sql)

I was using the 0.9.7 version

When the first magento product is created, the magento_product_sync.py
script fails.

the magento product is created, but the python script can't understand the
answer from the magento server.


Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/tinyerp-server/netsvc.py", line
202, in _dispatch
    r=m(*params)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/service/web_services.py",
line 422, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/service/web_services.py",
line 402, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/wizard/__init__.py", line
160, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/wizard/__init__.py", line
75, in execute_cr
    action_res = action(self, cr, uid, data, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/addons/magento_openerp_smile/wi
zard/magento_product_synchronize.py",
line 139, in _do_export
    new_id=server.call(session, 'product.create', ['simple',attr_set_id,
sku, product_data])
  File "xmlrpclib.py", line 1096, in __call__
    return self.__send(self.__name, args)
  File "xmlrpclib.py", line 1383, in __request
    verbose=self.__verbose
  File "xmlrpclib.py", line 1147, in request
    return self._parse_response(h.getfile(), sock)
  File "xmlrpclib.py", line 1281, in _parse_response
    p.feed(response)
  File "xmlrpclib.py", line 527, in feed
    self._parser.Parse(data, 0)
ExpatError: junk after document element: line 2, column 0

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/mage
nto_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-addon
s

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 [email protected] 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-addo
ns/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!

title says it all

Simply install trunk version with revision 150.
Many thanks to eLBati for reporting the issue:
http://groups.google.com/group/magento-openerp/browse_thread/thread/459688bace95
8f80

This was a commit mistake, we forgot to commit something, sorry about that.
Fix coming.

What steps will reproduce the problem?
1. Install magento-openerp-smile-synchro  module
2. Edit a product (I tried with several products, even a new one)
3. Save the product
You get the message : 'module' object has no attribute 'do_export'

Traceback (most recent call last):
  File "netsvc.pyo", line 200, in _dispatch
  File "service\web_services.pyo", line 366, in execute
  File "osv\osv.pyo", line 111, in execute
  File "osv\osv.pyo", line 92, in execute_cr
  File "E:\Program Files\TinyERP Server\addons\magento_openerp\magento.py",
line 53, in write
AttributeError: 'module' object has no attribute 'do_export'

This doesn't occur when you create a new product, only when you save after
editing, after the first save (when creating)

What is the expected output? What do you see instead?
Expected : no error
What I see : the error message "Traceback (most recent call last):
  File "netsvc.pyo", line 200, in _dispatch
  File "service\web_services.pyo", line 366, in execute
  File "osv\osv.pyo", line 111, in execute
  File "osv\osv.pyo", line 92, in execute_cr
  File "E:\Program Files\TinyERP Server\addons\magento_openerp\magento.py",
line 53, in write
AttributeError: 'module' object has no attribute 'do_export'
"

What version of the product are you using? On what operating system?
Tiny ERP - Client GTK - v4.2.3.3
magento_openerp_smile-0.9.8  

I tried this on several machines, and OS (windows) : vista AND XP both have
the problem, after a clean install of tinyerp (deleted also registry keys,
files, and DB before reinstalling)

Same problem regardless I use postgress 8.2 or 8.3...

Thank you very much for your help.

hey,
when i try to synchronize the products i get the following error. the first
product is created in magento, but i guess, when the script tries to update
the openerp table it dies with the following error message:

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/tinyerp-server/netsvc.py", line
200, in _dispatch
    r=m(*params)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/service/web_services.py",
line 422, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/service/web_services.py",
line 402, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/wizard/__init__.py", line
160, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/wizard/__init__.py", line
75, in execute_cr
    action_res = action(self, cr, uid, data, context)
  File
"/usr/lib/python2.4/site-packages/tinyerp-server/addons/magento_openerp_smile/wi
zard/magento_product_synchronize.py",
line 127, in _do_export
KeyError: 'product_id'




What version of the product are you using? On what operating system?


Please provide any additional information below.

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

As said in the FAQ, OpenERP require more precision on some fields to adapt
the Magento discount/tax system.

Instead of having to do this after module installtion via SQL or PGAdmin,
it would be nice to automatically fire the ALTER COLUMN inside the init
module method, just like regular SQL view creations in OpenERP reporting
modules.
Should be very easy.

Raphaël Valyi

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

Those attributes are affected to categories instead of products.

Hi,
i'm trying to import sale orders through TinyERP, and I'm getting the
following error msg.:

ConnectionError
Couldn't connect to Magento with URL
http://localhost/magento/index.php/api/xmlrpc

Could you please tell me, how to solve the connection problem? 
Thx.

What steps will reproduce the problem?
1. Install Magento 1.1.7
2. Install magento-openerp-smile-synchro
3. Copied the XML into the etc file
5. try the test URL's

and tried the pure path and check the file permissions.
rwxrwxrwx 1 www-data www-data 11013 25. Nov 19:30 openerp-synchro.php 


What is the expected output? What do you see instead?
XML output would be expected, but only a forbidden message comes. That can
be caused by invalid URL's or maybe some .htaccess file
ive tried:
/app/code/local/Smile/OpenERPSync/openerp-synchro.php
/app/code/local/Smile_OpenERP_Synchro/openerp-synchro.php
/app/code/community/Smile_OpenERP_Synchro/openerp-synchro.php

What version of the product are you using? On what operating system?
Magento 1.1.17
synchro 0.9.9


Please provide any additional information below.
your doing a awesome job! Hope keep it up!

Hi,
I want to automate the synchronization of sales orders, without passing  by
a link "import sale order"

best regards

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.