Solved

getting location from table of ip addresses

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is the optimum percentage to save images for webs. 4 31
MediaWiki - Move a site 4 30
deprecated mysql extensions 1 22
compare date to getdate() 8 14
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

740 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