[Koha] How to hide the OPAC "Cover Not Available" message?

Good night, How to hide the OPAC "Cover Not Available" message? I enabled "OPACAmazonCoverImages" and "OPACLocalCoverImages" to insert images that are not on Amazon. When he loads the image from Amazon, the message "Cover Not Available" also appears. I would like to remove this message when he

Re: [Koha] SQL report to search for series statements and volume numbers

Hi Roger This works exactly as it is needed, and even with correct sorting! Great! I'm not really familiar with the UNION clause but this seems a great way of using it. The SQL statement may be somewhat inefficient but is very effective though. In our database with around 30'000 test

Re: [Koha] SQL report to search for series statements and volume numbers

Hi Katrin You wrote: > if you use > > ExtractValue(metadata,'//datafield[@tag="490"]/subfield[@code="a"]') = > <> > > and there are multiple 490$a, they will appear as one space separated > string. That means, that you need to use LIKE and truncation with % to > locate the ones with the entry

Re: [Koha] SQL report to search for series statements and volume numbers

Hi Michael, an inefficient and quite long running SQL statement for your request might be the following: SELECT s.ser AS series, s.vol AS volume, s.biblionumber FROM ( SELECT ExtractValue(a.metadata,'//datafield[@tag="490"][1]/subfield[@code="a"]') AS ser,

[Koha] Serial Record Holding

Hi there. I would like to seek help regarding importing my serial holding into my koha. I got a holding file but i don't know how to upload it into my koha. I wish anyone here could help me do that.. I will pay for your service/consultation. Can be discussed. I did contact a few paid support