[Evergreen-reports] Offline Use Report

[Galen Charlton]

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> 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.
>
>
>
> *Elizabeth Davis* (she/her), *Support & Project Management Specialist*
>
> *Pennsylvania Integrated Library System **(PaILS) | SPARK*
>
> (717) 256-1627 | elizabeth.davis at sparkpa.org
> <katherine.dannehl at sparkpa.org>
> support.sparkpa.org | support at sparkpa.org
>
>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>


-- 
Galen Charlton
Implementation and IT Manager
Equinox Open Library Initiative
gmc at equinoxOLI.org
https://www.equinoxOLI.org
phone: 877-OPEN-ILS (673-6457)
direct: 770-709-5581
<http://evergreen-ils.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20240523/064604b5/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 5402 bytes
Desc: not available
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20240523/064604b5/attachment.png>