<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Menlo;
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Menlo-Regular;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
mso-fareast-language:EN-GB;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi Kostas,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I had that issue, the solution was to have all the GeoIP modules installed and the GeoIP.dat file in place before installing IRStats, which then created all
of the relevant tables. Obviously required a complete rebuild of the stats.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Alan<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> pgasinos pgs [mailto:pgasinos@gmail.com]
<br>
<b>Sent:</b> 12 December 2014 13:09<br>
<b>To:</b> eprints-tech@ecs.soton.ac.uk<br>
<b>Subject:</b> [EP-tech] Re: Antwort: Re: About IRStats2<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Seb,<o:p></o:p></p>
</div>
<p class="MsoNormal">1) I have the latest Eprints 3.3.12 and I have installed irstats with bazaar. I also checked the patches that you posted.
<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">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 <o:p></o:p></p>
</div>
<p class="MsoNormal">Kostas<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">2014-12-12 14:10 GMT+02:00 sf2 <<a href="mailto:sf2@ecs.soton.ac.uk" target="_blank">sf2@ecs.soton.ac.uk</a>>:<o:p></o:p></p>
<div>
<p><span style="font-family:"Verdana","sans-serif"">Kostas,<o:p></o:p></span></p>
<p><span style="font-family:"Verdana","sans-serif"">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)<o:p></o:p></span></p>
<p><span style="font-family:"Verdana","sans-serif"">2- Look if you have any data in the mysql table irstats2_countries (I think that's the name)<o:p></o:p></span></p>
<p><span style="font-family:"Verdana","sans-serif"">Seb<o:p></o:p></span></p>
<div>
<div>
<p><span style="font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
<p><span style="font-family:"Verdana","sans-serif"">On 12.12.2014 10:18, pgasinos pgs wrote:<o:p></o:p></span></p>
<blockquote style="border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Verdana","sans-serif"">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.<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">Kostas<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">2014-08-18 12:47 GMT+03:00 pgasinos pgs <<a href="mailto:pgasinos@gmail.com" target="_blank">pgasinos@gmail.com</a>>:
<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Verdana","sans-serif"">Thank you Martin<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">That solves the problem. I solve also the export error by installing libapache2-mod-geoip and libgeo-ip-perl.<br>
<br>
Best regards, <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""><br>
Kostas<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Verdana","sans-serif""><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">2014-08-16 12:08 GMT+03:00 <<a href="mailto:martin.braendle@id.uzh.ch" target="_blank">martin.braendle@id.uzh.ch</a>>:<o:p></o:p></span></p>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">Hi,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">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:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif"">$c->{irstats2}->{sets} = [<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> {<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'field' => 'divisions',<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'groupings' => [ 'authors' ]<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> },<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> {<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'field' => 'subjects',<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'groupings' => [ 'authors' ]<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> },<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> {<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'name' => 'type',<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'field' => 'type',<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'groupings' => [ 'authors' ]<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> },<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""># # EdShare:<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""># {<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""># 'field' => 'courses',<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""># }<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> # using creators_name and creators_id<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> {<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'name' => 'authors',<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'field' => 'creators',<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'groupings' => [ 'type' ],<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt;min-height:13px"><span style="font-size:8.5pt;font-family:"Menlo","serif""> <o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'anon' => 1, # don't show user's email address (the 'id' field)<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> # for compound:<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""># if use_ids == 0 -> just use _name, same as having field => 'creators_name'<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""># if use_ids == 1 -> use _id as key for the set and _name for display - value will be ignored if _id is NOT set!<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt;min-height:13px"><span style="font-size:8.5pt;font-family:"Menlo","serif""> <o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> 'use_ids' => 0,<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""># 'id_field' => 'id', # default value, optional. if the subfield is called 'email' then use 'email'<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> minimum_filter_length => 2,<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt;min-height:13px"><span style="font-size:8.5pt;font-family:"Menlo","serif""> <o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:8.5pt;font-family:"Menlo","serif""> },<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
</div>
<p style="mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;line-height:16.5pt">
<span style="font-size:10.5pt;font-family:"Verdana","sans-serif";color:#333333"> </span><span style="font-size:10.5pt;font-family:"Verdana","sans-serif""><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">Now authors statistics are generated correctly.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">Best regards,
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">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>
<o:p></o:p></span></p>
<div>
<div style="border:none;border-left:solid black 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">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 <o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Verdana","sans-serif""><o:p> </o:p></span></p>
<p><span style="font-family:"Arial","sans-serif"">Hi,</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","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><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">Most Downloaded Items:</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><tt><span style="font-size:13.5pt">count,eprintid,description</span></tt><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="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><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="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><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="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><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="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><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="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><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">Top Authors:</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><tt><span style="font-size:13.5pt">count,set_value,description</span></tt><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="9710",90de69aa75e88bae17a48fe111738757,"Zweifel, Peter"</span></tt><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="9170",a8919638b6af7edf5e6201132093647d,"Schwabe, Gerhard"</span></tt><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="8944",8d05f2d4d6fa6596e6b676723b5082c8,"Fehr, Ernst"</span></tt><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="8381",f3f5e1a2127f50a31435b5fb54d2bef9,"Deplazes, P"</span></tt><span style="font-family:"Verdana","sans-serif""><br>
</span><tt><span style="font-size:13.5pt">="8289",6f95d542bd0c4b9760811f454004c76c,"Linden, A"</span></tt><span style="font-family:"Verdana","sans-serif""><br>
<br>
<br>
</span><span style="font-family:"Arial","sans-serif"">You see immediately that this is plain wrong, because the top author, "Kälin, R" who published eprintid 10147 (see
</span><span style="font-family:"Verdana","sans-serif""><a href="http://www.zora.uzh.ch/10147/" target="_blank"><span style="font-family:"Arial","sans-serif"">http://www.zora.uzh.ch/10147/</span></a></span><span style="font-family:"Arial","sans-serif"">) isn't
on the list of top authors and should there have a count of 10077 downloads.</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">Kälin, R also doesn't appear in the Filter Items list of irstats2.</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">Checking the SQL tables as Seb suggested yields:</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Menlo-Regular","serif"">mysql> select * from eprint_creators_name where eprintid=10147\G</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">*************************** 1. row ***************************</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">eprintid: 10147</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">pos: 0</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">creators_name_honourific:
</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">creators_name_given: R</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">creators_name_family: K?lin</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">creators_name_lineage: </span>
<span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">1 row in set (0.00 sec)</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
<br>
</span><span style="font-family:"Menlo-Regular","serif"">mysql> select * from eprint_creators_id where eprintid=10147\G</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">Empty set (0.00 sec)</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
<br>
</span><span style="font-family:"Arial","sans-serif"">Another eprint indeed lists entries in the
</span><span style="font-family:"Menlo-Regular","serif"">eprint_creators_id</span><span style="font-family:"Arial","sans-serif""> table:</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Menlo-Regular","serif"">mysql> select * from eprint_creators_id where eprintid=13208;</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">+----------+-----+------------------------------+</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">| eprintid | pos | creators_id |</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">+----------+-----+------------------------------+</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">| 13208 | 0 | <a href="mailto:mjackson@vetclinics.uzh.ch" target="_blank">
mjackson@vetclinics.uzh.ch</a> |</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">| 13208 | 1 | |</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">| 13208 | 2 | <a href="mailto:jkuemmerle@vetclinics.uzh.ch" target="_blank">
jkuemmerle@vetclinics.uzh.ch</a> |</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">| 13208 | 3 | <a href="mailto:afuerst@vetclinics.uzh.ch" target="_blank">
afuerst@vetclinics.uzh.ch</a> |</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Menlo-Regular","serif"">+----------+-----+------------------------------+</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
<br>
</span><span style="font-family:"Arial","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","serif"">eprint_creators_id</span><span style="font-family:"Arial","sans-serif""> . Also it seems to produce a filter list entry only, if there is a corresponding entry in table eprint_creators_id.</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">Irstats2 authors, please correct this wrong behavior.</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">Best regards,</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">Martin</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">--</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Arial","sans-serif"">Dr. Martin Brändle</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Arial","sans-serif"">Informatikdienste</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Arial","sans-serif"">Universität Zürich</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Arial","sans-serif"">Winterthurerstr. 190</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Arial","sans-serif"">CH-8057 Zürich</span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-family:"Arial","sans-serif"">mail: <a href="mailto:martin.braendle@id.uzh.ch" target="_blank">
martin.braendle@id.uzh.ch</a></span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Arial","sans-serif"">phone: +41 44 63 56705</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Arial","sans-serif"">fax: +41 44 63 54505</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-family:"Arial","sans-serif""><a href="http://www.id.uzh.ch" target="_blank">http://www.id.uzh.ch</a></span><span style="font-family:"Verdana","sans-serif""><br>
<br>
<img border="0" width="16" height="16" id="_x0000_i1025" src="cid:image001.gif@01D01610.301EB130" alt="Inactive hide details for Sebastien Francois ---25/07/2014 15:49:42---And you do have creators data? (select * from eprint_cre"></span><span style="font-family:"Arial","sans-serif";color:#424282">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><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">Von:
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">Sebastien Francois <<a href="mailto:sf2@ecs.soton.ac.uk" target="_blank">sf2@ecs.soton.ac.uk</a>></span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">An:
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif""><a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a></span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">Datum:
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">25/07/2014 15:49</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">Betreff:
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">[EP-tech] Re: About IRStats2</span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">Gesendet von:
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif""><a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" target="_blank">eprints-tech-bounces@ecs.soton.ac.uk</a></span><span style="font-family:"Verdana","sans-serif""><o:p></o:p></span></p>
<div class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">
<hr size="2" width="100%" align="left">
</span></div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""><br>
<br>
<br>
</span><span style="font-size:13.5pt">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><span style="font-family:"Verdana","sans-serif""><o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt">Yes </span><span style="font-family:"Verdana","sans-serif""><br>
</span><span style="font-size:13.5pt">My repository is:</span><span style="font-family:"Verdana","sans-serif""><br>
<a href="http://anaktisis.teiwm.gr/" target="_blank"><span style="font-size:13.5pt;font-family:"Times New Roman","serif"">http://anaktisis.teiwm.gr</span></a></span><span style="font-size:13.5pt"> </span><span style="font-family:"Verdana","sans-serif""><br>
<br>
</span><span style="font-size:13.5pt">Kostas Pgasinos<br>
<br>
Στις Παρασκευή, 25 Ιουλίου 2014, ο χρήστης Sebastien Francois <</span><span style="font-family:"Verdana","sans-serif""><a href="mailto:sf2@ecs.soton.ac.uk" target="_blank"><span style="font-size:13.5pt;font-family:"Times New Roman","serif"">sf2@ecs.soton.ac.uk</span></a></span><span style="font-size:13.5pt">>
έγραψε: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><span style="font-family:"Verdana","sans-serif""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><tt><span style="font-size:13.5pt">*** 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></span></tt><span style="font-size:13.5pt;font-family:"Courier New""><br>
<tt>*** Archive: <a href="http://www.eprints.org/tech.php/" target="_blank">http://www.eprints.org/tech.php/</a></tt><br>
<tt>*** EPrints community wiki: <a href="http://wiki.eprints.org/" target="_blank">
http://wiki.eprints.org/</a></tt><br>
<tt>*** EPrints developers Forum: <a href="http://forum.eprints.org/" target="_blank">
http://forum.eprints.org/</a></tt></span><span style="font-family:"Verdana","sans-serif""><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Courier New"">*** 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></span><span style="font-family:"Verdana","sans-serif""><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Verdana","sans-serif""><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><o:p></o:p></span></p>
</blockquote>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Verdana","sans-serif""><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><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""><o:p> </o:p></span></p>
<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><o:p></o:p></pre>
<pre>*** Archive: <a href="http://www.eprints.org/tech.php/" target="_blank">http://www.eprints.org/tech.php/</a><o:p></o:p></pre>
<pre>*** EPrints community wiki: <a href="http://wiki.eprints.org/" target="_blank">http://wiki.eprints.org/</a><o:p></o:p></pre>
<pre>*** EPrints developers Forum: <a href="http://forum.eprints.org/" target="_blank">http://forum.eprints.org/</a><o:p></o:p></pre>
</blockquote>
<p><span style="font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><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><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
-- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). The Open University is authorised and regulated by the Financial Conduct Authority.
</body>
</html>