openerp-connector-community team mailing list archive

[Tero Juola <tjuola@xxxxxx>]

Hi Guewen

The addons_path looks like this:
addons_path = /opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/addons,
/opt/bitnami/apps/magentoconnector/connector,
/opt/bitnami/apps/magentoconnector/connector-ecommerce,
/opt/bitnami/apps/magentoconnector/connector-magento,
/opt/bitnami/apps/magentoconnector/e-commerce,
/opt/bitnami/apps/magentoconnector/product-attribute,
/opt/bitnami/apps/magentoconnector/sale-workflow

The file structure looks like this:
apps -> /opt/bitnami/apps

bitnami@ip-172-31-2-22:~/apps$ ls -al
total 20
drwxr-xr-x  5 root   root   4096 Aug  2 11:22 .
drwxr-xr-x 14 root   root   4096 Jul 10 15:26 ..
drwxr-xr-x  3 root   root   4096 Jul 10 15:05 bitnami
drwxrwxr-x  9 daemon daemon 4096 Aug  5 21:22 magentoconnector
drwxr-xr-x 10 daemon daemon 4096 Aug 18 04:47 odoo
bitnami@ip-172-31-2-22:~/apps$ cd magentoconnector
bitnami@ip-172-31-2-22:~/apps/magentoconnector$ ls -al
total 36
drwxrwxr-x  9 daemon daemon 4096 Aug  5 21:22 .
drwxr-xr-x  5 root   root   4096 Aug  2 11:22 ..
drwxrwxr-x  7 daemon daemon 4096 Sep 15 08:20 bank-statement-reconcile
drwxrwxr-x  5 daemon daemon 4096 Oct 11 20:21 connector
drwxrwxr-x  4 daemon daemon 4096 Aug  2 11:23 connector-ecommerce
drwxrwxr-x  6 daemon daemon 4096 Aug  2 11:23 connector-magento
drwxrwxr-x  8 daemon daemon 4096 Oct 19 08:11 e-commerce
drwxrwxr-x 11 daemon daemon 4096 Aug  2 11:24 product-attribute
drwxrwxr-x 25 daemon daemon 4096 Oct 11 20:23 sale-workflow
bitnami@ip-172-31-2-22:~/apps/magentoconnector$ cd connector-magento
bitnami@ip-172-31-2-22:~/apps/magentoconnector/connector-magento$ ls -al
total 84
drwxrwxr-x  6 daemon daemon  4096 Aug  2 11:23 .
drwxrwxr-x  9 daemon daemon  4096 Aug  5 21:22 ..
drwxrwxr-x  8 daemon daemon  4096 Aug  2 11:23 .git
-rw-rw-r--  1 daemon daemon   556 Aug  2 11:23 .gitignore
-rw-rw-r--  1 daemon daemon  1770 Aug  2 11:23 .travis.yml
-rw-rw-r--  1 daemon daemon   193 Aug  2 11:23 .travis_build_doc
-rw-rw-r--  1 daemon daemon   605 Aug  2 11:23 .travis_push_doc
-rw-rw-r--  1 daemon daemon 34499 Aug  2 11:23 LICENSE
-rw-rw-r--  1 daemon daemon  1004 Aug  2 11:23 README.md
drwxrwxr-x  8 daemon daemon  4096 Aug  2 11:23 __unported__
drwxrwxr-x  2 daemon daemon  4096 Oct  7 08:12 customize_example
drwxrwxr-x 10 daemon daemon  4096 Aug  2 11:41 magentoerpconnect
-rw-rw-r--  1 daemon daemon    86 Aug  2 11:23 ca_dependencies.txt
bitnami@ip-172-31-2-22:~/apps/magentoconnector/connector-magento$ cd magentoerpconnect
bitnami@ip-172-31-2-22:~/apps/magentoconnector/connector-magento/magentoerpconnect$ ls -al
total 540
drwxrwxr-x 10 daemon daemon  4096 Aug  2 11:41 .
drwxrwxr-x  6 daemon daemon  4096 Aug  2 11:23 ..
-rw-rw-r--  1 daemon daemon   726 Aug  2 11:23 AUTHORS
-rw-rw-r--  1 daemon daemon  6934 Aug  2 11:23 CHANGES.rst
-rw-rw-r--  1 daemon daemon  3995 Aug  2 11:23 README.rst
-rw-rw-r--  1 daemon daemon   401 Aug  2 11:23 __init__.py
-rw-rw-r--  1 daemon daemon   822 Aug  2 11:41 __init__.pyc
-rw-rw-r--  1 daemon daemon  2126 Aug  2 11:23 __openerp__.py
-rw-rw-r--  1 daemon daemon  1162 Aug  2 11:23 backend.py
-rw-rw-r--  1 daemon daemon   389 Aug  2 11:41 backend.pyc
-rw-rw-r--  1 daemon daemon  3241 Aug  2 11:23 connector.py
-rw-rw-r--  1 daemon daemon  2907 Aug  2 11:41 connector.pyc
-rw-rw-r--  1 daemon daemon  2572 Aug  2 11:23 consumer.py
-rw-rw-r--  1 daemon daemon  2179 Aug  2 11:41 consumer.pyc
-rw-rw-r--  1 daemon daemon  2686 Aug  2 11:23 delivery.py
-rw-rw-r--  1 daemon daemon  1930 Aug  2 11:41 delivery.pyc
-rw-rw-r--  1 daemon daemon   782 Aug  2 11:23 delivery_view.xml
drwxrwxr-x  9 daemon daemon  4096 Aug  2 11:23 doc
-rw-rw-r--  1 daemon daemon  1109 Aug  2 11:23 exception.py
-rw-rw-r--  1 daemon daemon   572 Aug  2 11:41 exception.pyc
drwxrwxr-x  2 daemon daemon  4096 Aug  2 11:23 i18n
drwxrwxr-x  2 daemon daemon  4096 Aug  2 11:23 images
-rw-rw-r--  1 daemon daemon 11031 Aug  2 11:23 invoice.py
-rw-rw-r--  1 daemon daemon  9651 Aug  2 11:41 invoice.pyc
-rw-rw-r--  1 daemon daemon  1931 Aug  2 11:23 invoice_view.xml
-rw-rw-r--  1 daemon daemon 23864 Aug  2 11:23 magento_model.py
-rw-rw-r--  1 daemon daemon 24178 Aug  2 11:41 magento_model.pyc
-rw-rw-r--  1 daemon daemon 18557 Aug  2 11:23 magento_model_view.xml
-rw-rw-r--  1 daemon daemon  5966 Aug  2 11:23 magentoerpconnect_data.xml
-rw-rw-r--  1 daemon daemon   897 Aug  2 11:23 magentoerpconnect_menu.xml
drwxrwxr-x  4 daemon daemon  4096 Aug  2 11:23 migrations
-rw-rw-r--  1 daemon daemon 23838 Aug  2 11:23 partner.py
-rw-rw-r--  1 daemon daemon 24084 Aug  2 11:41 partner.pyc
-rw-rw-r--  1 daemon daemon  3708 Aug  2 11:23 partner_category.py
-rw-rw-r--  1 daemon daemon  4319 Aug  2 11:41 partner_category.pyc
-rw-rw-r--  1 daemon daemon  4915 Aug  2 11:23 partner_view.xml
-rw-rw-r--  1 daemon daemon   582 Aug  2 11:23 payment_method.py
-rw-rw-r--  1 daemon daemon   987 Aug  2 11:41 payment_method.pyc
-rw-rw-r--  1 daemon daemon   578 Aug  2 11:23 payment_method_view.xml
-rw-rw-r--  1 daemon daemon 25521 Aug  2 11:23 product.py
-rw-rw-r--  1 daemon daemon 26913 Aug  2 11:41 product.pyc
-rw-rw-r--  1 daemon daemon 10089 Aug  2 11:23 product_category.py
-rw-rw-r--  1 daemon daemon 11008 Aug  2 11:41 product_category.pyc
-rw-rw-r--  1 daemon daemon  4820 Aug  2 11:23 product_view.xml
-rw-rw-r--  1 daemon daemon  2270 Aug  2 11:23 related_action.py
-rw-rw-r--  1 daemon daemon  1672 Aug  2 11:41 related_action.pyc
-rw-rw-r--  1 daemon daemon 44647 Aug  2 11:23 sale.py
-rw-rw-r--  1 daemon daemon 39453 Aug  2 11:41 sale.pyc
-rw-rw-r--  1 daemon daemon    85 Aug  2 11:23 sale_view.xml
drwxrwxr-x  2 daemon daemon  4096 Aug  2 11:23 security
-rw-rw-r--  1 daemon daemon  1537 Aug  2 11:23 setting.py
-rw-rw-r--  1 daemon daemon  1000 Aug  2 11:41 setting.pyc
-rw-rw-r--  1 daemon daemon  1570 Aug  2 11:23 setting_view.xml
drwxrwxr-x  3 daemon daemon  4096 Aug  2 11:23 static
-rw-rw-r--  1 daemon daemon 10625 Aug  2 11:23 stock_picking.py
-rw-rw-r--  1 daemon daemon  9999 Aug  2 11:41 stock_picking.pyc
-rw-rw-r--  1 daemon daemon  6160 Aug  2 11:23 stock_tracking.py
-rw-rw-r--  1 daemon daemon  5084 Aug  2 11:41 stock_tracking.pyc
-rw-rw-r--  1 daemon daemon  2063 Aug  2 11:23 stock_view.xml
drwxrwxr-x  2 daemon daemon  4096 Aug  2 11:23 tests
drwxrwxr-x  2 daemon daemon  4096 Aug  2 11:41 unit

Tero



> On 19 Oct 2015, at 11:59, Guewen Baconnier <guewen.baconnier@xxxxxxxxxxxxxx> wrote:
> 
> Because you probably hadn't cloned the entire repository: https://github.com/OCA/connector-magento/ <https://github.com/OCA/connector-magento/>
> Best practices are:
> 1. clone the full repository somewhere
> 2. modify the odoo configuration file and add the path of 'connector-magento' in 'addons_path'
> 
> 
> -- 
> Guewen Baconnier
> Business Solutions Software Developer
> 
> Camptocamp SA
> PSE A, CH-1015 Lausanne
> Phone: +41 21 619 10 39
> Office: +41 21 619 10 10
> http://www.camptocamp.com/ <http://www.camptocamp.com/>
> On Mon, Oct 19, 2015 at 10:51 AM, Tero Juola <tjuola@xxxxxx <mailto:tjuola@xxxxxx>> wrote:
> Another question:
> When I try to enable Magentoerpconnect Extensions: Prices are managed in OpenERP with pricelists in Settings, Connector I get this error message:
> Odoo
> 
> Odoo Server Error
> Traceback (most recent call last):
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 537, in _handle_exception
>     return super(JsonRequest, self)._handle_exception(exception)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 574, in dispatch
>     result = self._call_function(**self.params)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 310, in _call_function
>     return checked_call(self.db, *args, **kwargs)
>   File "/home/odoo/src/odoo/8.0/openerp/service/model.py", line 113, in wrapper
>     return f(dbname, *args, **kwargs)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 307, in checked_call
>     return self.endpoint(*a, **kw)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 803, in __call__
>     return self.method(*args, **kw)
>   File "/home/odoo/src/odoo/8.0/openerp/http.py", line 403, in response_wrap
>     response = f(*args, **kw)
>   File "/home/odoo/src/custom/private/loempia/controllers/embed.py", line 49, in download_urls
>     mods_to_install = Modules.compute_modules_to_install(series, module_names, local_modules)
>   File "/home/odoo/src/odoo/8.0/openerp/api.py", line 239, in wrapper
>     return new_api(self, *args, **kwargs)
>   File "/home/odoo/src/custom/private/loempia/loempia2.py", line 996, in compute_modules_to_install
>     assert len(mids) == len(set(requested_mods)), 'Unknown modules requested: %r' % requested_mods
> AssertionError: Unknown modules requested: ['magentoerpconnect_pricing']
> 
> Tero
> 
> 
>> On 19 Oct 2015, at 11:20, Tero Juola <tjuola@xxxxxx <mailto:tjuola@xxxxxx>> wrote:
>> 
>> Hi Guewen
>> 
>> Thank you. You are the Man :)
>> 
>> Tero
>> 
>>> On 19 Oct 2015, at 11:02, Guewen Baconnier <guewen.baconnier@xxxxxxxxxxxxxx <mailto:guewen.baconnier@xxxxxxxxxxxxxx>> wrote:
>>> 
>>> On Mon, Oct 19, 2015 at 9:57 AM, Tero Juola <tjuola@xxxxxx <mailto:tjuola@xxxxxx>> wrote:
>>> Hi
>>> 
>>> I get following error message when Odoo tries to import (scheduled) sales order from Magento:
>>> openerp.addons.magentoerpconnect.unit.import_synchronizer.import_record('magento.sale.order', 1, '400001143’)
>>> 
>>> This has worked fine before.
>>> 
>>> Traceback (most recent call last): File "/opt/bitnami/apps/magentoconnector/connector/connector/queue/worker.py", line 124, in run_job job.perform(session) File "/opt/bitnami/apps/magentoconnector/connector/connector/queue/job.py", line 467, in perform self.result = self.func(session, *self.args, **self.kwargs) File "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 379, in import_record importer.run(magento_id, force=force) File "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 220, in run record = self._create_data(map_record) File "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/sale.py", line 908, in _create_data **kwargs) File "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 164, in _create_data return map_record.values(for_create=True, **kwargs) File "/opt/bitnami/apps/magentoconnector/connector/connector/unit/mapper.py", line 934, in values values = self._mapper._apply(self, options=options) File "/opt/bitnami/apps/magentoconnector/connector/connector/unit/mapper.py", line 718, in _apply return self._apply_with_options(map_record) File "/opt/bitnami/apps/magentoconnector/connector/connector/unit/mapper.py", line 769, in _apply_with_options return self.finalize(map_record, result) File "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/sale.py", line 511, in finalize return onchange.play(values, values['magento_order_line_ids']) File "/opt/bitnami/apps/magentoconnector/connector-ecommerce/connector_ecommerce/unit/sale_order_onchange.py", line 203, in play order = self._play_order_onchange(order) File "/opt/bitnami/apps/magentoconnector/connector-ecommerce/connector_ecommerce/unit/sale_order_onchange.py", line 98, in _play_order_onchange onchange_specs) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/api.py", line 239, in wrapper return new_api(self, *args, **kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py", line 5843, in onchange record._onchange_eval(name, field_onchange[name], result) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py", line 5724, in _onchange_eval method_res = method(self) File "/opt/bitnami/apps/magentoconnector/e-commerce/sale_automatic_workflow/sale.py", line 61, in onchange_workflow_process_id if workflow.section_id: File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/fields.py", line 817, in __get__ self.determine_value(record) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/fields.py", line 910, in determine_value record._prefetch_field(self) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/api.py", line 239, in wrapper return new_api(self, *args, **kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py", line 3215, in _prefetch_field result = records.read(list(fnames), load='_classic_write') File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/api.py", line 239, in wrapper return new_api(self, *args, **kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py", line 3160, in read self._read_from_database(stored, inherited) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/api.py", line 239, in wrapper return new_api(self, *args, **kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/models.py", line 3283, in _read_from_database cr.execute(query_str, [tuple(sub_ids)] + where_params) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/sql_db.py", line 158, in wrapper return f(self, *args, **kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-8.0_20150423-py2.7.egg/openerp/sql_db.py", line 234, in execute res = self._obj.execute(query, params) ProgrammingError: column sale_workflow_process.section_id does not exist LINE 1: SELECT "sale_workflow_process"."id","sale_workflow_process”…
>>> 
>>> Tero
>>> 
>>> 
>>> 
>>> 
>>> Hi,
>>> 
>>> The table 'sale_workflow_process' miss a 'section_id' column. I guess you updated the module 'sale_automatic_workflow' but did not upgraded the module in Odoo. Try to start Odoo with the option '-u sale_automatic_workflow' or run the upgrade of the module from the Odoo interface.
>>> 
>>> 
>>> -- 
>>> Guewen Baconnier
>>> Business Solutions Software Developer
>>> 
>>> Camptocamp SA
>>> PSE A, CH-1015 Lausanne
>>> Phone: +41 21 619 10 39 <tel:%2B41%2021%20619%2010%2039>
>>> Office: +41 21 619 10 10 <tel:%2B41%2021%20619%2010%2010>
>>> http://www.camptocamp.com/ <http://www.camptocamp.com/> 
>>> 
>> 
>> -- 
>> Mailing list: https://launchpad.net/~openerp-connector-community <https://launchpad.net/~openerp-connector-community>
>> Post to     : openerp-connector-community@xxxxxxxxxxxxxxxxxxx <mailto:openerp-connector-community@xxxxxxxxxxxxxxxxxxx>
>> Unsubscribe : https://launchpad.net/~openerp-connector-community <https://launchpad.net/~openerp-connector-community>
>> More help   : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
> 
>