![]() Can be easily queried using the SDKs provided by IP2Location.Again, there are pros and cons with using the BIN file. The BIN binary file is a proprietary format that IP2Location have created to be queried using various Software Development Kits (SDKs). As mentioned above, IP2Location provides data in either a CSV file or a BIN binary file. Now, let’s take a look at the BIN database file. The loaded data requires gigabytes of storage with additional storage needed during updates. ![]() Another server is needed to run the relational database (assuming you have it separate from your main server).May have disruption during the database update since the table needs to be dropped and recreated.Need to download the latest data monthly and perform importing into database server.Depending on your infrastructure, the database can be scalable.A well-tuned relational database can perform very well under heavy load, especially with proper indexing and caching enabled.Easy to integrate no matter what programming language you’re using.There are pros and cons of this method of getting your geolocation data. Then you can make SQL queries from your website or application. If you’re going with the database route, you have the option of loading the CSV file into a relational database like MySQL, SQL Server, PostgreSQL or Oracle. In addition to the database method, users can also opt to make RESTful calls to the IP2Location Web Service (API service) to get the data they need. The first method is via the IP2Location database in the form of either a CSV (comma-separated values) file or a BIN binary data file. To make it easy for users to integrate the IP2Location data into their own websites or applications, IP2Location has provided 2 main methods of consuming the geolocation data. There are many uses for such data in online advertising, marketing as well as security applications. With just the IP address, their physical locations like city, state and country can be easily determined. It uses the UrlFetchApp service to perform multiple HTTP requests in a single batch for improved performance.IP2Location geolocation data helps users to detect the location of persons by their IP addresses. Internally, the Google Sheet uses the IP2location web service with Google Apps Script to transform IP addresses into geographic region. If you have a small list of IP address, use demo as the key or get your own API key from .Ĭlick the Run button, authorize the script and watch as the geographic details and ISP names are populated in the sheet. The lookup service works for both IPv4 and IPv6 addresses.Įnter your key in cell E1. Paste the list of IP addresses in column A, one per row. ![]() If you have a bulk list of IP addresses, you can use Google Sheets to estimate the corresponding geographic details for each of the addresses in few easy steps:Ĭlick here to make a copy of the Google Sheet for performing IP lookups in bulk. The IP location lookup service can retrieve the client’s country, city name, region, the ISP name and more. IP2Location is another good alternative that retrieves more detailed geolocation information for any IP address. We internally use that service at Digital Inspiration to determine the payment service provider on the checkout page. There are free web IP lookup services, for example, that will reveal the country of your client’s IP address with a simple HTTP request. ![]() A currency exchange website can determine your default currency based on your country which is detected from your IP address. For example, a weather website may use your IP address to estimate your approximate location and provide weather forecast for your current city automatically. Websites can determine the visitor’s geographic location using their IP address and serve more relevant content. How to determine the country, city and ISP name of IP addresses in bulk with Google Sheets and IP2Location service. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |