Re: [Koha] Display of information on OPAC

Hi Peter, for the holdings table in OPAC: The collection column appears as 'item_ccode' under column settings for holdingst. Copy information already appears in a separate column for me. Maybe you mean a different spot in the OPAC? Please don't reply to the Digest emails as this will break

Re: [Koha] ITEM STATUS in KOHA

Hi, Koha doesn't use a single status field, but stores information regarding the status in multiple places: - items.damaged - items.lost - items.onloan / issues - items.notforloan ... You can find more information on Koha's database structure on http://schema.koha-community.org. Hope this

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

Hi Ana, I've never done it, but it looks like it might be possible with the 'swap' functionality in MARCEdit: https://lists.katipo.co.nz/public/koha/2013-January/035302.html I also found: https://bywatersolutions.com/news/marcedit-koha-items Hope this helps, Katrin On 20.02.19 14:56,

Re: [Koha] search result list is void of information

Hi Guiseppe, I read that you are using UNIMARC, I think you might have been hit by this bug: *Bug 22085* - UNIMARC default XSLT broken by Bug 14716 It will be

[Koha] Offline Circulation | Issue with Borrowers.db File

Hi, Koha Version : 18.11.02.000 Desktop Application : v1.3.2 I was able to generate the borrowers.db file using the cronjob script available, after specifying the path in Desktop Application and entering/scanning card number the search is not working a "," is seen in the address filed no name

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

That doesn't work. It seems to be implicitly saying find rows where i.issuedate IS NOT NULL OR o.issuedate BETWEEN <> AND <>. Joe On Thu, Feb 21, 2019 at 1:05 PM Chris Brown wrote: > Hi Barton and Joe, > > All interesting discussion, and many thanks for the help and interest > but

Re: [Koha] Koha 18.05 Patron search broken for non-superlibrarian users

Hello Mai, Which exact version are you using? What you describe seems to have been fixed by bug 20998, which is part of 18.05.02 Last 18.05.x release is 18.05.08 Regards, Jonathan Le jeu. 21 févr. 2019 à 14:36, Mai a écrit : > > Dear all, > We're experiencing problems with patron search on

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

Hi Barton and Joe, All interesting discussion, and many thanks for the help and interest but putting the dates in twice is not a big deal for me. Acting on the results of our query (i.e. chasing up those active patrons for who we don't have email addresses) is many magnitudes more effort

[Koha] Koha 18.05 Patron search broken for non-superlibrarian users

Dear all, We're experiencing problems with patron search on Koha 18.05 When a non-superlibrarian staff member looks up a patron, the following error occurs: > Can't call method "branchcode" on an undefined value at > /usr/share/koha/intranet/cgi-bin/members/member.pl line 56, line > 751. If the

Re: [Koha] search result list is void of information

Hi, I don't think so because we did no customizations in our previous koha 17.11 -- it was a plain default installation done by myself so I'm sure of this. Anyway I will check this too, thank you. Giuseppe On Thu, 21 Feb 2019, Hugo Agud wrote: Hi this is probably because the old server

Re: [Koha] search result list is void of information

Hi this is probably because the old server has a customized xslt and in the new server there are not the files, then koha doesn't know how to set up the records, check at syspref the OPACXSLTResultsDisplay has default value instead a local path Hugo El jue., 21 feb. 2019 a las 17:18, Giuseppe

Re: [Koha] search result list is void of information

Hello Jonathan, I will try to reindex, it costs nothing -- could you please give me the command for that? But, to be honest, I don't see the reason why a reindexing would solve. I'm not reusing a pre-existing archive. I formatted everything, installed debian 9.7, then installed koha 18.11,

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

This was added in 18.05. There is a way to fudge it using SQL variables, but it's such a pain to write that you're better double-entering the values until you can upgrade to 18.05. if you *are* using 18.05, then you'll just need to make sure that whatever you want repeated, e.g. BETWEEN <> AND

Re: [Koha] search result list is void of information

Hi Giuseppe (cc the list I forgot in my previous answer), I would try a full zebra reindex, then search for relevant errors/warnings in the Koha log files if the reindex did not fix the problem. Regards, Jonathan Le mar. 19 févr. 2019 à 10:32, Giuseppe Ciaccio a écrit : > > On Tue, 19 Feb 2019,

Re: [Koha] 2 Different Issues: Patron Card Number / Library of Congress Call Numbers

Hi Sam, 1. Patron cardnumbers. That's a unique problem. My suggestion to you would involve resetting all the patron cardnumbers. If your cardnumbers are arbitrary and not printed on cards or used by patrons to login, then you can reset these cardnumbers. I would set the cardnumber to the

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

That is interesting. I'm using Koha 18.05 and it doesn't require me to enter the dates twice. You could just set the query up so that it looks at the past six months from the current day instead: SELECT b.cardnumber, b.surname, b.firstname, i.issuedate AS 'Current Issue', o.issuedate AS 'Old

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

Hi Joe, Many thanks for your help. That seems to be working. However your revised version does require the "from" and "to" dates to be entered twice when you run it. Is there a way to avoid that? (It's not a big deal as we won't be running the report very often) Thanks again, Chris Brown On

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

Hi Giacomo, Yes, it works. Thanks & regards, Peter Lau Librarian Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320 2 Tin Wan Hill Road, Tin Wan, Aberdeen YCCECE, Here We Grow Our Future | www.yccece.edu.hk -Original Message- From: Giacomo Visini

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

Hi Peter, Have a look here: https://wiki.koha-community.org/wiki/OpacHiddenItems I think this is what you're looking for, but I haven't tried it myself. Kind regards, Giacomo Visini DIVA library, Antwerp, Home of diamonds. giacomo.vis...@divaantwerp.be +32(0)3 360 52 42 -Oorspronkelijk

[Koha] 2 Different Issues: Patron Card Number / Library of Congress Call Numbers

Hi, All! I deeply apologize for the length of this message... Here at Northern Marianas College (NMC), we are still currently using *Koha version 3.14.11.000* (*definitely* time for an upgrade, I know; we are aiming to do so within the next few months). Meanwhile, I now have two (2) separate