Page Comparison

Follow the procedure below in order to update your existing Geo Location dataset to use in Configuring Geolocation Based Statistics.

1. Download the latest CSV file from here.

2. Download the geoip-2-csv-converter from https://github.com/maxmind/geoip2-csv-converter/releases according to your operating system.

...

1. Unzip the latest CSV file and the geoip-2-csv-converter your downloaded in step 1 and 2 above.

2. Run  update-geolocation-data.sh file with below command.

   sh update-geolocation-data.sh

   
   

   • Enter the path to extracted GeoLite2-City-Blocks-IPv4 directory which you downloaded first as the response for “Enter path to GeoLite2-City-Blocks-IPv4 directory: “

      E.g :   /<PATH_TO>/GeoLite2-City-CSV_20171107

     
     

   • Enter path to geoip2-csv-converter directory as the response for “Enter path to geoip2-csv-converter home directory:" 

     E.g :  /<PATH_TO>/geoip2-csv-converter-v1.0.0

     
     

   • After script execution, you will find the final.csv file inside the current directory you are in.

     Code Block
     ** get first column form original ** change column name to ‘network_cidr’ ** Extract ip address data ** change column name to ‘network_blocks’ ** extract entries from original cut: /home/chamalee/xxx/geoip2-csv-converter-v1.0.0/GeoLite2-City-Blocks-IPv4-converted.csv: No such file or directory ** change column name to ‘network’ ** change column name to ‘broadcast’ ** merge csv files

3. Shut down both APIM and APIM-Analytics servers if you are running them already.
4. Truncate BLOCKS and LOCATION tables from GEO_LOCATION_DATA database.

...