Bug 3758

Summary: Automatic update of exchange rates
Product: Koha Reporter: Nicole C. Engard <nengard>
Component: AcquisitionsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Bugs List <koha-bugs>
Severity: enhancement    
Priority: P5 - low CC: colin.campbell, indradg, janet.mcgowan, josef.moravec, katrin.fischer, mtompset, paul.poulain, severine.queune
Version: Main   
Hardware: PC   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20354
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18888
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Automagically fill currency table.

Description Chris Cormack 2010-05-21 01:14:39 UTC


---- Reported by nengard@gmail.com 2009-11-03 20:27:58 ----

I was thinking that it would be great (and very efficient) to have the Currencies & Exchange Rates page in Koha pull data in real time from a currency API.  There are a few out there: http://www.programmableweb.com/apitag/?q=currency&sort=date

Comments from IRC:

[15:24]  <pianohacker> nengard: If one of those has a good terms of use that would allow shipping it completely set up, that'd be nice
[15:24]  <nengard> not sure - would have to read through them all
[15:25]  <pianohacker> nengard: If the end-user had to set it up manually, that'd still be useful but not as much so
[15:25]  <nengard> it's just that exchange rates change hourly and so your acq may not have accurate accounting without pulling it in real time



---- Additional Comments From henridamien@koha-fr.org 2009-11-03 22:03:34 ----

mmm....
Quite tricky indeed.
What would you consider accurate : the currency at the time you place your order on a biblio,
at the time you send your order to the supplier, at the time you receive your parcel or at the moment you Pay the bill ?
Should the amount change depending on the currency updated every hour ?
Or should it be calculated once with the exchange rate at the moment you place the order ? => then a simple button to fetch the currency should be better than a cron or a Syndication to Currency changes.
But maybe I misunderstand the need.



---- Additional Comments From nengard@gmail.com 2009-11-03 22:47:32 ----

I would assume - and I could be wrong - that I would consider the point that the order is sent to the vendor to be the time I want the currency converted - since that's when the vendor will charge me ... but I guess that's not always accurate ... maybe instead of having it automatically updated allowing the librarians to click a "Get Update" button that queries the API for the most accurate data and updates the page with that ... not sure what's best.



---- Additional Comments From colin.campbell@ptfs-europe.com 2010-02-11 13:43:17 ----

Many libraries want periodic updates from an approved list. EG UN agencies work to a monthly list issued by a UN department and I've seen the same approach in some academics. i.e. they don't want to be affected by real time fluctuations so the api should support periodic as well as real time updates   



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:14 UTC  ---

This bug was previously known as _bug_ 3758 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3758

Actual time not defined. Setting to 0.0

Comment 1 Paul Poulain 2011-08-02 14:19:23 UTC
I prefer colin suggestion = having a batch that update rates.
It does not exist either, problem still relevant then. A patch anyone ?
Comment 2 Katrin Fischer 2011-10-28 17:12:36 UTC
Enhancement request still relevant after release of 3.6.
Comment 3 Indranil Das Gupta 2015-05-11 12:34:39 UTC
http://treasury.un.org/operationalrates/UNOperationalRatesRSS.xml seems to be a possible useful source.
Comment 4 Mark Tompsett 2018-03-09 14:46:46 UTC
(In reply to Paul Poulain from comment #1)
> I prefer colin suggestion = having a batch that update rates.
> It does not exist either, problem still relevant then. A patch anyone ?

Here you go. :)
Comment 5 Mark Tompsett 2018-03-09 14:48:09 UTC
Created attachment 72606 [details]
Automagically fill currency table.

Yes, it isn't a friendly patch format, because I have no idea where to drop it.
Comment 6 Katrin Fischer 2022-07-20 09:29:49 UTC
It looks like this has been abandoned, any chance to pick it up again?