X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)
-   -   Multi currency modul (https://forum.x-cart.com/showthread.php?t=38421)

virtual@croatia 04-10-2008 08:17 AM

Re: Multi currency modul
 
Quote:

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 04-15-2008 11:46 AM

Re: Multi currency modul
 
Sorry for the delay - been away

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

virtual@croatia 04-15-2008 11:09 PM

Re: Multi currency modul
 
Quote:

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:

Quote:

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 04-16-2008 12:40 PM

Re: Multi currency modul
 
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 04-16-2008 10:55 PM

Re: Multi currency modul
 
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 04-16-2008 11:38 PM

Re: Multi currency modul
 
Quote:

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 05-03-2008 07:34 AM

Re: Multi currency modul
 
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 05-04-2008 11:11 AM

Re: Multi currency modul
 
Quote:

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 05-04-2008 04:54 PM

Re: Multi currency modul
 
Will do. Thanks for your help!
Mario

konadnailart 05-07-2008 11:37 AM

Re: Multi currency modul
 
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')


All times are GMT -8. The time now is 06:07 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.