Magento

Hi,

I want my State/Region field to be a drop down list. So I add States for Malaysia to

table :
- directory_country_region
- directory_country_region_name

helps a lot when you want to set TableRate Shipping later.

so, here’s the sql.

mys-region.sql  (File Size: 2KB - Downloads: 1457)

mys-region-name.sql  (File Size: 2KB - Downloads: 1055)

Hi,

Wonderful codes you have there.

Thank you for contributing to the Malaysian community at Magento.

If you are interested, you can also help out in the translation of Magento from English to Bahasa Malaysia.
For more info, please refer to the thread below:-
http://www.magentocommerce.com/boards/viewthread/8203/

Thank you.

Regards,
James
Moderator for Malaysia Translations & Founder of Malaysian Magento Group

hi sham, i would like to ask where to put the code in...thank you…

Those files provided are sql dump files. For me I used SQLyog (a mysql gui) to import it into my database.

How do i add multi language State/Region drop down list ?

Thanks.......for useful mysql file............

Hi all, good to have many Malaysian here using Magento.

Thanks Shambie as I finally get to use your database and it works really well.

Hi,

I am new to Magento and may I know how can I add these to my store?

I have added the sql to my database and what should I do next?

Thank you!

@alvinluo

You may have already figured out that once you select the Country in Onepage, the Region dropdown will be populated with the state names and there’s really nothing else to do.

I’m using Magento ver. 1.3.2.3 and importing the provided SQL gives the following error in phpmyadmin;

#1062 - Duplicate entry ‘182’ for key 1

and so I edited the original SQL file to the following, and it works

mys-region.sql  (File Size: 2KB - Downloads: 507)

mys-region-name.sql  (File Size: 2KB - Downloads: 461)

Thanks, you are rocks.... I already loaded in and it work great. Now can select state and detect state from my multiple table.

Why here I?m getting this error?
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 \’INSERT INTO `directory_country_region` VALUES(382, \’IT\’, \’AG\’, \’Agrigento\’)\’ at line 6

Hi Shambie,

I need some help.
I’ve imported the 2 SQL files you provided to my database.

Trying to setup the TableRate for shipping but I’m prompted with these errors.

An error occurred while saving this configuration: Invalid Region/State “PER” in the Row #38. Invalid Region/State “PER” in the Row #39.

Before Row 39, all the others are set to * so it works.
The Country is set to MY as per your file. Also tried MYS, but both won’t work.
Tried to look for a solution online but to no avail.

Could you help please?
It’s my first time doing this and I’m totally lost…

Appreciate your help!

Thank you!

shambie - 05 June 2008 06:58 PM

Hi,

I want my State/Region field to be a drop down list. So I add States for Malaysia to

table :
- directory_country_region
- directory_country_region_name

helps a lot when you want to set TableRate Shipping later.

so, here’s the sql.

Thanks a lot for your effort.

shambie - 05 June 2008 06:58 PM

Hi,

I want my State/Region field to be a drop down list. So I add States for Malaysia to

table :
- directory_country_region
- directory_country_region_name

helps a lot when you want to set TableRate Shipping later.

so, here’s the sql.

Woohoo! Thanks a lot!