X-Cart forums

[virtual@croatia]

Originally Posted by 01bodyjewellery

I am still seeing no boxes to fill out on the currency lists.

I have followed your instructions about posting the SQL into phpMyadmin and it now says there are
Rows 210
Row length 6
Row size 26 B

Any ideas what else i could try?

Can you send me the master password on admin@smee.hr and I'll check it today?

[Freakmode]

Sorry for the delay - been away

Have sent over the details now, thanks for taking a look at this for us.

[virtual@croatia]

Originally Posted by 01bodyjewellery

I am still seeing no boxes to fill out on the currency lists.

We have fixed the problem. The problem was that, during the first installation, the tables xcart_currencies and xcart_country_currencies were empty and the module couldn't retract the data from them, required for the third table which is the part of the module. If someone else will have the same problem, fill the tables as I explained below and reinstall the module after that:

It seams that some xcart versions have the tables xcart_currencies and xcart_country_currencies empty. In that case you should download the last full version of the xcart, decompress it, open the file xcart_data.sql which is in the folder sql and copy everything between lines:

INSERT INTO xcart_country_currencies VALUES ('ADP','AD');

and

INSERT INTO xcart_currencies VALUES ('ZWD',716,'Zimbabwe Dollar','$');



Paste it in php MyAdmin and execute it. This will fill the tables with all world currencies.

[deadzebrainc]

Does anyone here have the programming chops (and time/energy/goodwill) to look into updating the currency data with daily exchange rates posted (for free) by the Federal Reserve at:
http://www.federalreserve.gov/releases/h10/Update/

It would be great if someone knew how to set up some sort of cron job or script that ran once daily to import the Federal Reserve data, parse it and update the x-cart currency SQL, turning this mod into a free near-real-time currency converter.

With the dollar doing its thing lately I am more and more concerned with easy international order accessibility, this would be a great thing!

[Freakmode]

Big thanks to Hrvoje for all his help in getting this and the GeoIP mod working on our store.
Immediate overnight benefit with many orders from the USA.

Great mod, really nice guy..

[virtual@croatia]

Originally Posted by deadzebrainc

Does anyone here have the programming chops (and time/energy/goodwill) to look into updating the currency data with daily exchange rates posted (for free) by the Federal Reserve at:
http://www.federalreserve.gov/releases/h10/Update/

It would be great if someone knew how to set up some sort of cron job or script that ran once daily to import the Federal Reserve data, parse it and update the x-cart currency SQL, turning this mod into a free near-real-time currency converter.

I've checked the pages. I was working on lot of parsers and the problem is that when they change the pages the whole job must to be redone again, completely from the beginning. If you find any xml pages for free with the same data I will do that. In the mean time, you'll have to do that manually.

Regards,
virtual@croatia

[Italian Glassman]

Just a quick question:
I deal with two main currencies (USD & CAD).

If my Canadian clients click on CAD, will their account be credited in CAD by PayPal?
Conversely, if my US clients click on USD, will their account be credited in USD by PayPal?

My site is currently only in USD and although I show the CAD conversion on the site, my Canadian clients still get charged in USD and some of them are annoyed by this (and some others have written to tell me that they won't buy from me until they can purchase in CAD).

Thanks for letting me know if your mod does this. If not, perhaps you can point me to something that could do the job. Thanks!!!

Mario

[virtual@croatia]

Originally Posted by Italian Glassman

Just a quick question:
I deal with two main currencies (USD & CAD).

If my Canadian clients click on CAD, will their account be credited in CAD by PayPal?
Conversely, if my US clients click on USD, will their account be credited in USD by PayPal?

My site is currently only in USD and although I show the CAD conversion on the site, my Canadian clients still get charged in USD and some of them are annoyed by this (and some others have written to tell me that they won't buy from me until they can purchase in CAD).

Thanks for letting me know if your mod does this. If not, perhaps you can point me to something that could do the job. Thanks!!!

Mario

This module won't help you to solve it. In the next 30 days I'm planning to include pay pal system into my web site and after that I'll know is it possible or not to do that. Could you please remind me on it 30 days from now?

virtual@croatia

[Italian Glassman]

Will do. Thanks for your help!
Mario

[konadnailart]

Hi
I got the following error when trying to install, any pointers. Am using 4.1.9.
Thanks


Copying skin files ...

Copying to file skin1\modules/Multi_Currency\currencies.tpl - [OK]
Copying to file skin1\modules/Multi_Currency\menu_currency.tpl - [OK]
[OK]

Activating the module ...

Please wait ...
[OK]

Please wait ...
Creating table: [xcart_currency_rate] ... [OK]
[FAILED] You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT value FROM xcart_config WHERE name = 'currency_symbol')