Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Multi currency modul

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #11  
Old 04-10-2008, 08:17 AM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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?
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
  #12  
Old 04-15-2008, 11:46 AM
 
Freakmode Freakmode is offline
 

X-Adept
  
Join Date: Jun 2003
Location: UK
Posts: 696
 

Default 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.
__________________
X-Cart 4.7.12 (Live)
Redux Template
CDSEO
Reply With Quote
  #13  
Old 04-15-2008, 11:09 PM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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.
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
  #14  
Old 04-16-2008, 12:40 PM
  deadzebrainc's Avatar 
deadzebrainc deadzebrainc is offline
 

Advanced Member
  
Join Date: Apr 2008
Posts: 45
 

Default 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!
__________________
DEAD ZEBRA, INC shop
X-cart 4.1.9
Reply With Quote
  #15  
Old 04-16-2008, 10:55 PM
 
Freakmode Freakmode is offline
 

X-Adept
  
Join Date: Jun 2003
Location: UK
Posts: 696
 

Default 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..
__________________
X-Cart 4.7.12 (Live)
Redux Template
CDSEO
Reply With Quote
  #16  
Old 04-16-2008, 11:38 PM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
  #17  
Old 05-03-2008, 07:34 AM
 
Italian Glassman Italian Glassman is offline
 

Advanced Member
  
Join Date: Sep 2007
Posts: 92
 

Default 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
__________________
X-Cart version 4.1.8
(given up, for now, on 4.1.9 upgrade)
Reply With Quote
  #18  
Old 05-04-2008, 11:11 AM
 
virtual@croatia virtual@croatia is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 92
 

Default 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
__________________
Check what you can do with x-cart 4.1.9:
www.smee.com

Modules I made:
IP_Ranges
Multy_Currency
Order_Dates

Modules I use:
Fancycategory
Magnifier
Survey
AOM
Reply With Quote
  #19  
Old 05-04-2008, 04:54 PM
 
Italian Glassman Italian Glassman is offline
 

Advanced Member
  
Join Date: Sep 2007
Posts: 92
 

Default Re: Multi currency modul

Will do. Thanks for your help!
Mario
__________________
X-Cart version 4.1.8
(given up, for now, on 4.1.9 upgrade)
Reply With Quote
  #20  
Old 05-07-2008, 11:37 AM
 
konadnailart konadnailart is offline
 

Member
  
Join Date: Mar 2005
Posts: 27
 

Default 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')
__________________
Xcart 4.1.9, AOM, One Page Checkout, Buy Together, Smart Search, On Sale, XC SEO Pro, Preordered/Backordered, Reward Points (Unresolve Issue), Marketing Manager Pro V3, RubyMod Currency, GeoIP.
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 05:13 AM.

   

 
X-Cart forums © 2001-2020