KB208680: How to add a Country Alternative Name to be automatically geocoded when using Data Import in MicroStrategy Web

How to add an additional Country Alternative Name 

• In the Strategy intelligence Server machine locate the following file typically under:
  

  
  C:\Program Files (x86)\Strategy\Intelligence Server\Country.csv

  
  Note: Backup this file for future reference.
   
• Stop the Intelligence Server
   
• Open this file with a text editor, such as Notepad++. 
   
• Locate the line with the country that needs to be modified. For example, "Democratic Republic of Congo" is located on line 20 and has the ID 19 by default as shown below:
  

  
  19,"Democratic Republic of the Congo","Austur-Kongo [...]

  
  Notice that in the Country.csv lookup table the third column corresponds to the Country Alternative Names
   
• In the third column add the entries needed separated by a comma. Notice that columns are always enclosed by double quotes and are also separated by commas. In the example above the alternative name "CongoDRC" will be added and the portion of the line will look similar to the one shown below:
  

  
  19,"Democratic Republic of the Congo","Congo DRC,Austur-Kongo [...]

  
  Note: No extra spaces or characters should be added unless they want to be used in the comparison. 
   
• Save the file with Unicode Encoding. In Notepad++ this will be equivalent to UTF-8 as shown below:
  
  

• Note: This is very important in order for the Intelligence Server to be able to read the file correctly.
   
• Start the Intelligence Server.
  Note: Every change on any look up tables require a server restart.

Third Party Software Installation
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.