CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Need Hong Kong states/districts
Pages: [1]

Author Topic: Need Hong Kong states/districts  (Read 9585 times)

craigntammy

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
Need Hong Kong states/districts
July 24, 2007, 02:11:11 am
Hi I need to know how to add the 18 districts of hong kong to the states drop down list They are not included for some reason but they are necessary for mail to actually get where it needs to go!

I am willing to add them myself just need to be pointed in the wright direction.

These are the districts

1. Islands; 2. Kwai Tsing; 3. North; 4. Sai Kung; 5. Sha Tin; 6. Tai Po; 7. Tsuen Wan; 8. Tuen Mun; 9. Yuen Long; 10. Kowloon City; 11. Kwun Tong; 12. Sham Shui Po; 13. Wong Tai Sin; 14. Yau Tsim Mong; 15. Central and Western; 16. Eastern; 17. Southern; 18. Wan Chai

Thanks

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Need Hong Kong states/districts
July 24, 2007, 03:19:57 am
Hm, indeed our database is missing the 18 Hong Kong districts. I’ll add them to CiviCRM 1.8 and let you know how to add them to your database so it’ll work when you upgrade to CiviCRM 1.8.

I filed CRM-2125 to track this.
« Last Edit: July 24, 2007, 03:22:19 am by Piotr Szotkowski »
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Need Hong Kong states/districts
July 24, 2007, 03:26:06 am
One more question: we associate an abbreviation with every district name. Are there any widely-used abbreviations for the 18 districts? Or, if not, are the above numbers widely-used to mean the respective districts?
« Last Edit: July 24, 2007, 03:37:55 am by Piotr Szotkowski »
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

craigntammy

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
Re: Need Hong Kong states/districts
July 24, 2007, 06:03:31 am
This seems to be the "official" order of the 18 districts
they (the hk government on their sites) divide them into 3 main categories (hong kong island, kowloon, and new territories) and then in each category the put them in alphabetical order
I have also added the Chinese characters for each don't know if this should be added here or into the translations for traditional Chinese
as far as abbreviations I don't think there are any, numbers 1-18 should be fine I cant seem to find a standard though


Central & Western District ( 中西區 )  CW
Eastern District ( 東區 )  EA
Southern District ( 南區 )  SO
Wan Chai District ( 灣仔區 )  WC

Kowloon City District ( 九龍城區 )  KC
Kwun Tong District ( 觀塘區 )  KU
Sham Shui Po District ( 深水埗區 )  SS
Wong Tai Sin District ( 黃大仙區 )  WT
Yau Tsim Mong District ( 油尖旺區 )  YT

Islands District ( 離島區 )  IS
Kwai Tsing District ( 葵青區 )  KI
North District ( 北區 )  NO
Sai Kung District ( 西貢區 )  SK
Sha Tin District ( 沙田區 )  ST
Tai Po District ( 大埔區 )  TP
Tsuen Wan District ( 荃灣區 )  TW
Tuen Mun District ( 屯門區 )  TM
Yuen Long District ( 元朗區 )  YL
« Last Edit: July 24, 2007, 06:35:20 am by craigntammy »

craigntammy

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
Re: Need Hong Kong states/districts
July 24, 2007, 06:30:48 am
Ok I found the abriviations at this site

http://www.statoids.com/uhk.html

will edit them in to the above post

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Need Hong Kong states/districts
July 24, 2007, 08:28:31 am
Thanks. I added the districts to the database for 1.8 and to the 1.7-to-1.8 upgrade script.

For those who want to have these provinces now, please issue the following SQL command in your CiviCRM database:

Code: [Select]
INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
(5177, 1098, "CW", "Central and Western"),
(5178, 1098, "EA", "Eastern"),
(5179, 1098, "SO", "Southern"),
(5180, 1098, "WC", "Wan Chai"),
(5181, 1098, "KC", "Kowloon City"),
(5182, 1098, "KU", "Kwun Tong"),
(5183, 1098, "SS", "Sham Shui Po"),
(5184, 1098, "WT", "Wong Tai Sin"),
(5185, 1098, "YT", "Yau Tsim Mong"),
(5186, 1098, "IS", "Islands"),
(5187, 1098, "KI", "Kwai Tsing"),
(5188, 1098, "NO", "North"),
(5189, 1098, "SK", "Sai Kung"),
(5190, 1098, "ST", "Sha Tin"),
(5191, 1098, "TP", "Tai Po"),
(5192, 1098, "TW", "Tsuen Wan"),
(5193, 1098, "TM", "Tuen Mun"),
(5194, 1098, "YL", "Yuen Long");

(This way your install will have the same ids as our ‘official’ one, which is a Good Thing™ to have.)
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

craigntammy

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
Re: Need Hong Kong states/districts
July 24, 2007, 08:49:41 am
Works Great
Thanks a lot
 
 :)

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Need Hong Kong states/districts

This forum was archived on 2017-11-26.