CRM-17852 Misspeled state names in Estonia/Lithuania

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Trivial
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.6.11, 4.7
          • Fix Version/s: 4.7.1
          • Component/s: Core CiviCRM
          • Labels:
          • Documentation Required?:
            None
          • Funding Source:
            Contributed Code

            Description

            Hi,
            for Estonia we have some misspelled state names in core.
            Based on https://en.wikipedia.org/wiki/ISO_3166-2:EE states should be corrected:

            misspelled valid
            Harjumsa Harjumaa
            Hitumea Hiiumaa
            Ida-Virumsa Ida-Virumaa
            Jarvamsa Jarvamaa
            Jogevamsa Jogevamaa
            Lasnemsa Laanemaa
            Parnumsa Parnumaa
            Polvarmea Polvamaa
            Raplamsa Raplamaa
            Saaremsa Saaremaa
            Tartumsa Tartumaa
            Viljandimsa Viljandimaa

            Also for Lithuania there is one misspelled state:

            misspelled valid
            Sisuliu apskritis Šiaulių Apskritis

            Based on: https://en.wikipedia.org/wiki/ISO_3166-2:LT

              Attachments

                Activity

                [CRM-17852] Misspeled state names in Estonia/Lithuania
                Joakim Särehag added a comment -

                Asked in IRC since there still are some mismatches between the ISO description on wikipedia and the suggestion, and I used the iso description. This means that there are more ä and õ in the names.

                Example, issue states
                Jarvamsa ->Jarvamaa
                wikipedia says Järvamaa

                I have created a pull request for this.

                Eileen McNaughton added a comment -

                I just merged this since it had merge on pass - but now I have some misgivings. Shouldn't the sql have been

                UPDATE civicrm_state_province SET name = 'Harjumaa' where name = '"Harjumsa";

                Eileen McNaughton added a comment -

                Thanks for fixing this & being so tolerant about us asking you to change it

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    Lukasz Krutul

                    Dates

                    • Created:
                      Updated:
                      Resolved: