Re: [Koha] Circulation timestamps
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 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
[Koha] Circulation timestamps
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/>* -- *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
Re: [Koha] Report help
Thanks so much Caroline. Perhaps I should look at the statistics wizards more often! 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 3 August 2018 at 18:29, Caroline Cyr-La-Rose < caroline.cyr-la-r...@inlibro.com> wrote: > Hi David, > > Did you try with the statistics wizards? If you go in Reports > Statistics > wizards > Patrons and then choose your first attribute "CC" as a row and > "CD" as a column, it should give you a table with all the different > combinations and the count of patrons with that combination. > > Caroline > Caroline Cyr La Rose, M.S.I. > Bibl. prof. / Chargée de la formation et du soutien > > Tél. : 1 (833) 465-4276 > caroline.cyr-la-r...@inlibro.com > inLibro | pour esprit libre | www.inLibro.com > Le 2018-08-03 à 11:57, David Hughes a écrit : > > Hi, > > I want to create a report that gives a grand total of records with various > combinations of two different patron attributes. > > I have two different borrower_attributes.code values "CC" and "CD" and I > want to output the grand totals of records with all permutations of > borrower_attributes.attribute that have these codes. So if > borrower_attributes.code CC has values 1, 2, 3 etc and > borrower_attributes.code CD has values A, B C I'd want to output the grand > totals of all records having > > CC value "1" CD value "A" > CC value "1" CD value "B" > CC value "1" CD value "C" > .. > CC value "2" CD value "A" > CC value "2" CD value "B" > > etc > > This is outwith the scope of my very limited SQL, so I'd appreciate any > help that the community would be able to offer. Thanks. > > 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/> > <http://library.dbs-students.com/>* > > > > -- *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
[Koha] Report help
Hi, I want to create a report that gives a grand total of records with various combinations of two different patron attributes. I have two different borrower_attributes.code values "CC" and "CD" and I want to output the grand totals of records with all permutations of borrower_attributes.attribute that have these codes. So if borrower_attributes.code CC has values 1, 2, 3 etc and borrower_attributes.code CD has values A, B C I'd want to output the grand totals of all records having CC value "1" CD value "A" CC value "1" CD value "B" CC value "1" CD value "C" .. CC value "2" CD value "A" CC value "2" CD value "B" etc This is outwith the scope of my very limited SQL, so I'd appreciate any help that the community would be able to offer. Thanks. 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/>* -- *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
Re: [Koha] Anonymous external link tracking
Hi Marc, I have now. Thanks :) Best wishes, 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 17 November 2017 at 12:29, Marc Véron <ve...@veron.ch> wrote: > Hi David > > Did you create a patron for anonymous tracking and set it in the following > syspref? > > AnonymousPatron - Use borrowernumber xxx as the Anonymous Patron (for > anonymous suggestions and reading history) > > Marc > > > Am 17.11.2017 um 13:21 schrieb David Hughes: > >> Hi, >> >> When the TrackClick OPAC parameter is set to 'Track anonymously' is the >> biblionumber recorded? I know that the borrowernumber isn't recorded, but >> according to the manual "If you choose to ‘Track anonymously’ then the >> borrowernumber will not be recorded, but the rest of the data will." >> >> I have this parameter set to 'Track Anonymously' and it looks like neither >> biblionumber or borrowernumber is being recorded. >> >> It'd be nice for our stats if we could track biblionumbers while not >> recording borrowernumbers. >> >> We're using Koha 16.11 >> >> Thanks. >> >> 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: As the protection of your data is important to us, we have included our policies regarding data in a Data Protection Statement and Privacy Policy, which you can access by visiting www.dbs.ie Privacy: We may contact you from time to time with details of courses and products that may be of interest to you. Please e-mail admissi...@dbs.ie if you do not wish to be included in this activity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Anonymous external link tracking
Hi, When the TrackClick OPAC parameter is set to 'Track anonymously' is the biblionumber recorded? I know that the borrowernumber isn't recorded, but according to the manual "If you choose to ‘Track anonymously’ then the borrowernumber will not be recorded, but the rest of the data will." I have this parameter set to 'Track Anonymously' and it looks like neither biblionumber or borrowernumber is being recorded. It'd be nice for our stats if we could track biblionumbers while not recording borrowernumbers. We're using Koha 16.11 Thanks. 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/>* -- Data Protection: As the protection of your data is important to us, we have included our policies regarding data in a Data Protection Statement and Privacy Policy, which you can access by visiting www.dbs.ie Privacy: We may contact you from time to time with details of courses and products that may be of interest to you. Please e-mail admissi...@dbs.ie if you do not wish to be included in this activity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha