[Koha] join/merge some tag 952 to only one

2019-02-20 Thread anabela semedo
Hello people I have multiple fields in my 952 file and would like to put them together so I can track the number of copies before importing them into the database. for example I have: 952$a 952$b 952$y 952$9 and I wish it were like this: 952$a$b$y$9 but it's the only thing I can not do in the edit

Re: [Koha] Ebook display in the opac

2019-02-20 Thread Katharina Klausner
Hi all, my colleague came up with a simpler solution without using reports. I edited all our e-book MARC records with MarcEdit to contain the phrase "Click here for online access" in 856 z. Then the opacuserjs is edited with this code: $(document).ready(function() { var tag = 'Click here for

Re: [Koha] Item cannot be issued through 3M self-check - error message PREVISSUE

2019-02-20 Thread Nick Clemens
Koha passes the 'PREVISSUE' as a flag that the checkout needs confirmation - for SIP machines this means the checkout fails I believe. You should only be seeing this message if the previous issues are being checked, if the pref is set to Do Not and the message is appearing there may be a bug. -Ni

Re: [Koha] Item cannot be issued through 3M self-check - error message PREVISSUE

2019-02-20 Thread Matthias Meusburger
Please see Bug 19457, that intends to fix this behavior. https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19457 Le 20/02/2019 à 15:43, Nick Clemens a écrit : Koha passes the 'PREVISSUE' as a flag that the checkout needs confirmation - for SIP machines this means the checkout fails I be

[Koha] Need a little help with an SQL query

2019-02-20 Thread Chris Brown
Gentle Reader, We want to get a list of all patrons for who we do *not *have email addresses but who are "active" (for example, have checked a book out in the last 6 months) I know how to get a list of patrons with no email address but my knowledge of SQL and the database schema aren't good enoug

Re: [Koha] Need a little help with an SQL query

2019-02-20 Thread Joe Sikowitz
Something like this may work: SELECT b.cardnumber, b.surname, b.firstname, i.issuedate FROM borrowers b INNER JOIN issues i ON (b.borrowernumber = i.borrowernumber) WHERE i.issuedate BETWEEN <> AND <> GROUP BY b.cardnumber Joe On Wed, Feb 20, 2019 at 11:24 AM Chris Brown wrote: > Gentle Reader

Re: [Koha] Need a little help with an SQL query

2019-02-20 Thread Joe Sikowitz
You could also add in old issues which you probably would want so that you get returned items: SELECT b.cardnumber, b.surname, b.firstname, i.issuedate AS 'Current Issue', o.issuedate AS 'Old Issue' FROM borrowers b INNER JOIN issues i ON (b.borrowernumber = i.borrowernumber) INNER JOIN old_issues

Re: [Koha] Need a little help with an SQL query

2019-02-20 Thread Joe Sikowitz
Ignore the last one. This one will work better. Hope this is helpful. SELECT b.cardnumber, b.surname, b.firstname, i.issuedate AS 'Current Issue', o.issuedate AS 'Old Issue' FROM borrowers b LEFT JOIN issues i ON (b.borrowernumber = i.borrowernumber) LEFT JOIN old_issues o ON (b.borrowernumber = o

[Koha] Suppression of display of In Process status in OPAC

2019-02-20 Thread Peter Lau
How can I suppress display of those items with Withdrawn status equals to “In Process”? Thanks & regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320 [image: https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE5NNu&r

Re: [Koha] Item cannot be issued through 3M self-check - error message PREVISSUE

2019-02-20 Thread Peter Lau
Hi Nick, So does not bug lie with the Koha software or the 3M self-check machine? I have found at least one local site with 3M self-check of the correct setting on Koha that allows multiple check-in and check-out by the same user successively. Thanks & regards, *Peter Lau* Librarian Tel: