Solved

getting location from table of ip addresses

Posted on 2014-09-17
2
265 Views
Last Modified: 2014-09-17
Hi,
i have been using the jdownloads extension on joomla site for a while now and it has been keeping logs of all downloaded files including a list of ip's

i would like to find a way to geolocate these ip's (ie - to find out what country they came from)

since i have 32000 records, its not something i can do manually, any suggestion of a tool / website / ??? that will do this for would be greatly appreciated.

(this is a one-time need, i will not have to do this again, if this changes the approaches suggested)

Cheers,
weaverk
0
Comment
Question by:weaverk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 2

Accepted Solution

by:
Akilandeshwari N earned 500 total points
ID: 40327513
You can download the database from http://db-ip.com/db/download/country and compare it with your IP list. Before comparing, have your IP list in an other sheet in the file you downloaded. Writing a simple formula to compare both the sheets would do well.
0
 
LVL 1

Author Closing Comment

by:weaverk
ID: 40327579
thanks
0

Featured Post

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
Make the most of your online learning experience.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Simple Linear Regression

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question