2 replies to this topic

[ilustrate]

i downloaded the Mexican Zone contribution but have no idea how to install it. it is basically just an sql file with all the states and values setup

like this but with all the states...

insert into zones (zone_id, zone_country_id, zone_code, zone_name) values (NULL, '138', 'AGS', 'Aguascalientes');
insert into zones (zone_id, zone_country_id, zone_code, zone_name) values (NULL, '138', 'BC', 'Baja California');
insert into zones (zone_id, zone_country_id, zone_code, zone_name) values (NULL, '138', 'BCS', 'Baja California Sur');

how do i import this? i use phpmyadmin for mySQL management.

do i upload this somewhere in the admin panel?

[Skribble]

I had the same problem... I downloaded the zones for the uk and it does have instructions, it has to be the same for mexico:

INSTALLATION
1. Start phpMyAdmin
2. Select 'Zones'
3. Click on 'SQL'
4. Click on 'Browse...' and select 'ukcounties.sql'
5. Click on 'Go'
6. You now have a complete list of UK counties in the database.


Just replace the name of the file with the one you have

[ilustrate]

Skribble, on Jul 13 2005, 03:48 PM, said:

I had the same problem... I downloaded the zones for the uk and it does have instructions, it has to be the same for mexico:

INSTALLATION
1. Start phpMyAdmin
2. Select 'Zones'
3. Click on 'SQL'
4. Click on 'Browse...' and select 'ukcounties.sql'
5. Click on 'Go'
6. You now have a complete list of UK counties in the database.
Just replace the name of the file with the one you have

<{POST_SNAPBACK}>

thanks a lot the instructions you gave me worked perfectly. i appreciate that.