<html><body bgcolor="#FFFFFF">
<p><font size="2" face="sans-serif">Hi,</font><br>
<br>
<font size="2" face="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 www.zora.uzh.ch) we get the following picture:</font><br>
<br>
<font size="2" face="sans-serif">Most Downloaded Items:</font><br>
<br>
<tt><font size="3">count,eprintid,description</font></tt><br>
<tt><font size="3">="10077",="10147","<a href='http://www.zoratest.uzh.ch/10147/'>Body Modification: psychologische Aspekte von Piercings und anderen Körperveränderungen</a>"</font></tt><br>
<tt><font size="3">="5958",="2532","<a href='http://www.zoratest.uzh.ch/2532/'>Welpenfütterung in der Schweiz</a>"</font></tt><br>
<tt><font size="3">="5204",="43064","<a href='http://www.zoratest.uzh.ch/43064/'>Extraartikuläre weichteilrheumatische Erkrankungen (Weichteilrheumatismus) und Rückenschmerzen</a>"</font></tt><br>
<tt><font size="3">="4956",="24050","<a href='http://www.zoratest.uzh.ch/24050/'>Traumatic pericarditis in cattle: clinical, radiographic and ultrasonographic findings</a>"</font></tt><br>
<tt><font size="3">="4539",="19506","<a href='http://www.zoratest.uzh.ch/19506/'>IFRS aktuell: Neues aus wichtigen Gremien rund um die internationale Rechnungslegung</a>"</font></tt><br>
<br>
<font size="2" face="sans-serif">Top Authors:</font><br>
<br>
<tt><font size="3">count,set_value,description</font></tt><br>
<tt><font size="3">="9710",90de69aa75e88bae17a48fe111738757,"Zweifel, Peter"</font></tt><br>
<tt><font size="3">="9170",a8919638b6af7edf5e6201132093647d,"Schwabe, Gerhard"</font></tt><br>
<tt><font size="3">="8944",8d05f2d4d6fa6596e6b676723b5082c8,"Fehr, Ernst"</font></tt><br>
<tt><font size="3">="8381",f3f5e1a2127f50a31435b5fb54d2bef9,"Deplazes, P"</font></tt><br>
<tt><font size="3">="8289",6f95d542bd0c4b9760811f454004c76c,"Linden, A"</font></tt><br>
<br>
<br>
<font size="2" face="sans-serif">You see immediately that this is plain wrong, because the top author, "Kälin, R" who published eprintid 10147 (see </font><a href="http://www.zora.uzh.ch/10147/"><font size="2" face="sans-serif">http://www.zora.uzh.ch/10147/</font></a><font size="2" face="sans-serif">) </font><font size="2" face="sans-serif">isn't on the list of top authors and should there have a count of 10077 downloads.</font><br>
<br>
<font size="2" face="sans-serif">Kälin, R also doesn't appear in the Filter Items list of irstats2.</font><br>
<br>
<font size="2" face="sans-serif">Checking the SQL tables as Seb suggested yields:</font><br>
<br>
<font size="2" face="Menlo-Regular">mysql> select * from eprint_creators_name where eprintid=10147\G</font><br>
<font size="2" face="Menlo-Regular">*************************** 1. row ***************************</font><br>
<font size="2" face="Menlo-Regular">eprintid: 10147</font><br>
<font size="2" face="Menlo-Regular">pos: 0</font><br>
<font size="2" face="Menlo-Regular">creators_name_honourific: </font><br>
<font size="2" face="Menlo-Regular">creators_name_given: R</font><br>
<font size="2" face="Menlo-Regular">creators_name_family: K?lin</font><br>
<font size="2" face="Menlo-Regular">creators_name_lineage: </font><br>
<font size="2" face="Menlo-Regular">1 row in set (0.00 sec)</font><br>
<br>
<br>
<font size="2" face="Menlo-Regular">mysql> select * from eprint_creators_id where eprintid=10147\G</font><br>
<font size="2" face="Menlo-Regular">Empty set (0.00 sec)</font><br>
<br>
<br>
<font size="2" face="sans-serif">Another eprint indeed lists entries in the </font><font size="2" face="Menlo-Regular">eprint_creators_id</font><font size="2" face="sans-serif"> table:</font><br>
<br>
<font size="2" face="Menlo-Regular">mysql> select * from eprint_creators_id where eprintid=13208;</font><br>
<font size="2" face="Menlo-Regular">+----------+-----+------------------------------+</font><br>
<font size="2" face="Menlo-Regular">| eprintid | pos | creators_id |</font><br>
<font size="2" face="Menlo-Regular">+----------+-----+------------------------------+</font><br>
<font size="2" face="Menlo-Regular">| 13208 | 0 | mjackson@vetclinics.uzh.ch |</font><br>
<font size="2" face="Menlo-Regular">| 13208 | 1 | |</font><br>
<font size="2" face="Menlo-Regular">| 13208 | 2 | jkuemmerle@vetclinics.uzh.ch |</font><br>
<font size="2" face="Menlo-Regular">| 13208 | 3 | afuerst@vetclinics.uzh.ch |</font><br>
<font size="2" face="Menlo-Regular">+----------+-----+------------------------------+</font><br>
<br>
<br>
<font size="2" face="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 </font><font size="2" face="Menlo-Regular">eprint_creators_id</font><font size="2" face="sans-serif"> . Also it seems to produce a filter list entry only, if there is a corresponding entry in table eprint_creators_id.</font><br>
<br>
<font size="2" face="sans-serif">Irstats2 authors, please correct this wrong behavior.</font><br>
<br>
<font size="2" face="sans-serif">Best regards,</font><br>
<br>
<font size="2" face="sans-serif">Martin</font><br>
<br>
<font size="2" face="sans-serif">--</font><br>
<font size="2" face="sans-serif">Dr. Martin Brändle</font><br>
<font size="2" face="sans-serif">Informatikdienste</font><br>
<font size="2" face="sans-serif">Universität Zürich</font><br>
<font size="2" face="sans-serif">Winterthurerstr. 190</font><br>
<font size="2" face="sans-serif">CH-8057 Zürich</font><br>
<br>
<font size="2" face="sans-serif">mail: martin.braendle@id.uzh.ch</font><br>
<font size="2" face="sans-serif">phone: +41 44 63 56705</font><br>
<font size="2" face="sans-serif">fax: +41 44 63 54505</font><br>
<font size="2" face="sans-serif"><a href="http://www.id.uzh.ch">http://www.id.uzh.ch</a></font><br>
<br>
<img width="16" height="16" src="cid:1__=4EBBF7A6DFB0D9F68f9e8a93df9@lotus.uzh.ch" border="0" alt="Inactive hide details for Sebastien Francois ---25/07/2014 15:49:42---And you do have creators data? (select * from eprint_cre"><font size="2" color="#424282" face="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</font><br>
<br>
<font size="1" color="#5F5F5F" face="sans-serif">Von: </font><font size="1" face="sans-serif">Sebastien Francois <sf2@ecs.soton.ac.uk></font><br>
<font size="1" color="#5F5F5F" face="sans-serif">An: </font><font size="1" face="sans-serif">eprints-tech@ecs.soton.ac.uk</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Datum: </font><font size="1" face="sans-serif">25/07/2014 15:49</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Betreff: </font><font size="1" face="sans-serif">[EP-tech] Re: About IRStats2</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Gesendet von: </font><font size="1" face="sans-serif">eprints-tech-bounces@ecs.soton.ac.uk</font><br>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<font size="3" face="serif">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:</font>
<ul style="padding-left: 36pt"><font size="3" face="serif">Yes </font><br>
<font size="3" face="serif">My repository is:</font><br>
<a href="http://anaktisis.teiwm.gr/"><font size="3" color="#0000FF" face="serif"><u>http://anaktisis.teiwm.gr</u></font></a><font size="3" face="serif"> </font><br>
<br>
<font size="3" face="serif">Kostas Pgasinos<br>
<br>
Στις Παρασκευή, 25 Ιουλίου 2014, ο χρήστης Sebastien Francois <</font><a href="mailto:sf2@ecs.soton.ac.uk"><font size="3" color="#0000FF" face="serif"><u>sf2@ecs.soton.ac.uk</u></font></a><font size="3" face="serif">> έγραψε:</font>
<ul style="padding-left: 9pt"><font size="3" face="serif">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</font></ul>
</ul>
<tt><font size="2">*** Options: </font></tt><tt><font size="2"><a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a></font></tt><tt><font size="2"><br>
*** Archive: </font></tt><tt><font size="2"><a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a></font></tt><tt><font size="2"><br>
*** EPrints community wiki: </font></tt><tt><font size="2"><a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></font></tt><tt><font size="2"><br>
*** EPrints developers Forum: </font></tt><tt><font size="2"><a href="http://forum.eprints.org/">http://forum.eprints.org/</a></font></tt><tt><font size="2"><br>
</font></tt><br>
</body></html>