[Koha] Batch item modification: barcodes including space are not found

Hi, the barcodes of my items usually include a space as a separator between internal subfields (e.g. AA 001). While I never had any trouble when dealing with them at MySQL level, I find out now that the "Batch item modification" tool is not able to find barcodes including a space. I even tri

[Koha] No items expected when receiving shipment

Hi, (using Koha 21.05.05.003 in Ubuntu 18.04) after closing a basket under Acquisition, I try to "receive a new shipment", but the "Items expected" column has 0 (zero) for each order. This did not happen a few releases ago ... Any suggestion? Many thanks! Giuseppe. ___

[Koha] search results inconsistent with items.location

Hi, (using Koha 21.11.00.000 on Ubuntu 18.04) from the administrator's interface, when a catalogue search yields several results, the listed "location" is sometimes not up to date. Checking a given bibliorecord, I can see that the "location" for the item in question is updated. I have to "ed

[Koha] search patron not working

Hi, I am using Koha 22.05.00.000 on Ubuntu 18.04.6 LTS. Since a few (Koha) updates ago, I've noticed that the "search patrons" function is not working. I type in the first letters or the full name of an (existing) patron, the search engine starts, but no one is found. In order to display t

Re: [Koha] search patron not working

Hi, Katrin. the patron search in 22.05 was changed over to use the API for searching. I think the API is not working correctly for you. In fact, after looking for "API" among the Koha Administrative Interface paraments, I noticed that RESTBasicAuth and others were "disabled" for me. After e

Re: [Koha] search patron not working

Hi, Katrin. You have a package installation on Ubuntu 18.04 LTS? Yes, correct. What does your entry in etc/apt/sources.list.d/koha.list look like? The above file reads: deb http://debian.koha-community.org/koha stable main Many thanks! Giuseppe.

Re: [Koha] search patron not working

.koha-community.org/wiki/Koha_on_Debian#Support_for_Koha_on_older_versions_of_Debian.2FUbuntu_.28Debian_8.2C_Ubuntu_18.04.2C_Ubuntu_16.04.29 I am not sure what the exact steps are, but this might get you a little further to resolving this. Katrin On 20.06.22 05:35, Giuseppe Angilella wrote: Hi, Katrin.

Re: [Koha] search patron not working

vileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at i...@ptfs-europe.com On Tue, 21 Jun 2022 at 1

[Koha] Alternate graphic representation (880) for Contents (505)

Hi, while I can fill a 880 (Alernate graphic representation) for any linked field, this is usually diaplayed only for 240 (Uniform title), 245 (Title statement), or 100 (Main entry-Personal name) fields. Is it possible to have an Alternate graphic representation displayed also for a 505$t (F

Re: [Koha] koha 22.11 upgrading Error

Hi, same problem here. Googling around, I've found a related issue here: https://lists.katipo.co.nz/public/koha/2022-October/058542.html It seems to have to do with a constraint on a column, to be removed before the update can be applied, and then to be enforced again. But I wouldn't dare a

[Koha] Cannot import records: Failed to connect: Error connecting to localhost:61613

Hi, after upgrading a Debian (Ubuntu) installation to version 22.11.03.000 Rosalie , I fail to import any new Marc record into the database. My worker-output.log reports: Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giv

[Koha] Koha update being kept back on Ubuntu 18.04 bionic

Hi, I am currently using Koha 22.11.06 on Ubuntu 18.04 Recently, "sudo apt upgrade" kept an available update for Koha "on hold". Is it possible to perform the upgrade nonetheless? Is it recommended, or will it cause problems (i.e., the new version of Koha will still be compatible with Ubuntu

[Koha] Koha 23.11 on Ubuntu 22.04: broken dependency

Hi, when trying to update Koha to the newest release (23.11) in my Ubuntu system (22.04) I get the following error: Errors were encountered while processing: /var/cache/apt/archives/koha-l10n_23.11.00-1_all.deb The following packages have unmet dependencies: perl : Depends: perl-base (= 5.3

Re: [Koha] Koha 23.11 on Ubuntu 22.04: broken dependency

Hi, David! Encouraged by your experience, I did as you (and the system itself, in fact) suggested to do (but I had not the nerve to do!). I had to run the command twice, for some reason, but it seemed it worked, eventually! Many thanks! Giuseppe. On Sat, 2 Dec 2023, David Liddle wrote:

[Koha] 404 Error after upgrading to 25.04

Hi, I'm experiencing exactly the same problem as reported by Beda in May 2024: After upgrading to Koha 25.04, several tables in opac do not load (including items, patrons, libraries ... ). The subject thread interrupts after a reported attempt to debug REST_API. Has a solution been found? A

Re: [Koha] 404 Error after upgrading to 25.04

Updating further to 24.05.02.000 seems to have done the trick! Sorry for raising the problem again! Best, Giuseppe. On Tue, 6 Aug 2024, Giuseppe Angilella wrote: Hi, I'm experiencing exactly the same problem as reported by Beda in May 2024: After upgrading to Koha 25.04, several tabl

[Koha] how to classify e-books/e-readers

Hi, my library purchased a few e-readers (Kindles), which I am going to populate with e-books soon. Each e-reader is likely to eventually contain the same collection of e-books, but should of course be available for loan separately. I assume that a separate MARC record should be entered for

[Koha] e-books as Koha items

Hi, I've just started populating my library's catalog with e-book readers and e-books. I've defined different item types for either e-readers and e-books, and classified the former as "equipment" and the latter as "monographs" in the appropriate MARC record fields (leader etc). For a given

Re: [Koha] e-books as Koha items

ld fix the main issue of keeping track of loans. The only drawback is that the call number of the e-reader would be the same for all the e-books contained in it, which would therefore not show up appropriately in the "Browse shelf". Giuseppe. On Thu, 15 Jun 2017, Giuseppe Angilella wrote:

[Koha] DBMS_auto_increment : cannot check-in items checked out before a certain upgrade

Hi, I am running Koha 17.05.05.000 on Ubuntu 14.04.1 with mysql Ver 14.14 Distrib 5.5.58. I regularly upgrade Koha via apt-get, and I've suddenly realized I cannot check-in items which had been checked-out (presumably before a certain upgrade). I can check-in items which have been checked-

[Koha] adding existing items to acquisitions

Hi, how can I add existing items to existing acquisitions? The normal procedure would be to first "order" an item within an acquisition's basket, and then have it "received". But I am trying to reconstruct past acquisitions (for the sake of my library's records), that had been dealt with outs

[Koha] synchro two instances of Koha

Hi, is it possible to synchronize two (online) instances of Koha? I mean, two identical installations, updated regularly, residing on two different machines, where patrons and administrators can access and modify entries independently. Would it possible to synchronize their databases (and per

[Koha] new authorized value for damaged: tinyint vs int

Hi, I've defined a new authorized value for the DAMAGED category. In my database, this corresponds to id = 256 in the authorised_values table, where id is an int(11). However, when I try to select that authorized value for a particular item, my choice is not recorded. I noticed that items.da

[Koha] upgrade to Koha 18.11 on Ubuntu 18.04

Hi, I have a (working) instance of Koha 17.11.05-1 installed on an Ubuntu 18.01.1 LTS (bionic) machine. I would like to upgrade Koha to the current version 18.11.01-1, but I get the error: sudo apt upgrade koha-common Some packages could not be installed. This may mean that you have requeste

Re: [Koha] upgrade to Koha 18.11 on Ubuntu 18.04

lvo. Il giorno ven 28 dic 2018 alle ore 17:55 Giuseppe Angilella ha scritto: Hi, I have a (working) instance of Koha 17.11.05-1 installed on an Ubuntu 18.01.1 LTS (bionic) machine. I would like to upgrade Koha to the current version 18.11.01-1, but I get t

[Koha] new item for ebook in Acquisitions

Hi, I usually link "items" for an ebook record to my (only) Kindle reader, also present as a record, using the 773 MARC field for the host item entry in the record for the ebook, and a corresponding 774 MARC field in the constituent unit entry in the record for the kindle. This automatically

[Koha] exporting MARC records on mysql conditions

Hi, the online export tool for bibliographic records allows to select records in a given range of either biblio number, or item call number, or accession date. Would it be possible (perhaps via an off-line script) to select records fulfilling other constraints? (Say, a full mysql "where..."

[Koha] loan availability of damaged items

Hi, would it be possible to record the damaged status of an item (say, Cover missing) with a nonzero value of the 952$4 MARC subfield, and make the item still available for loan? Thanks, Giuseppe. ___ Koha mailing list http://koha-community.org Ko

Re: [Koha] loan availability of damaged items

On Sun, 1 Feb 2015, Giuseppe Angilella wrote: Hi, would it be possible to record the damaged status of an item (say, Cover missing) with a nonzero value of the 952$4 MARC subfield, and make the item still available for loan? Thanks, Giuseppe. __

Re: [Koha] Another Library using Koha online!

Dear Stephan, congratulations indeed for your library's new website: that's gorgeous indeed! I would be especially interested in receiving updates concerning the integration of Koha with Facebook and other social networks (such as Twitter). Posting new acquisitions to a Facebook account is w

[Koha] DVD cover from Amazon

Hi, assuming that the EAN (barcode: not an ISBN) on a motion picture's DVD should be entered in 024$a (Other Standard Identifier), is it possible to have Amazon's cover for that DVD displayed, as is the case when a (valid) ISBN is entered in 020$a for a monograph (book)? Many thanks and best r

[Koha] browse shelf for serials without items

Dear Kohaers, while it is possible to assign a call number to a serial subscription, as far as I understand, it is currently not possible to have a serial shown with the "browse shelf" function, unless that serial has items (with their own, proper call numbers). I wonder whether it is possib

[Koha] staff member responsible of loan/renewal recorded in issues?

Dear Kohaers, is the information concerning which staff member was responsible of a loan or renewal of a given item recorded anywhere in the database? I couldn't find it in the "issues" tables. Assuming it is not, it could be a relevant information to record, in cases where several staff mem

Re: [Koha] staff member responsible of loan/renewal recorded in issues?

On Fri, 8 May 2015, Tajoli Zeno wrote: I think you can record it if you active IssueLog: Home › Administration › System preference > IssueLog Thank you, Zeno. I did indeed turn on both IssueLog and ReturnLog, and can now browse them through Tools > Additional tools > Log viewer > Circulati

[Koha] converting existing serial subscriptions from "no items" to "generate items"

Hi, whenever one creates a new subscription for a serial, Koha prompts whether you would like to "create an item record when receiving this serial", or not. Now, after some experience with my patrons, it seems that the best way of keeping track of serial loans is to have items for each seria

[Koha] adding MARC tags (not in framework) while cataloguing

Hi, I occasionally need to add unfrequently used MARC tags to new records, even though they are not present (=active for staff) in the default MARC framework. I realize that it is possible to activate those tags by (temporarily) modifying the default MARC framework, or that one can save the

[Koha] importing new authorities other than in PERSO_NAME via Tools/Z39.50

Hi, is it possible to import a new authority other than in PERSO_NAME (say, a new Uniform Title) via Tools ("Stage MARC records for import"), or even by Z39.50? Seemingly, in order to populate any authority table other than the default (i.e. PERSO_NAME) it is only possible to create a new au

[Koha] loop over subjects (in SQL report)

Hi, I would like to list records by subject (in a SQL report). I can isolate the first subject in a record with ExtractValue(biblioitems.marcxml,'//datafield[substring(@tag,1,1) = "6"][1]/subfield[@code>="a"]') But then I need to perform a UNION DISTINCT with another SELECT addressing the se

[Koha] how to fix encoding of biblioitems.kohaxml (moving to latest Koha)

Hi, I'm upgrading to Koha latest release (3.14.01.000) from a quite old one (2.x). I've imported the old database, let the web installation procedure perform the automatic steps to upgrade the sql structure, then launched the convert_to_utf8.pl tool in .../migration_tools/22_to_30/ My stuf

[Koha] Location and item information (Marc 952) from Koha 2.x to 3.14

Hi, I'm in the progress of updating my Koha system here from 2.x to 3.14 (a giant leap, seemingly!) After using the built-in migration scripts and fixing many local inconsistencies, I am left with the Koha-to-Marc mapping of the subfields in the 952 tab (Location and item information). I a

Re: [Koha] Location and item information (Marc 952) from Koha 2.x to 3.14

Dear Chris, thanks for replying. On Mon, 17 Feb 2014, Chris Cormack wrote: Item data in 3.4.x and above is no longer stored in the MARC but in the items table, did you run the script to tidy that up? I cannot be sure: I've performed an installation from packages, and several migration scrip

Re: [Koha] Location and item information (Marc 952) from Koha 2.x to 3.14

Dear Chris, misc/maintenance/remove_items_from_biblioitems.pl --run I launched the script above (with an added parameter --where="biblioitemnumber=2388", to restrict its action to one single item, to begin with), and it stripped indeed all the 952 subfields for the (single) item specified f

Re: [Koha] Location and item information (Marc 952) from Koha 2.x to 3.14

Dear Chris, briefly: it works! many thanks for your kind advice! :-) Now, a more extensive summary for the possible benefit of other future passers-by (and for my own reference). My problem was I could not properly edit existing items (or edit newly added items) for biblio records belonging

[Koha] empty Tools list

Hi, I'm in the process of upgrading an old database to the current version of Koha. The migration process had errors, which I am now trying to identify and fix (one by one, alas). Presently, the Koha instance working on the updated database does not display any tool in the Tools page. It onl

Re: [Koha] empty Tools list

I suspect that this has to do with some missing entry in some table of the Koha mysql database. The question is: which one? Any hint? In Koha 3.14, new permissions have been introduced (with respect to the much older release I was using). Therefore, after some intuition, trial and error, I sol

[Koha] marc21_leader.pl : how to change default values?

Hi, how is it possible to change the default values filled in MARC subfield 000 by marc21_leader.pl, without editing the perl script itself? There seems to be no explicit way to do that in Home > Administration > MARC frameworks > Default MARC framework Many thanks, Giuseppe. _

[Koha] original title in OPAC

Hi, how do I display the title in the original language of a translated item in the OPAC? This should be contained in the MARC field 765$t (which is normally hidden). (A varying form of title, as recorded in 246$a, is shown as "Other title".) Should 765$t be somehow linked to the subtitle

[Koha] irregular serial numbering

Hi, I'm having trouble in defining the numbering pattern for a serial. The serial is weekly (number icreases by one every new week, and is never reset to one), but the volume number increases at the beginning of each new second month. This means every 7, or 8, or 9 weeks (i.e., issues), depen

[Koha] ISBD view of multiple publishers

Hi, whenever a biblio has two or more entries in 260$a (place of publication) and/or 260$b (name of publisher), the ISBD view lists them grouping places first, and then names, regardless of the order in the MARCxml, e.g.: Roma : Mosca : Editori Riuniti ; MIR, 2003. rather than: Roma : Edit

[Koha] sorting long Cutter's

Hi, call numbers having Cutter parts made of several substrings currently are not sorted correctly. Here are examples: | itemcallnumber | cn_source | cn_sort| | 530 F435 1996 v1 | ddc | 530_F435_1996000_V1| | 530 F435 1996 v2p1 | ddc | 530_

[Koha] cross-links in analytics

Hi, when a "Link to host item" is added to a constituent record, the appropriate 773 Marc datafield is created in the constituent record, and populated with the appropriate subfields referring to the host item. Then, the OPAC for the constituent record does show the link to the host record.

Re: [Koha] cross-links in analytics

Dear Elaine, thank you very much for your kind feedback. On Tue, 29 Jul 2014, Elaine Bradtke wrote: We  manually input our 774 fields.  That's ok, but does it result in cross-links to the constituent parts in the host item's OPAC? Many thanks! Giuseppe. __

Re: [Koha] cross-links in analytics

constituent parts. But it would be nice if the 774 fields worked as they should. On Tue, Jul 29, 2014 at 4:30 AM, Giuseppe Angilella wrote: Dear Elaine, thank you very much for your kind feedback. On Tue, 29 Jul 2014, Elaine Bradtke wrote: We  manually input our 77

[Koha] branch restrictions to staff

Hi, further to the following message of 2004 (!): http://lists.katipo.co.nz/public/koha/2004/007518.html is it possible with current Koha version to restrict circulation (and perhaps patron management) for a given staff member (or staff members belonging to a given patron category) for items

[Koha] uploaded cover images: format and dimensions

Hi, what are the recommended format (jpg? png?) and dimensions of a cover image for a bibliorecord? Is a single image appropriately rescaled, when displayed in the OPAC normal view for the record, and in the "browse shelf" below? Many thanks, Giuseppe. _

[Koha] batch items modification: itemnumber contains space

Hi, I would like to use the batch items modification tool to a list of items, whose itemnumbers contain a space (e.g. 01 1234). The tool treats the two parts of the itemnumber as a distinct number (i.e. 01 and 1234), therefore no item is found. I tried enclosing the itemnumbers in inverted