[Evergreen-reports] Offline Use Report

[Elizabeth Davis]

Hi Galen

Thanks! I edited the query based on what you shared, and I think this will be helpful.

I’ll put in a wishlist bug to make this a source.



[cid:image004.png at 01DAAD24.58037360]Elizabeth Davis (she/her), Support & Project Management Specialist
Pennsylvania Integrated Library System (PaILS) | SPARK
(717) 256-1627 | elizabeth.davis at sparkpa.org<mailto:katherine.dannehl at sparkpa.org>
support.sparkpa.org<https://support.sparkpa.org/> | support at sparkpa.org<mailto:support at sparkpa.org>

From: Galen Charlton <gmc at equinoxoli.org>
Sent: Thursday, May 23, 2024 2:26 PM
To: Evergreen Community Reports Email List <evergreen-reports at list.evergreen-ils.org>
Cc: Elizabeth Davis <elizabeth.davis at sparkpa.org>
Subject: Re: [Evergreen-reports] Offline Use Report

Hi,

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).

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.,

SELECT to_timestamp(create_time) FROM offline.session ORDER BY 1 DESC LIMIT 5;

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).

Regards,

Galen

On Thu, May 23, 2024 at 1:53 PM Elizabeth Davis via Evergreen-reports <evergreen-reports at list.evergreen-ils.org<mailto:evergreen-reports at list.evergreen-ils.org>> wrote:
Hello

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.

[cid:image003.png at 01DAAD24.57FFA2D0]Elizabeth Davis (she/her), Support & Project Management Specialist
Pennsylvania Integrated Library System (PaILS) | SPARK
(717) 256-1627 | elizabeth.davis at sparkpa.org<mailto:katherine.dannehl at sparkpa.org>
support.sparkpa.org<https://urldefense.proofpoint.com/v2/url?u=https-3A__support.sparkpa.org_&d=DwMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=j4SWsMDXRVOGlMb-EfMRIp9IjAos-OG-ewOKBUjTNh8&m=LEopF4gt2i0yeIXttZghdanVIwsgHU-hXHAKIKeMqIuaY5Z6xA7bjVMXbXYohxHe&s=KqtQ_xz2CmBF_Xz1B_0_fTjz5F2RC5zBl2WYU-OlhCM&e=> | support at sparkpa.org<mailto:support at sparkpa.org>

_______________________________________________
Evergreen-reports mailing list
Evergreen-reports at list.evergreen-ils.org<mailto:Evergreen-reports at list.evergreen-ils.org>
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports<https://urldefense.proofpoint.com/v2/url?u=http-3A__list.evergreen-2Dils.org_cgi-2Dbin_mailman_listinfo_evergreen-2Dreports&d=DwMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=j4SWsMDXRVOGlMb-EfMRIp9IjAos-OG-ewOKBUjTNh8&m=LEopF4gt2i0yeIXttZghdanVIwsgHU-hXHAKIKeMqIuaY5Z6xA7bjVMXbXYohxHe&s=ARjE9XqnJW4LiOjYzN8GtrWLyjaxU5a0neE9jO2hoFk&e=>


--
Galen Charlton
Implementation and IT Manager
Equinox Open Library Initiative
gmc at equinoxOLI.org<mailto:gmc at equinoxOLI.org>
https://www.equinoxOLI.org<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.equinoxOLI.org&d=DwMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=j4SWsMDXRVOGlMb-EfMRIp9IjAos-OG-ewOKBUjTNh8&m=LEopF4gt2i0yeIXttZghdanVIwsgHU-hXHAKIKeMqIuaY5Z6xA7bjVMXbXYohxHe&s=BuAqn981OTckusYeb_4HrqTNiALDF115x1hAGc3L-mg&e=>
phone: 877-OPEN-ILS (673-6457)
direct: 770-709-5581
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20240523/cc99d025/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10034 bytes
Desc: image001.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20240523/cc99d025/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 5402 bytes
Desc: image003.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20240523/cc99d025/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 5407 bytes
Desc: image004.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20240523/cc99d025/attachment-0005.png>