The standard Slate exports for country values, such as citizenship and address, show the full country name. To meet external system requirements for country codes, use translation codes to export ISO Alpha-2, ISO Alpha-3, FIPS 10-4, or custom country code values.
📝 Note
Standard country and region lists can change when Slate updates these values. Displayed names can change, and values can become active or inactive. Review integrations, imports, exports, reports, and other data feeds that reference country or region names after a standard-list update.
How translation codes work for country values
For string-based translation codes, you’ll create a translation code for each country value that should return a code. After the Country Code translation key exists in your database, you can use it to export ISO Alpha-2, ISO Alpha-3, FIPS 10-4, and custom country codes for each country. If you use custom country codes, edit the translation codes manually or update them in batch.
The export values for these translation codes are as follows:
Export | Code |
|---|---|
Export Value | ISO Alpha-2 |
Export Value 2 | ISO Alpha-3 |
Export Value 3 | FIPS 10-4 |
Export Value 4 | Custom |
Export Value 5 | Custom |
📝 Note
Some active country values do not have a code for every standard code type. For these countries, the associated export value is intentionally blank.
Adding or updating translation codes
Country code translation codes are managed in Database → Translation Codes. Create or import the Country Code translation key before using it in exports. For steps to create translation keys and translation codes manually, see Translation Codes.
For a full country code list, batch import is typically the faster way to add or update country code values. For many values, add or update translation codes in batch with the Translation Code Import source format from Database → Source Format Library.
Editing translation codes
Edit a small number of country code values from the Translation Codes tool:
Go to Database → Translation Codes.
Select the Country Code translation key. If your database has many translation keys, use the search box to find the Country Code key.
Select the translation code to edit. Use the Search box to find a specific translation code.
Update the export values.
Select Save.
Using translation codes
Use translation codes in exports in the Query Builder, Report Builder, and Rules Editor. Set Export Value to one of the Translation Code options, and then select the translation code key.
For example, to export a country's ISO Alpha-3 value, set Translation Value to Export 2 Value and set Translation Key to Country Code.
For recurring integrations and data feeds, use an agreed country code instead of the displayed country name when the receiving system supports that code. Confirm whether the receiving system expects ISO Alpha-2, ISO Alpha-3, FIPS 10-4, or a custom value. Review custom translation values after standard-list updates.
