How to populate a CB Field with a Country List

16 years 3 months ago #16088 by madcat
Replied by madcat on topic Shame on whoever created the country list !
Never expected politics will get into a CB open source component... :(

Line #170 in the country list.txt

The word "Occupied" shouldn't be there.... this is not a political article but a country list for use in general sites. Besides there is no such country yet... ok they need a name fine, no problem. But no one occupied them. they have their own government. and that actually doesnt matter for the purpose of this list.......

That would be nice if someone fix the "bug" in the file that is available for download.

Please Log in to join the conversation.

16 years 2 months ago #16757 by heymcd
The attached SQL contains the entire list of 400+ countries recognized by the US and Canadian postal services.

The list has been formatted so that USA, Canada and UK are the top three values, then a seperator, then the remainder of the values.

Create your custom cb_country field.

Replace the 'YY' with your table pre-fix, replace the 'XX' with your fieldid.

Tested successfully using phpMyAdmin 2.8.1 against a mySQL 5.0.18 database.

All the best, Bill.

Attachment Country_SQL.txt not found



Post edited by: heymcd, at: 2006/07/09 12:39

Post edited by: heymcd, at: 2006/07/09 12:42
Attachments:

Please Log in to join the conversation.

16 years 2 months ago #16759 by heymcd
The attached SQL contains the entire list of 70+ states, provinces and territories recognized by the US and Canadian postal services.

The list has been formatted so that US values are the top values, then a seperator, then the Canadian values.

Create your custom cb_state field.

Replace the 'YY' with your table pre-fix, replace the 'XX' with your fieldid.

Tested successfully using phpMyAdmin 2.8.1 against a mySQL 5.0.18 database.

All the best, Bill.

Attachment State_SQL.txt not found

Attachments:

Please Log in to join the conversation.

16 years 2 months ago #16760 by madcat
thanks !

Do you have a plain text version of these files ? i mean without the SQL ....

Please Log in to join the conversation.

16 years 2 months ago #16761 by heymcd
The attached plain text file contains the entire list of 400+ countries recognized by the US and Canadian postal services.

Attachment Country.txt not found

Attachments:

Please Log in to join the conversation.

16 years 2 months ago #16762 by heymcd
The attached plain text file contains the entire list of 70+ states, provinces and territories recognized by the US and Canadian postal services.

Attachment State.txt not found

Attachments:

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.256 seconds

Facebook Twitter LinkedIn