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.hug...@dbs.ie *http://library.dbs.ie <http://library.dbs-students.com/>* On Thu, 13 Dec 2018 at 12:16, Katrin Fischer <katrin.fischer...@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.hug...@dbs.ie > > *http://library.dbs.ie <http://library.dbs-students.com/>* > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@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. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha