Propose new Mautic features

Fingerprint

The piece of text below is a shortened, hashed representation of this content. It's useful to ensure the content hasn't been tampered with, as a single modification would result in a totally different value.

Value: acc07fa1050f5570fbc22badceeb88b56e5b54df9772b941d84eeb74129ab8c6

Source: {"body":{"en":"<p><strong>Has your proposal been discussed on the Mautic Forums already?</strong><br>https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816<br></p><p><strong>Is your feature request related to a problem? Please describe.</strong><br>It is very challenging to add a contact or company via API including a full address, because if country and state fields are not an exact match according to the Mautic regions definitions, the request gets rejected. As an aggravating factor, naming conventions on both country and region definitions are inconsistent, and regions of several countries are incomplete or outdated. Those issues are surely affecting geolocalization as well, since an exact match can hardly be guaranteed under such circumstances.<br></p><p><strong>Describe the solution you'd like</strong><br></p><p>I would propose:</p><p><br></p><ol><li>To find an authoritative source like the CLDR charts and update the whole file countries.json and regions.json accordingly:<strong><br></strong> <a href=\"https://www.unicode.org/cldr/charts/45/by_type/index.html\" rel=\"noopener noreferrer\" target=\"_blank\">https://www.unicode.org/cldr/charts/45/by_type/index.html</a><strong><br></strong> I am not sure if CLDR is the best authoritative source, but it is surely a good option. If anybody can suggest something better, please comment. Probably there is a way to even extract this information programmatically. A good option might be this libary, that provides already correct data as a PHP implementation:<br>https://github.com/commerceguys/addressing<br>It would be interesting to also investigate, which standards the geolocalization services are using to deliver country and state information.<strong><br></strong> I am aware that updating this definitions will require a database update, but it is better to do that once well done then to have 100 pull requests, because somebody is accidentally stepping over a wrong definition that they happened to find.</li><li>To change those definitions 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. Using the above library would resolve this problem as well.</li><li>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.<br><br>For migration purposes we need to do a matching of the current definitions with the new values, which can probably be assisted by AI.</li></ol>\ngid://app/Decidim::Hashtag/2/_Mautic"},"title":{"en":"Cleanup of Countries and Regions List and Implementation of 2 Digit Country Codes"}}

This fingerprint is calculated using a SHA256 hashing algorithm. In order to replicate it yourself, you can use an MD5 calculator online and copy-paste the source data. ×