I remember before the server went down there was a post in which someone attached a zip file with the sql for all country's and their zones. Does anyone still have that file?
Fri, 09/28/2007 - 11:32
regions anyone?
Actually, I've done it myself see attached.
The original data I was working with had a region column for grouping the countrys by continent. I've attached a CSV file if anyone is interested in it. Perhaps would be handy for the shipping module.
| Attachment | Size |
|---|---|
| uc_countries.sql_.zip | 3.92 KB |
| all countires and iso codes.csv_.txt | 8.18 KB |
BRILLIANT!
Thanks to tr_ who pointed this post out to me. This needs to be in the contribs section, as i've had several clients ask for this, and was just about to do it myself!
Re: regions anyone?
Thanks. I tried searching for it, but couldn't find it out.
Re: Re: regions anyone?
After I've uploaded the sql file to the database the region bar for the country where regions are not specified shows "Not applicable". It should give an option for users to write zones on their own. Please check the image below.
Any solution to the problem?
| Attachment | Size |
|---|---|
| zone-not-applicable.jpg | 25.88 KB |
Re: Re: Re: regions anyone?
No known solution to this problem, but for most places in the world it won't matter. City, Postal code, and Country usually suffice.
Re: Re: Re: Re: regions anyone?
The list of 189 countries (without regions) which are supported by Paypal. Paypal supports 190 countries but I didn't find code for one country named "Democratic Republic of the Congo (CD)".
To show ONLY Paypal countries in country list remove all previous countries in SQL, database of ubercart (uc_countries), through phpMyAdmin, then import the file to phpMyAdmin. Remove the extension "_.txt" before you proceed.
| Attachment | Size |
|---|---|
| uc_countries.sql_.txt | 7.95 KB |
Re: Re: Re: Re: Re: regions anyone?
Why the Japan regions in uc_country shows as question - "????" marks? It isn't displaying any properly language?
Democratic Republic of the Congo
According to Wikipedia, the codes for CD are 180 and COD
http://en.wikipedia.org/wiki/ISO_3166-1
Attached is an updated file just with that one line added.
I've also made an insert query according to the full country list in the same wikipedia page... If anyone is interested I can put that up here.
| Attachment | Size |
|---|---|
| uc_countries.sql_.txt | 8 KB |
this seemed to work for me - thanks!
Thanks for this. I think your uc_countries.sql_.zip works fine on my site. all African countries appear to be available, which is my top priority.
It would be helpful for others I think if these were already included in the ubercart module by default, with all countries turned on or at least easy to turn on. I had an interesting 20 minutes of pressing the button to install all the countries available in ubercart before finding this.
Cheers,
Tobias
List of 190 countries of PayPal.
*List of 190 countries of PayPal.
*Name of countries are exactly as stated in paypal website - https://www.paypal.com/worldwide/.
*There is an error in country numeric code of Ethiopia which has been rectified in this update.
I have manually checked each and every code so there should not be errors anymore.
| Attachment | Size |
|---|---|
| uc_paypal_countries.sql_.txt | 7.98 KB |
RE: Paypal Countries
The problem with the Paypal Countries list is that PayPal doesn't service all the countries in the world, and therefore the list is incomplete. I ran into this problem when trying to accept donations from South American countries like Paraguay and Uraguay -- PayPal doesn't have a relationship with those countries.
--
This thread contains a far more complete list of countries (245 at the time of this post):
http://www.ubercart.org/forum/internationalization/347/country_and_zone_...