Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

getting location from table of ip addresses

Posted on 2014-09-17
2
Medium Priority
?
270 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 1500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses

824 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