Forum OpenACS Development: ref-currency package
I analyzed ref-currency pkg's datamodel and felt it was missing a table to actually storage the currency values.
So far so good, a simple two columns table, currency_code and value, if it wasn't my need to make thing complicated.
Giving more thought on that, I realized that maybe I'd like to storage currency and also keep a historic of values.
Thus I wonder what if the best approach would be to use cr_items and cr_revisions.
However, wouldn't that be too much, like missile to kill a little bird?
I did look at ecommerce.
There's nothing there related to currencies. There are Shipping costs and sales taxes though they are realted to business they aren't specifically related to what I'm building.
Prices are tagged in US dollars and that's it. No conversion engines, no rating updates from a WS'es or anything like that.
Please, do correct myself if I'm being wrong here.
Yes, I do want something more specialized to handle exchange rates. That's what I am building and I thought ref-currency pkg is a the best place to be: conversion engines, rating updates from a Web services such as ECB http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml
with parameter to have control over a few services.
Plus, together with rates history we could build graphics ... Sky's the limit here.
What do you think/suggest?
Yes, ecommerce package has limited use for this.
There is tcl code handling currency conversion on this page:
I haven't tried it, but it appears to connect with a Yahoo API.
Anyway... thumbs up for development on this. In that post I offered myself for analysis and coding, but I won't have time until March, so...
Ah! I have some working code for retrieving exchange rates from the euroforex!
I couldn't help it and coded a bit.
Here it's html version of it.
It basically consume a xml from ECB http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml
And do conversions. EUR's currency pivot.
The object's to build a WS.