<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi JM,<br>
<br>
That's a bug in EPrints::Database::prepare_select (I recall that
bug nearly drove me mad!).<br>
<br>
See
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a href="https://github.com/eprints/irstats2/issues/1">https://github.com/eprints/irstats2/issues/1</a>
and look at my comments for a way to fix that issue.<br>
<br>
Seb.<br>
<br>
<br>
On 19/06/13 08:51, Jean-Marie Le Bechec wrote:<br>
</div>
<blockquote cite="mid:51C162F9.8000105@inp-toulouse.fr" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hi Seb,<br>
<br>
the process is ok (create table, etc) :<br>
<br>
$ /appli/eprints/archives/oatao/bin/stats/process_stats oatao
--setup --verbose<br>
Generating set tables.<br>
Removed table 'irstats2_sets_authors'<br>
Removed table 'irstats2_sets_divisions'<br>
Removed table 'irstats2_sets_subjects'<br>
Removed table 'irstats2_sets_type'<br>
Removed table 'irstats2_groupings_authors'<br>
Removed table 'irstats2_groupings_divisions'<br>
Removed table 'irstats2_groupings_subjects'<br>
Removed table 'irstats2_groupings_type'<br>
Removed table 'irstats2_cache_set_values'<br>
Creating internal tables<br>
About to process dataset 'history'<br>
Creating table 'irstats2_history'<br>
history: starting from record 0<br>
history: 1083209 records to process.<br>
About to process dataset 'access'<br>
Creating table 'irstats2_referrer'<br>
Creating table 'irstats2_browsers'<br>
Creating table 'irstats2_search_terms'<br>
Creating table 'irstats2_downloads'<br>
Creating table 'irstats2_views'<br>
Access: accessid to process: from 0 to 1727808<br>
Access: it took 1 secs to parse 1 records ( average = 1.00
records/sec )<br>
Access: 1 records kept out of 1 ( ratio = 100.00% )<br>
About to process dataset 'eprint'<br>
Creating table 'irstats2_doc_access'<br>
Creating table 'irstats2_deposits'<br>
Creating table 'irstats2_doc_format'<br>
eprint: starting from record 0<br>
eprint: 2652 records to process.<br>
Leaving now<br>
<br>
but the results are not (or not complete). I see some informations
about eprints database but nothing about downloads! See attached
images.<br>
<br>
Another thing : Looking where this problem could come I changed
the perl path in this file fp_stats.<br>
<br>
Thanks <br>
<br>
jean-marie<br>
<br>
<br>
<div class="moz-cite-prefix">Le 17/06/2013 17:01, Jean-Marie Le
Bechec a écrit :<br>
</div>
<blockquote
cite="mid:EMEW3|239ca3b40af53f437ceee64a38b206e8p5GG2314eprints-tech-bounces|ecs.soton.ac.uk|51BF24BB.3090007@inp-toulouse.fr"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Sol. 1 ! <br>
<br>
jean-Marie<br>
<br>
<div class="moz-cite-prefix">Le 17/06/2013 16:47, Sebastien
Francois a écrit :<br>
</div>
<blockquote
cite="mid:EMEW3|0096a05d924f8a0e746e88f1c6260ef6p5GFjy03sf2|ecs.soton.ac.uk|51BF2182.5080001@ecs.soton.ac.uk"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Hello Jean-Marie!<br>
<br>
On 17/06/13 15:09, Jean-Marie Le Bechec wrote:<br>
</div>
<blockquote cite="mid:51BF18AC.4040705@inp-toulouse.fr"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hi Seb,<br>
<br>
When i try to execute the script : ./process_stats oatao
--setup --verbose<br>
<br>
the prompt give me this : <br>
<br>
"Generating set tables.<br>
Can't call method "clone" on an undefined value at
/appli/eprints/perl_lib/EPrints/Database.pm line 931,
<DATA> line 959."<br>
</blockquote>
<br>
Yep, that rings a bell. The problem is that in EPrints 3.3.9,
some of the core DB API has changed (namely "create_tables()")
which is very naughty. My code abstracts this and tries to
detect the changes but in your instance it seems to have
failed to detect your EPrints version.<br>
<br>
You can either:<br>
<br>
(1) patch EPrints/Plugin/Stats/Handler.pm::_create_table
(~line 1198) to:<br>
<br>
if( (EPrints->VERSION()||'v3.2.0') gt <b>'v3.3.8' </b>)<br>
<br>
^^ quotes v3.3.8 basically<br>
<br>
and test. if that doesn't work, just force the old API call:<br>
<br>
(2) same file, same lines:<br>
<br>
sub _create_table<br>
{<br>
my( $self, $tablename, $setkey, @fields ) = @_;<br>
<br>
<b>#</b> if( (EPrints->VERSION()||'v3.2.0') gt
v3.3.8 )<br>
<b>#</b> {<br>
<b>#</b> return
$self->{dbh}->create_table( $tablename, $setkey, @fields
);<br>
<b>#</b> }<br>
<br>
# pre-3.3.9 API<br>
return $self->{dbh}->create_table( $tablename,
undef, $setkey, @fields );<br>
}<br>
<br>
and this should work.<br>
<br>
<br>
<blockquote cite="mid:51BF18AC.4040705@inp-toulouse.fr"
type="cite"> <br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
My eprints is : EPrints 3.2.4 (Victoria Sponge)<br>
<br>
I also have installed "Date::Calc" and added
EP_TRIGGER_DYNAMIC_TEMPLATE => 10, (line 123)<br>
EP_TRIGGER_DYNAMIC_TEMPLATE (line 153)<br>
<br>
</blockquote>
OK for Date::Calc.<br>
<br>
I don't think that adding the trigger's constants will help
here because you may have the constants defined nicely, but
you'll be missing the code which is actually calling the
trigger. <br>
<br>
And since you're using v3.2.4, I think you'd need to back-port
a bit too much code.<br>
<br>
Anyway the point of that trigger is to insert some elements in
the <head> sections of your template, that's something
you can easily do by hand:<br>
<br>
- edit your template files (default.xml, perhaps secure.xml)<br>
<br>
- add the following into your <head>:<br>
<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<!-- IRStats2 --><br>
<script type="text/javascript" src=<a
moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="http://www.google.com/jsapi"><font color="red"><b>MailScanner
has detected a possible fraud attempt from
"www.google.com" claiming to be</b></font>
"http://www.google.com/jsapi"</a>>// <!-- No script
--></script><br>
<script
type="text/javascript">google.load("visualization", "1",
{packages:["corechart", "geochart"]});</script><br>
<!-- end IRStats2 --><br>
<br>
If you're editing secure.xml, you'll be loading the above page
from an HTTPS so technically you should use:<br>
<br>
<!-- IRStats2 --><br>
<script type="text/javascript" src="<b>https</b>://www.google.com/jsapi">//
<!-- No script --></script><br>
<script
type="text/javascript">google.load("visualization", "1",
{packages:["corechart", "geochart"]});</script><br>
<!-- end IRStats2 --><br>
<br>
- reload apache<br>
<br>
<br>
Merci for your feedback JM - if you get to patch
Handler::_create_table, could you let me know which method
worked (1 or 2)? This way I can patch the IRStats2.<br>
<br>
Seb.<br>
<br>
<br>
<blockquote cite="mid:51BF18AC.4040705@inp-toulouse.fr"
type="cite"> in Const.pm<br>
<br>
Any idea ?<br>
<br>
Thanks !<br>
<br>
Jean-Marie<br>
<br>
<br>
<div class="moz-cite-prefix">Le 05/06/2013 15:09, Sebastien
Francois a écrit :<br>
</div>
<blockquote
cite="mid:EMEW3|3501dfe33389a0be16eba1c63a9e7944p54E8l14eprints-tech-bounces|ecs.soton.ac.uk|51AF388A.8050807@ecs.soton.ac.uk"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Hi Pierre,<br>
<br>
I haven't tested on 3.1, I doubt it will work as most of
the API is using some "concepts" introduced in 3.2.<br>
<br>
Seb.<br>
<br>
On 05/06/13 13:47, Nault, Pierre wrote:<br>
</div>
<blockquote
cite="mid:B3C24EA955FF0C4EA14658997CD3E25E6D97717F@CAHIER.gst.uqam.ca"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14
(filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
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;}
pre
{mso-style-priority:99;
mso-style-link:"Préformaté HTML Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.PrformatHTMLCar
{mso-style-name:"Préformaté HTML Car";
mso-style-priority:99;
mso-style-link:"Préformaté HTML";
font-family:"Consolas","serif";
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.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]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi
Sebastien,<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">
</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">What is the compatibility with
eprints 3.1 ?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">Pierre Nault<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"
lang="FR">De :</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"
lang="FR"> <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a>
[<a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">mailto:eprints-tech-bounces@ecs.soton.ac.uk</a>]
<b>De la part de</b> Sebastien Francois<br>
<b>Envoyé :</b> 5 juin 2013 05:56<br>
<b>À :</b> <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a><br>
<b>Objet :</b> [EP-tech] Re: IRStats2 Beta<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi,<br>
<br>
It's a rewrite so I'm tempted to say that
everything is different ;-)<br>
<br>
The main points are:<br>
<br>
- integrated to the EPrints API so configuring,
extending etc should be easy if you know EPrints
already. It's also rather easy to include graphs
etc on pages<br>
- report-based, which can be configured/managed in
the local conf<br>
- it can generate data from any EPrints' dataset,
not just the download stats (for example: graph of
deposits over time, size of the review over time
etc...)<br>
- data can be exported to XML, JSON, CSV (should
be easy to add other formats if needed)<br>
- uses Google Charts<br>
<br>
The main thing for me is that it's easy to
customise/extend e.g. you could have reports on
citations if you have this enabled on your
repository. <br>
<br>
You can see a demo there: <a
moz-do-not-send="true"
href="http://files.eprints.org/cgi/stats/report">http://files.eprints.org/cgi/stats/report</a><br>
<br>
Seb.<br>
<br>
<br>
On 04/06/13 18:34, Centro de Documentación wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<div>
<p class="MsoNormal"
style="margin-bottom:12.0pt">Hi Sebastian,<br>
<br>
What are the main differences between
version 1 and 2?<o:p></o:p></p>
</div>
<p class="MsoNormal"
style="margin-bottom:12.0pt">Of course, Google
Charts and ...<o:p></o:p></p>
</div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Thu, May 30, 2013 at
12:17 PM, Sebastien Francois <<a
moz-do-not-send="true"
href="mailto:sf2@ecs.soton.ac.uk"
target="_blank">sf2@ecs.soton.ac.uk</a>>
wrote:<o:p></o:p></p>
<p class="MsoNormal">Hi all,<br>
<br>
I have added IRStats2 to the eprints GitHub so
you may now download and<br>
use/test it.<br>
<br>
EPrints 3.3 users may use the bazaar package
available from there:<br>
<a moz-do-not-send="true"
href="https://github.com/eprints/irstats2/blob/master/epm/irstats2-0.0.2.epm"
target="_blank">https://github.com/eprints/irstats2/blob/master/epm/irstats2-0.0.2.epm</a><br>
(note that it's not yet live on the
Bazaar-store). Even so you can<br>
install the package easily this way, you still
need to run a script to<br>
process the stats. That is not yet automated.<br>
<br>
EPrints 3.2 users will have to copy files by
hand, it's pretty<br>
straight-forward and the INSTALL file contains
some instructions.<br>
<br>
It's not quite the final/stable release yet
but it has been thoroughly<br>
tested on a few "real" repositories and it's
unlikely to break a<br>
repository anyway.<br>
<br>
I hope you'll enjoy, please contribute (ideas
/ comments / bugs etc)<br>
directly to me or to GitHub.<br>
<br>
Seb.<br>
<br>
PS: yes, it can run in parallel to IRStats1.<br>
*** Options: <a moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://www.eprints.org/tech.php/"
target="_blank">http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a
moz-do-not-send="true"
href="http://wiki.eprints.org/"
target="_blank">http://wiki.eprints.org/</a><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><br>
<br>
<br>
<o:p></o:p></p>
<pre>*** Options: <a moz-do-not-send="true" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><o:p></o:p></pre>
<pre>*** Archive: <a moz-do-not-send="true" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><o:p></o:p></pre>
<pre>*** EPrints community wiki: <a moz-do-not-send="true" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
***********************************************
Jean Marie Le Bechec
Service Commun de la Documentation
Responsable ingenierie documentaire
&
Direction du Systeme d'Information
Referent Etudes
Institut National Polytechnique de Toulouse
6 allee Emile Monso - bp 34038 -
31029 Toulouse cedex 4
Tel : 05 34 32 31 16
Mail : <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:lebechec@inp-toulouse.fr">lebechec@inp-toulouse.fr</a>
***********************************************
</pre>
</blockquote>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
***********************************************
Jean Marie Le Bechec
Service Commun de la Documentation
Responsable ingenierie documentaire
&
Direction du Systeme d'Information
Referent Etudes
Institut National Polytechnique de Toulouse
6 allee Emile Monso - bp 34038 -
31029 Toulouse cedex 4
Tel : 05 34 32 31 16
Mail : <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:lebechec@inp-toulouse.fr">lebechec@inp-toulouse.fr</a>
***********************************************
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
***********************************************
Jean Marie Le Bechec
Service Commun de la Documentation
Responsable ingenierie documentaire
&
Direction du Systeme d'Information
Referent Etudes
Institut National Polytechnique de Toulouse
6 allee Emile Monso - bp 34038 -
31029 Toulouse cedex 4
Tel : 05 34 32 31 16
Mail : <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:lebechec@inp-toulouse.fr">lebechec@inp-toulouse.fr</a>
***********************************************
</pre>
</blockquote>
<br>
</body>
</html>