This Example Demonstrates how to Download IP Locations data file and how to prepare it for range lookup

  • Download and install Advanced ETL Processor [Link]
  • Download and Unzip example [Link]
  • Create a new directory and call it IP Locations
  • Create a new transformation and open .ats file
  • Create a new package and open .wfp file

Directory 

Getting Refresh token

dowload ip location

package

  • Double click on Set Variables package action and amend values of DOWNLOAD_TOKEN and DATABASE_CODE

set variables

  • Double click on transformation and select 0002 IP Locator Transformation

transformation action properties

  •  Run the package by pressing the green arrow.

Note: transformation is used to prepare data for the range lookup transformation function

transformation

About IP2Location

IP2Location™ is a non-intrusive geo IP solution to help you to identify visitor's geographical location, i.e. country, region, city, latitude, longitude, ZIP code, time zone, connection speed, ISP and domain name, IDD country code, area code, weather station code and name, mobile carrier information, elevation &amp; usage type<br>using a proprietary IP address lookup database and technology without invading the Internet user's privacy.

Please contact us if you need help with transforming the data

Visit ETL Tools Forum