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
Solved

getting location from table of ip addresses

Posted on 2014-09-17
2
259 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
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

856 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