 |
UbercartOne cart to rule them all... |
|
| Donate to Ubercart | ||
Country- and zone update
Submitted by qrios on Thu, 08/16/2007 - 07:44
I repost an sql import that make's all(?) countries and their zone's available to Ubercart. Truncate the MYSQL tables: uc_zones and uc_countries I think this could be in core. Regards, Kees Web development, web applicaties, internet winkel
Thanks, Kees. Our copy of that file got corrupted in the server crash, so we couldn't repost it. He man, Anytime. Blame your shitty server crash. Did your smile crash to on your avatar   haha, kees, i noticed that too! lyle's avatar suddenly looked very sober after the crash... is it just me or does anyone else see something strange with the zone names containing special characters? the first of the german zones, for example, and a few in france, metropolitan? on my system, the special characters are displayed as you would see them in html. ampersand-uuml-semicolon, etc. I have the same problem. In DB: Generated source: So its a problem with the output of the &-Character This has to do with the fact this list comes straight from osCommerce. Drupal filters apparently the "&" char and replaces it whith "&" I adapted the SQL code by replacing all html special chars by their unicode equivalents. Pleas test if this breaks zone-display somewhere else in Ubercart (like in orders or...) Kees
strange, it might be just my setup, but in my phpMyadmin I have to run the SQL code by copy/pasting the contents to the interface instead of looking up the file itself by [browse]. The latter breaks strings containing the special chars. thanks, kees! i also had a problem with the second file, though, so i'm putting this one up in case anyone else has problems with keesje's ones. i had to copy and paste it into the SQL window, too.
Hi, Can someone help and tell me how to accomplish the truncate op ? Thanks, It's the red "Empty" button. It'll show an alert message with "Do you really want to TRUNCATE table name?"  hmmm... can anyone you give a full workflow on how to import this? Hi! I was just wondering if the files here are still wholly based on OsCommerce's world_zones? Or have they been updated with the country files that have been added to Ubercart? amitaibu: 1. go to php myadmin page in your favourite web browser; 2. select your drupal database; 3. browse to uc_countries; 4. click 'empty' in the tabs above the table; 5. an alert will ask you if you're sure you want to truncate the uc_countries table, click ok; 6. click 'sql' in the tabs above the table; 7. you should see a large text field labeled "run sql query/queries on databasename". delete any default text in this field and copy and paste the sql out of the text document you downloaded from this forum topic. this is what you should copy: INSERT INTO `uc_countries` VALUES (1, 'Afghanistan', 'AF', 'AFG', 1);8. repeat steps 3-7 for uc_zones. hope that helps! Hmm, whilst setting up my store the first thing I noticed is that the county of Cumbria is missing from the UK zone (because I live there). I've done a little more digging and can see that also missing is the Isle of Man, Jersey and Guernsey. There may be others. In fact I believe that the Royal Mail only use post codes and do not recommend using postal counties for addresses therefore I suspect it will be confusing to customers who cannot enter their known and trusted addresses if the option is mandatory and the list is pre-defined. Perhaps the zone field could be left greyed out upon selection of the UK in the countries field? Hmm, sorry the file is incomplete. I of course would have no way of checking, but I have made the address forms on the checkout page configurable. You can turn off the zone field altogether at /admin/store/settings/checkout/edit/fields. i've looked over the file and i think that it should be mentioned that people using this file shouldn't use (or rather, use with caution) the importable country files that are part of ubercart. as they might cause some conflicts. i 'fixed' the country file for the philippines and i made some changes to it based on the internationalization notes and ISOs (i even added some other provinces!) that were discussed on the old forum boards. as an example, the philippines' zone/country code in the oscommerce file is 168 and it's 608 in the file that i 'fixed'. so be careful with them files. The countries file attached previously in this thread is incompatible with the country files that come with ubercart core. Using this may break things like existing customers, shipping rules etc. The attached file contains information on all countries (source: iso3166-1), with country id's as defined in ISO, and is compatble with ubercart core files. It does not contain information about zones. You can import this into your database and it will not remove existing zones you might have imported from ubercart core. You can also import new zones - just disable the relevant country and import it. I find this good enough for me, since I do need a list of all countries, but not all zones in the world (US, CA are good enough for now.. if more are needed, I'll import them).
great! maybe we can just add an empty field for the zones of the other countries (those without zones in the db)? Great, thanks a lot! Perhaps a link to your post should be included in the docs? That .sql file contains Yugoslavia which leads me to believe it's outdated. Anyone know different? I have noticed that there is no Cleveland or Redcar and Cleveland options. I live there and have been trying to figure out what zones actually exist. I've found it hard to find solid info online about it. We need the zones so we can show different payment modules for different zones within the UK. Well I believe that it's not a problem since Serbia and Macedonia are listed as well. Kosovo is missing ("de jure" still part of Serbia), probably they don't yet have seperate postal addresses so that won't make any problem either. Hungary's zones in this file are a crazy mix of counties and a few cities _and_ we don't need to include the county name in postal address at all. I've just started to play around with Übercart and I really like it but I found this part quite flaky. I'll simply go with the full list of countries with an optional State/Region field.  I'll simply go with the full list of countries with an optional State/Region field. That's what I've done too, for similar reasons. I have customers in 53 countries other than the US, and trying to impose Zones is more trouble than it's worth. May I ask that how specifically did you implement the custom address field?
|
|
?
Joined: 08/13/2007