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) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Counties in Wales (UK)
Pages: [1]

Author Topic: Counties in Wales (UK)  (Read 680 times)

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Counties in Wales (UK)
March 26, 2015, 04:22:28 am
The data in the current CivicRM database for states in the UK (civicrm_state_province) lists the following for counties in Wales:

2678   Gwynedd   GWN   1226
2757   Powys   POW   1226
2804   Mid Glamorgan   VGL   1226
9998   West Glamorgan   WGM   1226
10013   Clwyd   CWD   1226
10014   Dyfed   DFD   1226
10015   South Glamorgan   SGM   1226

Current information (source: https://en.wikipedia.org/wiki/Local_government_in_Wales) suggests the following:

Blaenau Gwent
Bridgend (Pen-y-bont ar Ogwr)
Caerphilly (Caerffili)
Cardiff (Caerdydd)
Carmarthenshire (Sir Gaerfyrddin)
Ceredigion
Conwy
Denbighshire (Sir Ddinbych)
Flintshire (Sir y Fflint)
Gwynedd
Isle of Anglesey (Ynys Môn)
Merthyr Tydfil (Merthyr Tudful)
Monmouthshire (Sir Fynwy)
Neath Port Talbot (Castell-nedd Port Talbot)
Newport (Casnewydd)
Pembrokeshire (Sir Benfro)
Powys
Rhondda Cynon Taf
Swansea (Abertawe)
Torfaen (Tor-faen)
Vale of Glamorgan (Bro Morgannwg)
Wrexham (Wrecsam)

How do we go about getting things updated, or is it just left to individual users to amend their databases? I can see that it could cause all sort of issues with historic data.
Graham Mitchell
http://mc3.coop

MJCO

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviPal (CiviCRM + Drupal) lover
    • MJCO
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.xx
  • MySQL version: 5.5
  • PHP version: 5.4
Re: Counties in Wales (UK)
April 12, 2015, 08:16:31 am
See issue on issue tracker here: https://issues.civicrm.org/jira/browse/CRM-16279
MJCO

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Counties in Wales (UK)
April 13, 2015, 10:10:33 am
One of my clients wanted to 'see' the UK as four different countries, with the counties related to each country.  So I manually updated civicrm_state_province using my own made up 'country_id' for the countries.  But the counties are practically an impossibility to satisfy everyone, so you just have to do your best.  Perfect example... (stand back)... there is no such county as Yorkshire !!!! :D   Historically, of course, but it doesn't exist in any administrative way... but you know that.
Andy Clark

MJCO

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviPal (CiviCRM + Drupal) lover
    • MJCO
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.xx
  • MySQL version: 5.5
  • PHP version: 5.4
Re: Counties in Wales (UK)
April 13, 2015, 12:23:50 pm
That was part of the reason behind suggesting that maybe using the ISO subdivisions list may be the most appropriate. Counties are not required, recommended or used for post any more, so the 'postal counties' list is a thing of the past.

Ideally - I'l like to see it disappear from Addresses in CiviCRM altogether but that's not likely ;-)
MJCO
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Counties in Wales (UK)

This forum was archived on 2017-11-26.