Nicolas, I have not modified the code of the Yahoo webservice, I have only modified the code of the XML-based webservice i.e. admin.ch, ECB and PL NBP.
-- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to the OpenERP Project Group. https://bugs.launchpad.net/bugs/645263 Title: c2c_currency_rate_update outdated XML lib and a crash Status in OpenObject Addons Modules: In Progress Bug description: I am currently testing the module "c2c_currency_rate_update" from extra-addons, stable branch. I am using the current stable branch for server and addons. The great news is that I managed to update several currencies with the service "Yahoo Finance" ! But it seems I found 2 issues with the module. I am a beginner in Python, so I may be wrong or say stupid things, please take it into account when reading this. 1) First issue : deprecated pyxml lib makes ECB and Admin.ch service unusable ? In the file currency_rate_update.py, for the service ECB (European Central Bank) and Admin.ch, there is an import of a library : from xml import xpath (line 365 for Admin.ch and 417 for ECB) For what I understand, this lib is part of the pyXML lib, available from this project : http://sourceforge.net/projects/pyxml/ Under Ubuntu, the lib was provided by the package python-xml. Since Karmic, this lib is no longer provided, see http://packages.ubuntu.com/search?keywords=python-xml&searchon=names&suite=all§ion=all Probably, the reason for that is written on http://sourceforge.net/projects/pyxml/ : PyXML is no longer maintained. So, shouldn't we use another XML lib ? If yes, which one do you suggest ? 2) if I start the server with --log-level=debug, when I do anything in the "Currency autoupdate configuration" (under Administration > Users > Companies) and save it, or when I click on Refresh currencies, or when the scheduled action to refresh currencies is executed, I get the following crash in the logs : [2010-09-22 16:12:38,161][erp_des4] DEBUG:sql:bad query: select company_id from res_currency [2010-09-22 16:12:38,162][erp_des4] DEBUG:sql:None [2010-09-22 16:12:38,162][erp_des4] DEBUG:sql:[01]: ERREUR: la colonne « company_id » n'existe pas [2010-09-22 16:12:38,162][erp_des4] DEBUG:sql:[02]: LIGNE 1 : select company_id from res_currency [2010-09-22 16:12:38,163][erp_des4] DEBUG:sql:[03]: ^ [2010-09-22 16:12:38,164][erp_des4] DEBUG:sql:[01]: File "/usr/lib/python2.6/threading.py", line 504, in __bootstrap [2010-09-22 16:12:38,164][erp_des4] DEBUG:sql:[02]: self.__bootstrap_inner() [2010-09-22 16:12:38,164][erp_des4] DEBUG:sql:[03]: File "/usr/lib/python2.6/threading.py", line 532, in __bootstrap_inner I confirm there is no company_id field on the res_currency object ! Do you confirm these two issues ? If yes, I am willing to spend time to try to fix them, but : - for point n°1, I need some advice on which python XML lib we should use now - for point n°2, I will probably need some help, because I don't see what triggers this bad SQL query... _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
