[Koha] Circulation timestamps

[David Hughes]

Hi Katrin,

Good point re: offline circulation, though if Koha is offline, our
self-service stations will be offline too, so that wouldn't be an issue,
for us anyway

Kind regards

David Hughes

Systems Librarian
Dublin Business School
13-14 Aungier St.
Dublin 2
Ireland

00 353 1 417 8744

david.hughes at dbs.ie
*http://library.dbs.ie <http://library.dbs-students.com/>*


On Thu, 13 Dec 2018 at 12:16, Katrin Fischer <katrin.fischer.83 at web.de>
wrote:

> Hi Hugh,
>
> we have seen some weird behavior with the timestamps and self checks
> too. I agree that it should be the same date and time in both tables,
> but I think we might want the time of the self check, not the server
> time. I think using the time and date the self check transmits via SIP2
> could be a feature. It could be needed for things like offline
> circulation to work correctly where the transactions are sent to Koha at
> a later point in time after the connection has been lost.
>
> Some SIP2 experts might have better insight.
>
> Katrin
>
> On 13.12.18 12:26, David Hughes wrote:
> > Hi,
> >
> > I'm not sure if this a bug, or merely an observation, but I think it's
> > worth noting.
> >
> > A colleague drew my attention to a reader who, according to the
> circulation
> > history tab on their patron record, returned 5 books at one of our
> > self-service stations at 2am this morning.  The problem being we close at
> > 10pm.  Nobody thinks the reader broke into the library specifically to
> > return overdue books.  The more mundane solution was that somehow, the
> > clock on the self-service station PC was set 12 hours fast.
> >
> > Looking at the circulation log, the books were returned at 2pm yesterday.
> > Querying the statistics table for the reader's borrower number also comes
> > up with books being returned yesterday at 2pm.  Doing the same for the
> > old_issues table comes up the books being returned at 2am this morning.
> So
> > it's possible for the statistics and old_issues tables to show different
> > return dates on books; statistics datetime seems to come from the Koha
> > server, but old_issues returndate seems to come from the date/time on the
> > local machine.
> >
> > The reader's books were overdue, but we have a one day grace period
> before
> > fines are incurred - these fines come from the books being returned today
> > at 2am after being due on the 11th - so fine information seems to come
> from
> > the return date on the local machine.
> >
> > I am a humble librarian who may be completely wrong about this, but
> > shouldn't the return date on both tables come from the same place and
> fines
> > be generated from the server time, not the local machine?
> >
> > Kind regards,
> >
> > David Hughes
> >
> > Systems Librarian
> > Dublin Business School
> > 13-14 Aungier St.
> > Dublin 2
> > Ireland
> >
> > 00 353 1 417 8744
> >
> > david.hughes at dbs.ie
> > *http://library.dbs.ie <http://library.dbs-students.com/>*
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>

-- 


*Data Protection: *The protection of your data is important to us.  
Please see our Privacy Notice <https://www.dbs.ie/privacy-policy> for more 
information on how we handle your data.