Hi, I have a working GeoIP-based report for Analog 5.31. You can see a sample report and download the patch from:
http://bigmac.mugnolo.com/analog/ For those who asked, I have succesfully compiled a Win32 version of Analog 5.31 with the patch applied. The command line is +e. If enough interest and feedback exists, I plan to integrate support for other IP address-to-location database formats -- the "open" ones, first. I'm looking at Geobytes now, but unfortunately they don't seem to provide an open API and database to start playing with. Regards ----- Original Message ----- From: "Craig Keefner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 1:23 PM Subject: [analog-help] Geo-IP lookups > I want to replace an existing Webtrends report via Analog which is the "Visitor > By Country" which uses their geotrends ip database. > > i am thinking that I can use the geo-ip database from www.maxmind.com ($50) as > my DNSCache and accomplish that. > > If someone can tell me what is involved (and whether I am on a good track), I > would sure appreciate it. I understand the limitation of truly accurate results > but I have some pretty stubborn sales/marketing folks to make happy. > > They have an optmized binary file for use with APIs (perl/c/etc) and as that is > faster and I have perl skills inhouse we would do that. Alternative is CSV. The > breakdown of the maxminds (in csv) is: > > Database Fields > Field Data Type Field Description > Start IP Address varchar(15) First IP in netblock > End IP Address varchar(15) Last IP in netblock > Start IP Number unsigned bigint First IP in netblock, numeric representation. > End IP Number unsigned bigint Last IP in netblock, numeric representation. > Country Code char(2) ISO 3166 Country Code, with the addition of > > * A1 for Anonymous Proxies > * A2 for Satellite Providers > > Country Name varchar(50) The name of the country > > I hope this is valid question for this group and I haven't neglected anything > necessary. let me know if so. > > thanks > > Craig > > -- > Executive Director/Publisher > Self-Service and Kiosk Association > http://www.kiosks.org > [EMAIL PROTECTED] > 502-241-1318 > > +------------------------------------------------------------------------ > | TO UNSUBSCRIBE from this list: > | http://lists.isite.net/listgate/analog-help/unsubscribe.html > | > | Digest version: http://lists.isite.net/listgate/analog-help-digest/ > | Usenet version: news://news.gmane.org/gmane.comp.web.analog.general > | List archives: http://www.analog.cx/docs/mailing.html#listarchives > +------------------------------------------------------------------------ > > +------------------------------------------------------------------------ | TO UNSUBSCRIBE from this list: | http://lists.isite.net/listgate/analog-help/unsubscribe.html | | Digest version: http://lists.isite.net/listgate/analog-help-digest/ | Usenet version: news://news.gmane.org/gmane.comp.web.analog.general | List archives: http://www.analog.cx/docs/mailing.html#listarchives +------------------------------------------------------------------------
