GeoIPMap

[anonymous-matomo-user]

i spent the last two days to extend the GeoIP-Plugin with a visualisation on google-maps.
also a "live view" is available

Feel free to try it out, copy&paste or what ever you want to use it for :)

http://www.suenkel.de/blog/2011/03/piwik-plugin-geoip-with-google-maps/

Keywords: GeoIP, Map, third-party-plugin

[robocoder]

Sounds interesting Christian. I'm in the process of moving the GeoIP plugin into core, so I'll definitely take a look at your work.

Let us know when your site is loading...

Framework Exception
An unhandled Error (type Exception) occured: Locale: code not set yet

Line 103 of file /home/www/suenkel.de/www/lib/controllers/components/locale.php

Backtrace (hover over strings to see full version):

[anonymous-matomo-user]

;-)

debug on and the autosetting of the languagefiles failed
fixed..

[anonymous-matomo-user]

Attachment: Screenshot of GeoIPMap
map.png

[mattab]

It would be nice to have World map view plotting all visitors cities from a given day. Will the new GeoIP API in #1823 return "Top cities" with the lat/long info for each city?

[DaSchTour]

Piwik is a alternative to Google Analytics and now Googe Maps should be included? Maybe OpneStreetMaps should be used for this?

[anonymous-matomo-user]

Replying to DaSch:

Piwik is a alternative to Google Analytics and now Googe Maps should be included? Maybe OpneStreetMaps should be used for this?

+1 for OpenStreetMaps

[mattab]

Maybe we can create a ticket for link the IP to open street map, if that would be useful

[anonymous-matomo-user]

Replying to mbozzolan:

Replying to DaSch:

Piwik is a alternative to Google Analytics and now Googe Maps should be included? Maybe OpneStreetMaps should be used for this?

+1 for OpenStreetMaps

Done.
http://www.suenkel.de/asset/source/Piwik/Plugin_GeoIPMap/PiwikPluginGeoMapIP_latest.zip

[anonymous-matomo-user]

There is an update available (compatible to Piwik Version 1.9.X/ new GeoIP)

[http://www.suenkel.de/asset/source/Piwik/Plugin_GeoIPMap/PiwikPluginGeoMapIP_latest.zip]

[mattab]

Congrats on the update!

[anonymous-matomo-user]

Hi,

I just installed the Plugin under Piwik 1.9.2 with GeoIP (PECL) - but it's not really working? "Live-Data" shows no hits - even there are lot's of them ... Other Pages won't show any information too. Any idea where I should start searching the problem?

Thank you
Andreas Schnederle-Wagner

[anonymous-matomo-user]

aaaaah...
ok. i found another peace of source, which is deprecated with version 1.9.X.

fixed and updated, this fixes the live view.

the "world/europe...." views are available after running an archive-process
(there was also a minor fix, because there are entries available without lat/lon infos, but location_country set)

new version is available:
http://www.suenkel.de/asset/source/Piwik/Plugin_GeoIPMap/PiwikPluginGeoMapIP_latest.zip
or here:
http://plugin.suenkel.org/plugin/detail?name=GeoIPMap

[anonymous-matomo-user]

Hi,

alright - Live-Data is working now! ;-)
But World/Europe/... is still without any data?
Archive is running every hour - so there already should be some data I guess?!

Andreas

[anonymous-matomo-user]

Hi andreas,

many thanks for debugging ;)
the archive data has to be changed. I fixed this with skipping "old" archive data.
if you want to analyse historical data, sorry, you have to rebuild the archives.

new version
http://www.suenkel.de/asset/source/Piwik/Plugin_GeoIPMap/PiwikPluginGeoMapIP_latest.zip
or here:
http://plugin.suenkel.org/plugin/detail?name=GeoIPMap

[anonymous-matomo-user]

Hi,

archiving should have run once by now - and the other Maps still don't show any data - anything else that could be wrong here? ;-)

Andreas

[anonymous-matomo-user]

Hi again,

one day passed now - and the other Maps (except Live-Data) still show no Data ... guess there is still something wrong! :-(

Andreas

[anonymous-matomo-user]

Hi,

after 4 days - still no Data in the other Maps except Live-Data.

Andreas

[anonymous-matomo-user]

Hi andreas,

sorry for the delay, but I have to dig a little bit deeper in the core src after an other bugreport.

Two posibilities:

1. Use version 1.8.r8 (available via Plugin Installer http://plugin.suenkel.org
2. In some cases the mapping table "countrycontinent" was empty. Deactivate/activate the plugin, and the table should be filled up. (worst case: use the deinstall-process of the Plugin Installer in expertmode)

If both of them is not the right solution for you, please drop me a note at:
http://suenkel.de/about/contact/ and we could have a deeper look into your installation

[anonymous-matomo-user]

Hi,

after a deep dive and a long debugging session (many thanks to Marco) we found the bug while using the Mysqli-driver...
A fixed version is online

http://plugin.suenkel.org/api/download/GeoIPMap/stable

deactivate/activate the plugin to enable the new mappingtable

Chris

[anonymous-matomo-user]

there is a new version 1.99 available, which is also compatible to Piwik Version 2

http://plugin.suenkel.org/plugin/detail?name=GeoIPMap

[mattab]

Along with the Piwik 2.0 release and new design for Piwik, we have also launched the official Plugins Marketplace to let any developer share their work to the thousands of Piwik users worldwide.

Maybe you'd like to publish your plugin there?

In any case, keep up the good work! Cheers.