| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Steps for Implementers | |||||||||||||||||||||||||
2 | This catalog uses data from the following sources: a. ISO Codes: https://unstats.un.org/unsd/methodology/m49/ and https://github.com/lukes/ISO-3166-Countries-with-Regional-Codes/blob/master/all/all.csv b. Geolocations: https://worldmap.harvard.edu/data/geonode:country_centroids_az8 | |||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | 1. Configure the following new fields on the ampi__Geographical_Area__c object: 1a. Text(3) field 'M-49 Code' to store the M-49 Codes for Continents, Regions, Sub Regions, and Countries 1b. Text(3) field 'ISO Alpha 3 Code' to store the ISO Alpha 3 codes for Countries 1d. Text(2) field 'ISO Alpha 2 Code' field to store the ISO Alpha 2 code for Countries | |||||||||||||||||||||||||
5 | 2. The tab named "ampi__Geographical_Area__c (Continents)" contains the highest level regions (i.e. continents). Upload it to ampi__Geographical_Area__c object | |||||||||||||||||||||||||
6 | 3. The tab named "ampi__Geographical_Area__c (Regions)" contains the second highest level regions. Upload it to ampi__Geographical_Area__c object using dataloader.io and mapping Parent Geographic Area by lookup via Geographic Area Name field OR Use VLOOKUP to replace the values in column Parent Geographic Area by Salesforce IDs of Geographic Area records of continents (uploaded in step #2), and then upload it via dataloader | |||||||||||||||||||||||||
7 | 4. The tab named "ampi__Geographical_Area__c(Sub-Regions) contains the third highest level regions. Upload it to ampi__Geographical_Area__c object using dataloader.io and mapping Parent Geographic Area by lookup via Geographic Area Name field OR Use VLOOKUP to replace the values in column Parent Geographic Area by Salesforce IDs of Geographic Area records of regions (uploaded in step #3), and then upload it via dataloader | |||||||||||||||||||||||||
8 | 5. The tab named ampi__Geographical_Area__c (Countries) contains the countries. Upload it to ampi__Geographical_Area__c object using dataloader.io and mapping Parent Geographic Area by lookup via Geographic Area Name field OR Use VLOOKUP to replace the values in column Parent Geographic Area by Salesforce IDs of Geographic Area records of countries (uploaded in step #4), and then upload it via dataloader |