Hi, By discard I mean skip it from the report so coverflow will only show items with covers.
Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mar. 20 juin 2023 à 02:38, libr...@ssst.edu.ba <libr...@ssst.edu.ba> a écrit : > Hi Alvaro, > > > > What do you mean by discard items with no covers? I don’t want to discard > them; I want them to use the cover I upload for those records that don’t > have Amazon covers (mostly because they are titles published in my country > and are not available via big distributors). Or is that not what “discard” > means in this context? > > > > Best regards > > > > *Aida Đikić* > > > > > > *From:* Alvaro Cornejo <cornejo.alv...@gmail.com> > *Sent:* Monday, June 19, 2023 4:34 PM > *To:* libr...@ssst.edu.ba > *Cc:* koha@lists.katipo.co.nz > *Subject:* Re: [Koha] Local covers and the Coverflow plugin > > > > Hi > > > > You need to "discard" items with no covers from your query. > > > > We use this: > > > > SELECT DISTINCT biblio.title, biblio.biblionumber, c.imagenumber AS > localcover > FROM items i > LEFT JOIN biblioitems USING (biblioitemnumber) > LEFT JOIN biblio ON (i.biblionumber=biblio.biblionumber) > LEFT JOIN biblioimages c ON (i.biblionumber=c.biblionumber) > WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND > biblioitems.isbn IS NOT NULL AND c.imagenumber != '' > ORDER BY rand() > LIMIT 50 > > > > Hope helps > > > > Regards > > > > Alvaro > > > > > > |----------------------------------------------------------------------------------------| > > Stay safe / Cuídate/ Reste sécurisé > > *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à > mesure. > > *q* Recycle always / Recicla siempre / Recyclez toujours > > P Print only if absolutely necessary / Imprime solo si es necesario / > Imprimez seulement si nécessaire > > > > > > Le lun. 19 juin 2023 à 02:16, libr...@ssst.edu.ba <libr...@ssst.edu.ba> a > écrit : > > Hello Alvaro, > > I don't know how to do that, since I never even touched SQL before. I can > copy and paste code from the SQL list, but don’t really understand what it > does and how to change it to do what I need. > > I just checked the report, it is public. The code I'm using is from the > plugin configuration: > > SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title > FROM items i > LEFT JOIN biblioitems m USING (biblioitemnumber) > LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND > m.isbn IS NOT NULL AND m.isbn != '' > GROUP BY biblionumber > HAVING isbn != "" > ORDER BY rand() > LIMIT 30 > > The instructions then go on to say: > > Note: You can add an additional column 'localcover' - this should be blank > if the biblio doesn't have a localcover and can contain any other data if > it does. If this column is populated a local cover will be used. Example > below: > > SELECT DISTINCT biblio.title, biblio.biblionumber, > SUBSTRING_INDEX(biblioitems.isbn, ' ', 1) AS isbn, c.imagenumber AS > localcover > FROM items > LEFT JOIN biblioitems USING (biblioitemnumber) > LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) > LEFT JOIN cover_images c ON (items.biblionumber=c.biblionumber) > WHERE biblioitems.isbn IS NOT NULL AND biblioitems.isbn !='' > ORDER BY RAND() > LIMIT 15; > > > But when I tried replacing the first code with the second, I didn't get > any results. Right now I'm back to the original code, and have turned the > local covers option off, so I have several "No image available" images. > Where do I change what to get local covers? > > Best regards > > Aida Đikić > > > From: Alvaro Cornejo <cornejo.alv...@gmail.com> > Sent: Friday, June 16, 2023 4:27 PM > To: libr...@ssst.edu.ba > Cc: koha@lists.katipo.co.nz > Subject: Re: [Koha] Local covers and the Coverflow plugin > > Hi Aida > > You only need to change/edit the report that pulls information for > coverflow. Also remember to define the report as public. > > Regards > > Alvaro > > > |----------------------------------------------------------------------------------------| > Stay safe / Cuídate/ Reste sécurisé > 7 Switch off as you go / Apaga lo que no usas / Débranchez au fur et à > mesure. > q Recycle always / Recicla siempre / Recyclez toujours > P Print only if absolutely necessary / Imprime solo si es necesario / > Imprimez seulement si nécessaire > > > Le ven. 16 juin 2023 à 03:41, mailto:libr...@ssst.edu.ba <mailto: > libr...@ssst.edu.ba> a écrit : > Hello again, > > I'm trying to find a way to have local covers show in the Coverflow plugin > on the OPAC page for titles not added via Z39.50. > > I had originally set it up using the first example in the configuration > (items added in the last 30 days), but going back I see there's another > example for adding additional columns. Since it said, "you can add an > additional column" I thought I was supposed to paste it below the already > existing code. That... ended up with an error yeah :) So I replaced it and > ran the report but could not get a local cover. > > What am I doing wrong this time? I uploaded the cover in the holdings > area. Is there another location I should do it instead? I checked old posts > on the mailing list, but could not find any solutions for this. I would > also like to work out a way to show covers of our collections (e.g. CS > textbooks, ECON textbooks, donated books etc.) but for that I need to > figure out lists?? > > I'm on Koha 23.05.00 and Ubuntu 22.04.2 LTS. > > Best regards > > Aida Đikić > _______________________________________________ > > Koha mailing list http://koha-community.org > mailto:Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
