Update currencies from timegenie.com's xml feed

[DrByte]

It appears that BOC has changed their data feeds.

function quote_boc_currency($currencyCode = '', $base = DEFAULT_CURRENCY)
{
  if ($currencyCode == $base) return 1;
  static $CSVContent;
  $requested = $currencyCode;
  $url = 'http://www.bankofcanada.ca/stats/assets/csv/fx-seven-day.csv';
  $currencyArray = array();
  $currencyArray['CAD'] = 1;
  if (!isset($CSVContent) || $CSVContent == '') {
    $CSVContent = file($url);
    if (! is_object($CSVContent) && function_exists('curl_init')) {
      $CSVContent = doCurlCurrencyRequest('GET', $url);
      $CSVContent = explode("\n", $CSVContent);
    }
  }
  foreach ($CSVContent as $line) {
    if (substr($line, 0, 1) == '#' || substr($line, 0, 4) == 'Date' || trim($line) == '') continue;
    $data = explode(',', $line);
    $curName = $data[1];
    $curRate = $data[sizeof($data)-1];
    $currencyArray[trim($curName)] = (float)$curRate;
  }
  $rate = (string)($currencyArray[DEFAULT_CURRENCY]/(float)$currencyArray[$requested]);
  return $rate;
}

These updates will be in v1.5.1

[simon1066]

Thank you, that works well.

Having carried out some checks on the updated exchange rates I see that the Boc values in 'fx-seven-day.csv' are not referenced to one currency such as CAD but give the value in CAD for 1 unit of each countries' currency. i.e. from the .csv, 1 Croatian Kuna = 0.1741 CAD, what zen cart needs is 1 CAD = 5.7408 Croatian Kuna. Therefore the reciprocal values of the Boc supplied exchange rates are required.

Perhaps this calculation can be incorporated into the code somewhere. If not I may have to do without that source.

[DrByte]

grr - I'd posted the wrong update. Corrected above.

[simon1066]

Thank you for sorting all this out.

I can report that the Timegenie, Boc & Ecb feeds are all working and that Zen Cart is able to populate, from free sources, the exchange rates for 61% of the world's currencies.

[DrByte]

New plugins uploaded:
TimeGenie - http://www.zen-cart.com/downloads.php?do=file&id=1505
GoogleFinance - http://www.zen-cart.com/downloads.php?do=file&id=1506

[chris3J13]

Hi Dr Byte
I am new here. I try to put more than one currencies in my website to show the price in different currency. I notice it does not update the exchange rate automatically, then I download your currency timegenie 150 and plugin to my admin folder. also I put a tat in my side "source timegenie.com", I still can not make it work . I have try to make the default currency either USA or AUD. Can you help ?

[joyjoy]

New plugins uploaded:
TimeGenie - http://www.zen-cart.com/downloads.php?do=file&id=1505
GoogleFinance - http://www.zen-cart.com/downloads.php?do=file&id=1506

Hello! Thank you for providing this mod! I just have a question. Does it update the rates automatically within the admin section or do I need to do anything else?