search

ivylabs / suitecrm-data-integration

7 stars 5 forks source link

Create Country Mapping ETL #8

Open harrisward opened 5 years ago

harrisward commented 5 years ago

By default SuiteCRM allows users to enter country data via a text field. Its possible to enable the countries_dom dropdown for this field. The values for this dropdown are locate in suitecrm/include/language/vim en_us.lang.php as a php array.

We need to get this array, parse it and map it to country ISO codes in the ETL to support the IvyDC map component

samus-aran commented 4 years ago

This array isn't stored in the database anywhere so the only way to get this is via the actual files of SuiteCRM (include/language/etc) which has it's own issues, or a API call (which I don't think exists yet to get counties dom or any dom), or pre-define the countries list in a file within ETL which the user can copy/pasta their custom counties dom to via a configuration file.

Ideally it would be great to get the call via the API (both v4_1 & V8) without authentication but that would require either upgrading their instance.

I would suggest just pre-defining it which the user setting up the installation can overwrite it if it defers to their instance's countries dropdown list.

countries_cvs.txt