US States vs UK Counties

Hi There,

I've disabled all but the United Kingdom, as that is the only territory that we will be launching in, for now anyway. This has left 4 'States' as your MembershipPro calls them, England, Wales, Scotland and Northern Ireland when really they're countries within the UK.

Separate to this, I need to add a list of each of the actual counties as we call them within the 4 of these countries within the UK... how can I achieve this list, that can then be picked up during registration process in a dropdown box please, this is imperative as in this day and age, the user should not have to type something like their county in and instead just select their desired one from a dropdown box list.

I look forward to your thoughts and hopefully a solution.

Regards,

Hi Robert

Not sure I understand your requirement. However, you can access to Membership Pro -> Setup -> States to add new states to meet your need.

Please give it a try and update us with the result

Regards,

Tuan

Tuan Pham Ngoc wrote: Hi Robert

Not sure I understand your requirement. However, you can access to Membership Pro -> Setup -> States to add new states to meet your need.

Please give it a try and update us with the result

Regards,

Tuan

Tuan,

Thanks for the reply and ok I will do as you mention here and see what happens, I will update this thread as soon as I have completed this task and have an outcome, one way or the other.

Regards,

Tuan Pham Ngoc wrote: Hi Robert

Not sure I understand your requirement. However, you can access to Membership Pro -> Setup -> States to add new states to meet your need.

Please give it a try and update us with the result

Regards,

Tuan

Hi Tuan,

I now know that I can update the States by adding new one's, well in the UK they're called 'Counties' so I created a language override so they're named Counties but your extension only comes with North American states included.

Therefore, I would like to ask if there's any possibility that I can insert the full UK counties list in a text file format, probably comma delimited directly in to the database; as to insert new counties manually will take me forever, as there's over 100?

Maybe you could help kindly advise me what table / record in the database this would need an sql query to be run, not that I know what query would work at this point. I have full access to the database via phpmyadmin but only enter there if and when I need to do some basic maintenance or run a query etc.

Also, in the screenshot see the red highlighted two fields;



State Code 3
State Code 2

However, I have tried finding this out online but there doesn't seem to be any 'Official' state (county) codes used in the UK... are these two state codes actually required for your extension / component to work?

I look forward to hearing from you.

Regards,