Currency Update (Automatic)

[CJJUNE]

I GOT IT!. The command I use is;-

php /home/[your username]/public_html/rss/import_feeds.php

[Danielle]

Hmmm this has always been working fine, but now I've moved to a new server and the script and cron are working except they update my currency rate to 0 which makes everything in my store free if visitors are shopping in US $, eek!!! I didn't change the file at all, I can't understand why it's doing that. Any thoughts anyone?

TIA!

[CJJUNE]

Hmmm this has always been working fine, but now I've moved to a new server and the script and cron are working except they update my currency rate to 0 which makes everything in my store free if visitors are shopping in US $, eek!!! I didn't change the file at all, I can't understand why it's doing that. Any thoughts anyone?

TIA!

Why don't you Google the error message that comes out? The solution is somewhere out there in the WWW.

[Danielle]

There is no error message...everything appears to work great, but when I check the currency values in my admin, Canadian is correct and USD is changed to 0.

[kuroi]

What happens when you do a manual update? How do you know that CRON and the script are working?

[saher.alsous]

well, what should i do here

i think i read all the posts here but i can't find one thing

in the mod they said that you should change line 16

is it this one? define('CURRENCY_SERVER_BACKUP', 'oanda');

i doubt it

but i thought that it would be this one

$location = '/home/***/***/currency_update.php'; // location of zen-cart intall

i put my physical address here

and in the cron job i put the physical address my host supervisor gave it to me...


but still nothing is working!!!???

did i made the right change inside the script?

can you advice in it?


saher

[phreakymonkey]

My host has allow_url_fopen disabled for security reasons, and I'm sort of loath to enable it since most of the advice I've found suggests leaving it alone unless you really know what you're doing. I know zilch about web security, so...

Several people have suggested using cURL as an alternative, but I don't know PHP from Hebrew and haven't figured out how to do it. Perhaps I'm revealing my ignorance here, but mightn't it be a good idea to make the switch in the next version of the script in the interest of maximum compatibility? It would at least eliminate one of the issues people are having. It's just these two lines that are causing problems, right?

$page = file('http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=' . $code .  '&format=CSV&dest=Get+Table&sel_list=' . $base);

$page = file('http://www.xe.net/ucc/convert.cgi?Amount=1&From=' . $from . '&To=' . $to);

[phreakymonkey]

I spent a bunch of time searching tutorials and other various websites, trying to figure out how to replace the php file() function with cURL. Then I found the admin/includes/functions/localization.php file, which seems to be what this is based on. I just cut and pasted that code into the currency_update.php file, and it seems to have just updated my currencies okay on my server with allow_url_fopen disabled. Here it is if anyone wants to poke at it. I'm certainly not going to put it up on the Downloads page until someone who is more knowledgeable about these things checks and makes sure nothing is going to explode.

Currency Update (cURLed)

[masterblaster]

Thank you kuroi and phreakymonkey for making those little changes to the script. I haven't given too much attention to it, since it *should* be working as a standalone script, regardless of the zen version.

Unfortunaly I didn't think of file() fopen() disallowed by a server when writing the script... The CURL method is the best alternative, which should work ok.

I will see if I can improve the script for now and make it available on my website by tomorrow.

[Phil020782]

Hi,
I seem to be having a little difficulty getting this mod set up.

Please can someone advise me if these settings are correct:

the currency_update.php file is in directory /home/admin*****
the run command is in directory /etc/cron.hourly/hourlytasks
my store is in directory /var/www/html

I have the setting in the currency_update.php file set to /var/www/html
the run command is set to usr/bin/php /home/admin*****/currency_update.php

This should run the script every hour but when I look in admin->localization->currencies the displayed last update date was days ago.

Please can someone tell me what I'm doing wrong?

Thanks