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?
All countires and zones?
|
|
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 |
|---|---|
| all countires and iso codes.csv_.txt | 8.18 KB |
| uc_countries.sql_.zip | 3.92 KB |
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!
Thanks. I tried searching for it, but couldn't find it out.
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 |
No known solution to this problem, but for most places in the world it won't matter. City, Postal code, and Country usually suffice.
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 |
Why the Japan regions in uc_country shows as question - "????" marks? It isn't displaying any properly language?
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
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 |
*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 |
|
|
Joined: 08/08/2007