openerp-india team mailing list archive

[Truong Vinh Trinh <truongvinhtrinh2011@xxxxxxxxx>]

Hello Alexis,

Nice post!!
- VND is not supported with webservice from ECB, when choose to get rate exchange for VND the program will throw exception and the other currency types will not has their exchange rate values.
To ignore the unsupported currencies when using ECB's webservice, I added:

if curr not in self.supported_currency_array :
                continue 

AFTER:
if main_currency != 'EUR':
            main_curr_data = self.rate_retrieve(dom, ecb_ns, main_currency)
        for curr in currency_array:

Trinh V Truong.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/645263

Title:
  c2c_currency_rate_update outdated XML lib and a crash

Status in OpenERP Addons (modules):
  Fix Released

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&section=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...

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/645263/+subscriptions