webERP Forum

Full Version: Currencies Maintenance takes too much time to load
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Jayasuriya


Hi,

Currencies Maintenance takes too much time to load and and even getting slow when we adding a new Currency. However I have disabled the automatic updates options as well. Is there any particular reason for this?

Thanks,
Sumith
Yes the system is going off to google or ECB to get the latest rates. Can't recall if there is an off option for that or not ... there should be.
Hello,

I have another problem with the Currency-Board. It just doesn'T update the data for the ecb-rates. Update automatically is enabled. And whenI change it to "manually" I have no idea where to put in the rates. I don'T find a field for that in the edit option nor in the data table of currencies. Please help.
You can choose between google and ECB - from Setup=>configuration settings - or turn it off altogether using the option:

Quote:Auto Update Exchange Rates Daily: Automatic updates to exchange rates will retrieve the latest daily rates from either the European Central Bank or Google once per day - when the first user logs in for the day. Manual will never update the rates automatically - exchange rates will need to be maintained manually

see http://www.weberp.org/weberp/SystemParameters.php
Quote:Source Exchange Rates From: Specify the source to use for exchange rates

Currency rates can be updated manually Setup=>General Setup Options=>Currency Maintenance

see http://www.weberp.org/weberp/Currencies.php
Well I did that and now I've got that error popping up for each currency:


Warning: file() [function.file]: URL file-access is disabled in the server configuration in .../webERP/includes/MiscFunctions.php on line 229

Warning: file(http://www.google.com/finance/converter?...EUR&to=AUD) [function.file]: failed to open stream: no suitable wrapper could be found in .../webERP/includes/MiscFunctions.php on line 229

Ah ha!! This is to do with your PHP configuration.

You need to create a file called php.ini in your webERP directory containing:

Code:
allow_url_fopen = ON

see

http://www.solo-technology.com/blog/2010...ed-issues/
Yep now it works fine. Thanks a lot.^^
(02-25-2013, 04:32 PM)Jayasuriya Wrote: [ -> ]Hi,

Currencies Maintenance takes too much time to load and and even getting slow when we adding a new Currency. However I have disabled the automatic updates options as well. Is there any particular reason for this?

Thanks,
Sumith

Hi, Sumith:

You should revise currencies.php at line 286 too:
locale_number_format(GetCurrencyRate($myrow['currabrev'],$CurrencyRatesArray),8),
you can just change it to '0';

Hope it's helpful.

Best regards!

Exson