<div dir="ltr">Muchas gracias Ricardo!! <div>Voy a probar! </div><div>Y sabes si hay alguna manera en Koha de que se pueda generar un Handle con la url que crea en los archivos que se suben?</div><div>No hay apuro, muchas gracias y buen domingo! </div><div>Saludos cordiales,</div><div><br></div><div>Samanta</div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:13px"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avg.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El dom., 14 jun. 2020 a las 14:25, Ricardo Vargas (<<a href="mailto:ricvargasmed@gmail.com">ricvargasmed@gmail.com</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hola:<div><br></div><div>Podrías usar este como base, que es para un mes atrás:</div><div><br></div><div><pre style="padding:0px;border:0px none white;color:rgb(0,0,0);background:none rgb(249,249,249);font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10.3187px;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><span style="color:rgb(153,51,51);font-weight:bold">SELECT</span> count<span style="color:rgb(102,204,102)">(</span>url<span style="color:rgb(102,204,102)">)</span> <span style="color:rgb(153,51,51);font-weight:bold">AS</span> <span style="color:rgb(255,0,0)">'times'</span><span style="color:rgb(102,204,102)">,</span> url <span style="color:rgb(153,51,51);font-weight:bold">FROM</span> linktracker <span style="color:rgb(153,51,51);font-weight:bold">WHERE</span> timeclicked <span style="color:rgb(102,204,102)">></span> DATE_SUB<span style="color:rgb(102,204,102)">(</span>now<span style="color:rgb(102,204,102)">(</span><span style="color:rgb(102,204,102)">)</span><span style="color:rgb(102,204,102)">,</span> INTERVAL <span style="color:rgb(204,102,204)">1</span> MONTH<span style="color:rgb(102,204,102)">)</span> <span style="color:rgb(153,51,51);font-weight:bold">GROUP</span> <span style="color:rgb(153,51,51);font-weight:bold">BY</span> url</pre><pre style="padding:0px;border:0px none white;color:rgb(0,0,0);background:none rgb(249,249,249);font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10.3187px;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><br></pre><pre style="padding:0px;border:0px none white;color:rgb(0,0,0);background:none rgb(249,249,249);font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10.3187px;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top">Y entonces solo le agregas en el where que inicie con la URL de tu Koha, algo así:</pre><pre style="padding:0px;border:0px none white;color:rgb(0,0,0);background:none rgb(249,249,249);font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10.3187px;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><br></pre><pre style="padding:0px;border:0px none white;color:rgb(0,0,0);background:none rgb(249,249,249);font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10.3187px;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><span style="color:rgb(153,51,51);font-weight:bold">SELECT</span> count<span style="color:rgb(102,204,102)">(</span>url<span style="color:rgb(102,204,102)">)</span> <span style="color:rgb(153,51,51);font-weight:bold">AS</span> <span style="color:rgb(255,0,0)">'times'</span><span style="color:rgb(102,204,102)">,</span> url <span style="color:rgb(153,51,51);font-weight:bold">FROM</span> linktracker <span style="color:rgb(153,51,51);font-weight:bold">WHERE</span> timeclicked <span style="color:rgb(102,204,102)">></span> DATE_SUB<span style="color:rgb(102,204,102)">(</span>now<span style="color:rgb(102,204,102)">(</span><span style="color:rgb(102,204,102)">)</span><span style="color:rgb(102,204,102)">,</span> INTERVAL <span style="color:rgb(204,102,204)">1</span> MONTH<span style="color:rgb(102,204,102)">)</span> AND url like '<a href="http://laurldetuopac" target="_blank">http://laurldetuopac</a>%' <span style="color:rgb(153,51,51);font-weight:bold">GROUP</span> <span style="color:rgb(153,51,51);font-weight:bold">BY</span> url</pre><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><br></pre><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top">Si quieres el mismo reporte, pero por un rango de fechas lo haces así:</pre><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><br></pre><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><span style="color:rgb(153,51,51);font-weight:bold">SELECT</span> count<span style="color:rgb(102,204,102)">(</span>url<span style="color:rgb(102,204,102)">)</span> <span style="color:rgb(153,51,51);font-weight:bold">AS</span> <span style="color:rgb(255,0,0)">'times'</span><span style="color:rgb(102,204,102)">,</span> url </pre><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><span style="color:rgb(153,51,51);font-weight:bold">FROM</span> linktracker </pre><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><span style="color:rgb(153,51,51);font-weight:bold">WHERE</span> date(timeclicked) BETWEEN<span style="font-family:Arial,Helvetica,sans-serif"> </span><span style="font-family:Arial,Helvetica,sans-serif;color:rgb(102,204,102)"><<</span><span style="font-family:Arial,Helvetica,sans-serif">Fecha inicial</span><span style="font-family:Arial,Helvetica,sans-serif;color:rgb(102,204,102)">|</span><span style="font-family:Arial,Helvetica,sans-serif">date</span><span style="font-family:Arial,Helvetica,sans-serif;color:rgb(102,204,102)">>></span><span style="font-family:Arial,Helvetica,sans-serif"> </span><span style="font-family:Arial,Helvetica,sans-serif;color:rgb(153,51,51);font-weight:bold">AND</span><span style="font-family:Arial,Helvetica,sans-serif"> </span><span style="font-family:Arial,Helvetica,sans-serif;color:rgb(102,204,102)"><<</span><span style="font-family:Arial,Helvetica,sans-serif">Fecha final</span><span style="font-family:Arial,Helvetica,sans-serif;color:rgb(102,204,102)">|</span><span style="font-family:Arial,Helvetica,sans-serif">date</span><span style="font-family:Arial,Helvetica,sans-serif;color:rgb(102,204,102)">>></span></pre><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top">AND url like '<a href="http://laurldetuopac" target="_blank">http://laurldetuopac</a>%'</pre><pre style="padding:0px;border:0px none white;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;line-height:1.2em;margin-top:0px;margin-bottom:0px;vertical-align:top"><span style="color:rgb(153,51,51);font-weight:bold">GROUP</span> <span style="color:rgb(153,51,51);font-weight:bold">BY</span> url<br></pre></pre></div></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El dom., 14 jun. 2020 a las 12:17, Samanta Tello Borisovsky (<<a href="mailto:samantatellob@gmail.com" target="_blank">samantatellob@gmail.com</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">¡Hola comunidad!<div>Quería saber si se pueden realizar y si alguien ya lo hizo, informes de la cantidad de descargas hechas de los materiales en texto completo subidos al campo 856 $u, no de enlaces sino de los materiales efectivamente subidos al Koha.</div><div>Muchas gracias,</div><div>Saludos cordiales,</div><div><br></div><div>Samanta Tello</div></div><div id="gmail-m_-1571578482265365679gmail-m_6279810616225687776DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid rgb(211,212,222)">
<tbody><tr>
<td style="width:55px;padding-top:13px"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color:rgb(68,83,234)" target="_blank">www.avg.com</a>
</td>
</tr>
</tbody></table><a href="#m_-1571578482265365679_m_6279810616225687776_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>
-- <br>
Koha-es mailing list<br>
<a href="mailto:Koha-es@lists.koha-community.org" target="_blank">Koha-es@lists.koha-community.org</a><br>
<a href="https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-es" rel="noreferrer" target="_blank">https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-es</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div>Saludos...<br><br>Ricardo Vargas.<br><a href="mailto:ricvargasmed@gmail.com" target="_blank">ricvargasmed@gmail.com</a><br></div><div>Cel. 55-4338-4601</div></div></div>
</blockquote></div>