Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-17184

Some "States" (Departments) are missing from El Salvador

    Details

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

      Description

      El Salvador has 14 Departments. Departments are like States or provinces. There are only 11 in the civicrm_state_province.

      The following are missing:
      Department Abbreviations
      ---------------- -------------------
      La Libertad LI
      La Paz PA
      La UniĆ³n UN

      INSERT INTO `civicrm_state_province`
      (`name`, `abbreviation`, `country_id`)
      VALUES
      ('La Libertad', 'LI', 1066),
      ('La Paz', 'PA', 1066),
      ('La Union','UN', 1066)

      Source: http://www.statoids.com/usv.html
      https://en.wikipedia.org/wiki/Departments_of_El_Salvador (doesn't list abbreviations)

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              Paul-Tahoe Paul Hugo
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: