Use a coherent county list, with ISO abbreviations in DB

Ideas and Feature Requests
21

Name of the folder is probably wrong.

Make sure its named MZagmajsterIsoCodeBundle.

22

Yes indeed, the folder was not named that, now it is installed. Thank you!

23

I would extend this issue to include the country and region list. Countries are a painful issue, but it is manageable. When it comes to regions, the situation is worse. They are fairly well defined for most Western countries, but it is getting messy for the rest of the world. Several countries have wrong or outdated information when it comes to the Regions file. Some regions are simply missing. There are also some inconsistencies like Brazilian states are without accents, when the rest of the world has accents on their state names.

What would be needed:

  1. Find an authoritative source like the CLDR charts, or maybe this libary which is based on CLDR: GitHub - commerceguys/addressing: A PHP addressing library, powered by CLDR and Google's address data.
  2. To change those definitions at: mautic/app/bundles/CoreBundle/Assets/json at 5.x · mautic/mautic · GitHub to include a key/value pair, so that a two letter country code is associated to the country name, and the sames for the region definitions. Having this information, we could extend the API to accept in the country field the two letter code or the written out country name, and the same for the state definitions.
  3. As a next step it can be even considered to save the two letter code instead of the name in the database. This would save some space, and would reduce also the number of database updates in case of name changes. I am not much familiar with Symphony, but I assume that such a change can be done just on the model layer, without the View and Logic being aware of any change in the database.
1 Like
24

I have opened a proposal here:

Come and throw in your vote for that issue!

1 Like