Magento OpenERP Connector

Export catalog bug

Asked by Paul Catinean on 2012-07-15

Environment:

Ubuntu 10.04 (Lucid)
Openerp 6.1 (Revision 4232)
Magento ver. 1.7.0.2

I have downloaded the three versions of magentoerpconnect: Legacy Module, 6.1 Module, Trunk Module

Absolutely none of the above have worked in exporting the catalog:

1. Legacy Module

    - Complains about (<Fault 103: 'Default Product Listing Sort by not exists on Available Product Listing Sort By'>)
    - Ran query on magento side: update eav_attribute set is_required = 0 where attribute_code = 'available_sort_by'; -> Nothing changes!
    - Altered the data dictionary that get passed into ext_update (data['available_sort_by'] = [''], data['default_sort_by'] = '')
    - I export catalog after that, no errors but NOTHING gets exported

Bare in mind that i firstly import everything (products, categories, partners) then i duplicate a Root Catalog -> Category have export to magento clicked, change the name...NOTHING gets exported

2. 6.1 Module

- On Export Catalog i get TypeError: object of type 'bool' has no len() (same test case and procedure as above)

3. Trunk version

[code]
2012-07-15 10:05:05,104 6355 INFO ? Magento-Trunk: Login Successful
2012-07-15 10:05:05,175 6355 INFO ? Magento-Trunk: Start to export the ressource product.category
2012-07-15 10:05:05,232 6355 INFO ? Magento-Trunk: Retrieve the list of ids to export for the ressource product.category
2012-07-15 10:05:05,240 6355 INFO ? Magento-Trunk: 1 product.category ressource will be exported
2012-07-15 10:05:05,244 6355 INFO ? Magento-Trunk: Start to read the ressource product.category : [5]
2012-07-15 10:05:05,308 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.category : 5
2012-07-15 10:05:05,325 6355 INFO ? Magento-Trunk: Calling Method:catalog_category.update,Arguments:[2, {u'meta_description': u'', u'meta_title': u'', u'meta_keywords': u'', u'name': u'Default Category', u'is_active': 1, 'default_sort_by': u'None', 'page_layout': u'No layout updates', u'include_in_menu': 1, u'is_anchor': 0, 'magento_exportable': True, u'url_key': u'default-category', 'available_sort_by': u'None', u'description': u''}, False]
2012-07-15 10:05:06,438 6355 INFO ? Magento-Trunk: Query Returned:True
2012-07-15 10:05:06,439 6355 INFO ? Magento-Trunk: Calling Method:catalog_category.move,Arguments:[2, 1]
2012-07-15 10:05:07,655 6355 INFO ? Magento-Trunk: Query Returned:True
2012-07-15 10:05:07,745 6355 INFO ? Magento-Trunk: Attempting connection with Settings:http://localhost/magento/index.php/api/xmlrpc/,openerp,123456
2012-07-15 10:05:08,633 6355 INFO ? Magento-Trunk: Login Successful
2012-07-15 10:05:08,685 6355 INFO ? Magento-Trunk: Start to export the ressource product.product
2012-07-15 10:05:08,748 6355 INFO ? Magento-Trunk: Retrieve the list of ids to export for the ressource product.product
2012-07-15 10:05:08,750 6355 INFO ? Magento-Trunk: 6 product.product ressource will be exported
2012-07-15 10:05:08,759 6355 INFO ? Magento-Trunk: Start to read the ressource product.product : [1, 2, 3, 4, 5, 6]
2012-07-15 10:05:10,101 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 1
2012-07-15 10:05:10,330 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:10,376 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, '', {u'name': u'Service on Timesheet', u'weight': 0.0, u'price': 75.0, 'websites': [1], u'short_description': '', 'categories': [1], u'description': ''}]
2012-07-15 10:05:11,297 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:11,329 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 2
2012-07-15 10:05:11,485 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:11,509 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, u'SHIP', {u'name': u'Shipping costs', u'weight': 0.0, u'price': 0.0, 'websites': [1], u'short_description': '', 'categories': [2], u'description': ''}]
2012-07-15 10:05:12,384 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:12,418 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 3
2012-07-15 10:05:12,574 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:12,597 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, u'CASH ON DELIVERY', {u'name': u'Cash on delivery', u'weight': 0.0, u'price': 0.0, 'websites': [1], u'short_description': '', 'categories': [2], u'description': ''}]
2012-07-15 10:05:13,462 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:13,495 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 4
2012-07-15 10:05:13,663 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:13,686 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, u'GIFT CERTIFICATE', {u'name': u'Gift Certificate', u'weight': 0.0, u'price': 0.0, 'websites': [1], u'short_description': '', 'categories': [2], u'description': ''}]
2012-07-15 10:05:14,564 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:14,595 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 5
2012-07-15 10:05:14,818 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:14,986 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, u'DISCOUNT', {u'name': u'Discount Coupon', u'weight': 0.0, u'price': 0.0, 'websites': [1], u'short_description': '', 'categories': [2], u'description': ''}]
2012-07-15 10:05:15,866 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:15,895 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 6
2012-07-15 10:05:15,914 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.update,Arguments:[1, {u'sku': u'100', u'set': 4, u'name': u'Sample-Product', u'weight': 10.0, 'type_id': u'simple', u'price': 100.0, 'websites': [1], u'short_description': u'Sample', 'categories': [3], u'description': u'Sample-Product'}, False, 'id']
2012-07-15 10:05:17,628 6355 INFO ? Magento-Trunk: Query Returned:True
2012-07-15 10:05:17,647 6355 INFO ? Magento-Trunk: Calling Method:product_stock.update,Arguments:[1, {'use_config_manage_stock': 1, 'is_in_stock': 0, 'manage_stock': 0, 'qty': 0.0}]
2012-07-15 10:05:19,192 6355 INFO ? Magento-Trunk: Query Returned:True
2012-07-15 10:05:19,192 6355 INFO ? Magento-Trunk: Successfully updated stock level at 0.0 for product with code 100
2012-07-15 10:05:19,251 6355 INFO ? Magento-Trunk: Attempting connection with Settings:http://localhost/magento/index.php/api/xmlrpc/,openerp,123456
2012-07-15 10:05:20,154 6355 INFO ? Magento-Trunk: Login Successful
2012-07-15 10:05:20,196 6355 INFO ? Magento-Trunk: Start to export the ressource product.product
2012-07-15 10:05:20,247 6355 INFO ? Magento-Trunk: Retrieve the list of ids to export for the ressource product.product
2012-07-15 10:05:20,249 6355 INFO ? Magento-Trunk: 6 product.product ressource will be exported
2012-07-15 10:05:20,253 6355 INFO ? Magento-Trunk: Start to read the ressource product.product : [1, 2, 3, 4, 5, 6]
2012-07-15 10:05:21,347 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 1
2012-07-15 10:05:21,518 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:21,543 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, '', {u'name': u'Service on Timesheet', u'weight': 0.0, u'price': 75.0, 'websites': [1], u'short_description': '', 'categories': [1], u'description': ''}]
2012-07-15 10:05:22,434 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:22,462 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 2
2012-07-15 10:05:22,652 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:22,676 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, u'SHIP', {u'name': u'Shipping costs', u'weight': 0.0, u'price': 0.0, 'websites': [1], u'short_description': '', 'categories': [2], u'description': ''}]
2012-07-15 10:05:23,567 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:23,595 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 3
2012-07-15 10:05:23,762 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:23,786 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, u'CASH ON DELIVERY', {u'name': u'Cash on delivery', u'weight': 0.0, u'price': 0.0, 'websites': [1], u'short_description': '', 'categories': [2], u'description': ''}]
2012-07-15 10:05:24,674 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:24,706 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 4
2012-07-15 10:05:24,840 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:24,863 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, u'GIFT CERTIFICATE', {u'name': u'Gift Certificate', u'weight': 0.0, u'price': 0.0, 'websites': [1], u'short_description': '', 'categories': [2], u'description': ''}]
2012-07-15 10:05:25,702 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:25,728 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 5
2012-07-15 10:05:25,850 6355 ERROR ? Magento-Trunk: (u"Error with the mapping : default_sort_by. Error details : 'bool' object is unsubscriptable",)
2012-07-15 10:05:25,874 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.create,Arguments:[u'simple', 0, u'DISCOUNT', {u'name': u'Discount Coupon', u'weight': 0.0, u'price': 0.0, 'websites': [1], u'short_description': '', 'categories': [2], u'description': ''}]
2012-07-15 10:05:26,746 6355 ERROR ? Magento-Trunk: Error with xmlrpc protocole. Error details : error 102 : group creation failed due to invalid data.
2012-07-15 10:05:26,772 6355 INFO ? Magento-Trunk: Start to transform and send the ressource product.product : 6
2012-07-15 10:05:26,803 6355 INFO ? Magento-Trunk: Calling Method:ol_catalog_product.update,Arguments:[1, {u'sku': u'100', u'set': 4, u'name': u'Sample-Product', u'weight': 10.0, 'type_id': u'simple', u'price': 100.0, 'websites': [1], u'short_description': u'Sample', 'categories': [3], u'description': u'Sample-Product'}, False, 'id']
[/code]

I also tried selecting a warehouse in the shop, a pricelist, sale journal and export after...nothing works. Even found a branch that had a 1.7.0.0+ referential version, that didn't work either it had the exact same effect as the normal one.

I have also fixed the import product attributes by adding weight to the dictionary, but the above still remain...have i really missed something that bad?