Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Configuration
  3. Currency Rate Update: OpenExchangeRates.org v 12.0
  4. Sales Conditions FAQ

Currency Rate Update: OpenExchangeRates.org

by CorporateHub https://github.com/OCA/currency , Odoo Community Association (OCA) https://github.com/OCA/currency
Odoo
v 12.0 Third Party 95
Download for v 12.0 Deploy on Odoo.sh
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Discuss (mail)
• Invoicing (account)
Community Apps Dependencies Show
Currency Rate Update
Lines of code 710
Technical Name currency_rate_update_oxr
LicenseAGPL-3
Websitehttps://github.com/OCA/currency
You bought this module and need support? Click here!

Currency Rate Update: OpenExchangeRates.org

Beta License: AGPL-3 OCA/currency Translate me on Weblate Try me on Runboat

This module adds OpenExchangeRates.org currency exchange rates provider.

Table of contents

  • Configuration
  • Bug Tracker
  • Credits
    • Authors
    • Contributors
    • Maintainers

Configuration

To configure OpenExchangeRates.org currency rates provider credentials:

# Go to Invoicing > Configuration > Settings # Fill application credentials in Currencies > OpenExchangeRates.org Provider section

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • CorporateHub

Contributors

  • CorporateHub
    • Alexey Pelykh <alexey.pelykh@corphub.eu>

Maintainers

This module is maintained by the OCA.

Odoo Community Association

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

This module is part of the OCA/currency project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
  • Ratings
  • Discuss
There are no ratings yet!
Receive error every time I try to set openexchangesrate.org as the currency provider under odoo CE 12
by
Adrian Maudsley
on 5/26/19, 3:41 AM

Error: Odoo Server Error Traceback (most recent call last): File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/api.py", line 1032, in get value = self._data[field][record.id][key] KeyError: During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/fields.py", line 970, in __get__ value = record.env.cache.get(record, self) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/api.py", line 1034, in get raise CacheMiss(record, field) odoo.exceptions.CacheMiss: ('res.currency.rate.provider(,).available_currency_ids', None) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/http.py", line 654, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/http.py", line 312, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/tools/pycompat.py", line 87, in reraise raise value File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/http.py", line 696, in dispatch result = self._call_function(**self.params) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/http.py", line 344, in _call_function return checked_call(self.db, *args, **kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/service/model.py", line 97, in wrapper return f(dbname, *args, **kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/http.py", line 337, in checked_call result = self.endpoint(*a, **kw) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/http.py", line 939, in __call__ return self.method(*args, **kw) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/http.py", line 517, in response_wrap response = f(*args, **kw) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/addons/web/controllers/main.py", line 962, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/addons/web/controllers/main.py", line 954, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/api.py", line 749, in call_kw return _call_kw_multi(method, model, args, kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/api.py", line 736, in _call_kw_multi result = method(recs, *args, **kwargs) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/models.py", line 5433, in onchange snapshot1 = Snapshot(record, nametree) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/models.py", line 5340, in __init__ if subnames else record[name] File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/models.py", line 5049, in __getitem__ return self._fields[key].__get__(self, type(self)) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/fields.py", line 976, in __get__ self.determine_draft_value(record) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/fields.py", line 1096, in determine_draft_value self._compute_value(record) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/fields.py", line 1032, in _compute_value getattr(records, self.compute)() File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/customadd/currency_rate_update/models/res_currency_rate_provider.py", line 129, in _compute_available_currency_ids provider._get_supported_currencies() File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/models.py", line 1555, in search res = self._search(args, offset=offset, limit=limit, order=order, count=count) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/models.py", line 4045, in _search query = self._where_calc(args) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/models.py", line 3838, in _where_calc where_clause, where_params = e.to_sql() File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/osv/expression.py", line 1287, in to_sql q, ps = self.__leaf_to_sql(leaf) File "/opt/bitnami/apps/odoo/lib/odoo-12.0.post20181218-py3.7.egg/odoo/osv/expression.py", line 1229, in __leaf_to_sql raise ValueError("Invalid domain term %r" % (leaf,)) ValueError: Invalid domain term ('name', 'in', dict_keys(['AED', 'AFN', 'ALL', 'AMD', 'ANG', 'AO,.... " ( truncated final line in log which just listed currency)


Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with