Elxis CMS Forum

Support => Technical support => Topic started by: jason on July 20, 2010, 17:08:27

Title: IOS select currency problem
Post by: jason on July 20, 2010, 17:08:27
In default IOS currency goobal setting Has "TWD" support.

after set, the Elxis CMS system said " Sysytem not supported"

How can I fix that??

Thanks for your great help
 
Title: Re: IOS select currency problem
Post by: datahell on July 20, 2010, 18:42:12
What exactly you can not do? Set as default IOSR currency the TWD?
Title: Re: IOS select currency problem
Post by: jason on July 21, 2010, 04:50:34
component-->IOs reservations-->configuration-->General seeting-->currency---->I set "TWDTaiwan Dollar"

component-->IOs reservations-->configuration-->Front Page-->Select currency--> set "Yes"

module-->Set module-->IOSR select currency-->Module detail-->set Position "user1" parameters set " show exchange set "Yes'

after go tto "home page'" , select currency is there,  but only message as flows

   "System default currency is not supported by IOS Reservations exchange rates system. "

so my problem is they can be set, but not support by IOS exchange rates system

It seems need to set exchange rate somewhere I dont know 
Title: Re: IOS select currency problem
Post by: datahell on July 21, 2010, 14:42:25
You can add TWD in IOSR exchange rates system by inserting one new row at the corresponding database table (via phpmyadmin) but the rates will not be updated automatically as ECB does not provide information for the EUR-TWD exchange rates. So, you will have to set manually the rate for TWD and do that again each time this changes.
Title: Re: IOS select currency problem
Post by: jason on July 21, 2010, 16:09:41
Thanks, very helpful 
Title: Re: IOS select currency problem
Post by: datahell on July 21, 2010, 20:06:54
Some more info:
related database table: elx_res_exchange
Today's EUR to TWD exchange rate:  1 : 41.1366

So, create a new entry in table elx_res_exchange like this:

35, TWD, 41.1366, 1451577600

Source: http://www.exchange-rates.org/Rate/EUR/TWD (http://www.exchange-rates.org/Rate/EUR/TWD)

In order for IOSR not to update automatically and continuously the exchange rate for TWD (as this will fail) I have set the timestamp (last column in table elx_res_exchange = lastupdate) to a future date (1451577600 = December 31, 2015 10:00:00)
Title: Re: IOS select currency problem
Post by: jason on July 22, 2010, 06:08:13
Sorry bother you again.

I already added the exchange rate in mysql. It's ok.

but after that ,It seems more place need to be amended.

1)  the selctlist need to add "TWD-New Taiwan Dollars" , no "TWD" on the list.

2)  need to tell PhP code to do calculation for default currency and TWD.

Thanks again.