The ActiveIP2Country plugin uses an IP-to-country database to determine the visitor's country. In contrast, Piwik normally guesses the visitor's country from his/her browser language and region.
Note: due to changes in IP block assignments, ActiveIP2Country does not attempt to correct earlier log_visit data.
This plugin uses any CSV (comma-separated values) file (named "ip-to-country.csv") containing IP address ranges (start and end expressed as longs) followed by a two letter ISO country code. Values may be double quoted. The country code can be upper or lower case.
The plugin will automatically generate a more compact, binary "ip-to-country.dat" file. To regenerate this file, simply remove it. ### Performance
On my antiquated Athlon 1.4 GHz processor (test box): - search overhead adds ~ 2 ms per query
If shared memory is available: - minimum shared memory segment requires approx: 1 MB - loading .dat file into memory: ~ 1 ms
If updating the .csv file: - time to re-generate .dat file: ~ 7s ### Requirements - Piwik 0.5.5 (or above) ### To install - Extract the attached .zip file in the plugins folder. - Activate the plugin from the Settings | Plugins tab. ### For support - Send me a tweet @vipsoft - DO NOT CREATE A NEW TICKET HERE
Attachment: 2010.01.12 update of ip-to-country.csv ActiveIP2Country.2.zip
Updates to the .csv file can be found at: - !http://ip-to-country.webhosting.info/
Proposal: - merge functionality from #45 into this plugin but re-use the existing country & continent columns, with fallback to region from browser language - add an installation/settings screen that (1) tests the server capability (e.g., mod_geoip or geoip extension installed, ability to use GEOIP_MEMORY_CACHE, etc; (2) button to run the geoipupdaterows script; (3) allows the user to select which geolocation implementation to use - refactor so that other implementations are available, e.g., - maxmind.com's GeoIP database(s) - ip2location.com (proposed in http://forum.piwik.org/index.php?showtopic=2061_ - hostip.info (used by OWA) - any ip-to-country.csv file
(This isn't being suggested for #45 due to trademark issues.)
I assume we can close this ticket, once GeoIP is in core? #1823
Yes, I'm rolling it into the new plugin.
Actually, I'll close this ticket now as the ip-to-country.csv file is longer being maintained. (4 months without an update)