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

Ability to export US state 2-letter abbreviations

    Details

    • Type: New Feature
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.2
    • Fix Version/s: 1.3
    • Component/s: None
    • Labels:
      None

      Description

      The general option to make exported address data conform to US postal service guidelines would be great, but a particular subset of that issue seems more pressing: two-letter US state abbreviations. Currently the system seems to import two-letter abbrv. and translates them into full state names (including for export). That is nice for display, but we need those two-letter abbreviations again for export.

      I could create an Excel macro to do all the find/replacing but that seems like a bit too much post-export work.

      More broadly, maybe data export transformations could be plug-in-able on the export screen, so users could contribute their own sets of transformations and use/ignore them Drupal module-style. On the export screen then there would be a list of available transformations and corresponding checkboxes to apply/ignore them.

      You could make the same transformations available for input too, perhaps.

      -jesse@idcwebdev.com

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              jesse_idc Jesse Mortenson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: