Local covers and the Coverflow plugin
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ć
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, library@ssst.edu.ba <library@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 Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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.alvaro@gmail.com> Sent: Friday, June 16, 2023 4:27 PM To: library@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é Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. Recycle always / Recicla siempre / Recyclez toujours Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba <mailto:library@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
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, library@ssst.edu.ba <library@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.alvaro@gmail.com> Sent: Friday, June 16, 2023 4:27 PM To: library@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é Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. Recycle always / Recicla siempre / Recyclez toujours Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire
Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba <mailto: library@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
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.alvaro@gmail.com> Sent: Monday, June 19, 2023 4:34 PM To: library@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 |----------------------------------------------------------------------------------------| [https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, library@ssst.edu.ba<mailto:library@ssst.edu.ba> <library@ssst.edu.ba<mailto:library@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.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com>> Sent: Friday, June 16, 2023 4:27 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba> Cc: koha@lists.katipo.co.nz<mailto: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é • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. • Recycle always / Recicla siempre / Recyclez toujours • Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba> <mailto:library@ssst.edu.ba<mailto:library@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<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Copy and paste the above SQL code. Save the report follow error, *The following error was encountered:* The database returned the following error: Table 'koha_library.biblioimages' doesn't exist Please check the log for further details. On Tue, 20 Jun 2023, 1:09 pm library@ssst.edu.ba, <library@ssst.edu.ba> wrote:
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.alvaro@gmail.com> Sent: Monday, June 19, 2023 4:34 PM To: library@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
|----------------------------------------------------------------------------------------| [ https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, library@ssst.edu.ba<mailto: library@ssst.edu.ba> <library@ssst.edu.ba<mailto:library@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.alvaro@gmail.com<mailto: cornejo.alvaro@gmail.com>> Sent: Friday, June 16, 2023 4:27 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba> Cc: koha@lists.katipo.co.nz<mailto: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é • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. • Recycle always / Recicla siempre / Recyclez toujours • Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire
Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba<mailto: library@ssst.edu.ba> <mailto:library@ssst.edu.ba<mailto: library@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<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
I was just about to write that I got that error after running the new report. Where do I find the log, and how do I correct the error? I have one image uploaded so far, for one record. Best regards Aida Đikić From: MASTeR Library <mamcet.library10@gmail.com> Sent: Tuesday, June 20, 2023 9:48 AM To: library@ssst.edu.ba Cc: Alvaro Cornejo <cornejo.alvaro@gmail.com>; koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Local covers and the Coverflow plugin Copy and paste the above SQL code. Save the report follow error, The following error was encountered: The database returned the following error: Table 'koha_library.biblioimages' doesn't exist Please check the log for further details. On Tue, 20 Jun 2023, 1:09 pm library@ssst.edu.ba<mailto:library@ssst.edu.ba>, <library@ssst.edu.ba<mailto:library@ssst.edu.ba>> wrote: 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.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com>> Sent: Monday, June 19, 2023 4:34 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba> Cc: koha@lists.katipo.co.nz<mailto: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 |----------------------------------------------------------------------------------------| [https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba>> <library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@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.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com><mailto:cornejo.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com>>> Sent: Friday, June 16, 2023 4:27 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba>> Cc: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz><mailto:koha@lists.katipo.co.nz<mailto: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é • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. • Recycle always / Recicla siempre / Recyclez toujours • Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba>> <mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@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<mailto:Koha@lists.katipo.co.nz><mailto:Koha@lists.katipo.co.nz<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<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Alright, I did some digging re: Table 'koha_library.biblioimages' doesn't exist, and I found the following on https://github.com/bywatersolutions/koha-plugin-coverflow/issues/46 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; This works for my installation; however, I need to upload images for all the items, which results in this: https://i.ibb.co/qnRFq8g/Screenshot-2023-06-20-111023.png Is there a way to attach a local cover image to the record and not the items? We have locally published textbooks where there’s several items students can borrow for their classes. I would rather not have to upload an identical image to each item. Best regards Aida Đikić From: library@ssst.edu.ba Sent: Tuesday, June 20, 2023 9:50 AM To: MASTeR Library <mamcet.library10@gmail.com> Cc: Alvaro Cornejo <cornejo.alvaro@gmail.com>; koha <koha@lists.katipo.co.nz> Subject: RE: [Koha] Local covers and the Coverflow plugin I was just about to write that I got that error after running the new report. Where do I find the log, and how do I correct the error? I have one image uploaded so far, for one record. Best regards Aida Đikić From: MASTeR Library <mailto:mamcet.library10@gmail.com> Sent: Tuesday, June 20, 2023 9:48 AM To: mailto:library@ssst.edu.ba Cc: Alvaro Cornejo <mailto:cornejo.alvaro@gmail.com>; koha <mailto:koha@lists.katipo.co.nz> Subject: Re: [Koha] Local covers and the Coverflow plugin Copy and paste the above SQL code. Save the report follow error, The following error was encountered: The database returned the following error: Table 'koha_library.biblioimages' doesn't exist Please check the log for further details. On Tue, 20 Jun 2023, 1:09 pm mailto:library@ssst.edu.ba, <mailto:library@ssst.edu.ba> wrote: 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 <mailto:cornejo.alvaro@gmail.com> Sent: Monday, June 19, 2023 4:34 PM To: mailto:library@ssst.edu.ba Cc: mailto: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 |----------------------------------------------------------------------------------------| [https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, mailto:library@ssst.edu.ba<mailto:mailto:library@ssst.edu.ba> <mailto:library@ssst.edu.ba<mailto:mailto:library@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 <mailto:cornejo.alvaro@gmail.com<mailto:mailto:cornejo.alvaro@gmail.com>> Sent: Friday, June 16, 2023 4:27 PM To: mailto:library@ssst.edu.ba<mailto:mailto:library@ssst.edu.ba> Cc: mailto:koha@lists.katipo.co.nz<mailto:mailto: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é • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. • Recycle always / Recicla siempre / Recyclez toujours • Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 16 juin 2023 à 03:41, mailto:mailto:library@ssst.edu.ba<mailto:mailto:library@ssst.edu.ba> <mailto:mailto:library@ssst.edu.ba<mailto:mailto:library@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:mailto:Koha@lists.katipo.co.nz<mailto:mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org mailto:Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, I also have a question about what to do with records that don’t have an ISBN, since it seems that coverflow will only work with those that do (biblioitems.isbn IS NOT NULL)? We have some old books that don't have ISBNs and I'd like them to appear in the coverflow as well. Best regards Aida Đikić From: MASTeR Library <mamcet.library10@gmail.com> Sent: Tuesday, June 20, 2023 9:48 AM To: library@ssst.edu.ba Cc: Alvaro Cornejo <cornejo.alvaro@gmail.com>; koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Local covers and the Coverflow plugin Copy and paste the above SQL code. Save the report follow error, The following error was encountered: The database returned the following error: Table 'koha_library.biblioimages' doesn't exist Please check the log for further details. On Tue, 20 Jun 2023, 1:09 pm library@ssst.edu.ba<mailto:library@ssst.edu.ba>, <library@ssst.edu.ba<mailto:library@ssst.edu.ba>> wrote: 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.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com>> Sent: Monday, June 19, 2023 4:34 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba> Cc: koha@lists.katipo.co.nz<mailto: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 |----------------------------------------------------------------------------------------| [https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba>> <library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@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.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com><mailto:cornejo.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com>>> Sent: Friday, June 16, 2023 4:27 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba>> Cc: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz><mailto:koha@lists.katipo.co.nz<mailto: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é • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. • Recycle always / Recicla siempre / Recyclez toujours • Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba>> <mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba><mailto:library@ssst.edu.ba<mailto:library@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<mailto:Koha@lists.katipo.co.nz><mailto:Koha@lists.katipo.co.nz<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<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi You can delete ISBN filter from query. However you might get unexpected results. You can run the report from the reports pages and see what does it gives you and play with them. 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 à 03:13, library@ssst.edu.ba <library@ssst.edu.ba> a écrit :
Hi,
I also have a question about what to do with records that don’t have an ISBN, since it seems that coverflow will only work with those that do (biblioitems.isbn IS NOT NULL)? We have some old books that don't have ISBNs and I'd like them to appear in the coverflow as well.
Best regards
*Aida Đikić*
*From:* MASTeR Library <mamcet.library10@gmail.com> *Sent:* Tuesday, June 20, 2023 9:48 AM *To:* library@ssst.edu.ba *Cc:* Alvaro Cornejo <cornejo.alvaro@gmail.com>; koha < koha@lists.katipo.co.nz> *Subject:* Re: [Koha] Local covers and the Coverflow plugin
Copy and paste the above SQL code.
Save the report follow error,
*The following error was encountered:* The database returned the following error: Table 'koha_library.biblioimages' doesn't exist Please check the log for further details.
On Tue, 20 Jun 2023, 1:09 pm library@ssst.edu.ba, <library@ssst.edu.ba> wrote:
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.alvaro@gmail.com> Sent: Monday, June 19, 2023 4:34 PM To: library@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
|----------------------------------------------------------------------------------------| [ https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, library@ssst.edu.ba<mailto: library@ssst.edu.ba> <library@ssst.edu.ba<mailto:library@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.alvaro@gmail.com<mailto: cornejo.alvaro@gmail.com>> Sent: Friday, June 16, 2023 4:27 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba> Cc: koha@lists.katipo.co.nz<mailto: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é • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. • Recycle always / Recicla siempre / Recyclez toujours • Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire
Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba<mailto: library@ssst.edu.ba> <mailto:library@ssst.edu.ba<mailto: library@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<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
Hello, The ISBN filter would be the “AND biblioitems.isbn IS NOT NULL” part?? I don't think that would be a good idea; there might be only about 100 books out of 9000 that have been published before 1970, and I don’t want to break the plugin. I already found that according to https://github.com/bywatersolutions/koha-plugin-coverflow/issues/46 LEFT JOIN biblioimages c ON (i.biblionumber=c.biblionumber) should be LEFT JOIN cover_images c ON (items.biblionumber=c.biblionumber) at least for my version of Koha. Best regards Aida Đikić From: Alvaro Cornejo <cornejo.alvaro@gmail.com> Sent: Tuesday, June 20, 2023 3:29 PM To: library@ssst.edu.ba Cc: MASTeR Library <mamcet.library10@gmail.com>; koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Local covers and the Coverflow plugin Hi You can delete ISBN filter from query. However you might get unexpected results. You can run the report from the reports pages and see what does it gives you and play with them. Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. Recycle always / Recicla siempre / Recyclez toujours Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mar. 20 juin 2023 à 03:13, mailto:library@ssst.edu.ba <mailto:library@ssst.edu.ba> a écrit : Hi, I also have a question about what to do with records that don’t have an ISBN, since it seems that coverflow will only work with those that do (biblioitems.isbn IS NOT NULL)? We have some old books that don't have ISBNs and I'd like them to appear in the coverflow as well. Best regards Aida Đikić From: MASTeR Library <mailto:mamcet.library10@gmail.com> Sent: Tuesday, June 20, 2023 9:48 AM To: mailto:library@ssst.edu.ba Cc: Alvaro Cornejo <mailto:cornejo.alvaro@gmail.com>; koha <mailto:koha@lists.katipo.co.nz> Subject: Re: [Koha] Local covers and the Coverflow plugin Copy and paste the above SQL code. Save the report follow error, The following error was encountered: The database returned the following error: Table 'koha_library.biblioimages' doesn't exist Please check the log for further details. On Tue, 20 Jun 2023, 1:09 pm mailto:library@ssst.edu.ba, <mailto:library@ssst.edu.ba> wrote: 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 <mailto:cornejo.alvaro@gmail.com> Sent: Monday, June 19, 2023 4:34 PM To: mailto:library@ssst.edu.ba Cc: mailto: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 |----------------------------------------------------------------------------------------| [https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, mailto:library@ssst.edu.ba<mailto:mailto:library@ssst.edu.ba> <mailto:library@ssst.edu.ba<mailto:mailto:library@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 <mailto:cornejo.alvaro@gmail.com<mailto:mailto:cornejo.alvaro@gmail.com>> Sent: Friday, June 16, 2023 4:27 PM To: mailto:library@ssst.edu.ba<mailto:mailto:library@ssst.edu.ba> Cc: mailto:koha@lists.katipo.co.nz<mailto:mailto: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é • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. • Recycle always / Recicla siempre / Recyclez toujours • Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 16 juin 2023 à 03:41, mailto:mailto:library@ssst.edu.ba<mailto:mailto:library@ssst.edu.ba> <mailto:mailto:library@ssst.edu.ba<mailto:mailto:library@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:mailto:Koha@lists.katipo.co.nz<mailto:mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org mailto:Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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, library@ssst.edu.ba <library@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.alvaro@gmail.com> *Sent:* Monday, June 19, 2023 4:34 PM *To:* library@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, library@ssst.edu.ba <library@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.alvaro@gmail.com> Sent: Friday, June 16, 2023 4:27 PM To: library@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:library@ssst.edu.ba <mailto: library@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
Ah, but that’s not what I want. I want the coverflow plugin to show ALL items, and I want to replace “No cover available” with an actual, locally saved cover. I managed to find a way to do so on the Bywater github page, but it means that I have to upload a cover to each ITEM. That is unwieldy because we often have titles with multiple items (sometimes over 20) that students can borrow from the library. I need to find if there’s a way to upload an image to a RECORD. Best regards Aida Đikić From: Alvaro Cornejo <cornejo.alvaro@gmail.com> Sent: Tuesday, June 20, 2023 3:25 PM To: library@ssst.edu.ba Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Local covers and the Coverflow plugin Hi, By discard I mean skip it from the report so coverflow will only show items with covers. Regards, Alvaro |----------------------------------------------------------------------------------------| [https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, library@ssst.edu.ba<mailto:library@ssst.edu.ba> <library@ssst.edu.ba<mailto:library@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.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com>> Sent: Monday, June 19, 2023 4:34 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba> Cc: koha@lists.katipo.co.nz<mailto: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 |----------------------------------------------------------------------------------------| [https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, library@ssst.edu.ba<mailto:library@ssst.edu.ba> <library@ssst.edu.ba<mailto:library@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.alvaro@gmail.com<mailto:cornejo.alvaro@gmail.com>> Sent: Friday, June 16, 2023 4:27 PM To: library@ssst.edu.ba<mailto:library@ssst.edu.ba> Cc: koha@lists.katipo.co.nz<mailto: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é • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. • Recycle always / Recicla siempre / Recyclez toujours • Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba<mailto:library@ssst.edu.ba> <mailto:library@ssst.edu.ba<mailto:library@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<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Alvaro Cornejo -
library＠ssst.edu.ba -
MASTeR Library