<div dir="ltr"><div>Hi,</div><div><br></div><div>There are two underlying database tables involved, offline.script (which has a row for each file loaded into an offline session) and offline.session (which has a row for each pending and completed session).</div><div><br></div><div>They're not the friendliest of tables to work with - in particular, their date/time fields are integer columns that store seconds since the Unix epoch rather than being true timestamp columns, and they don't have foreign key constraints. That said, with direct SQL access, they are enough to write reports on which libraries and staff members are using offline, when they processed transactions, and how many transactions were processed. The to_timestamp() SQL function can be used to deal with the date/time fields, e.g.,</div><div><br></div><div>SELECT to_timestamp(create_time) FROM offline.session ORDER BY 1 DESC LIMIT 5; <br></div><div><br></div><div>They're also not set up as reporting sources, but there's no technical barrier to a small enhancement to make them accessible to the reporter (though converting those tables' date/time columns to the timestamp type would be a nice thing to do at the cost of some more work in the code that actually does offline processing).<br></div><div><br></div><div>Regards,</div><div><br></div><div>Galen<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 23, 2024 at 1:53 PM Elizabeth Davis via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org" target="_blank">evergreen-reports@list.evergreen-ils.org</a>> wrote:<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>
<div lang="EN-US">
<div>
<p class="MsoNormal">Hello<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I was curious if anyone has ever built a report on use of the offline mode use. I realize I can’t track how often they use it, but I am curious how often people are uploading transactions.
<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:12pt"><u></u> <u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><u></u><img width="83" height="83" style="width: 0.8645in; height: 0.8645in;" src="cid:ii_18fa6a82706692e331" align="left" hspace="12"><u></u><b><span style="font-size:12pt;color:rgb(22,105,122)">Elizabeth
Davis</span></b><b><span style="font-size:12pt"> </span></b><span style="font-size:12pt">(she/her),
<b><i><span style="color:rgb(22,105,122)">Support & Project Management Specialist</span></i></b><span style="color:rgb(22,105,122)"> </span></span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><b><span style="font-size:12pt;color:rgb(51,102,204)">Pennsylvania Integrated Library System
</span></b><b><span style="font-size:12pt;color:rgb(68,114,196)">(PaILS) | SPARK</span></b><span style="font-size:12pt;color:rgb(51,102,204)"> </span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:12pt;color:rgb(51,102,204)">(717) 256-1627</span><span style="font-size:12pt"> |
<a href="mailto:katherine.dannehl@sparkpa.org" target="_blank"><span style="color:rgb(5,99,193)">elizabeth.davis@sparkpa.org</span></a> <br>
<a href="https://support.sparkpa.org/" target="_blank"><span style="color:rgb(5,99,193)">support.sparkpa.org</span></a><span style="color:rgb(51,102,204)"> |
</span><a href="mailto:support@sparkpa.org" target="_blank"><span style="color:rgb(5,99,193)">support@sparkpa.org</span></a><span style="color:rgb(51,102,204)"> </span></span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</div></blockquote></div><br clear="all"><br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr">Galen Charlton<br>Implementation and IT Manager<br>Equinox Open Library Initiative<br><a href="mailto:gmc@equinoxOLI.org" target="_blank">gmc@equinoxOLI.org</a><br><a href="https://www.equinoxOLI.org" target="_blank">https://www.equinoxOLI.org</a> <br>phone: 877-OPEN-ILS (673-6457)<br>direct: 770-709-5581<br><a href="http://evergreen-ils.org" target="_blank"></a></div></div>