<div dir="ltr"><div><div><div>Hi Seb,<br><br></div>1) I have the latest Eprints 3.3.12 and I have installed irstats with bazaar. I also checked the patches that you posted. <br></div>2) I have no such table. My tables are: <br>irstats2_browsers <br>irstats2_cache_downloads <br>irstats2_cache_set_values <br>irstats2_cache_views <br>irstats2_deposits <br>irstats2_doc_access <br>irstats2_doc_format <br>irstats2_downloads <br>irstats2_groupings_authors <br>irstats2_groupings_divisions <br>irstats2_groupings_subjects <br>irstats2_groupings_type <br>irstats2_history <br>irstats2_internal <br>irstats2_referrer <br>irstats2_search_terms <br>irstats2_sets_authors <br>irstats2_sets_divisions <br>irstats2_sets_subjects <br>irstats2_sets_type <br>irstats2_views <br><br></div>Kostas<br><div><div class="gmail_extra"><br><div class="gmail_quote">2014-12-12 14:10 GMT+02:00 sf2 <span dir="ltr"><<a href="mailto:sf2@ecs.soton.ac.uk" target="_blank">sf2@ecs.soton.ac.uk</a>></span>:<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div style="font-family:Verdana,Geneva,sans-serif">
<p>Kostas,</p>
<p>1- Look for javascript warnings/errors when looking at the report which has the map (known issue between google chart and prototype 1.7 - fixed in latest eprints I think)</p>
<p>2- Look if you have any data in the mysql table irstats2_countries (I think that's the name)</p>
<p>Seb</p><div><div class="h5">
<p> </p>
<p>On 12.12.2014 10:18, pgasinos pgs wrote:</p>
<blockquote type="cite" style="padding-left:5px;border-left:#1010ff 2px solid;margin-left:5px">
<div dir="ltr">
<div>All statistics from my repository working just fine except one: The thing I can't manage to work is the map of the Origin of downloads. The map shows up but is inactive. I have tried few downloads but nothing shows up in the map. I thing I have installed all libraries and modules regarding geoip but no results.<br><br></div>
Kostas</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2014-08-18 12:47 GMT+03:00 pgasinos pgs <span><<a href="mailto:pgasinos@gmail.com" target="_blank">pgasinos@gmail.com</a>></span>:
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>Thank you<span><span style="font-family:'Sans Serif',Verdana,Arial,Helvetica,sans-serif"> </span></span>Martin<br><br></div>
That solves the problem. I solve also the export error by installing libapache2-mod-geoip and libgeo-ip-perl.<br><br><span style="font-family:'Sans Serif',Verdana,Arial,Helvetica,sans-serif"><span style="font-family:'Sans Serif',Verdana,Arial,Helvetica,sans-serif">Best regards,</span></span>
<div><br>Kostas</div>
</div>
<div class="gmail_extra"><br><br>
<div class="gmail_quote"><span>2014-08-16 12:08 GMT+03:00 <span><<a href="mailto:martin.braendle@id.uzh.ch" target="_blank">martin.braendle@id.uzh.ch</a>></span>:<br></span>
<div>
<div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>Hi,</div>
<div> </div>
<div>found a solution myself. In cfg.d/<a href="http://z_irstats2.pl" target="_blank">z_irstats2.pl</a>, the use_ids flag must be set to 0:</div>
<div> </div>
<div>
<p style="margin:0px;font-size:11px;font-family:Menlo">$c->{irstats2}->{sets} = [</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> {</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'field' => 'divisions',</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'groupings' => [ 'authors' ]</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> },</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> {</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'field' => 'subjects',</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'groupings' => [ 'authors' ]</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> },</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> {</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'name' => 'type',</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'field' => 'type',</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'groupings' => [ 'authors' ]</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> },</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"># # EdShare:</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"># {</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"># 'field' => 'courses',</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"># }</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> # using creators_name and creators_id</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> {</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'name' => 'authors',</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'field' => 'creators',</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'groupings' => [ 'type' ],</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"> </p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'anon' => 1, # don't show user's email address (the 'id' field)</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> # for compound:</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"># if use_ids == 0 -> just use _name, same as having field => 'creators_name'</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"># if use_ids == 1 -> use _id as key for the set and _name for display - value will be ignored if _id is NOT set!</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"> </p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> 'use_ids' => 0,</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"># 'id_field' => 'id', # default value, optional. if the subfield is called 'email' then use 'email'</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> minimum_filter_length => 2,</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"> </p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> },</p>
</div>
<div> </div>
<p style="margin-top:0px;margin-bottom:16px;font-size:14px;line-height:22px"><span style="color:#333333"> </span></p>
<div>Now authors statistics are generated correctly.</div>
<div> </div>
<span style="font-family:'Sans Serif',Verdana,Arial,Helvetica,sans-serif"><span style="font-family:'Sans Serif',Verdana,Arial,Helvetica,sans-serif">Best regards,</span></span>
<div> </div>
<div>Martin<br><br><span style="color:#990099">-----<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" target="_blank">eprints-tech-bounces@ecs.soton.ac.uk</a> schrieb: -----</span>
<div style="padding-left:5px">
<div style="padding-right:0px;padding-left:5px;border-left:solid black 2px">An: <a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a><br>Von: <a href="mailto:martin.braendle@id.uzh.ch" target="_blank">martin.braendle@id.uzh.ch</a><br> Gesendet von: <a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" target="_blank">eprints-tech-bounces@ecs.soton.ac.uk</a><br>Datum: 15.08.2014 08:57<br>Betreff: [EP-tech] Antwort: Re: About IRStats2
<div>
<div><br><br>
<p><span style="font-family:sans-serif">Hi,</span><br><br><span style="font-family:sans-serif">it looks like irstats2 has a flaw in gathering author data. From our statistics on our test server zoratest (irstats2 is not yet deployed on the production server <a href="http://www.zora.uzh.ch" target="_blank">www.zora.uzh.ch</a>) we get the following picture:</span><br><br><span style="font-family:sans-serif">Most Downloaded Items:</span><br><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">count,eprintid,description</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="10077",="10147","<a href='<a href="http://www.zoratest.uzh.ch/10147/" target="_blank">http://www.zoratest.uzh.ch/10147/</a>'>Body Modification: psychologische Aspekte von Piercings und anderen Körperveränderungen</a>"</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="5958",="2532","<a href='<a href="http://www.zoratest.uzh.ch/2532/" target="_blank">http://www.zoratest.uzh.ch/2532/</a>'>Welpenfütterung in der Schweiz</a>"</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="5204",="43064","<a href='<a href="http://www.zoratest.uzh.ch/43064/" target="_blank">http://www.zoratest.uzh.ch/43064/</a>'>Extraartikuläre weichteilrheumatische Erkrankungen (Weichteilrheumatismus) und Rückenschmerzen</a>"</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="4956",="24050","<a href='<a href="http://www.zoratest.uzh.ch/24050/" target="_blank">http://www.zoratest.uzh.ch/24050/</a>'>Traumatic pericarditis in cattle: clinical, radiographic and ultrasonographic findings</a>"</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="4539",="19506","<a href='<a href="http://www.zoratest.uzh.ch/19506/" target="_blank">http://www.zoratest.uzh.ch/19506/</a>'>IFRS aktuell: Neues aus wichtigen Gremien rund um die internationale Rechnungslegung</a>"</span></tt><br><br><span style="font-family:sans-serif">Top Authors:</span><br><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">count,set_value,description</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="9710",90de69aa75e88bae17a48fe111738757,"Zweifel, Peter"</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="9170",a8919638b6af7edf5e6201132093647d,"Schwabe, Gerhard"</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="8944",8d05f2d4d6fa6596e6b676723b5082c8,"Fehr, Ernst"</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="8381",f3f5e1a2127f50a31435b5fb54d2bef9,"Deplazes, P"</span></tt><br><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">="8289",6f95d542bd0c4b9760811f454004c76c,"Linden, A"</span></tt><br><br><br><span style="font-family:sans-serif">You see immediately that this is plain wrong, because the top author, "Kälin, R" who published eprintid 10147 (see </span><a href="http://www.zora.uzh.ch/10147/" target="_blank"><span style="font-family:sans-serif">http://www.zora.uzh.ch/10147/</span></a><span style="font-family:sans-serif">) </span><span style="font-family:sans-serif">isn't on the list of top authors and should there have a count of 10077 downloads.</span><br><br><span style="font-family:sans-serif">Kälin, R also doesn't appear in the Filter Items list of irstats2.</span><br><br><span style="font-family:sans-serif">Checking the SQL tables as Seb suggested yields:</span><br><br><span style="font-family:Menlo-Regular">mysql> select * from eprint_creators_name where eprintid=10147\G</span><br><span style="font-family:Menlo-Regular">*************************** 1. row ***************************</span><br><span style="font-family:Menlo-Regular">eprintid: 10147</span><br><span style="font-family:Menlo-Regular">pos: 0</span><br><span style="font-family:Menlo-Regular">creators_name_honourific: </span><br><span style="font-family:Menlo-Regular">creators_name_given: R</span><br><span style="font-family:Menlo-Regular">creators_name_family: K?lin</span><br><span style="font-family:Menlo-Regular">creators_name_lineage: </span><br><span style="font-family:Menlo-Regular">1 row in set (0.00 sec)</span><br><br><br><span style="font-family:Menlo-Regular">mysql> select * from eprint_creators_id where eprintid=10147\G</span><br><span style="font-family:Menlo-Regular">Empty set (0.00 sec)</span><br><br><br><span style="font-family:sans-serif">Another eprint indeed lists entries in the </span><span style="font-family:Menlo-Regular">eprint_creators_id</span><span style="font-family:sans-serif"> table:</span><br><br><span style="font-family:Menlo-Regular">mysql> select * from eprint_creators_id where eprintid=13208;</span><br><span style="font-family:Menlo-Regular">+----------+-----+------------------------------+</span><br><span style="font-family:Menlo-Regular">| eprintid | pos | creators_id |</span><br><span style="font-family:Menlo-Regular">+----------+-----+------------------------------+</span><br><span style="font-family:Menlo-Regular">| 13208 | 0 | <a href="mailto:mjackson@vetclinics.uzh.ch" target="_blank">mjackson@vetclinics.uzh.ch</a> |</span><br><span style="font-family:Menlo-Regular">| 13208 | 1 | |</span><br><span style="font-family:Menlo-Regular">| 13208 | 2 | <a href="mailto:jkuemmerle@vetclinics.uzh.ch" target="_blank">jkuemmerle@vetclinics.uzh.ch</a> |</span><br><span style="font-family:Menlo-Regular">| 13208 | 3 | <a href="mailto:afuerst@vetclinics.uzh.ch" target="_blank">afuerst@vetclinics.uzh.ch</a> |</span><br><span style="font-family:Menlo-Regular">+----------+-----+------------------------------+</span><br><br><br><span style="font-family:sans-serif">Conclusion: irstats2 seems to gather author statistics only correctly, if there is creators_id entry (at least an e-mail address set) in table </span><span style="font-family:Menlo-Regular">eprint_creators_id</span><span style="font-family:sans-serif"> . Also it seems to produce a filter list entry only, if there is a corresponding entry in table eprint_creators_id.</span><br><br><span style="font-family:sans-serif">Irstats2 authors, please correct this wrong behavior.</span><br><br><span style="font-family:sans-serif">Best regards,</span><br><br><span style="font-family:sans-serif">Martin</span><br><br><span style="font-family:sans-serif">--</span><br><span style="font-family:sans-serif">Dr. Martin Brändle</span><br><span style="font-family:sans-serif">Informatikdienste</span><br><span style="font-family:sans-serif">Universität Zürich</span><br><span style="font-family:sans-serif">Winterthurerstr. 190</span><br><span style="font-family:sans-serif">CH-8057 Zürich</span><br><br><span style="font-family:sans-serif">mail: <a href="mailto:martin.braendle@id.uzh.ch" target="_blank">martin.braendle@id.uzh.ch</a></span><br><span style="font-family:sans-serif">phone: +41 44 63 56705</span><br><span style="font-family:sans-serif">fax: +41 44 63 54505</span><br><span style="font-family:sans-serif"><a href="http://www.id.uzh.ch" target="_blank">http://www.id.uzh.ch</a></span><br><br><img src="cid:f49494130705492319ff6f1981ba245d@ecs.soton.ac.uk" alt="Inactive hide details for Sebastien Francois ---25/07/2014 15:49:42---And you do have creators data? (select * from eprint_cre" height="16" width="16" border="0"><span style="color:#424282;font-family:sans-serif">Sebastien Francois ---25/07/2014 15:49:42---And you do have creators data? (select * from eprint_creators_name ---and/or--- select * from epri</span><br><br><span style="color:#5f5f5f;font-family:sans-serif;font-size:xx-small">Von: </span><span style="font-family:sans-serif;font-size:xx-small">Sebastien Francois <<a href="mailto:sf2@ecs.soton.ac.uk" target="_blank">sf2@ecs.soton.ac.uk</a>></span><br><span style="color:#5f5f5f;font-family:sans-serif;font-size:xx-small">An: </span><span style="font-family:sans-serif;font-size:xx-small"><a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a></span><br><span style="color:#5f5f5f;font-family:sans-serif;font-size:xx-small">Datum: </span><span style="font-family:sans-serif;font-size:xx-small">25/07/2014 15:49</span><br><span style="color:#5f5f5f;font-family:sans-serif;font-size:xx-small">Betreff: </span><span style="font-family:sans-serif;font-size:xx-small">[EP-tech] Re: About IRStats2</span><br><span style="color:#5f5f5f;font-family:sans-serif;font-size:xx-small">Gesendet von: </span><span style="font-family:sans-serif;font-size:xx-small"><a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" target="_blank">eprints-tech-bounces@ecs.soton.ac.uk</a></span></p>
<hr size="2" width="100%" align="left"><br><br><br><span style="font-family:serif;font-size:medium">And you do have creators data? (select * from eprint_creators_name ---and/or--- select * from eprint_creators_id)<br><br> Cos that's where irstats2 tries to process the data from.<br><br> Seb.<br><br> On 25/07/14 13:07, pgasinos pgs wrote:</span></div>
</div>
<div><span style="font-family:serif;font-size:medium">Yes </span><br><span style="font-family:serif;font-size:medium">My repository is:</span><br><a href="http://anaktisis.teiwm.gr/" target="_blank"><span style="color:#0000ff;font-family:serif;font-size:medium"><span style="text-decoration:underline">http://anaktisis.teiwm.gr</span></span></a><span style="font-family:serif;font-size:medium"> </span><br><br><span style="font-family:serif;font-size:medium">Kostas Pgasinos<br><br> Στις Παρασκευή, 25 Ιουλίου 2014, ο χρήστης Sebastien Francois <</span><a href="mailto:sf2@ecs.soton.ac.uk" target="_blank"><span style="color:#0000ff;font-family:serif;font-size:medium"><span style="text-decoration:underline">sf2@ecs.soton.ac.uk</span></span></a><span style="font-family:serif;font-size:medium">> έγραψε:</span><span style="font-family:serif;font-size:medium">Hey,<br><br> Do you have a URL I can look at?<br><br> It seems like there are some issues with your data (the "countries' does not exist" error indicates some issues with Geo::IP). Do you get any related errors/warnings when you run "bin/epadmin test"?<br><br> If that were possible, I'd re-generate all the stats:<br><br> bin/stats/process_stats <id> --uninstall<br><br> then<br><br> bin/stats/process_stats <id> --setup --verbose<br><br> As you know, this may take some time (depending on the size of your 'access' dataset).<br><br> Kind regards,<br> Seb</span></div>
<div><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium">*** Options: </span></tt><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium"><a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a></span></tt><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium"><br> *** Archive: </span></tt><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium"><a href="http://www.eprints.org/tech.php/" target="_blank">http://www.eprints.org/tech.php/</a></span></tt><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium"><br> *** EPrints community wiki: </span></tt><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium"><a href="http://wiki.eprints.org/" target="_blank">http://wiki.eprints.org/</a></span></tt><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium"><br> *** EPrints developers Forum: </span></tt><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium"><a href="http://forum.eprints.org/" target="_blank">http://forum.eprints.org/</a></span></tt><tt><span style="font-family:'Courier New',Courier,monospace;font-size:medium"><br></span></tt><br>
<div><span style="font-family:'Courier New',Courier,monospace;font-size:medium">*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br> *** Archive: <a href="http://www.eprints.org/tech.php/" target="_blank">http://www.eprints.org/tech.php/</a><br>*** EPrints community wiki: <a href="http://wiki.eprints.org/" target="_blank">http://wiki.eprints.org/</a><br> *** EPrints developers Forum: <a href="http://forum.eprints.org/" target="_blank">http://forum.eprints.org/</a><br></span></div>
</div>
</div>
</div>
</div>
<br>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br> *** Archive: <a href="http://www.eprints.org/tech.php/" target="_blank">http://www.eprints.org/tech.php/</a><br> *** EPrints community wiki: <a href="http://wiki.eprints.org/" target="_blank">http://wiki.eprints.org/</a><br> *** EPrints developers Forum: <a href="http://forum.eprints.org/" target="_blank">http://forum.eprints.org/</a><br><br></blockquote>
</div>
</div>
</div>
</div>
<br>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br> *** Archive: <a href="http://www.eprints.org/tech.php/" target="_blank">http://www.eprints.org/tech.php/</a><br> *** EPrints community wiki: <a href="http://wiki.eprints.org/" target="_blank">http://wiki.eprints.org/</a><br> *** EPrints developers Forum: <a href="http://forum.eprints.org/" target="_blank">http://forum.eprints.org/</a><br><br></blockquote>
</div>
</div>
<br>
<pre>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a href="http://www.eprints.org/tech.php/" target="_blank">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a href="http://wiki.eprints.org/" target="_blank">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a href="http://forum.eprints.org/" target="_blank">http://forum.eprints.org/</a>
</pre>
</blockquote>
<p> </p>
<div> </div>
</div></div></div>
<br>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
*** Archive: <a href="http://www.eprints.org/tech.php/" target="_blank">http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a href="http://wiki.eprints.org/" target="_blank">http://wiki.eprints.org/</a><br>
*** EPrints developers Forum: <a href="http://forum.eprints.org/" target="_blank">http://forum.eprints.org/</a><br>
<br></blockquote></div></div></div></div>